Python Connector.execute_query Exemples

Exemple #1

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