def insert_data_hrb(): cursor = globalvars.cnx3.cursor() sql = "SELECT * FROM tbs001_developprojectbasicinfo" cursor.execute(sql) data = cursor.fetchall() cursor = globalvars.cnx1.cursor() for row in data: sql = "SELECT * FROM phase_a1 " "WHERE XiangMuMingCheng=%s" param = (row[0],) cursor.execute(sql, param) data1 = cursor.fetchall() if cursor.rowcount == 0: continue elif cursor.rowcount == 1: pid = data1[0][0] else: print globalvars.get_time(), "数据出错!", row[0] pid = data1[0][0] log_yushouli(row, pid) log_shouli(row, pid) log_bumen(row, pid) log_fuzeren(row, pid) log_tacha(row, pid) log_huiyi(row, pid) log_pinggu(row, pid) log_kaoping(row, pid) log_shangbao(row, pid) globalvars.cnx1.commit()
def run(): print globalvars.get_time(), '清空staff表' globalvars.trunc_staff() print globalvars.get_time(), '添加staff表数据(黑龙江)' insert_data_hlj() print globalvars.get_time(), '添加staff表数据(哈尔滨)' insert_data_hrb() print globalvars.get_time(), '添加authority表数据' insert_authority() print globalvars.get_time(), '更新authority表数据' update_authortity()
def run(): print globalvars.get_time(), '清空pinggu_danwei表' globalvars.trunc_pgdw() print globalvars.get_time(), '添加pinggu_danwei表数据(黑龙江)' insert_data_hlj() print globalvars.get_time(), '添加pinggu_danwei表数据(哈尔滨)' insert_data_hrb() print globalvars.get_time(), '添加评估单位登录信息' update_data_acc()
def run(): print globalvars.get_time(), '清空jianshe_danwei表' globalvars.trunc_jshdw() print globalvars.get_time(), '添加jianshe_danwei数据(黑龙江)' insert_data_hlj() print globalvars.get_time(), '添加jianshe_danwei数据(哈尔滨)' insert_data_hrb()
def run(): print globalvars.get_time(), "清空phase_log表" globalvars.trunc_log() print globalvars.get_time(), "添加phase_log数据(黑龙江)" insert_data_hlj() print globalvars.get_time(), "添加phase_log数据(哈尔滨)" insert_data_hrb() print globalvars.get_time(), "删除phase_log表无效数据" cursor = globalvars.cnx1.cursor() sql = "DELETE FROM phase_b_log WHERE account is NULL" cursor.execute(sql) globalvars.cnx1.commit()
def run(): print globalvars.get_time(), '清空phase表' globalvars.trunc_phase() print globalvars.get_time(), '添加phase数据(黑龙江)' insert_data_hlj() print globalvars.get_time(), '添加phase数据(哈尔滨)' insert_data_hrb()
def run(): print globalvars.get_time(), '清空zhuanjia表' globalvars.trunc_zhuanjia() print globalvars.get_time(), '添加zhuanjia表数据(黑龙江)' insert_data_hlj() print globalvars.get_time(), '添加zhuanjia表数据(哈尔滨)' insert_data_hrb()
# -*- coding:utf-8 -*- import globalvars if __name__ == '__main__': print globalvars.get_time(), '1123'
def run(): print globalvars.get_time(), '清空pinggu_xiangmufuzeren表' globalvars.trunc_xmfzr() print globalvars.get_time(), '添加pinggu_xiangmufuzeren数据(黑龙江)' insert_data_hlj() print globalvars.get_time(), '添加pinggu_xiangmufuzeren数据(哈尔滨)' insert_data_hrb() print globalvars.get_time(), '修正评估类别' update_leibie() print globalvars.get_time(), '修正资格证编号' update_zigezheng() print globalvars.get_time(), '修正上岗证编号' update_shanggangzheng()
def run(): print globalvars.get_time(), '修正A1表环评类别' update_a1_hplb() print globalvars.get_time(), '修正A1表环统类别' update_a1_htlb()
import jshdw import staff import pgdw import xmfzr import zhuanjia import phase import phase_log import phase_a4 import phase_a5 import phase_a6 reload(sys) sys.setdefaultencoding("utf-8") if __name__ == '__main__': print globalvars.get_time(), '开始运行' #jshdw.run() #staff.run() #pgdw.run() #xmfzr.run() #zhuanjia.run() phase.run() #phase_log.run()