1. 目录介绍
app------>后台管理界面
config------>flask配置文件
model------>连接数据库表,相当于将mysql中表里的字段一一对应的写入,不需要迁移
service------>创建属性,是否可增删改
util------>加载数据库配置及用sqlalchemy创建连接对象
2. 代码
app—>app.py
from flask_admin import Admin
from flask import Flask
from util import db_util
from service.save_blank import BView
app = Flask(__name__)
admin = Admin(app)
admin.add_view(BView(db_util.get_test_session(),name = u'学生表'))
if __name__ == '__main__':
app.run()
config—>dev—>env.ini
[db_test]
mysql.host = 127.0.0.1
mysql.port = 3306
mysql.dbname = db_test
mysql.user = root
mysql.password = 123456
mysql.pool.size = 10
mysql.pool.timeout = 36000
mysql.pool.recycle = 60
model—>db_test.py
from sqlalchemy import Column, Date, DateTime, JSON, String, TIMESTAMP, Table, text
from sqlalchemy.dialects.mysql import BIGINT, INTEGER, MEDIUMTEXT, TINYINT, TINYTEXT
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base(