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()