#### 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