def select_roles_referential(): select_query = select([ROLE_REFERENTIAL_TABLE]) rows = connection.execute(select_query) roles = [] for row in rows: roles.append(row['role']) return roles
def insert_project(project_id, project_name, project_type): insert = PROJECT_TABLE.insert().values(project_id=project_id, project_name=project_name, project_type=project_type) try: result = connection.execute(insert) except Exception as ex: print('Error occured : ' + str(ex))
def insert_role_for_user(email, project_id, role): insert = USER_PROJECT_ROLE_TABLE.insert().values(email=email, project_id=project_id, role=role) try: result = connection.execute(insert) except Exception as ex: print('Error occured : ' + str(ex))
def insert_task(task_id, task_type, labels, project_id): insert = TASK_TABLE.insert().values(task_id=task_id, task_type=task_type, project_id=project_id, labels=labels) try: result = connection.execute(insert) except Exception as ex: print('Error occured : ' + str(ex))
def insert_user(email, last_name, first_name): insert = USERS_TABLE.insert().values(email=email, last_name=last_name, first_name=first_name, is_deleted=False) try: result = connection.execute(insert) except Exception as ex: print('Error occured : ' + str(ex))
def select_projects(): select_query = select([PROJECT_TABLE]) rows = connection.execute(select_query) projects = [] for row in rows: projects.append( Project(project_id=row['project_id'], project_name=row['project_name'], project_type=row['project_type'], tasks=None)) return projects
def select_users(): select_query = select([USERS_TABLE ]).where(USERS_TABLE.c.is_delete is False) rows = connection.execute(select_query) users = [] for row in rows: users.append( User(email=row['email'], first_name=row['first_name'], last_name=row['last_name'])) return users
def select_tasks(): select_query = select([TASK_TABLE]) rows = connection.execute(select_query) tasks = [] print(rows == None) for row in rows: tasks.append( Task(task_id=row['task_id'], task_type=row['task_type'], project_id=row['project_id'], labels=row['labels'])) print(len(tasks)) return tasks
def select_projects_roles_by_user(email): join_tables = USERS_TABLE.join( USER_PROJECT_ROLE_TABLE, USERS_TABLE.c.email == USER_PROJECT_ROLE_TABLE.c.email) query = select([ USER_PROJECT_ROLE_TABLE.c.email, USER_PROJECT_ROLE_TABLE.c.project_id, USER_PROJECT_ROLE_TABLE.c.role ]).select_from(join_tables).where(USER_PROJECT_ROLE_TABLE.c.email == email) rows = connection.execute(query) users = [] for row in rows: users.append( UserProjectRole(email=row['email'], project_id=row['project_id'], role=row['role'])) return users
def insert_role_to_referential(role): insert = ROLE_REFERENTIAL_TABLE.insert().values(role=role) try: result = connection.execute(insert) except Exception as ex: print('Error occured : ' + str(ex))