# MySQL数据库配置
class BaseConfig:
    DIALECT = 'mysql'
    DRIVER = 'pymysql'
    HOST = 'localhost'
    PORT = '3306'
    USERNAME = 'root'
    PASSWORD = '123456'
    DATABASE = 'bs_jaotong'

    # mysql不识别utf-8，需要直接写成utf8
    SQLALCHEMY_DATABASE_URI = "{}+{}://{}:{}@{}:{}/{}?charset=utf8".format(DIALECT, DRIVER, USERNAME, PASSWORD, HOST,
                                                                           PORT, DATABASE)
    # SQLALCHEMY_DATABASE_URI = f"{DIALECT}+{DRIVER}://{USERNAME}:{PASSWORD}@{HOST}:{PORT}/{DATABASE}?charset=utf8"
    SQLALCHEMY_TRACK_MODIFICATIONS = True
# SQLALCHEMY_ECHO = True