def get_res(): # time_type = fs["time_type"].value curr_date = fs["curr_date"].value #time_type = 1 #curr_date = "2014-11-15" # res = dict() # try: conn, cur = TE_DAILY_TAG.get_conn() table = TE_DAILY_TAG.get_table(time_type) # select_sql = "select 1 from " + table where_sql = " where unix_timestamp(time) >= unix_timestamp('%s') and unix_timestamp(time) <= unix_timestamp('%s')" % (curr_date + " 00:00:00", curr_date + " 23:59:59") select_sql += where_sql # #print select_sql cur.execute(select_sql) all_data = cur.fetchall() res["res"] = all_data # cur.close() conn.close() # res["status"] = 0 res["message"] = "ok" except Exception, e: # res["status"] = 1 res["message"] = e
def get_res(): # time_type = fs["time_type"].value curr_date = fs["curr_date"].value user = fs["user"].value # #time_type = 1 #curr_date = "2014-11-15" # res = dict() # try: conn, cur = TE_DAILY_TAG.get_conn() table = TE_DAILY_TAG.get_table(time_type) # insert_sql = "insert into " + table + "(user, time)" insert_sql += " values ('%s', '%s')" % (user, curr_date) # #print insert_sql cur.execute(insert_sql) conn.commit() # cur.close() conn.close() # res["status"] = 0 res["message"] = "ok" except Exception, e: # res["status"] = 1 res["message"] = e