def keywordquery():
query = request.form['query']
arealist, stationlist = areaandstationlist(cursor)
info = []
idinfo = []
global info0
for station in stationlist:
sql = "SELECT stationid,name1,IDENTIFIER,assetid FROM %s \
WHERE stationid LIKE '%%%s%%' OR name1 LIKE '%%%s%%'" % (
station, query, query)
try:
# 执行SQL语句
cursor.execute(sql)
# 获取所有记录列表
results = cursor.fetchall()
if results != None:
info.extend(results)
idinfo.extend([i[3] for i in results])
except:
print("Error: unable to fetch data")
if info == []:
queryerr = 1
return render_template('index.html', queryerr=queryerr)
for i in range(len(idinfo)):
if idinfo[i] is None:
idinfo[i] = "该基站未进行资产匹配！,".strip(',').split(',')
else:
idinfo[i] = idinfo[i].strip(',').split(',')
info0 = info
return render_template('keywordquery.html', assets=info, idinfo=idinfo)
def keywordquery():
query = request.form['query']
arealist,stationlist = areaandstationlist(cursor)
station = u'站址'
info = []
idinfo =[]
global info0
sql = "SELECT id,crru,c基站,c室分站,c直放站,lrru,l基站,资产个数 FROM %s WHERE id LIKE '%%%s%%' " % (station, query)
try:
# 执行SQL语句
cursor.execute(sql)
results = cursor.fetchall()
if results != None:
info = list(results)
except:
print("Error: unable to fetch data")
if info == []:
queryerr = 1
return render_template('index.html', queryerr=queryerr)
# for i in range(len(idinfo)):
# if idinfo[i] is None:
# idinfo[i]="该基站未进行资产匹配！,".strip(',').split(',')
# else:
# idinfo[i] = idinfo[i].strip(',').split(',')
info0 = info
return render_template('keywordquery.html', assets=info)
import pymysql
import time
from match_f import areaandstationlist, assetmatch, stationmatch
starttime = time.clock()
# 连接数据库
db = pymysql.connect("localhost",
"root",
"",
"assetsmanagement",
charset='utf8')
cursor = db.cursor()
# 查询数据库中的表格
(arealist, stationlist) = areaandstationlist(cursor)
#打开保存匹配结果文件
f = open('result.txt', 'w+')
# 资产匹配基站
for area in arealist:
assetmatch(cursor, area, stationlist, f)
f.close()
f = open('result.txt', 'a+')
# 基站匹配资产
for station in stationlist:
stationmatch(cursor, station, arealist, f)
f.close()
db.close()
print(time.clock() - starttime)