Create database queries in the challenge models

[thejoefriel]

• Get challenge details (we may be able to create one model which gets all the challenge details and then we can just select which bits we want for the challenges landing page and the selected challenge page)
• Insert accepted challenge
• Change accepted challenge to completed and add points to user
• Remove accepted challenge
• Only get accepted challenges
• Only get completed challenges
• Remove completed challenge and remove points from user

Group them together:

• Set up index.js that requires and then exports all the models from one place

[thejoefriel]

Trying out some pseudo(ish) code for the SQL queries:

Get challenge details:

• SELECT * FROM challenges

Insert accepted challenge:

• SELECT id FROM challenges WHERE challenge_name='${challengeName}'
  (the challengeName will be the challenge title name that we need to send across with the POST
• assign this query to a variable (e.g. sql_getChallengeID)
• SELECT id FROM users WHERE id = '${userID}'
  (userID will be the user's ID which we need to store during their session and send with the POST or we match against username instead)
• assign this query to a variable (e.g. sql_getUserID)
• INSERT INTO challenges-status (user_id, challenge_id, status) VALUES ('${sql_getUserID}', '${sql_getChallengeID}', 'accepted')

Change challenge to completed:

• SELECT id FROM challenges WHERE challenge_name='${challengeName}'
  (the challengeName will be the challenge title name that we need to send across with the POST)
• assign this query to a variable (e.g. sql_getChallengeID)
• SELECT id FROM users WHERE id = '${userID}'
  (userID will be the user's ID which we need to store during their session and send with the POST or we match against username instead)
• assign this query to a variable (e.g. sql_getUserID)
• UPDATE challenges-status SET status = completed WHERE challenge_id = $'{sql_getChallengeID)}' AND user_id = '${sql_getUserID}'