import os from sqlalchemy import create_engine os_env_code_status = os.getenv('LYY_STATUS', 'product') if os_env_code_status == 'dev': # 测试数据库连接字符串 print("测试环境--数据库!") host = "139.186.151.174" port = 3306 user = "hcst" passwd = "hcst@2020" db = 'jeecg-boot' charset = 'utf8' db_con_str = "mysql+pymysql://%s:%s@%s:%d/%s" % ("hcst", "hcst@2020", "139.186.151.174", 3306, "jeecg-boot") engine = create_engine(db_con_str, connect_args={'charset': 'utf8'}) else: # 线上数据库连接字符串 print("生产环境--数据库!") host = "139.186.27.96" port = 4000 user = "data" passwd = "hcst@2021" db = 'jeecg-boot' charset = 'utf8' db_con_str = "mysql+pymysql://%s:%s@%s:%d/%s" % ("data", "hcst@2021", "139.186.27.96", 4000, "jeecg-boot") engine = create_engine(db_con_str, connect_args={'charset': 'utf8'})