def edit_collection_route(): options = {"year": datetime.datetime.now().year} options = authenticate(options) collection = request.args.get('collection') if request.method == 'GET': img_data = query("SELECT * from Images WHERE collection = '" + collection + "'") options['images'] = img_data return render_template("editCollection.html", **options) elif request.method == 'POST': if request.form['op'] == 'add': file = request.files['file'] comment = request.form['comment'] if file.filename != '': if file and allowed_file(file.filename): m = hashlib.md5( (file.filename + collection + str(datetime.datetime.now())).encode('utf-8')) hashed = m.hexdigest() get_extension = file.filename.rsplit('.', 1)[1].lower() new_filename = hashed + "." + get_extension filename = secure_filename(new_filename) carousel = '1' if request.form.getlist('carousel'): carousel = '0' conn = tinys3.Connection(s3_key, s3_skey, tls=True) conn.upload(new_filename, file, 'janehardystudio') query( "INSERT INTO Images(id, format, caption, collection, carousel) VALUES \ ('" + hashed + "', '" + get_extension + "','" + comment + "','" + collection + "','" + carousel + "')") return redirect( url_for('collection.edit_collection_route', collection=collection))
def main_route(): options = {"year": datetime.datetime.now().year} options = authenticate(options) data = query("SELECT * from Collections ORDER BY created_time;") options['collections'] = data slides = query( "SELECT * FROM Images WHERE carousel = '0' ORDER BY created_time;") options['slides'] = slides return render_template("index.html", **options)
def gallery_route(collection): options = {"year": datetime.datetime.now().year} options = authenticate(options) data = query("SELECT * from Collections ORDER BY created_time;") images = query("SELECT * FROM Images WHERE collection =\"" + str(collection) + "\" ORDER BY created_time;") options['collections'] = data options['images'] = images return render_template("gallery.html", **options)
def create_collection_route(): options = {"year": datetime.datetime.now().year} options = authenticate(options) if request.method == 'GET': data = query("SELECT * from Collections ORDER BY created_time DESC") options['collections'] = data return render_template("addCollect.html", **options) elif request.method == 'POST': new_collection = request.form['new_collection'] m = hashlib.new('md5') m.update(str(new_collection).encode('utf-8')) query("INSERT INTO Collections(title, size) values ('" + new_collection + "'" + ",'" + str(0) + "')") data = query("SELECT * from Collections ORDER BY created_time DESC") options['collections'] = data return render_template("addCollect.html", **options) else: return render_template("404.html")
def contact_route(): options = {"year": datetime.datetime.now().year} options = authenticate(options) data = query("SELECT * from Collections ORDER BY created_time DESC") options['collections'] = data return render_template("contact.html", **options)