vlambda博客
学习文章列表

# mybooks/app/models/bases.pydb = SQLAlchemy()class MyBase(db.Model): __abstract__ = True create_time = Column('create_time', Integer) status = Column(SmallInteger, default=1)

# mybooks/app/models/wish.pyclass Wish(MyBase): __tablename__ = 'wish' id = Column(Integer, primary_key=True) launched = Column(Boolean, default=False) user = relationship('User') uid = Column(Integer, ForeignKey('user.id'), nullable=True) isbn = Column(String(15), nullable=False)

# mybooks/app/models/user.pyclass User(MyBase): __tablename__ = 'user' id = Column(Integer, primary_key=True) nickname = Column(String(24), nullable=False) phone_number = Column(String(18), unique=True) email = Column(String(50), unique=True, nullable=False) _password = Column('password', String(128), nullable=True) confirmed = Column(Boolean, default=False) beans = Column(Float, default=0) send_counter = Column(Integer, default=0) receive_counter = Column(Integer, default=0) gifts = relationship('Gift')

# mybooks/app/models/gift.pyclass Gift(MyBase): __tablename__ = 'gift' id = Column(Integer, primary_key=True) launched = Column(Boolean, default=False) user = relationship('User') uid = Column(Integer, ForeignKey('user.id'), nullable=True) isbn = Column(String(15), nullable=False)

# mybooks/app/models/__init__.pyfrom .bases import *from .gift import *from .user import *from .wish import *

# mybooks/app/__init__.pydef create_app(): app = Flask(__name__) app.config.from_object("app.secure") db.init_app(app) db.create_all(app=app) return app

# mybooks/manage_server.pyapp = create_app()migrate = Migrate(app, db)manager = Manager(app)manager.add_command("db", MigrateCommand)if __name__ == "__main__": manager.run()