def writeIndexFutureDataSource(): link = 'http://data.eastmoney.com/IF/Data/Contract.html' webNet = 'http://data.eastmoney.com' currentList = crawIndexFutureDataSource(link,webNet) conn = IndexFutureDataNetSpiderUtils.getMySQLConn() cursor = conn.cursor() try: cursor.execute("DELETE FROM DATACENTER_STOCKFUTURE_RESOURCE_TABLE") conn.commit() except conn.Error,e: print "Mysql Error %d: %s" % (e.args[0], e.args[1]) conn.rollback()
def writeIndexFutureDataSource(): link = 'http://data.eastmoney.com/IF/Data/Contract.html' webNet = 'http://data.eastmoney.com' currentList = crawIndexFutureDataSource(link, webNet) conn = IndexFutureDataNetSpiderUtils.getMySQLConn() cursor = conn.cursor() try: cursor.execute("DELETE FROM DATACENTER_STOCKFUTURE_RESOURCE_TABLE") conn.commit() except conn.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1]) conn.rollback()