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
