from wowapi.wowapi import WoWApi
import psycopg2
conn = psycopg2.connect("dbname=testdb user=vincent")
conn.set_client_encoding('UTF-8')
cur = conn.cursor()
api = WoWApi()
regions = ['eu', 'us',] # 'kr', 'tw', 'cn']
for reg in regions:
data = api.get_realm(reg)
for i in data['data']['realms']:
cur.execute(
"""
INSERT INTO realms (name, origin, rtype) VALUES (%s, %s, %s);""", (i[u'slug'], reg.upper(), i['type']))
conn.commit()
cur.close()
conn.close()
from StringIO import StringIO
from datetime import datetime
psycopg2.extensions.register_type(psycopg2.extensions.UNICODE)
psycopg2.extensions.register_type(psycopg2.extensions.UNICODEARRAY)
conn = psycopg2.connect("dbname=testdb user=vincent")
conn.set_client_encoding('UTF-8')
cur = conn.cursor()
realm_id = 135
cur.execute("""SELECT MAX(time) FROM auction_realm_tick WHERE realm_id=%s """, (realm_id,))
last = cur.fetchone()
print "heure actuelle %s" % datetime.now()
api = WoWApi()
auctions = {}
try:
auctions = api.get_auctions('eu','illidan', lastmodified=last[0])
except WoWApiExcept.NotModified:
print 'Not modified'
exit(0)
try:
cur.execute("""INSERT INTO auction_realm_tick (realm_id, time) VALUES (%s, %s);""", (realm_id, auctions['lastmodified']))
except:
print "Auctions already in DB for %s" % auctions['lastmodified']
exit(0)
print "%s Add auctions in DB for %s" % (datetime.now(), auctions['lastmodified'])
for faction in ('horde', 'alliance', 'neutral'):
