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()
