def mutate(root, info, filename, projectid, file=None): if file is not None: f = file.read() else: f = None s, m = pg.executequery( 'insert into projectfiles (filename,file,projectid) values(%s,%s,%s)', [filename, f, projectid]) return editNote(status=s, msg=m)
def mutate(root, info, username, noteid, title, description=None, color=None): s, m = pg.executequery( 'update note set title = %s description = %s color = %s createdby = %s where noteid = %s);', [title, description, color, username, noteid]) return editNote(status=s, msg=m)
def mutate(root, info, username, title, projectid=None, description=None, color=None): if not projectid: s, m = pg.executequery( 'insert into note (title,description,color,boardid,createdby) values (%s,%s,%s,(select boardid from board where username = %s),%s);', [title, description, color, username, username]) else: s, m = pg.executequery('call add_note (%s, %s,%s,%s,%s)', [ username, projectid, title, description, color, ]) return addNote(status=s, msg=m)
def mutate(root, info, username, name, longdescription=None, shortdescription=None, path=None, members=None): usernames = [x.username for x in members] if members is not None else None roles = [x.role for x in members] if members is not None else None m = [[x, y] for x, y in zip(usernames, roles) ] if usernames is not None and roles is not None else None s, m = pg.executequery( "call create_project(%s,%s,%s,%s,%s,%s);", [username, name, longdescription, shortdescription, path, m]) return createProject(status=s, msg=m)
def mutate(root, info, assignedby, assignedto, projectid, title, description=None, startdate=None, enddate=None, priority=None, preqtaskid=None): if not priority: priority = 'normal' s, m = pg.executequery("call add_task (%s,%s,%s,%s,%s,%s,%s,%s,%s);", [ assignedby, assignedto, projectid, title, description, startdate, enddate, priority, preqtaskid ]) return addTask(status=s, msg=m)
def mutate( root, info, username, taskid, title, assignedto, preqtaskid=None, description=None, startdate=None, enddate=None, priority=None, ): s, m = pg.executequery( 'call edit_task (%s,%s,%s,%s,%s,%s,%s,%s,%s::integer[]);', [ username, taskid, assignedto, title, description, startdate, enddate, priority, preqtaskid ]) return updateTask(status=s, msg=m)
def mutate(root, info, username): s, m = pg.executequery("DELETE FROM users where username = %s", [username]) return deleteUser(status=s, msg=m)
def mutate(root, info, username, newfirstname, newlastname): s, m = pg.executequery( "UPDATE users SET firstname=%s, lastname=%s where username = %s", [newfirstname, newlastname, username]) return changeName(status=s, msg=m)
def mutate(root, info, username, oldpassword, newpassword): s, m = pg.executequery("CALL change_password(%s,%s,%s);", [username, oldpassword, newpassword]) return changePassword(status=s, msg=m)
def mutate(root, info, username, noteid): s, m = pg.executequery('delete from note where noteid = %s;', [noteid]) return deleteNote(status=s, msg=m)
def mutate(root, info, username, taskid): s, m = pg.executequery('call complete_task (%s,%s);', [taskid, username]) return completeTask(status=s, msg=m)
def mutate(root, info, username, member, projectid, role=None): s, m = pg.executequery("call add_member(%s,%s,%s,%s);", [username, member, projectid, role]) return addMember(status=s, msg=m)
def mutate(root, info, username, firstname, lastname, password, emailid): s, m = pg.executequery( "INSERT INTO users VALUES (%s,%s,%s,%s,%s,%s);", [username, firstname, lastname, password, emailid, None]) return createUser(status=s, msg=m)
def mutate(root, info, username, member, projectid): s, m = pg.executequery("call delete_member (%s,%s,%s);", [username, member, projectid]) return deleteMember(status=s, msg=m)
def mutate(root, info, username, projectid): s, m = pg.executequery("CALL delete_project(%s,%s);", [username, projectid]) return deleteProject(status=s, msg=m)