py_script/task_idl/idl_ad_tv_record_distribution.py

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

"""

"""

import sys

from fty_util.common import Mysql

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

conn = Mysql.createOfflineConn()

sql_comment = """
    truncate table idl.ad_tv_record_distribution
"""
sql = """
    truncate table idl.ad_tv_record_distribution
"""

Mysql.execute(sql, conn=conn)

sql = """
    insert into idl.ad_tv_record_distribution (tv_id, name, current_name, area, theme, first_type, second_type, company, record_date, form, num, film_date, film_period, `desc`, scriptwriter, director, distribution_date, is_distribute)
    select tv_id, name, current_name, area, theme, first_type, second_type, company, record_date, form, num, film_date, film_period, `desc`, scriptwriter, director, distribution_date, is_distribute from odl.ad_tv_record_distribution
"""
Mysql.execute(sql, conn=conn)

Mysql.close(conn)