-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path生成sqljson文件.py
39 lines (35 loc) · 1.49 KB
/
生成sqljson文件.py
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
#!/usr/bin/env python
# -*- coding:utf-8 -*-
__author__ = 'wangrong'
from gen_json_ora import GenJson4Ora
# db_con_dns = {
# 'instance': {
# 'cc': ['apig', 'ftf', 'cic', 'cpc', 'cpc_flow', 'custc', 'oc', 'drm', 'ebc', 'pos', 'sa', 'src'],
# 'pmt': ['ab', 'bc', 'pcc'],
# 'rb': ['pcb', 'inv', 'rb'],
# 'sett': ['med', 'sett'],
# 'stbp': ['stbp', 'etl', 'dap']},
# 'dburl': {'cc': ['172.16.80.11', '11521'],
# 'pmt': ['172.16.80.12', '11521'],
# 'rb': ['172.16.80.13', '11521'],
# 'sett': ['172.16.80.14', '11521'],
# 'stbp': ['172.16.80.15', '11521']},
# 'password': '1jian8Shu!'
# }
db_con_dns = {
'instance': {
'cc': ['apig', 'ftf', 'cic', 'cpc', 'cpc_flow', 'custc', 'oc', 'drm', 'ebc', 'pos', 'sa', 'src', 'ab', 'bc',
'pcc', 'pcb', 'inv', 'rb', 'med', 'sett', 'stbp', 'etl', 'dap','etlsys','etlbdp','vcon','vcoff']},
'dburl': {'cc': ['172.16.80.41', '11521']},
'password': '1jian8Shu!'
}
# db_con_dns = {
# 'instance': {
# 'dbepdb': ['apig', 'ftf', 'cic', 'cpc', 'cpc_flow', 'custc', 'oc', 'drm', 'ebc', 'pos', 'sa', 'src', 'ab', 'bc',
# 'pcc', 'pcb', 'inv', 'rb', 'med', 'sett', 'stbp', 'etl', 'dap']},
# 'dburl': {'dbepdb': ['172.16.24.172', '1521']},
# 'password': ''
# }
script_home = r'C:\Users\cc\Desktop\所内测试\周部署\验收A\20181008\dbeptest4\app_stateless'
gen = GenJson4Ora(script_home, db_con_dns)
gen.MainProcess()