(self)
Get all project items from projects table in db
Get all project items from projects table in db
Get all project items from projects table in db
def get_projects(self):
        """ Get all project items from projects table in db """

        connection = sqlite3.connect(self.SQL_FILE_PATH)
        cursor = connection.cursor()

        cursor.execute("SELECT * FROM projects")
        project_tuples = cursor.fetchall()
        project_objects = entities.Converter.convert_to_project(project_tuples)

        connection.close()

        self.projects.extend(project_objects)
def get_projects ( self ) : connection = sqlite3 . connect ( self . SQL_FILE_PATH ) cursor = connection . cursor ( ) cursor . execute ( "SELECT * FROM projects" ) project_tuples = cursor . fetchall ( ) project_objects = entities . Converter . convert_to_project ( project_tuples ) connection . close ( ) self . projects . extend ( project_objects )