ciclos

ref: configuration

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