def statis4FlightInfo(duration):
conn = g_db.getConn()
if not conn:
L.error("connect db failed.")
return ER_CONN_DB_FAILED
handler = FlightInfoHandler(conn)
print "FlightInfo:"
for i in range(duration, -1, -1):
queryDate = (datetime.datetime.today() - datetime.timedelta(days=i)).strftime("%Y-%m-%d")
recNum = handler.getRecordNum(query_date=queryDate)
print "{} : {}".format(queryDate, recNum)
def statis4FlightInfo(duration):
conn = g_db.getConn()
if not conn:
L.error("connect db failed.")
return ER_CONN_DB_FAILED
handler = FlightInfoHandler(conn)
print "FlightInfo:"
for i in range(duration, -1, -1):
queryDate = (datetime.datetime.today() -
datetime.timedelta(days=i)).strftime("%Y-%m-%d")
recNum = handler.getRecordNum(query_date=queryDate)
print "{} : {}".format(queryDate, recNum)
def processDataByFile(fileName, depDate, depCode, arrCode):
curDateTime = time.localtime(time.time())
queryDate = time.strftime('%Y-%m-%d', curDateTime)
queryTime = time.strftime('%H:%M:%S', curDateTime)
retList = qunar.analysis(fileName)
if not retList:
L.error("Not found airline")
global g_db
conn = g_db.getConn()
if not conn:
L.error("connect db failed.")
return ER_CONN_DB_FAILED
handler = FlightInfoHandler(conn)
for rec in retList:
flightInfo = FlightInfo(queryDate, queryTime, depDate, depCode, arrCode, rec)
handler.insertOneRec(flightInfo)
return ER_SUCC
