def fetch_image(release): d = release.data if "images" not in d: return None uri = d["images"][0]["uri"] hashuri = base64.b64encode(uri) if os.path.exists(util.userfile(hashuri)): imgdata = open(util.userfile(hashuri)).read() else: imgdata = urllib.urlopen(uri).read() open(util.userfile(hashuri), "wb").write(imgdata) return imgdata
import sqlite3 import util import cPickle as pickle import os import datetime db_file = util.userfile("discogs.db") create_flag = not os.path.exists(db_file) conn = sqlite3.connect(db_file) # fetch rows as dictionaries conn.row_factory = sqlite3.Row # default 7 days maximum data age max_age = 7 if create_flag: print "Creating new database." c = conn.cursor() c.execute('''CREATE TABLE responses (key TEXT PRIMARY KEY, last_update TEXT, data BLOB)''') c.execute('''CREATE TABLE posted (id INTEGER PRIMARY KEY, price REAL, count INTEGER, sales_hi REAL, sales_lo REAL, sales_avg REAL, sales_mdn REAL, date TEXT)''') conn.commit()