### models.py ``` from exts import db from datetime import datetime # 加密函數, generate_password_hash哈希,check_password_hash檢測密碼是否一致 from werkzeug.security import generate_password_hash,check_password_hash # 創建cms用戶數據庫模型 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) def __init__(self,username,password,email): self.username = username self.password = password self.email = email # getter/setter # 可以將一個方法定義成屬性 @property def password(self): return self._password # 重新定義設置方法 @password.setter def password(self,raw_password): # 加密 self._password = generate_password_hash(raw_password) def check_password(self,raw_password): # 原始密碼和加密后的密碼是否一致 result = check_password_hash(self._password,raw_password) return result # 重寫密碼字段 # 密碼:對外的字段名叫做password # 對內的字段名叫做"_password" ``` ### manage.py ``` #coding:utf-8 from flask_script import Manager from flask_migrate import MigrateCommand,Migrate from zlbbs import create_app from exts import db # 導入模型 from apps.cms import models # 執行命令 # python manage.py db init:初始化 # python manage.py db migrate:執行遷移腳本 # 有可能報AttributeError: 'NoneType' object has no attribute 'encoding'的錯誤,是因為寫數據庫連接的時候,utf8寫成了utf-8 # python manage.py db upgrade:映射到數據庫中 app = create_app() # 初始化app manager = Manager(app) # 綁定 Migrate(app,db) # 映射 manager.add_command('db',MigrateCommand) # 添加cms用戶 @manager.option('-u','--username',dest='username') @manager.option('-p','--password',dest='password') @manager.option('-e','--email',dest='email') def create_cms_user(username,password,email): user = models.CMSUser(username=username,password=password,email=email) db.session.add(user) db.session.commit() print("cms用戶添加成功") # 添加數據 # python manage.py create_cms_user -u miku -p 123456 -e 1479852727@qq.com if __name__ == "__main__": manager.run() ``` ### config.py ``` DEBUG = True # 配置數據信息 DB_USERNAME = 'root' DB_PASSWORD = '123456' DB_HOST = '127.0.0.1' DB_PORT = '3306' DB_NAME = 'zlbbs' DB_URI = 'mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8'.format(DB_USERNAME,DB_PASSWORD,DB_HOST,DB_PORT,DB_NAME) # 數據庫 SQLALCHEMY_DATABASE_URI = DB_URI # 屏蔽SQLalchemy發送的信號 SQLALCHEMY_TRACK_MODIFICATIONS = False ```