Menu

Updating Prices

Dave Drouin

The updateprices.py script can load your database with reasonable average meta item prices provided by Battleclinic. This is a good starting point. As Officer, Dead Space, Faction and Storyline items are now available on the market, you can then get up to date median prices as well for these from EVE Central. Here's how. From within the top level pykb source directory run this after installing your database and configuring the connection settings in here:

/home/ddrouin/pykb-code/pykb/conf/pykb.yml

./updateprices.py -sm '2012-05-10'
./updateprices.py -s '2012-05-11'
./updateprices.py

So assuming it's 5/12/2012 at roughly 8:00 p.m. EDT - seems to be around the time a new gzip daily archive is created by EVE Central, running the above will do the following:

-m tells it to go grab the meta item price sheet from Battleclinic and populate those item type prices as a starting point. The s tell it to then grab the EVE Central daily archive for the given date and select the median price for each item type, updating or adding to our price list as needed. The -s 2012-05-11 grabs the next day's archive and repeats the process - this may add a few more prices and will update most of the rest. Finally, if you're lucky the one for today will be there too - do the same.

So it's probably a good idea to set up a cron job to run this for a time when you generally see that there will be an EVE Central gzip file around - or just grab the previous day's as that'll always be there.


Related

Wiki: Aggregation
Wiki: Home
Wiki: MySQL Database Setup
Wiki: PostgreSQL Database Setup

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.