| 12345678910111213141516171819202122232425262728293031323334353637 | import osfrom sqlalchemy import create_engineos_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'})
 |