def GetAllProjects():
"""
Get all the saved projects in our database.
:return: Project[]
"""
projects = []
response = SaveHelper.executeQuery("SELECT ROWID, * FROM projects ORDER BY timestamp DESC")
for row in response:
projects.append(Project.FromRow(row))
return projects
def FromCommand(command):
"""
Load a command with details from the database.
:param command: command that is being called (string)
:return:
"""
response = SaveHelper.executeQuery("SELECT * FROM workspace_commands WHERE command_value = ?", command)
if len(response) == 0:
return None
else:
return Command.FromRow(response[0])
