Example #1
0
    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]+')'