Spent some time today using Python to parse a downloaded Eve-Central QuickLook API result, and to store the extracted orders in a MySQL database. To make it more interesting (and potentially more useful), I'm using the MySQLdb Python DB API implementation. A good reason for this is that EVE officially uses MSSQL as their DB servers, and makes their static data available as MSSQL DB dump. This can be loaded into a free-to-use version of MSSQL, so many people may be using this.
Currently I have Sell orders being inserted into the database, but I don't have them updating existing orders when newer data on an order is seen.
Currently I have Sell orders being inserted into the database, but I don't have them updating existing orders when newer data on an order is seen.
Archives



