import sqlite3, os

class Historicreset:
    def __init__(self):
        self.here_i_am = os.path.dirname(os.path.abspath(__file__))
        self.boom_database_name = "Trial7 Tracks Database"
        self.boom_table_list = []
        self.table0 = 'THE_1950s'
        self.table1 = 'THE_1960s'
        self.table2 = 'THE_1970s'
        self.table3 = 'THE_1980s'
        self.table4 = 'THE_1990s'
        self.table5 = 'THE_2000s'
        self.table6 = 'THE_2010s'
        self.table7 = 'THE_2020s'
        self.table8 = 'THE_Others'
        self.btab = 0

    def doit(self):
        self.boom_database = self.here_i_am + r"\\" + self.boom_database_name + ".db"
        self.boom_table_list.extend([self.table0, self.table1, self.table2, self.table3,
                                    self.table4, self.table5, self.table6, self.table7, self.table8])
        self.create_connection(self.boom_database)
        while self.btab < 9:
            self.reset(self.boom_table_list[self.btab])
            self.btab+=1

    def create_connection(self, db_file):  # NOTE Connect to the database
        self.conn = None
        self.conn = sqlite3.connect(db_file)
        return self.conn

    def reset(self, boomtable):
        cur = self.conn.cursor()
        cur.execute("SELECT * FROM " + boomtable + "")
        rows = cur.fetchone()
        cur.execute("UPDATE '" + boomtable + "' SET HISTORIC = FALSE ")
        self.conn.commit()



a = Historicreset()
a.doit()