# Santa Claus's Little Helpers <font size="5"> * Alex * Ayub * Pat * Roshan  --- ## Project requirements * Build an app using the Express framework. * Use a PostgreSQL database to store and retrieve your data. * Use the retrieved data to populate a Handlebars template for server-side rendering to be displayed on the front-end. Stretch Goals * Authorisation (editing to header partial for when logged in vs not) * Animated svg ---  ---  --- ## File structure - MVC Model  --- ## Mobbed the creation of files  --- ## Accessibility  --- ## Tests  --- ## Helper functions ```javascript= //goodBad.js module.exports = array => { const totalGoodPoints = array.reduce((acc, currNum) => { return acc + parseInt(currNum); }, 0); return totalGoodPoints; }; ``` --- ## Using helpers and handlebars to display our database ```javascript= {{#each users}} <tr> <td> {{capitaliseFirstLetter name}} </td> <td> {{gift}} </td> <td> {{goodBad behaviour}} </td> <td><a href="/delete-user/{{name}}"><button id="delete-button">X</button></a></td> </tr> {{/each}} ``` --- ## Delete user ```javascript= const deleteUserData = require("../model/queries/deleteData"); exports.deleteUser = (req, res) => { const nameUser = req.params.name; deleteUserData(nameUser) .then(() => { res.redirect("/presents"); }) .catch(err => { console.log("this is err", err.message); throw err; }); }; ``` --- ## Error handling ```javascript= exports.client = (req, res) => { res.status(404).render("error", { layout: "error", statusCode: 404, errorMessage: "Page not found :(", imageUrl: "https://gph.is/2ify9JA" }); }; ``` --- ## Use of promises ```javascript= postData({ name: req.body.username, behaviour: goodOrBad, category: req.body.category }) .then(() => { res.redirect("/presents"); }) .catch(error => { throw error; }); ``` --- ## Issues with data base integration ### Banging our heads for hours  ___ ```javascript= <label class="dropdown" for='category' name='category'> <p class="searchBy">Search by category </p> <select class="category" name="category" required> <option value="Sports"> Sports </option> <option value="Food"> Food </option> <option value="Technology"> Technology </option> <option value="Education"> Education </option> </select> </label> ``` ---  --- ## Pat brought the Christmas magic