HandleDB.py
1.61 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
#!/usr/bin/env python
# -*- coding: utf-8 -*-
# @Time : 2021/8/19 上午10:18
# @Author : 付孟奇
# 记录所有的数据库信息
'''所有线上数据信息以线上实际为准，本地只维护一个key'''
def dataBaseList(dbName):
databaseList = {
'中德安联-vdr': {"host": "rm-2zen60zh797n662w4lo.mysql.rds.aliyuncs.com",
"port": 3306,
"user": "vdr_allianz",
"password": "is611Z14$coBWPUyKR12_0d",
"db": "vdr_staging_allianz"
},
'中美大都会-vdr': {"host": "rm-2zen60zh797n662w4lo.mysql.rds.aliyuncs.com",
"port": 3306,
"user": "vdr_staging",
"password": "5HGKEm!15$_%yYod8wtPC",
"db": "vdr_staging"
},
'瑞泰-staging': {"host": "rm-2zen60zh797n662w4lo.mysql.rds.aliyuncs.com",
"port": 3306,
"user": "oldmutuallife_st",
"password": "EkKL#qX7j4M110!c17%15Qn",
"db": "oldmutuallife_staging"
},
'德华安顾-vdr': {"host": "rm-2zen60zh797n662w4lo.mysql.rds.aliyuncs.com",
"port": 3306,
"user": "vdr_ergolife",
"password": "MO19vuPr!15$_%yYe16ohpd12kUJQ518",
"db": "vdr-ergolife"
},
}
# 判断dbName是否存在该环境
if databaseList.get(dbName, 0) != 0:
data_base = databaseList[dbName]
return data_base
else:
return None