def task(quyu, conp, tag=None): sts = settings[quyu] for st in sts: conp = [*conp_, st[2]] if tag is None: bdate = st[4] else: bdate = datetime.strftime(datetime.now() + timedelta(days=-2), '%Y-%m-%d') src_update_dates(st[0], st[1], conp, bdate) print("t_gg_update") t_gg_update(conp, 'zlsys_%s' % st[2], st[3])
def task_conp_cfg(quyu, cfg, conpx, tag=None): cfg = json.loads(cfg) sts = cfg[quyu] for st in sts: conp = [*conpx, st[2]] if tag is None: bdate = st[4] else: bdate = datetime.strftime(datetime.now() + timedelta(days=-2), '%Y-%m-%d') src_update_dates(st[0], st[1], conp, bdate) print("t_gg_update") t_gg_update(conp, 'zlsys_%s' % st[2], st[3])
def work(conp, **krg): info = krg['info'] para = {"zfcg_bdate": None, "gcjs_bdate": None} if info is not None: info = json.loads(info) para.update(info) zfcg_bdate = para['zfcg_bdate'] gcjs_bdate = para['gcjs_bdate'] quyu = conp[4] schemas = db_query(""" SELECT nspname FROM pg_namespace """, dbtype="postgresql", conp=conp)['nspname'].values.tolist() if quyu not in schemas: db_command("""create schema if not exists %s """ % quyu, dbtype="postgresql", conp=conp) tables = db_query( """SELECT tablename FROM pg_tables where schemaname='%s' """ % quyu, dbtype="postgresql", conp=conp)['tablename'].values.tolist() if 't_gg' not in tables: tag = None else: tag = 'cdc' for st in data: if tag is None: jytype = st[1] if jytype == 'zfcg': bdate = st[4] if zfcg_bdate is None else zfcg_bdate else: bdate = st[4] if gcjs_bdate is None else gcjs_bdate print(bdate) else: bdate = datetime.strftime(datetime.now() + timedelta(days=-2), '%Y-%m-%d') src_update_dates(st[0], st[1], conp, bdate) est_func print("t_gg_update") t_gg_update(conp, st[2], st[3]) # conp=['postgres','since2015','192.168.4.201','zlsys','zlsys_yunnan_dalizhou'] # work(conp,info=None)
def work(conpx, **krg): para = {"info": None} para.update(krg) info = para['info'] schema = conpx[4] quyu = schema sts = settings[quyu] for st in sts: conp = conpx if info is None: bdate = st[4] else: bdate = datetime.strftime(datetime.now() + timedelta(days=-2), '%Y-%m-%d') src_update_dates(st[0], st[1], conp, bdate) print("t_gg_update") t_gg_update(conp, st[2], st[3])