def get_suspensionqq():
suspension_qq = SuspensionQQModel()
sort_col = request.args.get('sort_col');
if sort_col == None:
sort_col = 'CreatTime';
sort_type = request.args.get('sort_type')
if sort_type == None:
sort_type = 'DESC'
limit = request.args.get('max')
if limit == None:
limit = 5
offset = int(request.args.get('start'))
if offset == None:
offset = 0;
offset = offset*int(limit)
data = suspension_qq.get_suspensionqq(fileds="QQ")
info = "find suspension qq"
wirte_log_to_file(info)
total = len(data)
data = suspension_qq.get_suspensionqq(limit = int(limit),offset=int(offset),sort_col=sort_col,order_type=sort_type)
all_data = {
"total" :total,
"data" :data
}
return json.dumps(all_data)
def add_suspension_qq(self,url,index,path,re_pattern = "\d{5,}-{4}.{5,17}-{4}"):
logging.info(" add_suspension_qq start ")
elasticsearch_service = elasticsearchLib(url)
suspension_qq_model = SuspensionQQModel()
suspension_qq = elasticsearch_service.get_suspension_qq(index=index,path=path,re_pattern=re_pattern)
if suspension_qq != 'notfound':
for i in suspension_qq:
check_qq_is_exist = suspension_qq_model.check_qq_is_in_db(i)
if check_qq_is_exist:
if check_qq_is_exist['Password'] == suspension_qq[i]:
continue
else:
suspension_qq_model.update_qq_password(qq=i,Password = suspension_qq[i])
else:
qq_data = {}
qq_data['QQ'] = i;
qq_data['Password'] = suspension_qq[i]
qq_data['CreatTime'] = str(datetime.datetime.now().strftime('%Y.%m.%d %H:%M:%S'))
logging.info(" add qq to db")
suspension_qq_model.add_qq_to_db(qq_data=qq_data)