class MovieModel: def __init__(self): self.conn = Connector() def create(self, name, rating): query = CREATE_MOVIE self.conn.execute_query(query, (name, rating)) def list(self): query = LIST_MOVIES return self.conn.all(query) @classmethod def get_movie_id(self, id): query = GET_MOVIE_IN_PROJECTIONS a = conn.execute(query, (id, )) result = [] for i in a.fetchall(): result.append(i) # print(result) return result