def projects_for_user(user_id, cursor = None):
cursor.execute("""
SELECT project.id as proj_id,
project.designator as proj_designator,
project.name as proj_name,
project_image.folder as image_folder,
project_image.file_name as image_file_name,
project_image.file_type as image_file_type
from project
LEFT JOIN project_image ON project_image.project_id = project.id
WHERE project.id IN
(
SELECT distinct project_id
from user_projects
where user_id = %(user_id)s
);""",
{'user_id': user_id})
results = cursor.fetchall() or {}
projects = []
for row in results:
projects.append(Project.map_from_form(row))
return projects
def create_project(api_response = True):
project_form = sanitize.form_keys(json.loads(request.form['payload']))
project = Project.map_from_form(project_form)
token_form = sanitize.form_keys(json.loads(request.form['token']))
token = Token.map_from_form(token_form)
project = project_insert.create_project(project, token.user_id)
parent_url = "api/DAL/images/projects/"
project.image.save_to_file_system(parent_url)
return response.success(project.id)
def project(project_id, cursor = None):
cursor.execute("""
SELECT distinct
project.id as proj_id,
project.designator as proj_designator,
project.name as proj_name,
project_image.folder as image_folder,
project_image.file_name as image_file_name,
project_image.file_type as image_file_type
from project
LEFT JOIN project_image ON project_image.project_id = project.id
WHERE project.id = %(project_id)s""",
{'project_id': project_id})
row = cursor.fetchone()
project = Project.map_from_form(row)
return project
