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 Product(db.Model): __tablename__ = "products" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String) inventory_quantity = db.Column(db.Integer) price = db.Column(db.Numeric(8, 2)) weight = db.Column(db.Numeric(8, 2))
class Phone(db.Model): id = db.Column(db.Integer, primary_key=True) model = db.Column(db.String(50),nullable=False) description = db.Column(db.String(120), nullable=False) mass = db.Column(db.Numeric(10,2), nullable=False) ram = db.Column(db.Integer, nullable=False) release_date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) price = db.Column(db.Numeric(10,2), nullable=False) image_file = db.Column(db.String(30), nullable=False, default='default.jpg') stock_level = db.Column(db.Integer, nullable=False) manufacturer_id = db.Column(db.Integer, db.ForeignKey('manufacturer.id'), nullable=False) def __repr__(self): return f"Phone('{self.model}', '{self.description}', '{self.mass}', '{self.ram}', '{self.publication_date}', '{self.price}', '{self.stock_level}')"
class Book(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(200), nullable=False) category = db.Column(db.String(100), nullable=True) isbn = db.Column(db.String(50), nullable=False) publisher = db.Column(db.String(50), nullable=True) condition = db.Column(db.String(100), nullable=False) defects = db.Column(db.String(300), nullable=True) price = db.Column(db.Numeric(10, 2), nullable=False) shipping = db.Column(db.Numeric(10, 2), nullable=False) author = db.Column(db.String(100), nullable=True) cover = db.Column(db.String(100)) seller_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Book('{self.title}', '{self.price}')"
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 Review(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) username = db.Column(db.String(80), nullable=False) body = db.Column(db.String(200), nullable=False) rating = db.Column(db.Numeric(2, 1), default=0) timestamp = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) product_id = db.Column(db.Integer, db.ForeignKey('addproduct.id'), nullable=False)
class Order(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80), nullable=False) mobile_num = db.Column(db.Numeric(10, 2), nullable=False) quantity = db.Column(db.Integer, default=0) order_place = db.Column(db.String(1000), nullable=False) ddate = db.Column(db.DateTime, nullable=False, default=datetime.now) def __repr__(self): return '<Order %r>' % self.order_place
class Product(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30), nullable=False) price = db.Column(db.Numeric(10, 2), nullable=False) discount = db.Column(db.Integer, nullable=False, default=0) stock = db.Column(db.Integer, nullable=False) description = db.Column(db.String(300), nullable=False) color = db.Column(db.String(30), nullable=False) image_1 = db.Column(db.String(150), nullable=False, default='image.jpg') image_2 = db.Column(db.String(150), nullable=False, default='image.jpg')
class Item(db.Model): id = db.Column(db.Integer, primary_key=True) item_name = db.Column(db.String(50),nullable=False) description = db.Column(db.String(120), nullable=False) price = db.Column(db.Numeric(10,2), nullable=False) image_file = db.Column(db.String(30), nullable=False, default='default.jpg') stock_level = db.Column(db.Integer, nullable=False) maker_id = db.Column(db.Integer, db.ForeignKey('maker.id'), nullable=False) def __repr__(self): return f"Item('{self.item_name}', '{self.description}', '{self.price}', '{self.stock_level}')"
class Variant(db.Model): __tablename__ = "product_variants" id = db.Column(db.Integer, primary_key=True) product_id = db.Column(db.Integer, db.ForeignKey("products.id")) name = db.Column(db.String) inventory_quantity = db.Column(db.Integer) price = db.Column(db.Numeric(8, 2)) weight = db.Column(db.Numeric) product = db.relationship("Product", backref=db.backref("variants"))
class Game(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(50),nullable=False) description = db.Column(db.String(120), nullable=False) price = db.Column(db.Numeric(10,2), nullable=False) image_file = db.Column(db.String(30), nullable=False, default='default.jpg') stock_level = db.Column(db.Integer, nullable=False) company = db.Column(db.String(30), nullable=False) review = db.Column(db.String(250), nullable=False) def __repr__(self): return f"Book('{self.title}', '{self.description}', '{self.price}', '{self.stock_level}')"
class Book(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(50),nullable=False) description = db.Column(db.String(120), nullable=False) #publication_date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) price = db.Column(db.Numeric(10,2), nullable=False) image_file = db.Column(db.String(30), nullable=False, default='default.jpg') stock_level = db.Column(db.Integer, nullable=False) author_id = db.Column(db.Integer, db.ForeignKey('author.id'), nullable=False) def __repr__(self): return f"Book('{self.title}', '{self.description}', '{self.price}', '{self.stock_level}')"
class Record(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(100), nullable=False) artist = db.Column(db.String(100)) price = db.Column(db.Numeric(6, 2), nullable=False) description = db.Column(db.String(4000)) picture = db.Column(db.String(30), default='default.jpg') year = db.Column(db.Integer) genre = db.Column(db.String(30)) def __repr__(self): return f"Record('{self.name}', '{self.artist}')"
class W_item(db.Model): id = db.Column(db.Integer, primary_key=True) item_name = db.Column(db.String(50), nullable=False) description_1 = db.Column(db.String(120), nullable=False) description_2 = db.Column(db.String(120), nullable=False) price = db.Column(db.Numeric(10, 2), nullable=False) image_file = db.Column(db.String(30), nullable=False, default='default.jpg') size = db.Column(db.String(50), nullable=False, default='default.jpg') def __repr__(self): return f"Item('{self.item_name}', '{self.description_1}', '{self.description_2}', '{self.price}', '{self.size}')"
class BookSold(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(200), nullable=False) category = db.Column(db.String(100), nullable=True) isbn = db.Column(db.String(50), nullable=False) publisher = db.Column(db.String(50), nullable=True) condition = db.Column(db.String(100), nullable=False) defects = db.Column(db.String(300), nullable=True) price = db.Column(db.Numeric(10, 2), nullable=False) author = db.Column(db.String(100), nullable=True) cover = db.Column(db.String(100)) seller_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) buyer_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) posted = db.Column(db.Boolean, nullable=False, default=False)
class Book(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(50), nullable=False) description = db.Column(db.String(120), nullable=False) price = db.Column(db.Numeric(10, 2), nullable=False) image_file = db.Column(db.String(30), nullable=False, default='default.jpg') author_id = db.Column(db.Integer, db.ForeignKey('author.id'), nullable=False) def __repr__(self): return f"Book('{self.title}', '{self.description}', '{self.price}', '{self.stock_level}, '{self.purchase_counter}')"
class Product(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(50), nullable=False) description = db.Column(db.String(120), nullable=False) price = db.Column(db.Numeric(10, 2), nullable=False) image_file = db.Column(db.String(30), nullable=False, default='default.jpg') stock_level = db.Column(db.Integer, nullable=False) product_id = db.Column(db.Integer, db.ForeignKey('product.id'), nullable=False) def __repr__(self): return f"Product('{self.title}', '{self.description}', '{self.price}', '{self.stock_level}')"
class Addskin(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80), nullable=False) price = db.Column(db.Numeric(), nullable=False) float = db.Column(db.Numeric(), nullable=False) stock = db.Column(db.Integer(), default=1) 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 = db.Column(db.String(150), nullable=False, default='image.jpg') def __repr__(self): return '<Post %r>' % self.title @staticmethod def get_by_collection(category_id): return Addskin.query.filter_by(category_id=category_id).first()
class Addproduct(db.Model): 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) stock = db.Column(db.Integer, nullable=False) desc = db.Column(db.Text, nullable=False) pub_date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) 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 '<Addproduct {}>'.format(self.name)
class Product(db.Model): 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) stock = db.Column(db.Integer, nullable=False) desc = db.Column(db.Text, nullable=False) pub_date = db.Column(db.DateTime, nullable=False, default=datetime.now()) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'), nullable=False) brand = db.relationship('Brand', backref=db.backref('brand', lazy=True)) category_id = db.Column(db.Integer, db.ForeignKey('category.id'), nullable=False) category = db.relationship('Category', backref=db.backref('category', lazy=True)) image_1 = db.Column(db.String(256), nullable=False, default='image1.jpg') def __repr__(self): return '<Product %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.Numeric(18, 2), nullable=False) discount = db.Column(db.Integer, default=0) stock = db.Column(db.Integer, 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=True) #category = db.relationship('Category', backref=db.backref('posts', lazy=True)) category_id = db.Column(db.Integer, db.ForeignKey('category.id')) category = db.relationship('Category', backref=db.backref('posts', lazy=True)) image_1 = db.Column(db.String(150), nullable=False, default='image.jpg') def __repr__(self): return '<Addproduct %r>' % 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 Books(db.Model): book_id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) author = db.Column(db.String(50), nullable=False) description = db.Column(db.String(5000), nullable=False) isbn_number = db.Column(db.String(50), nullable=False) year_published = db.Column(db.Integer, nullable=False) publisher = db.Column(db.String(100), nullable=False) price = db.Column(db.Numeric(10, 2), nullable=False) image_file = db.Column(db.String(30), nullable=False, default='default.jpg') purchase_counter = db.Column(db.Integer, nullable=False) stock_level = db.Column(db.Integer, nullable=False) where_bought = db.relationship( 'Purchased_items', backref='item_details', lazy='dynamic') where_wishlisted = db.relationship( 'Wishlist', backref='item_details', lazy='dynamic') item_reviews = db.relationship( 'Reviews', backref='item_details', lazy='dynamic') def __repr__(self): return f"Books('{self.title}', '{self.description}', '{self.price}', '{self.stock_level}')"
class Product(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(100), 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) description = db.Column(db.Text, nullable=False) public_date = db.Column(db.DateTime, nullable=False, default=dt.utcnow) category_id = db.Column(db.Integer, db.ForeignKey('category.id'), nullable=False) category = db.relationship('Category', backref=db.backref('product', lazy=True)) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'), nullable=False) brand = db.relationship('Brand', backref=db.backref('product', 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 '<Product %r>' % self.name