class Addproduct(db.Model): __searchable__ = ["name", "description"] id = db.Column(db.Integer, primary_key=True) name = db.Column(db.Text, nullable=False) price = db.Column(db.Numeric) discount = db.Column(db.Integer, default=0) stock = db.Column(db.Integer, nullable=False) colors = db.Column(db.Text, nullable=False) description = db.Column(db.Text, nullable=False) pub_date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'), nullable=False) brand = db.relationship('Brand', backref=db.backref('brands', lazy=True)) category_id = db.Column(db.Integer, db.ForeignKey('category.id'), nullable=False) category = db.relationship('Category', backref=db.backref('posts', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='img.jpg.png') image_2 = db.Column(db.String(150), nullable=False, default='img.jpg.png') image_3 = db.Column(db.String(150), nullable=False, default='img.jpg.png') def __repr__(self): return '<Addproduct %r>' % self.name
class Addproduct(db.Model): __seachbale__ = ['name', 'desc'] id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80), nullable=False) price = db.Column(db.Numeric(10, 2), nullable=False) discount = db.Column(db.Integer, default=0) stock = db.Column(db.Integer, nullable=False) colors = db.Column(db.Text, nullable=False) desc = db.Column(db.Text, nullable=False) pub_date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) category_id = db.Column(db.Integer, db.ForeignKey('category.id'), nullable=False) category = db.relationship('Category', backref=db.backref('categories', lazy=True)) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'), nullable=False) brand = db.relationship('Brand', backref=db.backref('brands', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='image1.jpg') image_2 = db.Column(db.String(150), nullable=False, default='image2.jpg') image_3 = db.Column(db.String(150), nullable=False, default='image3.jpg') def __repr__(self): return '<Addproduct %r>' % self.name
class User(UserMixin, db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(15), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) password_hash = db.Column(db.String(128)) password = db.Column(db.String(60), nullable=False) is_admin = db.Column(db.Boolean, nullable=False, default=False) purchases = db.relationship('Purchases', backref='buyer', lazy='dynamic') reviews_left = db.relationship( 'Reviews', backref='reviewer_details', lazy='dynamic') items_wishlisted = db.relationship( 'Wishlist', backref='wishlister', lazy='dynamic') def __repr__(self): return f"User('{self.username}','{self.email}')" @property def password(self): raise AttributeError('password is not a readable attribute') @password.setter def password(self, password): self.password_hash = generate_password_hash(password) def verify_password(self, password): return check_password_hash(self.password_hash, password)
class addHDD(db.Model): id = db.Column(db.Integer, primary_key = True, nullable = False) name = db.Column(db.String(30), nullable = False) model = db.Column(db.String(30), nullable = False) series = db.Column(db.String(30), nullable = False) Interface = db.Column(db.String(30), nullable = False) Capacity = db.Column(db.String(30), nullable = False) RPM = db.Column(db.String(30), nullable = False) Cache = db.Column(db.String(30), nullable = False) features = db.Column(db.String(30), nullable = False) Usage = db.Column(db.String(10), nullable = False) Form_Factor = db.Column(db.String(10)) Height = db.Column(db.String(10)) Width = db.Column(db.String(10)) Length = db.Column(db.String(10)) date_released = db.Column(db.String(20), nullable=False,default=datetime.utcnow) single_url = db.Column(db.String(30)) category_id = db.Column(db.Integer, db.ForeignKey('category.id'),nullable=False) category = db.relationship('Category',backref=db.backref('HDD_categories', lazy=True)) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'),nullable=False) brand = db.relationship('Brand',backref=db.backref('HDD_brands', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='image1.jpg') image_2 = db.Column(db.String(150), nullable=False, default='image2.jpg') image_3 = db.Column(db.String(150), nullable=False, default='image3.jpg') def __repr__(self): return '<addHDD %r>' % self.name
class addRAM(db.Model): id = db.Column(db.Integer, primary_key = True, nullable = False) name = db.Column(db.String(30), nullable = False) model = db.Column(db.String(30), nullable = False) series = db.Column(db.String(30), nullable = False) capacity = db.Column(db.String(30), nullable = False) mem_type = db.Column(db.String(30), nullable = False) speed = db.Column(db.String(30), nullable = False) voltage = db.Column(db.String(30), nullable = False) buff_reg = db.Column(db.String(30), nullable = False) heatspreader = db.Column(db.String(5), nullable = False) features = db.Column(db.String(1000), nullable = False) date_released = db.Column(db.String(20), nullable=False,default=datetime.utcnow) single_url = db.Column(db.String(30)) category_id = db.Column(db.Integer, db.ForeignKey('category.id'),nullable=False) category = db.relationship('Category',backref=db.backref('RAM_categories', lazy=True)) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'),nullable=False) brand = db.relationship('Brand',backref=db.backref('RAM_brands', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='image1.jpg') image_2 = db.Column(db.String(150), nullable=False, default='image2.jpg') image_3 = db.Column(db.String(150), nullable=False, default='image3.jpg') def __repr__(self): return '<addRAM %r>' % self.name
class addCase(db.Model): id = db.Column(db.Integer, primary_key = True, nullable = False) name = db.Column(db.String(30), nullable = False) model = db.Column(db.String(30), nullable = False) series = db.Column(db.String(30), nullable = False) case_type = db.Column(db.String(30), nullable = False) color = db.Column(db.String(30), nullable = False) case_material = db.Column(db.String(30), nullable = False) power_supply = db.Column(db.String(30), nullable = False) Motherboard_Compatibility = db.Column(db.String(30), nullable = False) External_525_Drive_Bays = db.Column(db.String(10), nullable = False) External_35_Drive_Bays = db.Column(db.String(10)) External_25_Drive_Bays = db.Column(db.String(10)) Expansion_Slots = db.Column(db.String(10)) Front_Ports = db.Column(db.String(10)) Fan_Options = db.Column(db.String(50)) Radiator_Options = db.Column(db.String(30)) Max_GPU_Length= db.Column(db.String(10)) Max_CPU_Cooler_Height = db.Column(db.String(10)) features = db.Column(db.String(1000)) Dimensions_HxWxD = db.Column(db.String(10), nullable = False) Weight = db.Column(db.String(10), nullable = False) date_released = db.Column(db.String(20), nullable=False,default=datetime.utcnow) single_url = db.Column(db.String(30)) category_id = db.Column(db.Integer, db.ForeignKey('category.id'),nullable=False) category = db.relationship('Category',backref=db.backref('Case_categories', lazy=True)) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'),nullable=False) brand = db.relationship('Brand',backref=db.backref('Case_brands', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='image1.jpg') image_2 = db.Column(db.String(150), nullable=False, default='image2.jpg') image_3 = db.Column(db.String(150), nullable=False, default='image3.jpg')
class addCPU(db.Model): id = db.Column(db.Integer, primary_key = True, nullable = False) name = db.Column(db.String(30), nullable = False) model = db.Column(db.String(30), nullable = False) series = db.Column(db.String(30), nullable = False) cpu_type = db.Column(db.String(30), nullable = False) socket_type = db.Column(db.String(30), nullable = False) num_core = db.Column(db.String(30), nullable = False) num_threads = db.Column(db.String(30), nullable = False) frequency = db.Column(db.String(30), nullable = False) l1 = db.Column(db.String(10)) l2 = db.Column(db.String(10)) l3 = db.Column(db.String(10)) Manufacturing_Tech = db.Column(db.String(5), nullable=False) mem_type = db.Column(db.String(10), nullable = False) mem_channel = db.Column(db.Integer, nullable = False) PCI_Revision = db.Column(db.String(10), nullable = False) power = db.Column(db.String(10), nullable = False) features = db.Column(db.String(1000)) date_released = db.Column(db.String(20), nullable=False,default=datetime.utcnow) single_url = db.Column(db.String(30)) category_id = db.Column(db.Integer, db.ForeignKey('category.id'),nullable=False) category = db.relationship('Category',backref=db.backref('CPU_categories', lazy=True)) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'),nullable=False) brand = db.relationship('Brand',backref=db.backref('CPU_brands', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='image1.jpg') image_2 = db.Column(db.String(150), nullable=False, default='image2.jpg') image_3 = db.Column(db.String(150), nullable=False, default='image3.jpg')
class addAirCooling(db.Model): id = db.Column(db.Integer, primary_key = True, nullable = False) name = db.Column(db.String(30), nullable = False) model = db.Column(db.String(30), nullable = False) series = db.Column(db.String(30), nullable = False) cooler_type = db.Column(db.String(30), nullable = False) Fan_Size = db.Column(db.String(30), nullable = False) Socket_Compatibility = db.Column(db.String(100), nullable = False) RPM = db.Column(db.String(30), nullable = False) Noise_Level = db.Column(db.String(30), nullable = False) Power_Connector = db.Column(db.String(10), nullable = False) Color = db.Column(db.String(10)) LED = db.Column(db.String(10)) Heatsink_Material = db.Column(db.String(10)) Fan_Dimensions = db.Column(db.String(10)) Heatsink_Dimensions = db.Column(db.String(50)) Weight = db.Column(db.String(30)) features = db.Column(db.String(1000)) date_released = db.Column(db.String(20), nullable=False,default=datetime.utcnow) single_url = db.Column(db.String(30)) category_id = db.Column(db.Integer, db.ForeignKey('category.id'),nullable=False) category = db.relationship('Category',backref=db.backref('AirCooler_categories', lazy=True)) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'),nullable=False) brand = db.relationship('Brand',backref=db.backref('AirCooler_brands', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='image1.jpg') image_2 = db.Column(db.String(150), nullable=False, default='image2.jpg') image_3 = db.Column(db.String(150), nullable=False, default='image3.jpg') def __repr__(self): return '<addAirCooler %r>' % self.name
class Venta(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80), nullable=False) precio = db.Column(db.String(80), nullable=False) total = db.Column(db.String(80), nullable=False) cliente_id = db.Column(db.Integer, db.ForeignKey('cliente.id'), nullable=False) cliente = db.relationship('Cliente', backref=db.backref('cliente', lazy=True)) vendedor_id = db.Column(db.Integer, db.ForeignKey('vendedor.id'), nullable=False) vendedor = db.relationship('Vendedor', backref=db.backref('vendedor', lazy=True)) addproduct_id = db.Column(db.Integer, db.ForeignKey('addproduct.id'), nullable=False) addproduct = db.relationship('Addproduct', backref=db.backref('addproduct', lazy=True)) def __repr__(self): return '<Venta %r>' % self.name
class addWaterCooling(db.Model): id = db.Column(db.Integer, primary_key = True, nullable = False) name = db.Column(db.String(30), nullable = False) model = db.Column(db.String(30), nullable = False) series = db.Column(db.String(30), nullable = False) cooler_type = db.Column(db.String(30), nullable = False) Block_Compatibility = db.Column(db.String(30), nullable = False) Block_Dim = db.Column(db.String(30), nullable = False) Pump_Dim = db.Column(db.String(30), nullable = False) Pump_Noise = db.Column(db.String(30), nullable = False) Radiator_Dim = db.Column(db.String(10), nullable = False) Radiator_Material = db.Column(db.String(10)) Fan_Size = db.Column(db.String(10)) Fan_Dim = db.Column(db.String(10)) Fan_RPM = db.Column(db.String(10)) Fan_Air_Flow = db.Column(db.String(50)) Fan_Noise = db.Column(db.String(30)) Fan_Connector = db.Column(db.String(10)) Fan_Color = db.Column(db.String(10)) Input_Current = db.Column(db.String(10), nullable = False) date_released = db.Column(db.String(20), nullable=False,default=datetime.utcnow) single_url = db.Column(db.String(30)) category_id = db.Column(db.Integer, db.ForeignKey('category.id'),nullable=False) category = db.relationship('Category',backref=db.backref('WaterCooling_categories', lazy=True)) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'),nullable=False) brand = db.relationship('Brand',backref=db.backref('Water_Cooling_brands', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='image1.jpg') image_2 = db.Column(db.String(150), nullable=False, default='image2.jpg') image_3 = db.Column(db.String(150), nullable=False, default='image3.jpg') def __repr__(self): return '<addWaterCooling %r>' % self.name
class Addproduct(db.Model): # Añadir producto y caracteristicas a la BBDD __searchable__ = ['name', 'desc'] id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80), nullable=False) price = db.Column(db.Numeric(10, 2), nullable=False) cost = db.Column(db.Numeric(10, 2)) discount = db.Column(db.Integer, default=0) stock = db.Column(db.Integer, nullable=False) sells = db.Column(db.Integer, nullable=True) colors = db.Column(db.Text, nullable=False) description = db.Column(db.Text, nullable=False) pub_date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'), nullable=False) brand = db.relationship('Brand', backref=db.backref('brands', lazy=True)) category_id = db.Column(db.Integer, db.ForeignKey('category.id'), nullable=False) category = db.relationship('Category', backref=db.backref('posts', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='image.jpg') image_2 = db.Column(db.String(150), nullable=False, default='image.jpg') image_3 = db.Column(db.String(150), nullable=False, default='image.jpg') def __repr__(self): return '<Post %r>' % self.name
class Addproduct(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80), nullable=False) price = db.Column(db.Integer, nullable=False) discount = db.Column(db.Integer, default=None) stock = db.Column(db.Integer, nullable=False) origin = db.Column(db.Text, nullable=False) condition = db.Column(db.String(80), nullable=False) description = db.Column(db.Text, nullable=False) install_service = db.Column(db.String(10), nullable=False) colors = db.Column(db.Text, nullable=True) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'), nullable=True) brand = db.relationship('Brand', backref=db.backref('brands', lazy=True)) category_id = db.Column(db.Integer, db.ForeignKey('category.id'), nullable=True) category = db.relationship('Category', backref=db.backref('category', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='image.jpg') image_2 = db.Column(db.String(150), nullable=True, default='image.jpg') image_3 = db.Column(db.String(150), nullable=True, default='image.jpg') certificate = db.Column(db.String(150), nullable=True) def __repr__(self): return '<Addproduct %r>' % self.name
class Categories(db.Model): id = db.Column(db.Integer, primary_key=True) category_name = db.Column(db.String(40),nullable=False) create_date = db.Column(db.DateTime, nullable=False, default=datetime.datetime.utcnow) delete_date = db.Column(db.DateTime, nullable=False, default=datetime.datetime.utcnow) update_date = db.Column(db.DateTime, nullable=False, default=datetime.datetime.utcnow) category_product = db.relationship('Products', backref='category_product', lazy='select') category_warehouse = db.relationship('Warehouse', backref='category_warehouse', lazy='select')
class Orders(db.Model): id = db.Column(db.Integer, primary_key=True) Order_date = db.Column(db.DateTime, nullable=False, default=datetime.datetime.utcnow) create_date = db.Column(db.DateTime, nullable=False, default=datetime.datetime.utcnow) delete_date = db.Column(db.DateTime, nullable=False, default=datetime.datetime.utcnow) update_date = db.Column(db.DateTime, nullable=False, default=datetime.datetime.utcnow) order_order_details = db.relationship('Order_detail', backref='order_order_details', lazy='select') order_shipper = db.relationship('Shipper', backref='order_shipper', lazy='select') user_id = db.Column(db.Integer, db.ForeignKey('users.id'))
class Specs(db.Model): id = db.Column(db.Integer, primary_key=True) category_id = db.Column(db.Integer, db.ForeignKey('category.id'), nullable=False) category = db.relationship('Category', backref=db.backref('cat', lazy=True)) subcategory_id = db.Column(db.Integer, db.ForeignKey('subcategories.id')) subcategory = db.relationship('Subcategories', backref=db.backref('subcat', lazy=True)) name = db.Column(db.String(30), unique=True, nullable=False) def __repr__(self): return '<Specs %r>' % self.name
class Cart(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) user = db.relationship('User', backref='user', lazy=True, uselist=False) products = db.relationship('Product', secondary=association_table, backref='products', lazy=True) ordered = db.Column(db.Boolean, default=False) @property def total_price(self): return sum([i.price for i in self.products]) def __repr__(self): return '\n'.join([i.__repr__ for i in self.products])
class Maker(db.Model): id = db.Column(db.Integer, primary_key=True) Name = db.Column(db.String(20), nullable=False) items = db.relationship('Item', backref='maker', lazy=True) def __repr__(self): return f"Maker('{self.first_name}', '{self.last_name}')"
class Good(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(80)) quantity = db.Column(db.Integer) content = db.Column(db.String(512)) type_name = db.Column(db.String(80), db.ForeignKey('good_type.name')) purchase_price = db.Column(db.Float) trade_price = db.Column(db.Float) retail_price = db.Column(db.Float) good_url = db.Column(db.String(512)) warehouse_name = db.Column(db.String(80), db.ForeignKey('warehouse.name')) images = db.relationship('Image', backref='good', lazy='dynamic') def __init__(self, name, quantity, content, type_name, purchase_price, trade_price, retail_price, good_url, warehouse_name): self.name = name self.quantity = quantity self.content = content self.type_name = type_name self.purchase_price = purchase_price self.trade_price = trade_price self.retail_price = retail_price self.good_url = good_url self.warehouse_name = warehouse_name def __repr__(self): return '<Good %s %d %s>' % (self.name, self.quantity, self.content)
class Manufacturer(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30),nullable=False) phones = db.relationship('Phone', backref='manufacturer', lazy=True) def __repr__(self): return f"Manufacturer('{self.name}')"
class Addproduct(db.Model): __seachbale__ = ['name', 'desc'] id = db.Column(db.Integer, primary_key=True) T_Title = db.Column(db.String(80), nullable=False) gamename = db.Column(db.String(80), nullable=False) Game_Mode = db.Column(db.String(80), nullable=False) Tournament_Type = db.Column(db.String(80), nullable=False) Tournament_Title = db.Column(db.String(80), nullable=False) Prize_Pot = db.Column(db.Numeric(10, 2), nullable=False) Entery_Cost = db.Column(db.Numeric(10, 2), nullable=False) Maximum_Participants = db.Column(db.Numeric(10), nullable=False) Minimum_Participants = db.Column(db.Numeric(10), nullable=False) Enroled_Participants = db.Column(db.Numeric(10), nullable=False) Platform = db.Column(db.String(80), nullable=False) Starting_Date = db.Column(db.String(80), nullable=False) Tournament_Time = db.Column(db.String(80), nullable=False) Game_Settings = db.Column(db.String(80), nullable=False) Rule_Group = db.Column(db.String(80), nullable=False) Number_Of_Rounds = db.Column(db.String(80), nullable=False) Region = db.Column(db.String(80), nullable=False) name = db.Column(db.String(80), nullable=False) price = db.Column(db.Numeric(10, 2), nullable=False) discount = db.Column(db.Integer, default=0) stock = db.Column(db.Integer, nullable=False) colors = db.Column(db.Text, nullable=False) size = db.Column(db.Text, nullable=False) descrip = db.Column(db.Text, nullable=False) pub_date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) category_id = db.Column(db.Integer, db.ForeignKey('category.id'), nullable=False) category = db.relationship('Category', backref=db.backref('categories', lazy=True)) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'), nullable=False) brand = db.relationship('Brand', backref=db.backref('brands', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='image1.jpg') image_2 = db.Column(db.String(150), nullable=False, default='image2.jpg') image_3 = db.Column(db.String(150), nullable=True, default='image3.jpg') def __repr__(self): return '<Post %r>' % self.name
class addPSU(db.Model): id = db.Column(db.Integer, primary_key=True, nullable=False) name = db.Column(db.String(30), nullable=False) model = db.Column(db.String(30), nullable=False) series = db.Column(db.String(30), nullable=False) PSU_type = db.Column(db.String(30), nullable=False) max_power = db.Column(db.String(30), nullable=False) fans = db.Column(db.String(30), nullable=False) Main_Connector = db.Column(db.String(30), nullable=False) rail_12v = db.Column(db.String(30), nullable=False) PCI_Express_Connector = db.Column(db.String(10), nullable=False) SATA_Power_Connector = db.Column(db.String(10)) SLI = db.Column(db.String(10)) Modular = db.Column(db.String(10)) CrossFire = db.Column(db.String(10)) Efficiency = db.Column(db.String(50)) Energy_Efficient = db.Column(db.String(30)) Input_Voltage = db.Column(db.String(10)) Input_Frequency_Range = db.Column(db.String(10)) Input_Current = db.Column(db.String(10), nullable=False) Output = db.Column(db.String(30), nullable=False) MTBF = db.Column(db.String(30), nullable=False) Dimensions = db.Column(db.String(30), nullable=False) Max_PSU_Length = db.Column(db.String(30), nullable=False) features = db.Column(db.String(1000)) connectors = db.Column(db.String(100)) Weight = db.Column(db.String(10), nullable=False) date_released = db.Column(db.String(20), nullable=False, default=datetime.utcnow) single_url = db.Column(db.String(30)) category_id = db.Column(db.Integer, db.ForeignKey('category.id'), nullable=False) category = db.relationship('Category', backref=db.backref('PSU_categories', lazy=True)) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'), nullable=False) brand = db.relationship('Brand', backref=db.backref('PSU_brands', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='image1.jpg') image_2 = db.Column(db.String(150), nullable=False, default='image2.jpg') image_3 = db.Column(db.String(150), nullable=False, default='image3.jpg') def __repr__(self): return '<addPSU %r>' % self.name
class Addproduct(db.Model): __seachbale__ = ['name', 'desc'] id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80), nullable=False) model = db.Column(db.String(80), nullable=False) CPU_type = db.Column(db.String(80), nullable=False) cpu_socket = db.Column(db.String(30)) chipset = db.Column(db.String(80), nullable=False) mem_slots = db.Column(db.String(80), nullable=False) max_mem = db.Column(db.String(80), nullable=False) channels = db.Column(db.String(80), nullable=False) PCI = db.Column(db.String(500), nullable=False) storage = db.Column(db.String(80), nullable=False) audio_chipset = db.Column(db.String(80), nullable=False) audio_channels = db.Column(db.String(80), nullable=False) LAN_chipset = db.Column(db.String(80), nullable=False) form_factor = db.Column(db.String(80), nullable=False) features = db.Column(db.String(1000), nullable=False) single_url = db.Column(db.String(30)) release_date = db.Column(db.String(20), nullable=False, default=datetime.utcnow) #price = db.Column(db.Numeric(10,2), nullable=False) #discount = db.Column(db.Integer, default=0) #stock = db.Column(db.Integer, nullable=False) #colors = db.Column(db.Text, nullable=False) #discription = db.Column(db.Text, nullable=False) #desc = db.Column(db.Text, nullable=False) #pub_date = db.Column(db.DateTime, nullable=False,default=datetime.utcnow) #CPU_type_id = db.Column(db.Integer, db.ForeignKey('CPU_type.id'), nullable=False) #CPU_type = db.relationship('CPU_type', backref=db.backref('CPU_type'), lazy=True) category_id = db.Column(db.Integer, db.ForeignKey('category.id'), nullable=False) category = db.relationship('Category', backref=db.backref('categories', lazy=True)) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'), nullable=False) brand = db.relationship('Brand', backref=db.backref('brands', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='image1.jpg') image_2 = db.Column(db.String(150), nullable=False, default='image2.jpg') image_3 = db.Column(db.String(150), nullable=False, default='image3.jpg') def __repr__(self): return '<Post %r>' % self.name
class Producer(db.Model): id = db.Column(db.Integer, primary_key=True) first_name = db.Column(db.String(20),nullable=False) last_name = db.Column(db.String(30),nullable=False) movie = db.relationship('Movie', backref='producer', lazy=True) def __repr__(self): return f"Producer('{self.first_name}', '{self.last_name}')"
class ProductCategory(db.Model): __tablename__ = "product_categories" id = db.Column(db.Integer, primary_key=True) product_id = db.Column(db.Integer, db.ForeignKey("products.id")) category_id = db.Column(db.Integer, db.ForeignKey("categories.id")) product = db.relationship("Product", backref=db.backref("product_categories"))
class Order(db.Model): id = db.Column(db.Integer, primary_key=True) cart_id = db.Column(db.Integer, db.ForeignKey('cart.id'), nullable=False) cart = db.relationship('Cart', backref='cart', lazy=True, uselist=False) first_name = db.Column(db.String(100), nullable=False) last_name = db.Column(db.String(100), nullable=False) shipping_address = db.Column(db.String(100), nullable=False) closed = db.Column(db.Boolean, default=False)
class Category(db.Model): __tablename__ = "categories" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String, unique=True) products = db.relationship("Product", secondary="product_categories", backref=db.backref("categories"))
class Author(db.Model): id = db.Column(db.Integer, primary_key=True) first_name = db.Column(db.String(20),nullable=False) last_name = db.Column(db.String(30),nullable=False) books = db.relationship('Book', backref='author', lazy=True) def __repr__(self): return f"Author('{self.first_name}', '{self.last_name}')"
class Florist(db.Model): id = db.Column(db.Integer, primary_key=True) first_name = db.Column(db.String(20), nullable=False) last_name = db.Column(db.String(30), nullable=False) flowers = db.relationship('Flower', backref='florist', lazy=True) def __repr__(self): return f"Florist('{self.first_name}', '{self.last_name}')"
class addGraphicCard(db.Model): id = db.Column(db.Integer, primary_key=True, nullable=False) name = db.Column(db.String(30), nullable=False) model = db.Column(db.String(30), nullable=False) interface = db.Column(db.String(30), nullable=False) Chipset_Manufacturer = db.Column(db.String(30), nullable=False) GPU = db.Column(db.String(30), nullable=False) Boost_Clock = db.Column(db.String(30), nullable=False) Memory_Size = db.Column(db.String(30), nullable=False) Memory_Interface = db.Column(db.String(30), nullable=False) Memory_Type = db.Column(db.String(10)) DirectX = db.Column(db.String(10)) HDMI = db.Column(db.String(10)) Multi_Monitor = db.Column(db.String(10)) Display_Port = db.Column(db.String(30)) max_res = db.Column(db.String(30)) vr_ready = db.Column(db.String(10)) cooler = db.Column(db.String(10)) power = db.Column(db.String(10), nullable=False) req = db.Column(db.String(50), nullable=False) power_connector = db.Column(db.String(10)) single_url = db.Column(db.String(30)) features = db.Column(db.String(1000), nullable=False) dimentions = db.Column(db.String(10), nullable=False) date_released = db.Column(db.String(20), nullable=False, default=datetime.utcnow) category_id = db.Column(db.Integer, db.ForeignKey('category.id'), nullable=False) category = db.relationship('Category', backref=db.backref('GraphicCard_categories', lazy=True)) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'), nullable=False) brand = db.relationship('Brand', backref=db.backref('GraphicCard_brands', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='image1.jpg') image_2 = db.Column(db.String(150), nullable=False, default='image2.jpg') image_3 = db.Column(db.String(150), nullable=False, default='image3.jpg') def __repr__(self): return '<addGraphicCard %r>' % self.name
class AccountUser(db.Model, UserMixin): __tablename__ = "account_users" id = db.Column(db.Integer, primary_key=True) email = db.Column(db.String, unique=True) first_name = db.Column(db.String) last_name = db.Column(db.String) account_roles = db.relationship('AccountRole', secondary='roles_users')