py_script/task_odl/odl_ad_tv_lib_insert.py

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

"""odl.ad_tv_lib表更新数据

"""

import sys

from fty_util.common import Mysql

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

conn = Mysql.createOfflineConn()

# 情况odl.ad_tv_lib表数据
sql = """
    select max(tv_id) as tv_id from odl.ad_tv_lib
"""
row = Mysql.getOne(sql, conn=conn)
max_tv_id = row[0]

# 电视剧信息表
sql = """
    insert into odl.ad_tv_lib (tv_id, tv_name, director, scriptwriter, main_actors, types, first_type, second_type, description, \
        pub_comp, pub_date, filmer, scheming, producer, produce_comp, produce_date, show_time, is_use, categories) \
    select id, tv_name, director, scriptwritter, main_actors, types, first_type, second_type, \
    description, pub_comp, pub_date, production, \
    cehua, jianzhi, chupin_comp, chupin_date, show_time, '0', categories from yxb.ad_tv_lib where id > '%s'
"""
sql = sql % (max_tv_id)
Mysql.execute(sql, conn=conn)

Mysql.close(conn)