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
