本期目标:建立cms用户
1、安装flask_sqlalchemy等库
建议flask_migrate版本为2.7.0
pip install flask_sqlalchemy
pip install flask_script
pip install flask_migrate==2.7.0
pip install werkzeug
2、建立CMS模型
config.py
DEBUG = True
# SQLALCHEMY_DATABASE_URI中,root为用户名,123456为密码
SQLALCHEMY_DATABASE_URI = "mysql+pymysql://root:123456@127.0.0.1:3306/bbs?charset=utf8"
SQLALCHEMY_TRACK_MODIFICATIONS = False
在根目录里新建exts.py:
from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy()
在apps\cms\里新建models.py:
from exts import db
from datetime import datetime
class CMSUser(db.Model):
__tablename__ = "cms_user"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
username = db.Column(db.String(50), nullable=False)
password = db.Column(db.String(100), nullable=False)
email = db.Column(db.String(50), nullable=False, unique=True)
join_time = db.Column(db.DateTime, default=datetime.now)
manage.py:
from flask_script import Manager
from flask_migrate import Migrate, MigrateCommand
from fhuang_forum import app
from exts import db
from apps.cms import models as cms_models
manager = Manager(app)
Migrate(app, db)
manager.add_command("db", MigrateCommand)
if