py_script/task_clean/odl_ad_tv_record_distribution_update_company_field.py

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

"""更新表odl.ad_tv_record_distribution表的theme, first_type, second_type字段，去除空白符

"""

import datetime
import os
import sys
import time

from fty_util.common import Mysql

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

conn = Mysql.createOfflineConn()
# 清空走势数据

sql = """
    select id, company, `desc` from odl.ad_tv_record_distribution where id > 5000
"""

rows = Mysql.getAll(sql, conn=conn)
for row in rows:
    _id = row['id']
    company = row['company']
    desc = row['desc']
    company = company.replace(u'报备机构:', '').replace(u'报备机构：', '').replace('\r', '').replace('\n', '').replace('\t', '').replace('\'', '\\\'').replace('\"', '\\\"')
    desc = desc.replace(u'内容提要:','').replace(u'内容提要：','').replace('\r', '').replace('\n', '').replace('\t', '').replace('\'', '\\\'').replace('\"', '\\\"')

    sql = """
        update odl.ad_tv_record_distribution set company = '%s', `desc` = '%s' where id = '%s'
    """
    sql = sql % (company, desc, _id)
    Mysql.execute(sql, conn=conn)

Mysql.close(conn)