These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

static data in yaml ?

First post
Author
Previous Topic Next Topic
guigui lechat
the no fock given
#1 - 2017-03-14 13:43:23 UTC
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.
#2 - 2017-03-14 14:17:15 UTC
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
#3 - 2017-03-14 14:24:27 UTC
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
#4 - 2017-03-14 17:06:09 UTC
Althalus Stenory
Flying Blacksmiths
#5 - 2017-03-15 12:03:36 UTC  |  Edited by: Althalus Stenory
If you are using 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
#6 - 2017-03-15 12:25:44 UTC
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
#7 - 2017-03-15 13:53:11 UTC  |  Edited by: Steve Ronuken
Chruker is _significantly_ out of date. As in 2 years out of date.



The SDE is available directly from CCP in yaml. Not formatted as you want, but that's due to it mostly being an intermediate format, to be loaded back into a database. (it's easy to version control yaml. not so much for a database)

developers.eveonline.com, on the resources page.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
guigui lechat
the no fock given
#8 - 2017-03-15 16:00:23 UTC
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
#9 - 2017-03-15 19:52:06 UTC
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 - 2017-03-15 20:36:05 UTC
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#11 - 2017-03-15 23:15:18 UTC
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
#12 - 2017-03-16 03:47:40 UTC  |  Edited by: guigui lechat
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
#13 - 2017-03-16 14:15:50 UTC
guigui lechat wrote:
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.



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