Exemplos de Column em Python

Exemplo n.º 1

class Author(db.Model):
    """Author model."""
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    biography = db.Column(db.String(200))
    books = db.relationship('Book', back_populates='author')

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

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

Exemplo n.º 2

class Genre(db.Model):
    """Genre model."""
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False, unique=True)
    books = db.relationship(
        'Book', secondary='book_genre', back_populates='genres')

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

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

Exemplo n.º 3

Arquivo: models.py Projeto: asood92/bew-flask-wtform-lab

class Author(db.Model):
    """Author model."""

    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    biography = db.Column(db.String(200))
    books = db.relationship("Book", back_populates="author")

    # birthdate = db.Column(db.Date)

    def __str__(self):
        return f"<Author: {self.name}>"

    def __repr__(self):
        return f"<Author: {self.name}>"

Exemplo n.º 4

class Book(db.Model):
    """Book model."""
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80), nullable=False)
    publish_date = db.Column(db.Date)

    # The author - Who wrote it?
    author_id = db.Column(db.Integer, db.ForeignKey(
        'author.id'), nullable=False)
    author = db.relationship('Author', back_populates='books')

    # The audience - Who is this book written for?
    audience = db.Column(db.Enum(Audience), default=Audience.ALL)

    # The genres, e.g. fiction, sci-fi, fantasy
    genres = db.relationship(
        'Genre', secondary='book_genre', back_populates='books')

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

    def __repr__(self):
        return f'<Book: {self.title}, Publish Date: {self.publish_date}>'

Exemplo n.º 5

Arquivo: models.py Projeto: asood92/bew-flask-wtform-lab

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), nullable=False, unique=True)
    favorite_books = db.relationship("Book",
                                     secondary="user_book",
                                     back_populates="users_who_favorited")

Exemplo n.º 6

Arquivo: models.py Projeto: asood92/bew-flask-wtform-lab

    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False, unique=True)
    books = db.relationship("Book",
                            secondary="book_genre",
                            back_populates="genres")

    def __str__(self):
        return f"<Genre: {self.name}>"

    def __repr__(self):
        return f"<Genre: {self.name}>"


book_genre_table = db.Table(
    "book_genre",
    db.Column("book_id", db.Integer, db.ForeignKey("book.id")),
    db.Column("genre_id", db.Integer, db.ForeignKey("genre.id")),
)


class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), nullable=False, unique=True)
    favorite_books = db.relationship("Book",
                                     secondary="user_book",
                                     back_populates="users_who_favorited")


favorite_books_table = db.Table(
    "user_book",
    db.Column("book_id", db.Integer, db.ForeignKey("book.id")),

Exemplo n.º 7

    """Genre model."""
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False, unique=True)
    books = db.relationship('Book',
                            secondary='book_genre',
                            back_populates='genres')

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

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


book_genre_table = db.Table(
    'book_genre', db.Column('book_id', db.Integer, db.ForeignKey('book.id')),
    db.Column('genre_id', db.Integer, db.ForeignKey('genre.id')))


class User(UserMixin, db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), nullable=False, unique=True)
    password = db.Column(db.String(200), nullable=False)
    favorite_books = db.relationship('Book',
                                     secondary='user_book',
                                     back_populates='users_who_favorited')

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

Exemplo n.º 8

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(100), nullable=False, unique=True)
    favorite_books = db.relationship('Book', secondary="favorite_books")

Exemplo n.º 9

Arquivo: models.py Projeto: shahirkingali/BEW-1.2-Events-Homework

        return f'<Book: {self.title}>'

class Author(db.Model):
    """Author model."""
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    books = db.relationship('Book', back_populates='author')

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

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

class Genre(db.Model):
    """Genre model."""
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False, unique=True)
    books = db.relationship('Book', secondary='book_genre', back_populates='genres')

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

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

book_genre_table = db.Table('book_genre',
    db.Column('book_id', db.Integer, db.ForeignKey('book.id')),
    db.Column('genre_id', db.Integer, db.ForeignKey('genre.id'))
)