Ejemplos de Column en Python

Ejemplo n.º 1

Archivo: models.py Proyecto: GSPuniani/Grocery-Store-Forms

class GroceryStore(db.Model):
    """Grocery Store model."""
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80), nullable=False)
    address = db.Column(db.String(200), nullable=False)
    items = db.relationship('GroceryItem', back_populates='store')

    # Include string representations for the drop-down menu
    def __str__(self):
        return f'<Grocery Store: {self.title}>'

    def __repr__(self):
        return f'<Grocery Store: {self.title}>'

Ejemplo n.º 2

class User(UserMixin, db.Model):
    """Grocery Store model."""
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(50), nullable=False)
    password = db.Column(db.String(50), nullable=False)
    cart_items = db.relationship('GroceryItem',
                                 secondary='shopping_cart',
                                 back_populates='users_cart')

    def __str__(self):
        return f'{self.username}'

    def __repr__(self):
        return f'{self.username}'

Ejemplo n.º 3

class GroceryStore(db.Model):
    """Grocery Store model."""
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80), nullable=False)
    address = db.Column(db.String(200), nullable=False)
    items = db.relationship('GroceryItem', back_populates='store')
    created_by_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    created_by = db.relationship('User')

    def __repr__(self):
        return f'<Store: {self.title}>'

    def __str__(self):
        return f'<Store: {self.title}>'

Ejemplo n.º 4

class User(UserMixin, db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), nullable=False)
    password = db.Column(db.String(200), nullable=False)

    shopping_list_items = db.relationship('GroceryItem',
                                          secondary='shopping_list',
                                          back_populates='users_listed_by')

    def __str__(self):
        return f'<User: {self.username}>'

    def __repr__(self):
        return f'<User: {self.username}>'

Ejemplo n.º 5

Archivo: models.py Proyecto: GSPuniani/Grocery-Store-Auth

class GroceryStore(db.Model):
    """Grocery Store model."""
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80), nullable=False)
    address = db.Column(db.String(200), nullable=False)
    items = db.relationship('GroceryItem', back_populates='store')
    # Add created_by field to see the user who added the store
    created_by_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    created_by = db.relationship('User')

    # Include string representations for the drop-down menu
    def __str__(self):
        return f'<Grocery Store: {self.title}>'

    def __repr__(self):
        return f'<Grocery Store: {self.title}>'

Ejemplo n.º 6

Archivo: models.py Proyecto: lotsofluck/GroceryStore

class User(db.Model, UserMixin):
    """User Model"""
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(50), nullable=False)
    password = db.Column(db.String(50), nullable=False)
    shopping_list_items = db.relationship(
        "GroceryItem",
        secondary="shopping_list_table",
        back_populates="user_shopping_list",
    )

    shopping_list_table = db.Table(
        "shopping_list_table",
        db.Column("grocery_item", db.Integer,
                  db.ForeignKey("grocery_item.id")),
        db.Column("user", db.Integer, db.ForeignKey("user.id")),
    )

Ejemplo n.º 7

Archivo: models.py Proyecto: brianross93/grocerystore

class GroceryItem(db.Model):
    """Grocery Item model."""
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    price = db.Column(db.Float(precision=2), nullable=False)
    category = db.Column(db.Enum(ItemCategory), default=ItemCategory.OTHER)
    photo_url = db.Column(URLType)
    store_id = db.Column(db.Integer, db.ForeignKey('grocery_store.id'), nullable=False)
    store = db.relationship('GroceryStore', back_populates='items')
    created_by_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    created_by = db.relationship('User')

Ejemplo n.º 8

Archivo: models.py Proyecto: GSPuniani/Grocery-Store-Auth

class GroceryItem(db.Model):
    """Grocery Item model."""
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    price = db.Column(db.Float(precision=2), nullable=False)
    category = db.Column(db.Enum(ItemCategory), default=ItemCategory.OTHER)
    photo_url = db.Column(URLType)
    store_id = db.Column(
        db.Integer, db.ForeignKey('grocery_store.id'), nullable=False)
    store = db.relationship('GroceryStore', back_populates='items')
    # Add created_by field to see the user who added the item
    created_by_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    created_by = db.relationship('User')
    # Add many-to-many relationship between User and GroceryItem
    users_who_shopped = db.relationship(
        'User', secondary='shopping_list', back_populates='shopping_list_items')

Ejemplo n.º 9

class GroceryItem(db.Model):
    """Grocery Item model."""
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    price = db.Column(db.Float(precision=2), nullable=False)
    category = db.Column(db.Enum(ItemCategory), default=ItemCategory.OTHER)
    photo_url = db.Column(URLType)

    store_id = db.Column(db.Integer,
                         db.ForeignKey('grocery_store.id'),
                         nullable=False)
    store = db.relationship('GroceryStore', back_populates='items')
    """ Foreign Key column (to store the user’s id)"""
    created_by_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    """ Relationship (to store the User object itself) """
    created_by = db.relationship('User')

    customer = db.relationship("User", secondary="shopping_list")

Ejemplo n.º 10

class GroceryItem(db.Model):
    """Grocery Item model."""
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    price = db.Column(db.Float(precision=2), nullable=False)
    category = db.Column(db.Enum(ItemCategory), default=ItemCategory.OTHER)
    photo_url = db.Column(URLType)
    store_id = db.Column(db.Integer,
                         db.ForeignKey('grocery_store.id'),
                         nullable=False)
    store = db.relationship('GroceryStore', back_populates='items')

    def __str__(self):
        return f'<Item: {self.name}>'

    def __repr__(self):
        return f'<Item: {self.name}>'

Ejemplo n.º 11

class GroceryItem(db.Model):
    """Grocery Item model."""
    __tablename__ = 'groceryitem'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    price = db.Column(db.Float(precision=2), nullable=False)
    category = db.Column(db.Enum(ItemCategory), default=ItemCategory.OTHER)
    photo_url = db.Column(URLType)
    store_id = db.Column(db.Integer,
                         db.ForeignKey('grocery_store.id'),
                         nullable=False)
    store = db.relationship('GroceryStore', back_populates='items')
    created_by_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    created_by = db.relationship('User')
    shopping_list_user = db.relationship('User',
                                         secondary='shopping_list',
                                         back_populates='shopping_list_items')

    def __repr__(self):
        return f'<Item: {self.name}>'

    def __str__(self):
        return f'<Item: {self.name}>'

Ejemplo n.º 12

Archivo: models.py Proyecto: Kou-kun42/BEW-1.2-Forms

    photo_url = db.Column(URLType)
    store_id = db.Column(
        db.Integer, db.ForeignKey('grocery_store.id'), nullable=False)
    store = db.relationship('GroceryStore', back_populates='items')
    created_by_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    created_by = db.relationship('User')
    shopping_lists = db.relationship(
        "User",
        secondary="shopping_list",
        back_populates="shopping_list_items"
    )


class User(db.Model, UserMixin):
    """User model."""
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(42), nullable=False)
    password = db.Column(db.String(80), nullable=False)
    shopping_list_items = db.relationship(
        "GroceryItem",
        secondary="shopping_list",
        back_populates="shopping_lists"
    )


shopping_list_table = db.Table(
    "shopping_list",
    db.Column("groceryitem_id", db.Integer, db.ForeignKey("grocery_item.id")),
    db.Column("user_id", db.Integer, db.ForeignKey("user.id"))
    )

Ejemplo n.º 13

Archivo: models.py Proyecto: ruot-nyak/BEW-1.2-Forms-Homework

class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(24), nullable=False, unique=True)
    password = db.column(db.String(80))

    shopping_list_items = db.relationship('GroceryItem')

Ejemplo n.º 14

class GroceryItem(db.Model):
    """Grocery Item model."""
    __tablename__ = 'groceryitem'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    price = db.Column(db.Float(precision=2), nullable=False)
    category = db.Column(db.Enum(ItemCategory), default=ItemCategory.OTHER)
    photo_url = db.Column(URLType)
    store_id = db.Column(db.Integer,
                         db.ForeignKey('grocery_store.id'),
                         nullable=False)
    store = db.relationship('GroceryStore', back_populates='items')
    created_by_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    created_by = db.relationship('User')
    shopping_list_user = db.relationship('User',
                                         secondary='shopping_list',
                                         back_populates='shopping_list_items')

    def __repr__(self):
        return f'<Item: {self.name}>'

    def __str__(self):
        return f'<Item: {self.name}>'


shopping_list_table = db.Table(
    'shopping_list',
    db.Column('groceryitem_id', db.Integer, db.ForeignKey('groceryitem.id')),
    db.Column('user_id', db.Integer, db.ForeignKey('user.id')))

Ejemplo n.º 15

class User(UserMixin, db.Model):
    """User model."""
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(25), nullable=False)
    password = db.Column(db.String(80), nullable=False)
    shopping_list_items = db.relationship('GroceryItem')

Ejemplo n.º 16

Archivo: models.py Proyecto: ruot-nyak/BEW-1.2-Forms-Homework

    created_by = db.relationship('User')


class GroceryItem(db.Model):
    """Grocery Item model."""
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    price = db.Column(db.Float(precision=2), nullable=False)
    category = db.Column(db.Enum(ItemCategory), default=ItemCategory.OTHER)
    photo_url = db.Column(URLType)
    store_id = db.Column(db.Integer,
                         db.ForeignKey('grocery_store.id'),
                         nullable=False)
    store = db.relationship('GroceryStore', back_populates='items')
    created_by_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    created_by = db.relationship('User')
    users_items = db.relationship('User')


class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(24), nullable=False, unique=True)
    password = db.column(db.String(80))

    shopping_list_items = db.relationship('GroceryItem')


shopping_list_table = db.Table(
    'shopping_list', db.Column('user_id', db.Integer,
                               db.ForeignKey('user.id')),
    db.Column('item_id', db.Integer, db.ForeignKey('grocery_item.id')))

Ejemplo n.º 17

Archivo: models.py Proyecto: 0Lilymoon0/BEW-1.2-Homework-3

class GroceryStore(db.Model):
    """Grocery Store model."""
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80), nullable=False)
    address = db.Column(db.String(200), nullable=False)
    items = db.relationship('GroceryItem', back_populates='store')

Ejemplo n.º 18

class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), nullable=False)
    password = db.Column(db.String(80), nullable=False)
    shopping_list_items = db.relationship('GroceryItem',
                                          back_populates='user_items')