db.init_app(app) class User(db.Model): """ A user model which defines the sql table """ id = db.Column(db.Integer, primary_key=True) email = db.Column(db.String(100), unique=True) password = db.Column(db.String(100)) name = db.Column(db.String(1000)) balance = db.Column(db.Numeric(10, 2), default=0) class Ticket(db.Model): """ A ticket model which defines a ticket """ id = db.Column(db.Integer, primary_key=True) user = db.Column(db.Integer) date = db.Column(db.Date()) name = db.Column(db.String(1000)) price = db.Column(db.Numeric(10, 2), default=0) quantity = db.Column(db.Integer(), default=0) # it creates all the SQL tables if they do not exist with app.app_context(): db.create_all() db.session.commit()
def create_sql_tables(): # it creates all the SQL tables if they do not exist with app.app_context(): db.create_all() db.session.commit()