ref: products
src/types/product.py
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
from . import db from datetime import datetime as dt class Product(db.Model): __tablename__ = 'products' id = db.Column(db.Integer, primary_key = True) title = db.Column(db.String(256), nullable = False) description = db.Column(db.Text) group_id = db.Column(db.Integer, db.ForeignKey('groups.id'), nullable = False) category_id = db.Column(db.Integer, db.ForeignKey('product_categories.id'), nullable = False) created_at = db.Column(db.DateTime, default = dt.utcnow) updated_at = db.Column(db.DateTime, default = dt.utcnow) def __init__(self, title, description, group_id, category_id): self.title = title self.description = description self.group_id = group_id self.category_id = category_id def create(self): db.session.add(self) db.session.commit() def to_json(self): return { "title": self.title, "description": self.description, "group_id": self.group_id, "category_id": self.category_id, "created_at": self.created_at.__str__(), "updated_at": self.updated_at.__str__() } |