def webLabel(): sql = """ SELECT number FROM risk_number_label """ num = equery.execute_select(dbconfig.RISK_CONFIG, sql) numlist = [str(int(number['number'])) for number in num] update_label(numlist, 'web')
def get_userInfo(sql, filename): """ 获取用户基本信息 """ userInfo = equery.execute_select(dbconfig.MAIN_CONFIG, sql) userdata = pd.DataFrame(userInfo) userdata.to_csv(filename, index=False, encoding="utf-8") userdata = pd.read_csv(filename, encoding="utf-8") userdata['phone'] = [phone[2:-1] for phone in userdata['phone']] userdata['id_num'] = [id_num[2:-1] for id_num in userdata['id_num']] userdata.to_csv(filename, index=False, encoding="utf-8")
def contact_item_info(user): """ 获取每个人的运营商数据 """ sql = """ SELECT user_id,receive_phone,count(*) 'num' FROM third_mobile_tel_data WHERE user_id = '{}' AND call_type = 1 and receive_phone is not null GROUP BY receive_phone HAVING count(*) >= 2 """.format(user[0]) filename = user[1] + user[0] + '.csv' userContact = equery.execute_select(dbconfig.RISK_CONFIG, sql) if userContact: contactdata = pd.DataFrame(userContact) contactdata.to_csv(filename, index=False)
def query_group(): user_id = '6bad659bb6234b08b24787d11e5762a0' phoneId = '15777670597' sql = """ SELECT user_id,receive_phone,count(*) 'num' FROM third_mobile_tel_data WHERE user_id = '{}' AND call_type = 1 AND receive_phone IS NOT NULL GROUP BY receive_phone HAVING count(*) >= 2 """.format(user_id) userInfo = equery.execute_select(dbconfig.RISK_CONFIG, sql) content_list = [(item.get('receive_phone'), item.get('num')) for item in userInfo] content_dict = {} for phone, num in content_list: plabel = phone if not phone.startswith('0') else phone[1:] content_dict[plabel] = num jsondict = findgroup_api(content_dict, phoneId) json.dump(jsondict,open('html/temp.json','w'))
def query_one(): user_id = '7336dfc7597d46bfab2c68f841ef479d' phoneId = '15077694366' sql = """ SELECT user_id,receive_phone,count(*) 'num' FROM third_mobile_tel_data WHERE user_id = '{}' AND call_type = 1 AND receive_phone IS NOT NULL GROUP BY receive_phone HAVING count(*) >= 2 """.format(user_id) userInfo = equery.execute_select(dbconfig.RISK_CONFIG, sql) content_list = [(item.get('receive_phone'), item.get('num')) for item in userInfo] content_dict = {} for phone, num in content_list: plabel = phone if not phone.startswith('0') else phone[1:] content_dict[plabel] = num #record = find_label(content_dict, phoneId) record = find_api(content_dict, phoneId) print(record)
def query_maney(): user = pd.read_csv('data/testuser.csv') k,j,jbad,jblack,jblackgroup,jinterblack1,jinterblack2,jweb,jbank = 0,0,0,0,0,0,0,0,0 for i in range(len(user)): userId = user.ix[i]['id'] phoneId = user.ix[i]['phone'] sql = """ SELECT user_id,receive_phone,count(*) 'num' FROM third_mobile_tel_data WHERE user_id = '{}' AND call_type = 1 AND receive_phone IS NOT NULL GROUP BY receive_phone HAVING count(*) >= 2 """.format(userId) userInfo = equery.execute_select(dbconfig.RISK_CONFIG, sql) content_list = [(item.get('receive_phone'), item.get('num')) for item in userInfo] content_dict = {} for phone, num in content_list: plabel = phone if not phone.startswith('0') else phone[1:] content_dict[plabel] = num #record = find_label(content_dict, phoneId) jsondict = find_api(content_dict, phoneId) if jsondict['label'] is None: j += 1 if all([value is None for value in jsondict.values()]): k += 1 if jsondict['bad'] is None: jbad += 1 if jsondict['black'] is None: jblack += 1 if jsondict['blackgroup'] is None: jblackgroup += 1 if jsondict['interblack1'] is None: jinterblack1 += 1 if jsondict['interblack2'] is None: jinterblack2 += 1 if jsondict['web'] is None: jweb += 1 if jsondict['bank'] is None: jbank += 1 print(userId) print(phoneId) print(jsondict) print('未覆盖量:'+ str(k)) print('未存在于数据库的量:' + str(j)) print('总测试量:'+ str(len(user))) print('jbad:'+str(jbad)) print('jblack:'+str(jblack)) print('jblackgroup:'+str(jblackgroup)) print('jinterblack1:'+str(jinterblack1)) print('jinterblack2:'+str(jinterblack2)) print('jweb:'+str(jweb)) print('jbank:'+str(jbank))