class Transactions(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) create_on = db.Column(db.DateTime, nullable=False) def __init__(self): self.create_on = datetime.now()
class Products(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.Integer, nullable=False) price = db.Column(db.Integer, nullable=False) stock = db.Column(db.Integer, nullable=False)
class Transactions(db.Model): customer_transaction_id = db.Column(db.Integer, primary_key=True, autoincrement=True) event_time = db.Column(db.DateTime, nullable=False) def __init__(self): self.event_time = datetime.now()
class Products(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(45), nullable=False) price = db.Column(db.Integer, nullable=False) stock = db.Column(db.Integer, nullable=False) event_time = db.Column(db.DateTime, nullable=False) def __init__(self): self.event_time = datetime.now()
class TransactionProducts(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) transaction_id = db.Column(db.Integer, db.ForeignKey("transactions.id"), nullable=False) product_id = db.Column(db.Integer, db.ForeignKey("products.id"), nullable=False) product_qty = db.Column(db.Integer, nullable=False) transaction = relationship("Transactions", backref="transaction_products") product = relationship("Products", backref="transaction_products")
class TransactionProducts(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) transaction_id = db.Column(db.Integer, db.ForeignKey("transactions.customer_transaction_id"), nullable=False) product_id = db.Column(db.Integer, db.ForeignKey("products.id"), nullable=False) product_qty = db.Column(db.Integer, nullable=False) transaction = relationship("Transactions", backref="transaction_products") #transaction = relationship("Transactions") #product = relationship("Products", backref="transaction_products") product = relationship("Products") event_time = db.Column(db.DateTime, nullable=False) def __init__(self): self.event_time = datetime.now()
class TB_user(db.Model): id_user = db.Column(db.Integer, primary_key=True, autoincrement=True) first_name = db.Column(db.String(100), nullable=False) last_name = db.Column(db.String(100), nullable=False) username = db.Column(db.String(50), nullable=False) password = db.Column(db.String(120), nullable=False) email = db.Column(db.String(50), nullable=False) def __init__(self, username, password, email): self.username = username self.password = password self.email = email self.registered_on = datetime.utcnow() def is_authenticated(self): return True def is_active(self): return True def is_anonymous(self): return False def get_id(self): return unicode(self.id) def __repr__(self): return '<User %r>' % (self.username)
class tb_user(db.Model): id_user = db.Column(db.Integer, primary_key=True, autoincrement=True) first_name = db.Column(db.String(100), nullable=False) last_name = db.Column(db.String(100), nullable=False)