Esempi in Python per Numeric

Esempio n. 1

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

Esempio n. 2

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

Esempio n. 3

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

Esempio n. 4

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

Esempio n. 5

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

Esempio n. 6

File: models.py Progetto: nikki-99/MyShop

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)

Esempio n. 7

File: models.py Progetto: JorelleK/EcommerceSite

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

Esempio n. 8

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

Esempio n. 9

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

Esempio n. 10

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

Esempio n. 11

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

Esempio n. 12

File: models.py Progetto: HarryBatchelor/CM1102-Web-Apps

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

Esempio n. 13

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

Esempio n. 14

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

Esempio n. 15

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)

Esempio n. 16

File: models.py Progetto: gpsevdiotis/CM1202-Flask-Webshop

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

Esempio n. 17

File: models.py Progetto: Zdenoslav/FLASK2

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

Esempio n. 18

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

Esempio n. 19

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)

Esempio n. 20

File: models.py Progetto: ChiragSaini/E-Commerce-Using-Flask

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

Esempio n. 21

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

Esempio n. 22

File: models.py Progetto: tinokingstone/QUEST_GAMING

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

Esempio n. 23

File: models.py Progetto: anthoskountouris/CM1102_Online_Shop

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

Esempio n. 24

File: models.py Progetto: Laid018/ecomerce

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