def album(albumname, userkey):
# returns album informations including users, images
db = get_db()
cur = db.cursor()
cur.execute("SELECT name, soundcloud_url FROM album WHERE url=?",
(albumname, ))
album_info = cur.fetchone()
if album_info is None:
raise HTTPError(404, "album not existing")
if check_user_on_album(userkey, albumname) is None:
raise HTTPError(403, "user not on album")
album_users = []
cur = db.cursor()
cur.execute("SELECT email FROM users WHERE album_url=?", (albumname, ))
user_emails = cur.fetchall()
for user_email in user_emails:
album_users.append(user_email[0])
album_images = []
cur = db.cursor()
cur.execute(
"SELECT images.path, users.email, images.size FROM images, users WHERE images.album_url=? AND users.key = images.users_key",
(albumname, ))
db_album_images = cur.fetchall()
hostname = request.get_header('host')
for album_image in db_album_images:
filename_parts = os.path.splitext(album_image[0])
thumb_name = filename_parts[0] + '.320' + filename_parts[1]
album_images.append({
'url': 'http://' + hostname + album_image[0],
'thumb320': 'http://' + hostname + thumb_name,
'size': album_image[2],
'uploader': album_image[1]
})
return {
"name":
album_info[0],
"soundcloud_url":
album_info[1],
"download_url":
'http://' + hostname + '/rest/album/' + albumname + '/' + userkey +
'/download/' + albumname + '.zip',
"users":
album_users,
"images":
album_images
}
def album(albumname, userkey):
# returns album informations including users, images
db = get_db()
cur = db.cursor()
cur.execute("SELECT name, soundcloud_url FROM album WHERE url=?", (albumname, ))
album_info = cur.fetchone()
if album_info is None:
raise HTTPError(404, "album not existing")
if check_user_on_album(userkey, albumname) is None:
raise HTTPError(403, "user not on album")
album_users = []
cur = db.cursor()
cur.execute("SELECT email FROM users WHERE album_url=?", (albumname, ))
user_emails = cur.fetchall()
for user_email in user_emails:
album_users.append(user_email[0])
album_images = []
cur = db.cursor()
cur.execute("SELECT images.path, users.email, images.size FROM images, users WHERE images.album_url=? AND users.key = images.users_key", (albumname, ))
db_album_images = cur.fetchall()
hostname = request.get_header('host')
for album_image in db_album_images:
filename_parts = os.path.splitext( album_image[0] )
thumb_name = filename_parts[0] + '.320' + filename_parts[1]
album_images.append({
'url': 'http://' + hostname + album_image[0],
'thumb320': 'http://' + hostname + thumb_name,
'size': album_image[2],
'uploader': album_image[1]
})
return {
"name": album_info[0],
"soundcloud_url": album_info[1],
"download_url": 'http://' + hostname + '/rest/album/' + albumname + '/' + userkey + '/download/' + albumname + '.zip',
"users": album_users,
"images": album_images
}
def downloadalbum(albumname, userkey, dummy):
db = get_db()
cur = db.cursor()
cur.execute("SELECT name, url FROM album WHERE url=?", (albumname, ))
album_info = cur.fetchone()
if album_info is None:
raise "album not existing"
if check_user_on_album(userkey, albumname) is None:
raise "user not on album"
album_path = './images/' + albumname + '/'
zip_file_path = zip_album(album_path, albumname)
size = os.path.getsize(zip_file_path)
mtime = os.path.getmtime(zip_file_path)
fd = open(zip_file_path, 'rb')
return send_file(fd, filename=albumname+'.zip', ctype='application/zip', size=size, timestamp=mtime)
