def update_and_open_db(self):
if self.analysis_only:
self._open_db()
else:
#
#Check if todays price file is created
#
reader = sql_db_util.open_names();
for row in reader:
self.nameArray.append(row)
if sql_db_util.check_update():
print "Found Update"
self._open_db()
else:
#
# Check if today is a market day
#
if self._today_is_market_day():
print "TODAY IS MARKET DAY"
#
# Update Price and SMA DB (opens them too)
#
self.update_price_db()
self.update_sma_db()
else:
self._open_db()
def _open_db(self):
#
# Open Name Db
#
self.nameArray = []
reader = sql_db_util.open_names();
for row in reader:
self.nameArray.append(row)
#
# Open Price Db
#
self.priceArray = []
reader = sql_db_util.open_reader('stock_prices')
for row in reader:
self.priceArray.append(row)
#
# Open SMA Db
#
self.smaArray = []
reader = sql_db_util.open_reader('stock_sma')
for row in reader:
self.smaArray.append(row)
#
# Open 50day SMA
#
self.sma50Array = []
reader = sql_db_util.open_reader('stock_sma50')
for row in reader:
self.sma50Array.append(row)
