28 lines
880 B
Python
28 lines
880 B
Python
|
||
from flask import Flask
|
||
from flask_restful import Api
|
||
from flask_sqlalchemy import SQLAlchemy
|
||
from App import create_app
|
||
|
||
app = Flask(__name__)
|
||
api = Api(app)
|
||
# MySQL所在主机名,默认127.0.0.1
|
||
HOSTNAME = "localhost"
|
||
# MySQL监听的端口号,默认3306
|
||
PORT = 3306
|
||
# 连接MySQL的用户名,自己设置
|
||
USERNAME = "root"
|
||
# 连接MySQL的密码,自己设置
|
||
PASSWORD = "123456"
|
||
# MySQL上创建的数据库名称
|
||
DATABASE = "bs_jaotong"
|
||
# 通过修改以下代码来操作不同的SQL比写原生SQL简单很多 --》通过ORM可以实现从底层更改使用的SQL
|
||
app.config['SQLALCHEMY_DATABASE_URI'] = f"mysql+pymysql://{USERNAME}:{PASSWORD}@{HOSTNAME}:{PORT}/{DATABASE}?charset=utf8mb4"
|
||
#指定配置,用来省略提交操作
|
||
app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True
|
||
db = SQLAlchemy(app)
|
||
|
||
app = create_app()
|
||
if __name__ == '__main__':
|
||
app.run()
|