def get_crbt23g_user(filename): _temps = get_data(filename) try: temps = _temps[:-2] crbt23g = sum([float(x[1]) for x in temps]) except Exception: crbt23g = 0 return crbt23g
def get_streamnumber(filename): import re max_streamnumber = "" max_cluster = "" record_data = get_data(filename) for x in record_data: if re.match('s[cb][dp][0-9]{3}', str(x[0])): max_cluster = x[0] max_streamnumber = x[1].strip("\n") break return max_cluster, max_streamnumber
def get_dict(filename): caps = get_data(filename) caps_dict = {} for x in caps: try: x.remove('') except ValueError: pass if len(x) == 2: caps_dict[x[0]] = float(x[1]) else: caps_dict[x[0]] = x[1:] return caps_dict
def get_dailycaps(filename): caps = get_data(filename) caps_dict = {} for x in caps: try: x.remove('') except ValueError: pass if x[0] == "CRBT-CLAS03" and x[1] == "CLAS": pass else: caps_dict[x[0]] = float(x[2]) return caps_dict
def get_v_users(filename): today = datetime.date.today().strftime("%Y%m%d") all_users = get_data(filename) user_db = {} user_db['date'] = today for x in all_users: try: x.remove('') except ValueError: pass user_type = x[0].strip(' ') if user_type in config.users_tilte.keys(): user_name = config.users_tilte.get(user_type) user_value = int(x[1].strip(' ')) user_db[user_name] = user_value crbt_temp = get_crbt_user() crbt = crbt_temp if crbt_temp else 0 vrbt_temp = get_vrbt_user() vrbt = vrbt_temp if vrbt_temp else 0 ctx_only_temp = get_ctxonly_user() ctx_only = ctx_only_temp if ctx_only_temp else 0 ctx_group_temp = get_ctx_group() ctx_group = ctx_group_temp if ctx_group_temp else 0 crbt23g = get_crbt23g_user() newcy, ccp = get_cy_ccp() scim = get_scim_user() user_db.update({ 'crbt_volte': crbt, 'vrbt': vrbt, 'ctx_user': ctx_only, 'ctx_group': ctx_group, 'crbt_23g': crbt23g, 'newcy': newcy, 'ccp': ccp, 'scim': scim }) try: db.insert('users',**user_db) except Exception as e: logging.error("用户数入库错误" + str(e)) return user_db
def get_caps(filename): yesterday = (datetime.date.today() - datetime.timedelta(days=1)).strftime("%Y%m%d") caps_data = [] caps_db = {} record_data = get_data(filename) for value in record_data: caps_name = config.caps_tilte.get(value[0]) try: caps_value = float(value[1]) except ValueError: # 跳过数据为空 caps_value = "" caps_data.append( [caps_name, caps_name.split('_')[0].upper(), caps_value]) caps_db[caps_name] = caps_value caps_db['date'] = yesterday try: db.insert("caps", **caps_db) except Exception as e: logging.error("CAPS数据入库错误" + str(e)) return caps_data
def get_scim_user(filename): scim_user = float(get_data(filename)[0][1]) return scim_user
def get_vpmn_user(filename): vpmn_volte = float(get_data(filename)[0][0]) return vpmn_volte
def get_sicp4_user(filename): temps = get_data(filename) return [float(x[0]) for x in temps] if len(temps) ==2 else [0, 0]
def get_all_ctxuser(filename): temps = get_data(filename) ctx_all = sum([float(x[1]) for x in temps]) return ctx_all
def get_ctxonly_user(filename): ctx_user = float(get_data(filename)[0][0]) return ctx_user
def get_vrbt_user(filename): vrbt_users = float(get_data(filename)[0][0]) return vrbt_users
def get_crbt_user(filename): crbt_volte = sum([float(x[1]) for x in get_data(filename)]) return crbt_volte
def get_pyq_user(filename): pyq_volte = float(get_data(filename)[0][0]) return pyq_volte
def get_hjh_user(filename): hjh_volte = float(get_data(filename)[0][0]) return hjh_volte
def get_scpas_streamnumber(filename): record_data = get_data(filename) record_data.sort(key=lambda x: int(x[1]), reverse=True) max_cluster = record_data[0][0] max_streamnumber = record_data[0][1] return max_cluster, max_streamnumber