A centralised postgresql resource for FAC
Coverage: 90% Statements 18/20, 62.5% Branches 5/8, 100% Functions 0/0, 100% Lines 18/18
- Simple web app with a node server and a database
- Your database comes with a schema, which should be documented in your readme (along with any other architectural decisions)
- Database hosted on Heroku, or locally
- Build script for your database
- Security concerns appropriately considered (you must protect against script injections!)
- Good test coverage both server- and client-side
- Content dynamic, but DOM manipulation kept to a minimum
- Mobile-first design
- Clear user journey (even if you take one of our suggested ideas, document the user journey in your readme)
I can pick a topic and find a bunch of rad online resources with an article title, print data and link ๐
On load I can find out about the coolest articles peeps are raving about ๐ ๐ ๐
We planned out our flow as follows:
And wanted it to look like this:
Column | Type | Modifier |
---|---|---|
id | serial | PRIMARY KEY |
title | VARCHAR(300) | NOT NULL |
link | VARCHAR(300) | NOT NULL |
publish_month | INTEGER | |
publish_year | INTEGER | |
upvotes | INTEGER | DEFAULT 0 |
Column | Type | Modifier |
---|---|---|
id | serial | PRIMARY KEY |
topic | VARCHAR(300) | NOT NULL |
week | INTEGER |
Column | Type | Modifier |
---|---|---|
resource_id | INTEGER REFERENCES resources(id) | ON UPDATE CASCADE |
topic_id | INTEGER REFERENCES topics(id) | ON UPDATE CASCADE |
- Turns out sql hates capital letters! You can't name databases with caps ๐ฟ
- ALSO atom is a thief! ๐ And sometimes steals your letters from terminal
- Writing tests within a foreach loop which take a callback ๐จ
const topicArray = ['Javascript', 'CSS', 'Node', 'Databases', 'Accessibility', 'Git', 'TDD', 'HTTP', 'APIs', 'Callbacks', 'Software Architecture', 'Servers', 'Development Methodologies', 'HTML', 'UX'];
topicArray.forEach((topic) => {
tape(`getTopic ${topic} query`, (t) => {
getTopic(topic, (err, res) => {
const actual = res[0].topic;
const expected = topic;
t.equals(actual, expected, `getTopic object output topic should be ${topic}`);
t.end();
});
});
});
- Pushing to heroku from a local branch:
git push heroku yourbranch:master