def writeDailyFinanceComments():
link = 'http://roll.finance.sina.com.cn/finance/pl1/hgds/index.shtml'
currentList = crawDailyFinanceComments(link)
conn = SinaFinanceNetSpiderUtils.getMySQLConn()
cursor = conn.cursor()
try:
cursor.execute("DELETE FROM COMMENTS_FINANCE_RESOURCE_TABLE WHERE SOURCEFLAG = 'SINANET'")
conn.commit()
except conn.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
conn.rollback()
def writeDailyFinanceComments():
link = 'http://roll.finance.sina.com.cn/finance/pl1/hgds/index.shtml'
currentList = crawDailyFinanceComments(link)
conn = SinaFinanceNetSpiderUtils.getMySQLConn()
cursor = conn.cursor()
try:
cursor.execute(
"DELETE FROM COMMENTS_FINANCE_RESOURCE_TABLE WHERE SOURCEFLAG = 'SINANET'"
)
conn.commit()
except conn.Error, e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
conn.rollback()
