ref: legacy
src/types/order_product.py
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
from . import db from datetime import datetime as dt class OrderProduct(db.Model): __tablename__ = "order_products" id = db.Column(db.Integer, primary_key = True) product_id = db.Column(db.Integer, db.ForeignKey('products.id'), nullable = False) order_id = db.Column(db.Integer, db.ForeignKey('orders.id'), nullable = False) quantity = db.Column(db.Integer, default = 1, nullable = False) created_at = db.Column(db.DateTime, default = dt.utcnow) updated_at = db.Column(db.DateTime, default = dt.utcnow) def __init__(self, order_id, product_id, quantity): self.order_id = order_id self.product_id = product_id self.quantity = quantity def create(self): db.session.add(self) db.session.commit() |