python：flask-SQLalchemy-celery 自学

SQLalchemy生成表

模型类继承db.Model

# 构建模型类 类->表 类属性->字段 实例对象->记录

class User(db.Model):

__tablename__ = 't_user' # 设置表名, 表名默认为类名小写

id = db.Column(db.Integer, primary_key=True) # 设置主键, 默认自增

name = db.Column('username', db.String(20), unique=True) # 设置字段名 和 唯一约束

age = db.Column(db.Integer, default=10, index=True) # 设置默认值约束 和 索引

class QuestionModel(db.Model):

__tablename__ = "question"

id = db.Column(db.Integer, primary_key=True, autoincrement=True)

title = db.Column(db.String(100), nullable=False)

content = db.Column(db.Text, nullable=False)

create_time = db.Column(db.DateTime, default=datetime.now)

author_id = db.Column(db.Integer, db.ForeignKey("user.id")) # 外键

author = db.relationship(UserModel, backref="questions")

class AnswerModel(db.Model):

__tablename__ = "answer"

id = db.Column(db.Integer, primary_key=True, autoincrement=True)

content = db.Column(db.Text, nullable=False)

create_time = db.Column(db.DateTime, default=datetime.now)

# 外键

question_id = db.Column(db.Integer, db.ForeignKey("question.id"))

author_id = db.Column(db.Integer, db.ForeignKey("user.id"))

# 关系

question = db.relationship(QuestionModel, backref=db.backref("answers", order_by=create_time.desc()))

author = db.relationship(UserModel, backref="answers")

————————————————

flask db init

flask db migrate

flask db upgrade ##数据库迁移生成表

celery：

# broker='redis://:123456@127.0.0.1:6379/2' 密码123456

broker = 'redis://127.0.0.1:6379/0' # 无密码

# 任务结果存储

backend = 'redis://127.0.0.1:6379/1'