def produce():
#logging.info('start')
first_update()
obj = tvslist_updating.mysql_loging()
obj.tvsou_update_log
catalog.update()
update_catalog()
#! /usr/bin/env python
#coding:utf-8
import mysql
from create_tables import create_tables,update_list
from tvslist_updating import mysql_loging
create_tables()
update_list()
myobj = mysql_loging()
myobj.update_channel_list
sqlobj = mysql.mysqldb()
dbname = sqlobj.db_name
print 'dabase name ',dbname
print '**************************'
try:
conn = mysql.connect()
cursor = conn.cursor()
cursor.execute("SET NAMES utf8")
conn.commit()
dbnames = dbname + '.' + 'live_url'
sqlmess = """insert into %s (chid,live_path) select sortnumber,bsstype from epgdb_live.publish_catalog where catalogcode='channel' """ % dbnames
#print sqlmess
cursor.execute(sqlmess)
conn.commit()
conn.close()
except:
pass
