Add download queue data button

[jackieo5023]

This PR:

• Adds a button and endpoint to download course queue data as a csv on the course page
  • This is only viewable to course staff, which I have tested
• Changed a comment that was probably not changed after copy/paste to say "remove" instead of "add"

Here is an example of what the download would look like given fake data. Unfortunately, I couldn't upload to GitHub as a csv. Here is the SQL query that this was based off of:

SELECT
  questions.id AS id,
  courses.name AS CourseName,
  queues.name AS QueueName,
  u_asked.netid AS AskedBy_netid, u_asked.universityName AS AskedBy_RealName,
  u_answered.netid AS AnsweredBy_netid, u_answered.universityName AS AnsweredBy_RealName,
  topic,
  CONVERT_TZ(enqueueTime, '+0:00', 'US/Central') AS enqueueTime,
  CONVERT_TZ(dequeueTime, '+0:00', 'US/Central') AS dequeueTime,
  CONVERT_TZ(answerStartTime, '+0:00', 'US/Central') AS answerStartTime,
  CONVERT_TZ(answerFinishTime, '+0:00', 'US/Central') AS answerFinishTime,
  comments, preparedness,
  questions.location AS UserLocation,
  queues.location AS QueueLocation,
  CONVERT_TZ(queues.createdAt, '+0:00', 'US/Central') AS Queue_CreatedAt,
  queueId, courseId
FROM questions
  INNER JOIN queues ON questions.queueId = queues.id
  INNER JOIN courses ON queues.courseId = courses.id
  INNER JOIN users u_asked ON questions.askedById = u_asked.id
  LEFT JOIN users u_answered ON questions.answeredById = u_answered.id
WHERE courseId=6
ORDER BY enqueueTime DESC

[vercel[bot]]

This pull request is being automatically deployed with ZEIT Now (learn more). To see the status of your deployment, click below or on the icon next to each commit.

🔍 Inspect: https://zeit.co/illinois/queue/fmpfyvbdci 🌍 Preview: In Progress

[james9909]

Adding onto Nathan's comments, we should also add some tests for this new endpoint

[jackieo5023]

@nwalters512 as for your point about downloads being in another section, I think at this point @wadefagen just wants downloads to be pushed out as quick as possible - so I guess think of this as a temporary solution, and later I can make it nicer to be able to download per queue as well.

[jackieo5023]

Now ready for review again.

• Sequelize is weird in that if you specifically include an attribute in a related model, it doesn't exclude other attributes. So in the getColumns function, I whitelist the fields we want to display.
• Added tests for the endpoint.
• RealName is changed to UniversityName
• Moved all logic to api except for the download
• Changed timezone calculation to be on the javascript side rather than sequelize, as sqlite and mysql don't have the same timezone conversion functions

Here is an updated version of an example csv.

[jackieo5023]

Tested on staging. Everything appears to be working properly and correctly (times are verified to be in CST as well).

[nwalters512]

Going to give this a final look over!