Python Column示例

示例#1

class Rental(db.Model):

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    userid = db.Column(db.Integer, db.ForeignKey("user.id"))
    bookid = db.Column(db.Integer, db.ForeignKey("book.id"))
    book = db.relationship('Book')
    rental_date = db.Column(db.Date,
                            nullable=False,
                            default=datetime.today().date())
    return_date = db.Column(db.Date, nullable=True, default=None)

示例#2

文件： models.py 项目： karmadilos/Racer-Library

class Rental(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer,
                        db.ForeignKey('user.id', ondelete='CASCADE'),
                        nullable=False)
    book_id = db.Column(db.Integer,
                        db.ForeignKey('book.id', ondelete='CASCADE'),
                        nullable=False)
    user = db.relationship('User', backref=db.backref('rental_set'))
    book = db.relationship('Book', backref=db.backref('rental_set'))
    rental_date = db.Column(db.DateTime(), nullable=False)
    return_date = db.Column(db.DateTime(), nullable=True)

示例#3

文件： models.py 项目： karmadilos/Racer-Library

class Comment(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer,
                        db.ForeignKey('user.id', ondelete='CASCADE'),
                        nullable=False)
    book_id = db.Column(db.Integer,
                        db.ForeignKey('book.id', ondelete='CASCADE'),
                        nullable=False)
    user = db.relationship('User', backref=db.backref('comment_set'))
    book = db.relationship('Book', backref=db.backref('comment_set'))
    content = db.Column(db.Text(), nullable=False)
    rating = db.Column(db.Integer)
    create_date = db.Column(db.DateTime(), nullable=False)
    modify_date = db.Column(db.DateTime())


# db세팅법
# 0. 현재 위치를 racer-library로 이동
# 1. export FLASK_APP=elice_library
# 2. export FLASK_ENV=development
# 3. flask db init (최초 한번 수행. 데이터베이스를 관리하는 초기 파일들을 migrations라는 디렉터리에 생성)
# 4-0. 만약 flask db migrate를 했는데 Target database is not up to date. 오류 발생시
# 4-0. flask db heads (migrate 작업의 최종 리비전 보기)
# 4-0. flask db current (migrate 작업의 현재 리비전 보기)
# 4-0. flask db stamp head (현재 리비전을 최종 리비전으로 변경. 최종 리비전(head)과 현재 리비전(current)이 같은 값으로 변경)
# 4. flask db migrate (모델을 새로 생성하거나 변경할때 사용.)
# 5. flask db upgrade (모델의 변경 내용을 실제 데이터베이스에 적용할 때 사용)

示例#4

class Comment(db.Model):

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    bookid = db.Column(db.Integer, db.ForeignKey("book.id"))
    userid = db.Column(db.Integer, db.ForeignKey("user.id"))
    user = db.relationship('User')
    content = db.Column(db.TEXT)
    rating = db.Column(db.Integer)
    create_date = db.Column(db.DateTime, default=datetime.today())

示例#5

class User(db.Model):

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String(20))
    email = db.Column(db.String(30), primary_key=True)
    password = db.Column(db.String(30))

示例#6

class Book(db.Model):

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    book_name = db.Column(db.String(100))
    publisher = db.Column(db.String(30))
    author = db.Column(db.String(30))
    publication_date = db.Column(db.DATE)
    pages = db.Column(db.Integer)
    description = db.Column(db.TEXT)
    link = db.Column(db.String(200))
    rating = db.Column(db.Integer)
    isbn = db.Column(db.BIGINT)
    quantity = db.Column(db.Integer)
    image_path = db.Column(db.String(50))

示例#7

文件： models.py 项目： karmadilos/Racer-Library

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(50), nullable=False)
    email = db.Column(db.String(100), unique=True, nullable=False)
    password = db.Column(db.String(150), nullable=False)

示例#8

文件： models.py 项目： karmadilos/Racer-Library

class Book(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    bookname = db.Column(db.String(50), nullable=False)
    publisher = db.Column(db.String(50), nullable=False)
    author = db.Column(db.String(50), nullable=False)
    published_date = db.Column(db.DateTime(), nullable=False)
    pages = db.Column(db.Integer, nullable=False)
    isbn = db.Column(db.String(50), nullable=False)
    description = db.Column(db.Text, nullable=False)
    image_path = db.Column(db.String(50), nullable=False)
    stock = db.Column(db.Integer, nullable=False)
    rating = db.Column(db.Integer, nullable=False)
    link = db.Column(db.String(50), nullable=False)