def get_articles(): # sql_where = ADMIN_WEIXIN_CHECK.get_where_from_fs(fs) # res = dict() res["articles"] = list() # try: conn, cur = ADMIN_WEIXIN_CHECK.get_conn_for_mysql_art() table = ADMIN_WEIXIN_CHECK.get_table() # sql_select = "select count(*) as total_num from " + table sql_select += sql_where # #print sql_where #print sql_select cur.execute(sql_select) all_data = cur.fetchall() res["count"] = all_data # cur.close() conn.close() # UTIL.append_result_ok(res) except Exception, e: # UTIL.append_result_error(res, e)
def get_articles(): # sql_where = ADMIN_WEIXIN_CHECK.get_where_from_fs(fs) sql_limit = ADMIN_WEIXIN_CHECK.get_limit_from_fs(fs) # res = dict() res["articles"] = list() # try: conn, cur = ADMIN_WEIXIN_CHECK.get_conn_for_mysql_art() table = ADMIN_WEIXIN_CHECK.get_table() sql_select = "select * from " + table # sql_select += sql_where sql_select += " order by pub_time desc" sql_select += sql_limit #print sql_select # cur.execute(sql_select) all_data = cur.fetchall() for row in all_data: temp_row = copy.deepcopy(row) # res["articles"].append(UTIL.get_dict_in_utf8(temp_row)) # ''' ''' cur.close() conn.close() # UTIL.append_result_ok(res) except Exception, e: # UTIL.append_result_error(res, e)