def getSectorDayAnalysisList(id_list):
'''
查询sectorpredict表
返回list中的板块对应的kline数据，如果list为空，则返回所有数据
返回所有版块的kline数据
'''
# db
conn = DBUtil.getConnection()
cursor = conn.cursor()
sql_query = "SELECT sectorID, sectorName FROM sectorinfo WHERE sectorID=%s;"
# 查找 list(tuple(id, name))
sectorDayAnalysisTupleList = []
sectorAnalysisList = []
if 0 == len(id_list):
sql_query = sql_query[:sql_query.index("WHERE")]
cursor.execute(sql_query)
sectorDayAnalysisTupleList = cursor.fetchall()
else:
sectorDayAnalysisTupleList = DBUtil.query_many(sql_query, id_list)
# 根据 list(tuple(id, name)) 查询k线数据
for sectorID, sectorName in sectorDayAnalysisTupleList:
sql_query = "SELECT * from sectorpredictioninfo WHERE sectorID=%s"
res_number = cursor.execute(sql_query, sectorID)
if 0 != res_number:
sectorData = cursor.fetchone()
sectorAnalysis = SectorAnalysis()
sectorAnalysis.sectorID = sectorData[0]
sectorAnalysis.sectorName = sectorName
sectorAnalysis.recordTime = sectorData[1].strip().split(",")
sectorAnalysis.lastTrade = [
round(float(x), 2) for x in sectorData[2].strip().split(",")
if x != ""
]
sectorAnalysis.changeAmount = [
round(float(x)) for x in sectorData[3].strip().split(",")
if x != ""
]
sectorAnalysis.changeRate = [
round(float(x)) for x in sectorData[4].strip().split(",")
if x != ""
]
sectorAnalysis.totalCapit = [
round(float(x)) for x in sectorData[5].strip().split(",")
if x != ""
]
sectorAnalysis.turnoverRate = [
round(float(x)) for x in sectorData[6].strip().split(",")
if x != ""
]
sectorAnalysisList.append(sectorAnalysis)
cursor.close()
conn.close()
return sectorAnalysisList
def getSectorInfoListByIDList(id_list):
'''
查询sectorinfo表
查询idlist中对应的版块的最新信息，如果list为空，那么返回所有版块的信息
'''
sql_query = "SELECT sectorID, sectorName, sectorType.sectorTypeName, recordTime, lastTrade, changeAmount, " \
"changeRate, totalCapit, turnoverRate, riseNumber, fallNumber " \
"FROM sectorinfo JOIN sectorType " \
"ON sectorinfo.sectorType=sectorType.sectorTypeID " \
"WHERE sectorinfo.sectorID=%s;"
conn = DBUtil.getConnection()
cursor = conn.cursor()
sectorInfoTupleList = []
sectorInfoList = []
if 0 == len(id_list):
sql_query = sql_query[:sql_query.index("WHERE")] + ";"
amount = cursor.execute(sql_query)
sectorInfoTupleList = cursor.fetchall()
else:
amount = cursor.executemany(sql_query, id_list)
sectorInfoTupleList = DBUtil.query_many(sql_query, id_list)
for item in sectorInfoTupleList:
sectorInfo = SectorInfo()
sectorInfo.sectorID = item[0]
sectorInfo.sectorName = item[1]
sectorInfo.sectorType = item[2]
sectorInfo.recordTime = str(item[3])
sectorInfo.lastTrade = item[4]
sectorInfo.changeAmount = item[5]
sectorInfo.changeRate = item[6]
sectorInfo.totalCapit = item[7]
sectorInfo.turnoverRate = item[8]
sectorInfo.riseNumber = item[9]
sectorInfo.fallNumber = item[10]
sectorInfoList.append(sectorInfo)
cursor.close()
conn.close()
return sectorInfoList