Backend: Waitlist

[alliyya]

Updated: November 23rd 2018:

New mutations

Waitlist mutations have been modified to not use participant object addUserToEventWaitlist(userID: Int!, eventID: Int!): Int! removeUserFromEventWaitlist(userID: Int!, eventID: Int!): Int! addUserToSeminarWaitlist(userID: Int!, seminarID: Int!): Int! removeUserFromSeminarWaitlist(userID: Int!, seminarID: Int!): Int!

mutation addUserToEventWaitlist($user: Int!, $event: Int!) {
  addUserToEventWaitlist(userID: $user, eventID: $event)
}

mutation removeUserFromEventWaitlist($user: Int!, $event: Int!) {
  removeUserFromEventWaitlist(userID: $user, eventID: $event)
}

mutation removeUserFromSeminarWaitlist($user: Int!, $seminar: Int!) {
  removeUserFromSeminarWaitlist(userID: $user, seminarID: $seminar)
}

mutation addUserToSeminarWaitlist($user: Int!, $seminar: Int!) {
  addUserToSeminarWaitlist(userID: $user, seminarID: $seminar)
}
#query variables
# seminar 5 is full as is event 2 from sample data
{  
  "user": 9,
  "seminar": 5,
  "event": 2
}

Functionality

• When user is removed from an event/seminar and there are users on the waitlist for that event/seminar, they are automatically removed off the waitlist and added into the waitlist (Earliest user in waitlist)
• checks if there is space in the event before adding them into the waitlist

  New Resolver

  closes #99 getMyWaitlistedEventsAndSeminars(userID: Int!, type: String, limit: Int, offset: Int): [SearchResult!] Operates similarly to get myManagingEvents/

  {
  getMyWaitlistedEventsAndSeminars(userID: 9) {
  __typename
  ... on Event {
    id
    creator_id
    name
  }
  ... on Seminar {
    id
    name
    event_id
  }
  }
  }

Bug Fixes

• When user unattends event, they unattend related seminars and is removed from seminar waitlist for that event (closes #101)
• User cannot be added to seminar unless they are attending the parent event
• User cannot be added to waitlist if there is space in the seminar/event
• User cannot be added to waitlist if they are already attending event/seminar
• Capacity has been set to update with every change in seminar/event participation (closes #94)
• Updated current capacity of sample data events/seminar

[alliyya]

New mutations

Waitlist mutations have been modified to not use participant object addUserToEventWaitlist(userID: Int!, eventID: Int!): Int! removeUserFromEventWaitlist(userID: Int!, eventID: Int!): Int! addUserToSeminarWaitlist(userID: Int!, seminarID: Int!): Int! removeUserFromSeminarWaitlist(userID: Int!, seminarID: Int!): Int!

mutation addUserToEventWaitlist($user: Int!, $event: Int!) {
  addUserToEventWaitlist(userID: $user, eventID: $event)
}

mutation removeUserFromEventWaitlist($user: Int!, $event: Int!) {
  removeUserFromEventWaitlist(userID: $user, eventID: $event)
}

mutation removeUserFromSeminarWaitlist($user: Int!, $seminar: Int!) {
  removeUserFromSeminarWaitlist(userID: $user, seminarID: $seminar)
}

mutation addUserToSeminarWaitlist($user: Int!, $seminar: Int!) {
  addUserToSeminarWaitlist(userID: $user, seminarID: $seminar)
}
#query variables
# seminar 5 is full as is event 2 from sample data
{  
  "user": 9,
  "seminar": 5,
  "event": 2
}

Functionality

• When user is removed from an event/seminar and there are users on the waitlist for that event/seminar, they are automatically removed off the waitlist and added into the waitlist (Earliest user in waitlist)
• checks if there is space in the event before adding them into the waitlist

  New Resolver

  closes #99 getMyWaitlistedEventsAndSeminars(userID: Int!, type: String, limit: Int, offset: Int): [SearchResult!] Operates similarly to get myManagingEvents/

  {
  getMyWaitlistedEventsAndSeminars(userID: 9) {
  __typename
  ... on Event {
    id
    creator_id
    name
  }
  ... on Seminar {
    id
    name
    event_id
  }
  }
  }

Bug Fixes

• When user unattends event, they unattend related seminars and is removed from seminar waitlist for that event (closes #101)
• User cannot be added to seminar unless they are attending the parent event
• User cannot be added to waitlist if there is space in the seminar/event
• User cannot be added to waitlist if they are already attending event/seminar
• Capacity has been set to update with every change in seminar/event participation (closes #94)
• Updated current capacity of sample data events/seminar