def __init__(self): self.urlStockHolder = 'http://vip.stock.finance.sina.com.cn/corp/go.php/vCI_StockHolder/stockid/%s.phtml' BaseDB.__init__(self, 'stockinfo') self.conn.select_db('stockinfo'); self.cursor = self.conn.cursor() self.tblnameBigHolders = 'bigholders' self.tblnameHolderStats = 'holderstats' insertCols = "(" for i in range(len(DBCOL_NAME_BIG_HOLDERS)-1): insertCols += "%s,"%(DBCOL_NAME_BIG_HOLDERS[1+i]) self.insertSqlBigHolders = insertCols[0:-1]+')' insertCols = "(" for i in range(len(DBCOL_NAME_HOLDER_INFO)-1): insertCols += "%s,"%(DBCOL_NAME_HOLDER_INFO[1+i]) self.insertSqlHolderStats = insertCols[0:-1]+')'