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
python 3.6
pip3 install -r requirements.txt
source ./aes-env/bin/activate
ESI_CONFIG=~/esi.conf SECRET_KEY=test ./run.py
ESI_CLIENT_ID='c1l2i3e4n5t6_7i8d'
ESI_SECRET='1s2e3c4r5e6t7'
ESI_CALLBACK_URL='http://localhost:5000/probleme_callback'
./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>
source ./aes-env/bin/activate
python3 ./sde.py ~/Downloads/sde-20180110-TRANQUILITY.zip
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