from sqlalchemy import create_engine
# 准实时线上库
con_zss_online = create_engine('mysql+pymysql://pengcheng.zhang_r:DLOu90XfOgsvKuKC@10.17.115.6:4010/rc_real_time_data_pool?charset=utf8'
                               ,echo=False)
con_dp_analysis = create_engine('mysql+pymysql://pengcheng.zhang_r:DLOu90XfOgsvKuKC@10.17.115.6:4010/dp_analysis?charset=utf8'
                               ,echo=False)

con_zss_online_two = create_engine('mysql+pymysql://rc_feature_fetch_user:VRYB7ChzID6ccq8F@10.17.115.6:4010/rc_real_time_data_pool?charset=utf8'
                                   ,echo=False)


con_zss_analysis = create_engine('mysql+pymysql://pengcheng.zhang_r:DLOu90XfOgsvKuKC@172.30.11.22:4010/analysis_real_time?charset=utf8'
                                 ,echo=False)
con_tuomin_spider_center = create_engine('mysql+pymysql://pengcheng.zhang_r:0p951ekx8XWz3df@172.30.5.27:8066/spider_center?charset=utf8'
                                         ,echo=False)

con_tuomin_workflow = create_engine('mysql+pymysql://pengcheng.zhang_r:0p951ekx8XWz3df@172.30.5.27:8066/workflow?charset=utf8'
                                    ,echo=False)

con_feature = create_engine('mysql+pymysql://xyqb_rule_read:1q2w3e4r@xyqb-rule-db.quantgroups.com:6606/?charset=utf8'
                            ,echo=False)

con_feature_xyqb_feature = create_engine('mysql+pymysql://xyqb_rule_read:1q2w3e4r@xyqb-rule-db.quantgroups.com:6606/xyqb_feature?charset=utf8'
                            ,echo=False)

con_feature_hjs = create_engine('mysql+pymysql://pengcheng.zhang:pUtT8iNQvcdkj6ne@172.30.5.27:7336/risk_query?charset=utf8'
                                ,echo=False)

con_tuomin_xyqb = create_engine('mysql+pymysql://pengcheng.zhang_r:0p951ekx8XWz3df@172.30.5.27:8066/xyqb?charset=utf8'
                                ,echo=False)

con_palo = create_engine('mysql+pymysql://pengcheng_zhang:cd4D7GQP@172.20.6.9:9030/?charset=utf8',echo=False)


con_palo_test = create_engine('mysql+pymysql://pengcheng_zhang:cd4D7GQP@172.20.6.9:9030/test?charset=utf8',echo=False)


con_realtime = create_engine('mysql+pymysql://b_events_w:q3ReZoL9x5asCxcx@10.17.115.6:4010/rc_real_time_data_pool?charset=utf8'
                                  ,echo=False)
#数据库切换备注一下
# con_comservice = create_engine('mysql+pymysql://rc-historical-fetch-user:s@tkZuEX@eN$Qy9m@10.17.115.6:4010/rc_comservice_data_pool?charset=utf8'
#                               ,echo=False)

con_comservice = create_engine('mysql+pymysql://rc-historical-fetch-user:s@tkZuEX@eN$Qy9m@10.17.115.6:4010/rc_comservice_data_pool_v2?charset=utf8'
                              ,echo=False)

con_comservice_v3 = create_engine('mysql+pymysql://pengcheng_zhang:phBnseTGbmUd7cKI@fengkong-tidb.quantgroups.com:4010/rc_comservice_data_pool_v3?charset=utf8'
                                  ,echo=False)

con_lkbadmin = create_engine('mysql+pymysql://lkbadmin_feature_r:uij89knb762er4cgs67@172.30.220.16:33403/lkbadmin?charset=utf8'
                               ,echo=False)

con_tongdun = create_engine('mysql+pymysql://dailyreport:9XpnRus51fT45D5Y@172.30.5.29:3304/monitor?charset=utf8'
                            ,echo=False)

#手机号对应身份证个数
con_blacklist3_read = create_engine('mysql+pymysql://blacklist3_read:4cbv2AghLmpiSXAm@172.30.220.16:33310/blacklist3?charset=utf8'
                               ,echo=False)
#紧急联系人
con_urgent_people = create_engine('mysql+pymysql://drisk_controlpro:uijk78ytlk953rtg@172.30.220.16:33313/xyqb_user?charset=utf8'
                               ,echo=False)

#身份证归属地（省）黑名单标志
con_realtime_hmd = create_engine('mysql+pymysql://vcc_black_list_w:Kz8p0Wf0iw7nIV85@guangdadb.xyqb.com:3306/vcc_black_list?charset=utf8',echo=False)
#近一个月通话记录成功爬取标志
con_day30_sql = create_engine('mysql+pymysql://qa:qatest@172.30.220.9:3306/lkb_spider?charset=utf8',echo=False)

"""vcc 三期"""
con_vccthree_acsdb = create_engine('mysql+pymysql://qa:qatest@172.17.5.10:31110/acsdb?charset=utf8',echo=False)

con_vccthree_vcc_talos = create_engine('mysql+pymysql://qa:qatest@172.17.5.10:31110/vcc_talos?charset=utf8',echo=False)