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'):