def setup_tbl():
Person.create_table(fail_silently=True)
Company.create_table(fail_silently=True)
Payment.create_table(fail_silently=True)
Tariff.create_table(fail_silently=True)
Point.create_table(fail_silently=True)
Bike.create_table(fail_silently=True)
ReservationState.create_table(fail_silently=True)
Reservation.create_table(fail_silently=True)
def main(argv):
db.connect()
try:
Person.drop_table()
except sqlite3.OperationalError:
pass
Person.create_table()
with open(argv[1]) as f:
csv_file = DictReader(f)
for line in csv_file:
attrs = {
'trac_id': float(line['TRAC Assigned Identifier for Individual'].strip()),
'nationality': line['Nationality'].strip(),
'gender': line['Gender'].strip(),
}
try:
person = Person.select().where((Person.trac_id == attrs['trac_id']) & (Person.nationality == attrs['nationality'])).get()
except Person.DoesNotExist:
person = Person.create(**attrs)
def create_db_table(args):
Person.create_table()
Gender.create_table()
Gender.create(gender='m')
Gender.create(gender='w')
print('Table was created')
person.save()
return redirect(url_for('index'))
return render_template('edit.html', form=form, person=person)
@app.route('/delete/<int:id>', methods=['GET', 'POST'], endpoint="delete")
def delete(id):
try:
person = Person.get(Person.id == id)
except Person.DoesNotExist:
abort(404)
if request.method == 'POST':
person.delete_instance()
if request.is_xhr:
return jsonify(success=True, person=person.serialize())
else:
return redirect(url_for('index'))
return render_template('delete.html', person=person)
@app.errorhandler(404)
def page_not_found(error):
return render_template('404.html'), 404
if __name__ == "__main__":
Person.create_table(fail_silently=True)
app.run()
def insert_persons(persons):
Person.create_table()
pf = PersonFactory()
for p in persons:
p = pf.create_from_json(p)
p.save()
