def zx_list(xmurl, pagenum): #执行列表查询,返回总页数、总条数、每页数据 username = login_tool.login_tools().get_username().decode('utf-8') xmmc = cache_tool.res_cache(username) logger.info(xmmc) if xmmc[0] == None: xmmc_list = {} else: xmmc_list = re.split(r',', xmmc[0]) if xmurl in xmmc_list or xmmc[0] == None: sql_list = "SELECT zx.c_bh as zxbh,yl.c_ylmc as ylmc,to_char(zx.dt_zxsj, 'yyyy-mm-dd hh24:mi:ss') as zxsj,zx.c_cgl as cgl,zx.c_fgl as fgl,zx.c_tgl as tgl, c_sfci AS zxfs "\ "FROM db_apitesting.t_at_zxxx zx LEFT JOIN db_apitesting.t_at_ylxx yl ON zx.c_bh_yl = yl.c_bh LEFT JOIN db_apitesting.t_at_xmxx xm ON yl.c_bh_xm = xm.c_bh "\ "WHERE xm.c_url = '%s' ORDER BY zx.dt_zxsj DESC, zx.c_bh DESC LIMIT %s OFFSET %s;" % (xmurl, 10, (int(pagenum) - 1)*10) sql_count = "SELECT count(1) as counts "\ "FROM db_apitesting.t_at_zxxx zx LEFT JOIN db_apitesting.t_at_ylxx yl ON zx.c_bh_yl = yl.c_bh LEFT JOIN db_apitesting.t_at_xmxx xm ON yl.c_bh_xm = xm.c_bh "\ "WHERE xm.c_url = '%s';" % xmurl try: project_dict = {} res_list = all_dbc.pg_select_operator(sql_list) res_count = all_dbc.pg_select_operator(sql_count) project_dict['maxpage'] = math.ceil(res_count[0]['counts']/10) project_dict['maxsize'] = res_count[0]['counts'] project_dict['nowpage'] = int(pagenum) project_dict['reslist'] = res_list return jsonify(project_dict) except Exception as eee: logger.error(eee) return jsonify({'result': 'fail'}) else: abort(403)
def login(): if not request.json or 'username' not in request.json or 'password' not in request.json: abort(400) username = request.json['username'] password = request.json['password'] ccc = login_tool.login_tools().user_load(username.strip(), password) if ccc != False: return jsonify({'result': 'success', 'msg': '登录成功'}) else: return jsonify({'result': 'fail', 'msg': '账户或密码错误,请重新输入,或联系管理员重置'})
def reload_cache(): username = login_tool.login_tools().get_username().decode('utf-8') if username != 'lianglei': abort(403) else: try: cache_tool.add_cache() return jsonify({'result': 'success', 'msg': '缓存刷新成功'}) except Exception as eee: logger.error('缓存刷新失败:' + str(eee)) logger.exception(eee) return jsonify({'result': 'fail', 'msg': '缓存刷新失败'})
def updatepwd(): if not request.json or 'new_password' not in request.json: abort(400) new_password = request.json['new_password'] if 6 <= len(new_password) <= 18: username = login_tool.login_tools().get_username().decode('utf-8') res = login_tool.update_password(new_password, username) if res: return jsonify({'result': 'success', 'msg': '密码修改成功!'}) else: return jsonify({'result': 'fail', 'msg': '密码修改失败,请联系管理员!'}) else: return jsonify({'result': 'fail', 'msg': '密码需在6~18位之间'})
def view_page(ylbh, ylmc): info = {} info['ylbh'] = ylbh ip = cache_tool.res_cache('localip') wjlj = 'http://' + str(ip) + ':8585/downloadfile/' + str(ylbh) # wjlj = 'http://' + str(ip) + '/apitest/downloadfile/' + str(ylbh) #生产参数 edit_key_sql = "SELECT c_edit_key as key FROM db_apitesting.t_at_ylxx WHERE c_bh = '%s'" % ( ylbh) try: edit_key = all_dbc.pg_select_operator(edit_key_sql) except Exception as eee: logger.error('查询edit_key报错:' + str(eee)) logger.warn(wjlj) info['lj'] = wjlj info['key'] = edit_key[0]['key'] username = login_tool.login_tools().get_username().decode('utf-8') info['name'] = username return render_template('view.html', title=ylmc, info=info)
def add_tc(): if not request.json or 'tc_text' not in request.json: abort(400) username = login_tool.login_tools().get_username().decode('utf-8') if username == 'guest': return jsonify({'result': 'guest', 'msg': '游客就别吐槽了呗!_(ÒωÓ๑ゝ∠)_'}) tc_text = request.json['tc_text'] tc_id = base_tool.next_id() name = cache_tool.res_cache(username)[1] add_tc_sql = "INSERT INTO db_apitesting.c_at_tc (c_id, c_name, c_text, dt_tjsj, c_fkxx, c_fkzt, dt_fksj) VALUES ('%s', '%s', '%s', now(), NULL, '0', NULL);" % ( tc_id, name, tc_text) try: all_dbc.pg_insert_operator(add_tc_sql) except Exception as eee: logger.error('提交吐槽信息失败:' + str(eee)) logger.exception(eee) return jsonify({'result': 'fail', 'msg': '吐槽失败!(,,#゚Д゚) 请联系管理员'}) return jsonify({'result': 'success', 'msg': '提交成功'})
def project_list(): username = login_tool.login_tools().get_username().decode('utf-8') xmmc = cache_tool.res_cache(username) if xmmc[0] == None: sql = "SELECT c_bh as xmbh,c_xmmc as xmmc,c_url as xmdz FROM db_apitesting.t_at_xmxx" sql_count = "SELECT count(1) as counts FROM db_apitesting.t_at_xmxx" else: xmmc = xmmc[0].replace(',', '\',\'') xmmc = '\'' + str(xmmc) + '\'' sql = "SELECT c_bh as xmbh,c_xmmc as xmmc,c_url as xmdz FROM db_apitesting.t_at_xmxx WHERE c_url IN (%s)" % xmmc sql_count = "SELECT count(1) as counts FROM db_apitesting.t_at_xmxx WHERE c_url IN (%s)" % xmmc try: project_dict = {} res_list = all_dbc.pg_select_operator(sql) res_count = all_dbc.pg_select_operator(sql_count) project_dict['maxsize'] = res_count[0]['counts'] project_dict['reslist'] = res_list return jsonify(project_dict) except Exception as eee: logger.error('项目列表接口报错:' + str(eee)) return jsonify({'result': 'fail'})
def logout(): msg = login_tool.login_tools().logout() return jsonify({'result': 'success', 'msg': msg})