# Week 13- WIP Student Project  --- ## [** Demo App **](https://wip-app.netlify.app/) :bell:  --- ## Sprint Review :bell:  --- ### Kanban :cat:  --- ### Estimates and Actual Table :banana:  --- ### Estimates and Actual Graph :banana:  --- ### Going into Sprint 1 :banana:  --- ### Comparison Of Sprint 1 & Sprint 2 :banana:  #### Up from 65% to 80% accuracy in estimating this week! --- ## Learning Curves :bell: :jack_o_lantern: - Base64 <= it's not best practice... at all - React (grasped the fundamentals - thanks Izaak!) - Styled Components - React Router - Abstraction - SQL (SQL Fiddle)  --- ## Code Snips :jack_o_lantern:  --- ```sql= SELECT (SELECT username FROM users WHERE users.id=projects.user_id), projects.id, project_name, steps.date, step_link FROM projects JOIN user_watch ON project_id=projects.id JOIN users ON user_watch.user_id=users.id JOIN steps ON projects.id=steps.project_id WHERE user_watch.user_id=($1); ``` What I learned: `SELECT` what you want `FROM` a table `JOIN` another table `ON` where they match `WHERE` a condition is met and nest whatever extra queries you like so long as they only resolve to one thing and you are sure of what that is. And use a schema diagram and SQL Fiddle.  --- ```javascript= model .getWatchedProjectsFromDb(userId) .then((watchedProjects) => { model .getAllProjectsFromDb() .then((allProjects) => { const watchedIds = watchedProjects.map( (watchedProject) => watchedProject.id ); // filter all the projects where the project IDs are not watched or belonging to a user const exploreProjects = allProjects.filter( (project) => watchedIds.indexOf(project.id) === -1 && userId != project.user_id ); res.send(exploreProjects); }) }) ``` --- ## Test coverage :jack_o_lantern:   ---  --- ## Team Process/Workflow/Vibe :cat:  --- ### Hannah :banana: Everyone smashed their roles! :tada:  --- ### Kat :cat: Everyone carried each other!!! So Supportive! :100:  --- ### Camp:bell: We understood each other well!  --- ### Jack :jack_o_lantern: Building a semi-fuctional full stack app is hard and we were a good team in the face of that :person_doing_cartwheel:  --- ## Neat Tools Discovered :cat: [SQL visual tool to see results of Queries](http://sqlfiddle.com/) [Icon SVGs](https://iconsvg.xyz/) [Drawkit Illustrations](https://www.drawkit.io/free) [Undraw Illustrations](https://undraw.co/search) [A Japanese Stretch](https://www.youtube.com/watch?v=oQU-GDIjz6E&list=PLFRb4HVfmk6HyOnljs0layqYIIzkc__HA&index=1)  --- Postman collections  --- ## Special Thanks :banana: 💖 Shifu Reuben 💖 Oli 💖 Izaak 💖 Katia 💖 Renata 💖 Kristina 💖 Hannah's sister