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()