def getActiveProjects() -> list:
"""Get active projects
"""
cursor = connection.cursor()
cursor.execute(SQLQueries.ACTIVE_PROJECT_GET)
queryResult = cursor.fetchall()
if (len(queryResult) == 0):
return None
projectList = []
for project in queryResult:
projectData = Project()
projectData.projectId = project[0]
projectData.projectName = project[1]
projectList.append(projectData)
return projectList
