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