DataBaseConfig.py 812 B

12345678910111213141516171819202122232425262728293031323334
  1. import os
  2. from sqlalchemy import create_engine
  3. os_env_code_status = os.getenv('LYY_STATUS', 'product')
  4. if os_env_code_status == 'dev':
  5. # 测试数据库连接字符串
  6. host = "139.186.151.174"
  7. port = 3306
  8. user = "hcst"
  9. passwd = "hcst@2020"
  10. db = 'jeecg-boot'
  11. charset = 'utf8'
  12. db_con_str = "mysql+pymysql://%s:%s@%s:%d/%s" % ("hcst", "hcst@2020", "139.186.151.174", 3306, "jeecg-boot")
  13. engine = create_engine(db_con_str, connect_args={'charset': 'utf8'})
  14. else:
  15. # 线上数据库连接字符串
  16. pass
  17. # host = "139.186.151.174"
  18. # port = 3306
  19. # user = "hcst"
  20. # passwd = "hcst@2020"
  21. # db = 'jeecg-boot'
  22. # charset = 'utf8'
  23. # db_con_str = "mysql+pymysql://%s:%s@%s:%d/%s" % ("readonly", "hcst@2021", "139.186.27.96", 4000, "jeecg-boot")