py_script/task_idl/idl_tv_article_marketing_count.py

#!/usr/bin/env python
#coding=utf-8

"""新剧营销文章数量爬取

"""

import os
import sys

from fty_util.common import Mysql, Util

reload(sys)
sys.setdefaultencoding('utf8')

first_day = Util.get_first_date_of_yesterday()

conn = Mysql.createOfflineConn()
# 清空数据
sql = """
    truncate table idl.tv_article_marketing_count
"""
Mysql.execute(sql, conn=conn)

sql = """
    insert into idl.tv_article_marketing_count (tv_id, tv_name, search_type, media_name, search_restrict_url, scrapy_count)
    select tv_id, tv_name, search_type, media_name, search_restrict_url, scrapy_count from scrapy.scrapy_article_count order by tv_id asc
"""
Mysql.execute(sql, conn=conn)

Mysql.close(conn)