def get_oas():
    #
    sql_where = ADMIN_OA.get_where_from_fs(fs)
    sql_limit = ADMIN_OA.get_limit_from_fs(fs)
    #
    res = dict()
    res["oas"] = list()
    #
    try:
        conn, cur = ADMIN_OA.get_conn_for_mysql_oa()
        select_sql = "select * from t_account_manager"
        #
        select_sql += sql_where
        #
        select_sql += sql_limit
        all_data = UTIL.run_conn_select(cur, select_sql)
        #
        for row in all_data:
            res["oas"].append(UTIL.get_dict_in_utf8(row))
        #
        cur.close()
        conn.close()
        #
        UTIL.append_result_ok(res)
    except Exception, e:
        #
        UTIL.append_result_error(res, e)
def get_file():
    #
    res = dict()
    #
    # file-path
    temp_dir = "/search/chenzhengtong/weixin-recom/tempFiles/"
    full_path = temp_dir + "single.csv"
    f = open(full_path)
    lines = f.readlines(100000)
    #
    format_list = ["main_type", "title", "url", "level"]
    #
    if not lines:
        print "error"
    else:
        try:
            #
            conn, cur = ADMIN_OA.get_conn_for_mysql_oa()
            #
            for each_line in lines:
                line = str.rstrip(each_line)
                temp_list = line.split(",")
                #
                content_list = list()
                content_list.append(
                    unicode(temp_list[0], "gbk").encode("gbk")
                )
                content_list.append(
                    unicode(temp_list[1], "gbk").encode("gbk")
                )
                content_list.append(
                    temp_list[2].split(CONST.OPENID_PREFIX)[1]
                )
                content_list.append(temp_list[3])
                #
                sql_ui = ADMIN_OA.get_ui_sql(content_list)
                #print sql_ui
                #
                cur.execute(sql_ui)
            #
            cur.close()
            conn.close()
            #
            UTIL.append_result_ok(res)
        except Exception, e:
            #
            UTIL.append_result_error(res, e)
def get_oas():
    #
    update_details = ADMIN_OA.get_update_details_from_fs(fs)
    #
    res = dict()
    res["oas"] = list()
    #
    try:
        conn, cur = ADMIN_OA.get_conn_for_mysql_oa()
        update_sql = "update t_account_manager set"
        #
        update_sql += update_details 
        #
        UTIL.run_conn_update(cur, update_sql)
        #
        cur.close()
        conn.close()
        #
        UTIL.append_result_ok(res)
    except Exception, e:
        #
        UTIL.append_result_error(res, e)
def get_count():
    #
    sql_where = ADMIN_OA.get_where_from_fs(fs)
    #
    res = dict()
    #
    try:
        conn, cur = ADMIN_OA.get_conn_for_mysql_oa()
        sql_select = "select exists(select 1 from t_account_manager"
        sql_select += sql_where
        sql_select += ") as dup_check"
        #
        all_data = UTIL.run_conn_select(cur, sql_select)
        res["count"] = all_data
        #
        cur.close()
        conn.close()
        #
        UTIL.append_result_ok(res)
    except Exception, e:
        #
        UTIL.append_result_error(res, e)
def get_res():
    #
    sql_where = ADMIN_OA.get_where_from_fs(fs)
    #
    res = dict()
    #
    try:
        conn, cur = ADMIN_OA.get_conn_for_mysql_oa()
        sql_delete = "delete from t_account_manager"
        #
        sql_delete += sql_where 
        #
        #print sql_delete
        TE_CUSTOM.run_sql(cur, sql_delete)
        #
        cur.close()
        conn.close()
        #
        UTIL.append_result_ok(res)
    except Exception, e:
        #
        UTIL.append_result_error(res, e)
Exemple #6
0
def get_count():
    #
    sql_where = ADMIN_OA.get_where_from_fs(fs)
    #
    res = dict()
    #
    try:
        conn, cur = ADMIN_OA.get_conn_for_mysql_oa()
        select_sql = "select count(*) as total_num from t_account_manager"
        #
        select_sql += sql_where
        #
        all_data = UTIL.run_conn_select(cur, select_sql)
        res["count"] = all_data
        #
        cur.close()
        conn.close()
        #
        UTIL.append_result_ok(res)
    except Exception, e:
        #
        UTIL.append_result_error(res, e)
def get_res():
    #
    insert_details = ADMIN_OA.get_insert_details_from_fs(fs)
    #
    res = dict()
    #
    try:
        conn, cur = ADMIN_OA.get_conn_for_mysql_oa()
        insert_sql = "insert into t_account_manager"
        #
        insert_sql += insert_details 
        #
        #print insert_sql
        TE_CUSTOM.run_sql(cur, insert_sql)
        #
        cur.close()
        conn.close()
        #
        UTIL.append_result_ok(res)
    except Exception, e:
        #
        UTIL.append_result_error(res, e)
def get_file():
    #
    temp_dir = "/search/chenzhengtong/weixin-recom/tempFiles/"
    #
    file = fs["files"]
    #
    res = dict()
    #
    if file.filename:
        #
        # file-name
        #fn = file.filename
        fn = "single.csv"
        fn = os.path.basename(fn)
        #
        # file-path
        full_path = temp_dir + fn
        #
        #
        if os.path.isfile(full_path):
            os.remove(full_path)
        #
        #
        chunk = file.file.read()
        open(full_path, 'wb').write(chunk)
        #
        #
        f = open(full_path)
        lines = f.readlines(100000)
        oi_list = list()
        #
        if not lines:
            print "error"
        else:
            try:
                #
                conn, cur = ADMIN_OA.get_conn_for_mysql_oa()
                #
                for each_line in lines:
                    line = str.rstrip(each_line)
                    temp_list = line.split(",")
                    #
                    oi = temp_list[2].split(CONST.OPENID_PREFIX)[1]
                    oi_list.append(oi)
                #
                sql = "select count(*) as dup_num from t_account_manager where openid in "
                sql_in = ""
                for each_oi in oi_list[:-1]:
                    sql_in += "'" + each_oi + "',"
                sql_in += "'" + oi_list[-1] + "'"
                sql += "(" + sql_in + ")"
                #print sql
                all_data = UTIL.run_conn_select(cur, sql)
                res["count"] = all_data
                #
                cur.close()
                conn.close()
                #
                UTIL.append_result_ok(res)
            except Exception, e:
                #
                UTIL.append_result_error(res, e)