题目要求:
目录结构:
一、py文件:
# start.py
""" Todo """
from apps import *
from modules.index import index_blue
app.register_blueprint(index_blue)
if __name__ == '__main__':
# db.drop_all()
# db.create_all()
app.run()
# apps.py
""" Todo """
from flask import Flask, Blueprint, render_template, redirect, url_for, session, request
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config.from_object('setting')
db = SQLAlchemy(app=app)
# setting.py
""" Todo:配置文件 """
DEBUG = True # 开启调试
SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://root:mysql@127.0.0.1:3306/item1?charset=utf8' # 连接数据库
# SQLALCHEMY_ECHO = True # 查询时会显示原始sql语句【在控制面板显示】
SECRET_KEY = 'abc' # 密钥
SQLALCHEMY_TRACK_MODIFICATIONS = False # 是否显示警告信息
SQLALCHEMY_COMMIT_ON_TEARDOWN = True # 数据内容发生改变之后,自动提交
PER_PAGE_NUM=2 # 分页【如果总数据未超过定义的分页数据PER_PAGE_NUM,则不会显示分页】
# models.py
""" Todo """
from apps import *
# 文章表
class Title(db.Model):
id = db.Column(db.Integer, primary_key=True, comment='主键ID')
name = db.Column(db.String(30), comment='文章标题')
content = db.Column(db.Text, comment='文章内容')
# 评论表
class Comments(db.Model):
id = db.Column(db.Integer, primary_key=True, comment='主键ID')
comment = db.Column(db.Text, comment='评论内容')
tid = db.Column(db.Integer, db.ForeignKey(Title.id), comment='外键关联文章表id')
# manager.py
""" Todo """
from models import *
from flask_script import Manager
from flask_migrate import MigrateCommand, Migrate
manager