# FAC BiblioTech ### by PBOK    --- # See https://fac-week8-project.herokuapp.com/ --- # So you want to install me?? * clone repo * run ```npm install``` * ask us for the super secret env deets * run ```npm start``` --- ### TRAV IS WHO??? [](https://codecov.io/gh/fac18/week8-pbok)  --- ### HEROKU * Heroku tries to run ```npm start``` * we already had a ```start``` script in our package.json  --- * to override this, we created a Procfile  * with the below bit of code:  --- ### SCHEMA  --- ### ACCESSIBILITY  --- ### WIREFRAMES  --- ### USER FLOW  --- ### DESIGN  --- ### MVC ARCHITECTURE  --- ## SERVER ARCHITECTURE  --- ## CONTROLLA ```javascript // post request to add new resource to database library exports.post = (request, response) => { let { title, language, description, link } = request.body; db.addResource(title, language, description, link, (err, res) => { if (err) { throw err; } }) response.redirect('/'); };) ``` --- ## ADD RESOURCE TO LIBRARY ```javascript= const addResource = (title, language, description, link, cb) => { db.query(`INSERT INTO resources(title, language, description, link) VALUES ($1, $2, $3, $4)`, [title, language, description, link], (err, result) => { if (err) return cb(err); cb(null, result); }); } module.exports = { getAll, filterByLanguage, addResource }; ``` --- ## FILTERING BY LANG ```javascript= router.post('/filter-language', (req, res) => { res.redirect(`/library/${req.body.language}`); }); router.get('/library/:language', library.filterLanguage); ``` ```javascript= exports.filterLanguage = (request, response) => { let language = request.params.language; filterByLanguage(language, (err, res) => { if (err) console.log(err); const filterRows = res; response.render("filter", { filterRows }); }) }; ``` --- ```javascript= const filterByLanguage = (language, cb) => { db.query(`SELECT * FROM resources WHERE language=$1`, [language], (err, result) => { if (err) return cb(err); cb(null, result.rows); }); } ``` ```javascript= {{#each filterRows}} <tr> <td class="table-data">{{language}}</td> <td class="table-data">{{title}}</td> <td class="table-data">{{description}}</td> <td class="table-data"><a href="{{link}}" alt="link to resource" target="_blank" title="{{link}}">{{link}}</a></td> </tr> {{/each}} ``` --- ### DATABASE AND ROUTE TESTING  --- ### NICE THINGS WE'VE ACHIEVED: - Mobbing + working as a team - No HTML pages at all - Filtering option! - Modularise our code (a bit...) --- ### IF WE WERE TO DO IT AGAIN ### or continue working on it * Create and use custom helpers * Do more tests * Keep up the team work (woohoo!) --- # THANK YOU ### team PBOK