DB 3
SQL recap
-
standup / questions
-
short recap
-
questions to you
-
dealing with nested resources
-
continue working on todo
-
standup !
-
git / todo / node / express / mysql ?
-
-
-
-
Short recap
- C.R.U.D. / Http VERBS
- (API) routing
- SQL queries
- todo app
questions to you!
- why important to separate endpoints ?
- why name a file index.js ?
- git pull requests / git merge. fully understood ?
- why important to test other branches before merging ?
connection.query('INSERT INTO todos SET ?', request.body, (err, result) => {connection.query('SELECT * FROM todos', (error, data) => {dealing with nested resources
dealing with nested resources
- /users/:userId/todos
- get all todos for user {userId}
- how would you approach this ?
dealing with nested resources
dealing with nested resources
dealing with nested resources
- primary keys
- referencing keys from a table + db normalization
- link tables + foreign keys
- SQL: JOIN types
- http://www.sql-join.com/sql-join-types
