def store_activity_file_view():
##Flush DataBase
__clear_db__()
##
input_file = request.files.get('activity_file')
# read the file into memory
my_list = []
for line in input_file.readlines():
m = hashlib.md5()
m.update(line.strip().lower())
hashed = m.hexdigest()
patreon = PatreonModel(hash=hashed)
db_session.add(patreon)
my_list.append(hashed)
db_session.commit()
parameters = {
'title': 'Patreon Processing',
'relative_location': '..',
'name': '%s patreons loaded into the database' % (len(my_list))
}
return render_template('generic.mako', **parameters)
def __clear_db__():
all_records = PatreonModel.query.all()
for record in all_records:
record.query.delete()
db_session.commit()
