1026750 - Change organizerID in Events table to use numerical IDs

Status: RESOLVED WONTFIX

(Webmaker Graveyard :: Events, defect)

Description

[Gavin Suntop [:gvn]]

Currently organizerID contains the organizer's username. We should migrate the DB to use proper user ID numbers instead.

This will require a full audit of the Events app. Things are sure to break (RSVP listings on event pages certainly will).

Comment 1

[Errietta Kostala [:errietta]]

Attachment: https://github.com/mozilla/webmaker-events-service/pull/88

Not sure I'm on the right track here. also never messed with promises before. However, when trying to retrieve the username in this fashion from webmaker-events-2, i get   "organizerUsername": {
    "isFulfilled": false,
    "isRejected": false
  },

Not sure if I'm doing it wrong or it's just the jsonifying process when getting an event.

Comment 2

[Gavin Suntop [:gvn]]

Here are some approaches we can take. For now, let's defer this until we have more tests written and possibly post-Maker Party.

1) 

- Change organizerId to an INT type and migrate all existing alphanumeric username values to their numeric equivalents. This will require scripting.
- Add a new organizerUsername column and populate it with alphanumeric usernames. (Optional, but would make lookups easier.)

2) 

- Leave organizerId as-is. Add organizerNumericId (or something) as a new column with numeric user IDs. This is a bit semantically icky, but less prone to data corruption and regressions.