class DBConnector:
def __init__(self):
self.connector = Connector()
def create(self):
tables = [
DROP_MOVIE_TABLE, DROP_PROJECTIONS_TABLE, DROP_USERS_TABLE,
DROP_RESERVATIONS_TABLE, CREATE_USER_TABLE, CREATE_MOVIE_TABLE,
CREATE_PROJECTIONS_TABLE, CREATE_RESERVATION_TABLE,
INSERT_INTO_MOVIES, INSERT_INTO_PROJECTIONS,
INSET_INTO_RESERVATIONS
]
for table in tables:
self.connector.execute(table)
def create_saas_db():
conn = Connector()
conn.connect()
conn.execute(Table_sql)
conn.execute(Field_sql)
conn.execute(Data_sql)
conn.execute(Index_sql)
conn.close()
print("创建universal table成功!")
