def crawlStockPool(link):
#init MySQL Connection
mysqlConn = WlStockPoolSpiderUtils.getConnection()
mysqlCur = mysqlConn.cursor()
#INIT STOCK POOL INFORMATION
startContext = WlStockPoolSpiderUtils.returnStartContext(link,'<div class="arrowlist">')
startcontext = WlStockPoolSpiderUtils.returnFilterMainContext(startContext,'<div class="arrowlist">', '<div class="clear marb"></div>')
for i in range(WlStockPoolSpiderUtils.findAllTarget(startcontext,'<ul>')):
targetContext = WlStockPoolSpiderUtils.divisionTarget(startcontext,'<ul>','</ul>')
startcontext = targetContext['nextContext']
currentcontext = targetContext['targetContext']
stockMain = WlStockPoolSpiderUtils.filterContextByTarget(currentcontext,'<b>','</b></h2>')
gpcId = str(uuid.uuid1())
startFilterContext = currentcontext
filterCurrentForumSet = []
filterStockForum = []
## FILTER CURRENT UL LIST
for count in range(WlStockPoolSpiderUtils.findAllTarget(currentcontext, '<li>')):
filterTargetContext = WlStockPoolSpiderUtils.divisionTarget(startFilterContext,'<li>','</li>')
filterCurrentContext = filterTargetContext['targetContext']
startFilterContext = filterTargetContext['nextContext']
filterLinkUrl = WlStockPoolSpiderUtils.filterContextByTarget(filterCurrentContext,"<a href='",' target="_blank">')
linkUrl = filterLinkUrl[:len(filterLinkUrl)-1]
stockSector = WlStockPoolSpiderUtils.filterContextByTarget(filterCurrentContext,'target="_blank">','</a>')
stockSetId = str(uuid.uuid1())
stockSetMap = filterStockPoolList(linkUrl,stockSetId)
stockForumDescription = stockSetMap['stockForumDescription']
filterStockForum += stockSetMap['stockSet']
filterCurrentForumSet.append([gpcId,linkUrl,stockSector,stockForumDescription,stockSetId])
sql = "INSERT INTO STOCK_POOL_MAIN_TABLE (STOCK_MAIN,STOCKPOOL_ID)VALUES('"+stockMain+"','"+gpcId+"')"
##DATASET SUBMIT
try:
mysqlCur.execute(sql)
mysqlConn.commit()
except mysqlConn.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
mysqlConn.rollback()
## DATASET COMMIT TO STOCK_POOL_MAIN_THEME_RESOURCE_TABLE
try:
mysqlCur.executemany('INSERT INTO STOCK_POOL_MAIN_THEME_RESOURCE_TABLE (STOCKSETID,STOCKNAME,STOCKNUMBER) VALUES (%s,%s,%s)',filterStockForum)
mysqlConn.commit()
except mysqlConn.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
mysqlConn.rollback()
def crawlStockPool(link):
#init MySQL Connection
mysqlConn = WlStockPoolSpiderUtils.getConnection()
mysqlCur = mysqlConn.cursor()
#INIT STOCK POOL INFORMATION
startContext = WlStockPoolSpiderUtils.returnStartContext(
link, '<div class="arrowlist">')
startcontext = WlStockPoolSpiderUtils.returnFilterMainContext(
startContext, '<div class="arrowlist">',
'<div class="clear marb"></div>')
for i in range(WlStockPoolSpiderUtils.findAllTarget(startcontext, '<ul>')):
targetContext = WlStockPoolSpiderUtils.divisionTarget(
startcontext, '<ul>', '</ul>')
startcontext = targetContext['nextContext']
currentcontext = targetContext['targetContext']
stockMain = WlStockPoolSpiderUtils.filterContextByTarget(
currentcontext, '<b>', '</b></h2>')
gpcId = str(uuid.uuid1())
startFilterContext = currentcontext
filterCurrentForumSet = []
filterStockForum = []
## FILTER CURRENT UL LIST
for count in range(
WlStockPoolSpiderUtils.findAllTarget(currentcontext, '<li>')):
filterTargetContext = WlStockPoolSpiderUtils.divisionTarget(
startFilterContext, '<li>', '</li>')
filterCurrentContext = filterTargetContext['targetContext']
startFilterContext = filterTargetContext['nextContext']
filterLinkUrl = WlStockPoolSpiderUtils.filterContextByTarget(
filterCurrentContext, "<a href='", ' target="_blank">')
linkUrl = filterLinkUrl[:len(filterLinkUrl) - 1]
stockSector = WlStockPoolSpiderUtils.filterContextByTarget(
filterCurrentContext, 'target="_blank">', '</a>')
stockSetId = str(uuid.uuid1())
stockSetMap = filterStockPoolList(linkUrl, stockSetId)
stockForumDescription = stockSetMap['stockForumDescription']
filterStockForum += stockSetMap['stockSet']
filterCurrentForumSet.append([
gpcId, linkUrl, stockSector, stockForumDescription, stockSetId
])
sql = "INSERT INTO STOCK_POOL_MAIN_TABLE (STOCK_MAIN,STOCKPOOL_ID)VALUES('" + stockMain + "','" + gpcId + "')"
##DATASET SUBMIT
try:
mysqlCur.execute(sql)
mysqlConn.commit()
except mysqlConn.Error, e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
mysqlConn.rollback()
## DATASET COMMIT TO STOCK_POOL_MAIN_THEME_RESOURCE_TABLE
try:
mysqlCur.executemany(
'INSERT INTO STOCK_POOL_MAIN_THEME_RESOURCE_TABLE (STOCKSETID,STOCKNAME,STOCKNUMBER) VALUES (%s,%s,%s)',
filterStockForum)
mysqlConn.commit()
except mysqlConn.Error, e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
mysqlConn.rollback()
