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成功!")