No description, website, or topics provided.
Switch branches/tags
Nothing to show
Clone or download
Latest commit 8d8d1cc Feb 2, 2018
Permalink
Failed to load latest commit information.
app copy & volume Feb 2, 2018
migrations moon materials Jan 29, 2018
tmp unicode test Dec 7, 2017
MANIFEST.in setup? Dec 4, 2017
README moon mat reaction material bonus Feb 1, 2018
TODO.md copy & volume Feb 2, 2018
config.py preston -> esipy Jan 18, 2018
fabfile.py setup? Dec 4, 2017
manage.py migrate Dec 5, 2017
requirements.txt preston -> esipy Jan 18, 2018
run.py redis Dec 15, 2017
sde.py setup? Dec 4, 2017
setup.py setup? Dec 4, 2017
swagger.t.json market scanner Jan 22, 2018
wsgi.py wsgi Dec 5, 2017

README

#### Changes
2018-01-25 - added "fits on market" scanner
2018-01-05 - added NPC stations (30%, 50%)
2018-01-01 - changed price query method to avoid exception when multiply prices for type exists, possible fix for multiply prices
2017-12-29 - added warnings for settings, which usually lead to empty result
2017-12-27 - added user name uniqness validation
2017-12-24 - fixed wrong yield bonus


#### Dev server
    python 3.6

    pip3 install -r requirements.txt

    source ./aes-env/bin/activate
    ESI_CONFIG=~/esi.conf SECRET_KEY=test ./run.py    
    

#### esi.conf
    ESI_CLIENT_ID='c1l2i3e4n5t6_7i8d'
    ESI_SECRET='1s2e3c4r5e6t7'
    ESI_CALLBACK_URL='http://localhost:5000/probleme_callback'
    

#### MIGRATIONS
    ./manage.py script_sql mysql <script description>
    ./manage.py db_version
    ./manage.py version_control
    ./manage.py upgrade
    ./manage.py test
    ./manage.py downgrade <version>


#### SDE Import
    source ./aes-env/bin/activate
    python3 ./sde.py ~/Downloads/sde-20180110-TRANQUILITY.zip
        
        
#### TIPS

citadels

    SELECT t.id, t.name, ta.value, a.id, a.name
      FROM eve_types t,
           eve_groups g,
		   eve_type_attributes ta,
           eve_attributes a
      where g.category_id=65 
        and g.published=1
        and t.group_id = g.id 
    	and t.published=1
        
		and ta.type_id=t.id
        and a.id=ta.attribute_id
        and a.id in (1547)  
    	
citadel bonuses    
    	
    SELECT t.id,t.name, a.id, a.code, a.name, ta.value
      FROM eve_types t,
           eve_groups g,
           eve_type_attributes ta,
           eve_attributes a
      where g.category_id=65 
        and g.published=1
        and t.group_id = g.id 
        and t.published=1
        and ta.type_id = t.id
        and a.id=ta.attribute_id
        #and a.published=1
        and a.id in (2600,2601,2602)
        
ref. implants

    SELECT t.id, t.name, ta.value
      FROM eve_types t,
           eve_groups g,
           eve_type_attributes ta,
           eve_attributes a
      where ta.type_id=t.id
        and t.published=1
        and a.id=ta.attribute_id
        and a.id=379
        and g.id=t.group_id
        and g.category_id=20
      order by t.name       
      
citadel rigs

    SELECT t.id, t.name,             
           ta.value, 
           ta2.value as rig_size,           
           taH.value as rig_H,
           taL.value as rig_L,
           taZ.value as rig_Z
      FROM eve_types t,
           eve_groups g,
           eve_type_attributes ta,
           eve_attributes a,
           eve_type_attributes ta2,
           eve_attributes a2,
           eve_type_attributes taH,
           eve_attributes aH,           
           eve_type_attributes taL,
           eve_attributes aL,           
           eve_type_attributes taZ,
           eve_attributes aZ
      where t.published=1
        and g.id=t.group_id
        and g.category_id = 66
        and t.market_group_id in (2341,2342,2343)
        and ta.type_id=t.id
        and a.id=ta.attribute_id
        and a.id in (717)
        and ta2.type_id=t.id
        and a2.id=ta2.attribute_id
        and a2.id in (1547)        
        and taH.type_id=t.id
        and aH.id=taH.attribute_id
        and aH.id in (2355)        
        and taL.type_id=t.id
        and aL.id=taL.attribute_id
        and aL.id in (2356)        
        and taZ.type_id=t.id
        and aZ.id=taZ.attribute_id
        and aZ.id in (2357)
      order by t.name  
            
processing skills

    SELECT t.id, t.name, ta.value, a.id, a.name
      FROM evecalc_dev.eve_types t,
           eve_type_attributes ta,
           eve_attributes a
      where t.market_group_id=1323
        and ta.type_id=t.id
        and a.id=ta.attribute_id
        and a.id in (379)
      order by t.name      
         
skill to ores
         
     SELECT t.id, 
            t.name, 
            ore.type_id, 
            tor.name,
            g.*
       FROM eve_types t,       
            eve_market_groups g,
            eve_type_attributes ore,
            eve_attributes ao,
            eve_types tor
       where t.id in (12180,12181) #processing skill id
         and ore.value = t.id
         and ao.id=ore.attribute_id
         and ore.attribute_id in (790)
         and tor.id=ore.type_id
         and g.id = tor.market_group_id
       order by t.name, tor.name


reactor rigs

    SELECT t.id,
           t.name,
           ta.value  as time_bonus,
           ta2.value as mat_bonus,
           ta3.value as low_m,
           ta4.value as null_m,
           ta6.value as rig_size
          FROM eve_groups g,
               eve_types t
                   left join eve_type_attributes ta on ta.type_id = t.id and ta.attribute_id in (2713)
                   left join eve_attributes a on a.id=ta.attribute_id

                   left join eve_type_attributes ta2 on ta2.type_id = t.id and ta2.attribute_id in (2714)
                   left join eve_attributes a2 on a2.id=ta2.attribute_id

                   left join eve_type_attributes ta3 on ta3.type_id = t.id and ta3.attribute_id in (2356)
                   left join eve_attributes a3 on a3.id=ta3.attribute_id

                   left join eve_type_attributes ta4 on ta4.type_id = t.id and ta4.attribute_id in (2357)
                   left join eve_attributes a4 on a4.id=ta4.attribute_id

                   left join eve_type_attributes ta6 on ta6.type_id = t.id and ta6.attribute_id in (1547)
                   left join eve_attributes a6 on a6.id=ta6.attribute_id

          where g.published=1
            and g.category_id=66
            and t.group_id = g.id
            and (ta.value is not null or ta2.value is not null)
            and t.published=1
          order by ta6.value, t.name;


type attributes

SELECT t.id,
       t.name,
       ta.*,
       a.*
  FROM eve_groups g,
       eve_types t
         left join eve_type_attributes ta on ta.type_id = t.id #and ta.attribute_id in (2713)
         left join eve_attributes a on a.id=ta.attribute_id
  where g.published=1
    and t.group_id = g.id
    and t.published=1
    and t.name like 'Standup M-Set Hybrid Reactor Time Efficiency II'
  order by t.name;


reactions:

    type.group_id        |  rig.group_id M  |  rig.group_id T
    ---------------------------------------------------------
    1888 - Composite     |  1934,1939       |  1933,1939
    1889 - Hybrid        |  1936,1939       |  1935,1939
    1890 - Biochemical   |  1938,1939       |  1937,1939