An app to learn and share lifehacks.

Use single quotes when inserting strings

INSERT INTO hacks (ID, content, likes, dislikes, user_id, category_id) VALUES (2,'love yourself', 0,0, 1, 1);

SQL Tables Cheat Sheet: categories: ID, Name users: ID, username, displayname hacks: ID, content, likes, dislikes, user_id, category_id

This table has three columns: ID, username, displayname.

• ID is the primary key.
• username acts as the name that either comes from Google OAuth or is entered as a login name (used to log in).
• displayname actuallys acts as a displayname that is rendered in the hacks.

CREATE TABLE hacks ( _id SERIAL PRIMARY KEY, content varchar(1000), likes int, dislikes int, user_id int, category_id int, CONSTRAINT fk_user FOREIGN KEY(user_id) REFERENCES users(_id), CONSTRAINT fk_category FOREIGN KEY(category_id) REFERENCES categories(_id) );

CREATE TABLE categories ( _id SERIAL PRIMARY KEY, name varchar(1000) NOT NULL );

CREATE TABLE users ( _id SERIAL PRIMARY KEY, username varchar(50) NOT NULL UNIQUE, password varchar(50) NOT NULL, displayname varchar(50) UNIQUE );

The tables use sequences to generate the next primary key. The sequence is called 'hack_sequence' and is passed into the invocation of nextVal() as seen in apiController.js in the 'makeHack' func

hack_sequence Type | Start | Minimum | Maximum | Increment | Cycles? | Cache --------+-------+---------+---------+-----------+---------+------- bigint | 6 | 0 | 999 | 1 | yes | 1

user_sequence Type | Start | Minimum | Maximum | Increment | Cycles? | Cache --------+-------+---------+---------+-----------+---------+------- bigint | 2 | 0 | 999 | 1 | yes | 1

• Password for app sign up or sign in (Google Oauth does work tho!)
  • The username provided is stored in the database, you just don't need to pass in a password currently
• Like + Dislike buttons are not connected to anything
• Adding a new Hack does not automatically trigger a rerender of the page. Must go to category dropdown and reselect the category

• automatically render new hack on page (currently you have to navigate into another category and then return to the new hack category to see it rendered)
• be able to add new categories
• remove Oauth button on upper left when logged in using the app login

The main branch is pretty much empty. Dev is up to date.

Venmo $420.69 to @sussybacca96 and leave a valid email address in the comment. You will be emailed the client secret once the funds have cleared.