Python DBManager.close Examples

Example #1

tables_avg200 = []
tables_avg200_3 = []

values_BnH = {}
values_avg200 = {}
values_avg200_3 = {}

real_symbols = []

for symbol in symbols:
    db = DBManager(symbol)
    try:
        if not data_handler.scrape_and_save_raw_prices_to_db(db):
            data_handler.analyze_data_and_save_to_db(db)
        db.close()
    except scrape.SymbolNotFound:
        print("Symbol not Found - Skipping")
        continue

    try:
        buynhold = BuyAndHold(symbol=symbol,
                              start_date=start_date,
                              end_date=end_date,
                              amount=invest_per_symbol)
        avg200 = AVG200Strat(percents=1.0,
                             symbol=symbol,
                             start_date=start_date,
                             amount=invest_per_symbol,
                             end_date=end_date)
        avg200_3 = AVG200Strat(percents=1.03,