Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
guigui lechat
the no fock given
10
|
Posted - 2017.03.14 13:43:23 -
[1] - Quote
Hello. I would like to use data of - hulls - modules
typically something like
hulls: 74: name: vexor traits: - trait1 modules: high: 5 mid: 5 low: 4 attributes: pwr: 75.6 cpu: 0 speed: 103.6 modules: 12076: name: 50MN Microwarpdrive II slot: mid activation: cycle: 10 capa: 20 effect: - {speed:250, mass:+100kg, stacking: true} effect: - capa:-20 stacking: true
I can't find it in the various links provided. Does this data alredy exist? |
Blacksmoke16
Resilience.
47
|
Posted - 2017.03.14 14:17:15 -
[2] - Quote
It exists yes but would be a combination of various tables. Such as InvTypes to get the items and some dogma tables for the attributes.
Steve provides the conversions if you use MySQL etc.
https://www.fuzzwork.co.uk/dump/ |
guigui lechat
the no fock given
10
|
Posted - 2017.03.14 14:24:27 -
[3] - Quote
I don't use mysql, I want a yaml/json format - as specified in the title. Some data are available in yaml in the doc so I wonder if I could find the required data (in one or several tables) or if I need to create it. |
guigui lechat
the no fock given
10
|
Posted - 2017.03.14 17:06:09 -
[4] - Quote
I started importing it from chukker.
https://github.com/guiguilechat/EveOnline/blob/master/Database/src/main/resources/chrukerdump/hulls.yml
The code to dump is on the gihub. |
Althalus Stenory
Flying Blacksmiths
110
|
Posted - 2017.03.15 12:03:36 -
[5] - Quote
If you are doing it in java, why don't you use the sqlite export to get the data or to generate these yml/json ?
EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI
|
guigui lechat
the no fock given
10
|
Posted - 2017.03.15 12:25:44 -
[6] - Quote
Because I could not find an easy way to retrieve this data. sqlite needs to install a local DB, I'm not used to sqlite good-practice - while I am good with other librairies.
I make my project in two modules : - database store game data (and rules) - optimize allows to find the maximum value available for a ship given constraints
When this is done, I can compare effect of database modifications. and eg compare the values with 'stack penalized' modules using non-penalized additive instead of penalized multiplicative. |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6552
|
Posted - 2017.03.15 13:53:11 -
[7] - Quote
Chruker is _significantly_ out of date. As in 2 years out of date.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
guigui lechat
the no fock given
10
|
Posted - 2017.03.15 16:00:23 -
[8] - Quote
I downloaded the sde,
ok so I need to join the tables in - fsd/categoryIDs to get Module/Ship categories - fsd/groupIDs to get the corresponding groups - fsd/typeIDs.yaml to retrieve the basic data of the elements in those groups. - bsd/dgmAttributeTypes.yaml to filter the attributes I am interested in - bsd/dgmTypeAttributes to associate the attributes with the item
Of course I need to cache data and retrieve it from internet. working on it. |
guigui lechat
the no fock given
10
|
Posted - 2017.03.15 19:52:06 -
[9] - Quote
hmm how can I retrieve the yaml individually ? I feel like a waste of time to download the full zip and extract it locally, especially if a file is corrupted :/
I cache it locally ATM (actually cache the unzipped files) but that's meh :/ |
guigui lechat
the no fock given
10
|
Posted - 2017.03.15 20:36:05 -
[10] - Quote
started the dumpGǪ
https://github.com/guiguilechat/EveOnline/blob/master/Database/src/main/resources/SDEDump/dump.yaml |
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6553
|
Posted - 2017.03.15 23:15:18 -
[11] - Quote
I maintain a git repo of the SDE.
git://www.fuzzwork.co.uk/sde-tq.git
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
guigui lechat
the no fock given
10
|
Posted - 2017.03.16 03:47:40 -
[12] - Quote
do you give direct access, eg by http ? would be way easier for me to get it by URL. Because, dumping the full git (especially using java) may not be the most efficient way to do it. I have no issue unzipping the SDE to file, it only use the 30lines of donwloadSDE() ( https://github.com/guiguilechat/EveOnline/blob/master/Database/src/main/java/fr/guiguilechat/eveonline/database/retrieval/SDEDumper.java ) ; the issue is only to have to download a full zip in case of a small issue/modification. |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6556
|
Posted - 2017.03.16 14:15:50 -
[13] - Quote
I don't, no. Only the converted versions, and the git repo, which needs a git client.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |