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