def writeLPRConceptDataSource():
link = 'http://www.shibor.org/shibor/web/html/LPR.html'
dict = crawLPRDataSource(link)
conn = LPRDataNetSpiderUtils.getMySQLConn()
cursor = conn.cursor()
flag = LPRDataNetSpiderUtils.decideMessageExist(dict['CURRENTTIME'])
if(flag):
SQL = ' UPDATE DATACENTER_LPR_RESOURCE_TABLE RESOURCE SET RESOURCE.LRPIY=%s ' \
' WHERE 1=1 AND RESOURCE.CURRENTTIME=%s '
params = (dict['LPR1Y'],dict['CURRENTTIME'])
try:
cursor.execute(SQL,params)
conn.commit()
except conn.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
conn.rollback()
