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
def getDefaultProjects() -> list:
"""Creates default projects as defined in the configuration
with default task "-".
Returns:
list -- List of Projects
"""
projectList = []
for projectName in DEFAULT_PROJECT:
project = Project()
project.projectName = projectName
taskList = []
task = Task()
task.taskName = "-"
taskList.append(task)
project.taskList = taskList
projectList.append(project)
return projectList
