コード例 #1
0
def get_articles():
    #
    enable_time = \
        datetime.datetime.fromtimestamp(
            int(WEIXIN_CHECK.get_enable_time(fs)) / 1000
        )
    disable_time = \
        datetime.datetime.fromtimestamp(
            int(WEIXIN_CHECK.get_disable_time(fs)) / 1000
        )
    #print enable_time.strftime('%Y-%m-%d %H:%M:%S')
    #print disable_time.strftime('%Y-%m-%d %H:%M:%S')
    enable_time = enable_time.strftime('%Y-%m-%d %H:%M:%S')
    disable_time = disable_time.strftime('%Y-%m-%d %H:%M:%S')
    modify_time = UTIL.get_styled_today()
    #
    title = WEIXIN_CHECK.get_title(fs)
    readnum = WEIXIN_CHECK.get_readnum(fs)
    status = WEIXIN_CHECK.get_status(fs)
    type = WEIXIN_CHECK.get_type(fs)
    #
    title = UTIL.get_str_in_gbk(title)
    type = UTIL.get_str_in_gbk(type)
    keywords = WEIXIN_CHECK.get_keywords(fs)
    #
    urls = WEIXIN_CHECK.get_urls(fs)
    unquoted_urls = list()
    for each_url in urls:
        unquoted_urls.append(urllib.unquote(each_url))
    #
    res = dict()
    #
    try:
        conn, cur = ADMIN_WEIXIN_CHECK.get_conn_for_mysql_art()
        table = ADMIN_WEIXIN_CHECK.get_table()
        #
        update_sql = "update " + table + " set keywords='%s', title='%s', read_num='%s', topic1='%s', status=%s, start_time='%s', end_time='%s', modify_time='%s' where url in (%s)"
        in_clause = ', '.join(list(map(lambda x: '%s', unquoted_urls)))
        update_sql = update_sql % (keywords, title, readnum, type, status, enable_time, disable_time, modify_time, in_clause)
        #
        #print update_sql
        cur.execute(update_sql, unquoted_urls)
        #
        cur.close()
        conn.close()
        #
        UTIL.append_result_ok(res)
        #
        res["appendix"] = {}
        res["appendix"]["start_time"] = enable_time
        res["appendix"]["end_time"] = disable_time
        res["appendix"]["modify_time"] = modify_time
    except Exception, e:
        #
        UTIL.append_result_error(res, e)