def __init__(self, taskid):
#源表数据库连接
self.read_server_user = None
self.read_server_pass = None
self.read_server_address = None
self.read_service_name = None
# 加载数据库中其他字段
self.target_orm_name = None
self.source_orm_name = None
self.target_table_name = None
self.source_table_name = None
self.update_date = None
self.sql = None
self.sql1 = None
self.vc_orm = None
self.vc_source = None
self.conn_mysql = connect_mysql()
self.load_config(taskid)
# 连接数据库
sysstr = platform.system()
if sysstr == "Linux":
self.conn_source = self.connect_source()
else:
self.conn_source = connect_source()
self.conn_target = connect_target()
def call_port_data(self):
logger.info('开始执行存储过程')
dbsession_my = connect_mysql()
# dbsession_md = connect_target()
try:
logger.info('开始执行存储过程')
logger.info('连接数据库')
conn = cx_Oracle.connect('{}/{}@{}/{}'.format(
MD_SERVER_USER, MD_SERVER_PASS, MD_SERVER_ADDRESS,
MD_SERVICE_NAME))
cursor = conn.cursor()
logger.info('存储过程正在执行，请等待...')
cursor.callproc('p_update_port_asset_info')
cursor.callproc('p_update_port_combi_info')
cursor.callproc('p_update_port_fund_info')
cursor.callproc('p_update_port_fund_equity')
cursor.callproc('p_update_port_fund_fixincome')
cursor.callproc('p_update_port_map_common')
cursor.callproc('p_update_port_o3_map_dept')
cursor.callproc('p_update_port_o3_map_manager')
self.Update_py()
logger.info('存储过程执行完成')
cursor.close()
conn.close()
dbsession_my.query(TStatus).filter(
TStatus.l_child_id == self.task_id).update(
{TStatus.l_status: 0})
dbsession_my.close()
logger.info('存储过程执行完成')
except Exception as e:
print('{}'.format(e))
logger.info('存储过程执行异常，请检查')
finally:
pass
def Call_pro(self):
logger.info('开始执行存储过程')
dbsession_my = connect_mysql()
# dbsession_md = connect_target()
try:
#logger.info('开始执行存储过程')
logger.info('连接数据库')
conn = cx_Oracle.connect('{}/{}@{}/{}'.format(
MD_SERVER_USER, MD_SERVER_PASS, MD_SERVER_ADDRESS,
MD_SERVICE_NAME))
cursor = conn.cursor()
logger.info('存储过程PKG_BSC_SECURITY正在执行，请等待...')
cursor.callproc('PKG_BSC_SECURITY.P_UPDATE_TMP_BSC_SECURITY')
cursor.callproc('PKG_BSC_SECURITY.P_UPDATE_TL4')
cursor.callproc('PKG_BSC_SECURITY.P_UPDATE_KIND_ATYPE')
cursor.callproc('PKG_BSC_SECURITY.P_UPDATE_BSC_SECURITY')
cursor.callproc('p_update_residual_maturity')
cursor.callproc('p_update_bsc_marketinfo')
self.Update_py()
#logger.info('存储过程执行完成')
cursor.close()
conn.close()
dbsession_my.query(TStatus).filter(
TStatus.l_child_id == self.task_id).update(
{TStatus.l_status: 0})
dbsession_my.close()
logger.info('存储过程执行完成')
except Exception as e:
#print('{}'.format(e))
logger.info('存储过程执行异常，请检查')
finally:
pass
def save_db(self):
db = connect_mysql()
db.execute_ext(
'insert into t_extract_config(l_task_id,vc_souce_orm_name,vc_target_orm_name,vc_souce_table_name,vc_target_table_name,vc_source,l_auto_model,vc_sql) VALUES ("{}","{}","{}","{}","{}",10,1,"{}")'
.format(self.id, self.sou_orm_name, self.tar_orm_name,
self.source_name, self.target_name, self.sql))
db.execute_ext(
"insert into t_task_info(id,vc_task_name,l_visble,l_type,vc_operator,l_priority,vc_remark,vc_trigger_type ,l_bus_type) VALUES ('{}','{}',1,490,'卢方波',0,'基础数据抽取',1,1)"
.format(self.id, self.target_name))
db.save()
def __init__(self, param):
TkTaskBase.__init__(self, param)
self.conn_mysql = connect_mysql()
self.target_orm_name = None
self.source_orm_name = None
self.target_table_name = None
self.source_table_name = None
self.l_auto_model = None
self.load_target_table_name()
def __init__(self, taskid):
# 加载mysql数据库中表名和orm类名
self.conn_mysql = connect_mysql()
self.target_table_name = None
self.load_const(taskid)