Python TE_DAILY_TAG Examples

Example #1

File: api_mysql_is_tagged.py Project: TeaEra/CZT_Web

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

Example #2

File: api_mysql_tag.py Project: TeaEra/CZT_Web

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