Drop all tables from a SQLite database

DropAllTables.py

try:
  db.execute("CREATE TABLE Test (test_id INTEGER NOT NULL);")
  db.execute("INSERT INTO Test (test_id) VALUES (1);")
  tables = db.select(table="sqlite_master", where="type = 'table'", columns="name")
  self.assertTrue(len(tables) == 1)
  for table in tables:
    db.execute("DROP TABLE " + table['name'])
  tables = db.select(table="sqlite_master", where="type = 'table'", columns="name")
  self.assertTrue(len(tables) == 0)
except Exception as e:
  self.assertTrue(False, e)