def __init__(self, quote, database, logger=None): if logger == None: logSys = LogSubSystem(__name__, "debug") self._logger = logSys.getLog() else: self._logger = logger self.connection = sql.connect(database) with self.connection: self.connection.row_factory = sql.Row self.cursor = self.connection.cursor() self.cursor.execute( 'select symbol, market, rss from stocks where ticker=:ticker', {"ticker": quote}) row = self.cursor.fetchone() if (row == None): self._logger.error( '** No reference found in database, exiting...') sys.exit(-1) else: self.symbol = row['symbol'] self.market = row['market'] self.rss_source = row['rss'] self.rss = 'http://www.google.com/finance/company_news?q=' + row[ 'market'] + ':' + row['symbol'] + '&output=rss' self.name = quote
def __init__(self, quote, database, logger=None): if logger == None: logSys = LogSubSystem(__name__, "debug") self._logger = logSys.getLog() else: self._logger = logger self.connection = sql.connect(database) with self.connection: self.connection.row_factory = sql.Row self.cursor = self.connection.cursor() self.cursor.execute('select symbol, market, rss from stocks where ticker=:ticker', {"ticker": quote}) row = self.cursor.fetchone() if ( row == None ): self._logger.error('** No reference found in database, exiting...') sys.exit(-1) else: self.symbol = row['symbol'] self.market = row['market'] self.rss_source = row['rss'] self.rss = 'http://www.google.com/finance/company_news?q=' + row['market'] + ':' + row['symbol'] + '&output=rss' self.name = quote