else:
album_id = res[0]
cur.execute("insert or ignore into artists (name) values (?)", (artist,))
cur.execute("insert or ignore into links (url, album_id) values (?,?)", (link, album_id))
#cur.execute("insert or ignore into samples (url, album_id) values (?,?)", (sample, album_id))
db.commit()
cur.close()
##
if isDebug:
print "Link:", link
print "Artist:", artist
print "Album:", album
print "Desc:", desc
print "Year:",year
print "Sample:", sample
print
threads = chanscrape.getAllThreads("mu")
for thread in threads:
for post in thread['posts']:
parsePost(post)
util.webPrint("""<!doctype html>
<html>
<body>Scrape complete</body>
</html>
""")
print """<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>/mu/scrape</title>
<link rel="stylesheet" type="text/css" href="/static/style.css">
</head>
<body>
"""
form = cgi.FieldStorage()
# Warning: we assume that the above code will run without error
try:
form["q"] # Will raise KeyError if "q" does not exist
util.webPrint("<h1>Showing results for \"<i>%s</i>\":</h1><br />" % form["q"].value)
db = sqlite3.connect("muscrape.db")
c = db.cursor()
resultCount = 0
for row in c.execute("select * from albums where album_name like ?", ('%' + form["q"].value + '%',)):
util.webPrint("%s - %s" % (row[1], row[2]))
if row[3] != None:
util.webPrint("(%s)" % row[3])
util.webPrint("<br />")
util.webPrint('<a href="' + list(c.execute("select url from links where album_id=?", unicode(row[0])))[0][0] + '">Download</a> || <a href="/music/%s/%s/">Info</a><!--[User_Rating goes here]--><br />' % (cgi.escape(row[1], True), cgi.escape(row[2], True)))
util.webPrint("<br />")
resultCount += 1
if resultCount == 0:
print "<i>Sorry. No results were found.</i><br />"
c.close()
for link in cur.execute("select url from links where album_id=?", unicode(albumData[0])):
links.append(link[0])
samples = []
for sample in cur.execute("select url from samples where album_id=?", unicode(albumData[0])):
samples.append(sample[0])
# TODO: Fill in the data
print "Content-Type: text/html"
print
util.webPrint(
"""<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<link rel="stylesheet" type="text/css" href="/static/style.css">
<title>%s - %s</title>
</head>
<body>
%s - %s <br />
Year: %s <br />
Description: %s <br />
Samples: %s <br />
Download links: %s <br />
</body>
</html>
"""
% (artist, album, artist, album, year, desc, samples, links)
)
