| import pymysql | |
| timeout = 10 | |
| class DbConnection: | |
| def GetDbConnection(): | |
| db_params = { | |
| 'host': 'dpg-cnhir5fsc6pc73dvj380-a.oregon-postgres.render.com', | |
| 'database': 'OpenAI', | |
| 'user': 'anu', | |
| 'password': '5omRLogf9Kdas3zoBFPCT9yrCGU4IbEX', | |
| } | |
| return db_params | |
| def GetMySQLDbConnection(): | |
| connection = pymysql.connect( | |
| charset="utf8mb4", | |
| connect_timeout=timeout, | |
| cursorclass=pymysql.cursors.DictCursor, | |
| db="defaultdb", | |
| host="mysql-anu-xboxgames1900-aebf.a.aivencloud.com", | |
| password="AVNS_TGfs_uHRKteMjB9pFnq", | |
| read_timeout=timeout, | |
| port=25227, | |
| user="avnadmin", | |
| write_timeout=timeout, | |
| ) | |
| return connection | |