/09-sql-joins-relations

Primary LanguageJavaScript

Lab 09: Database Relationships & SQL Joins

Content

  1. Submission Instructions
  2. Resources
  3. Configuration
  4. User Stories and Feature Tasks

Submission Instructions

Follow the submission instructions outlined in our submit-process repo.

Resources

SQLBolt -- Interactive SQL Tutorial

SQL Cheat Sheet

Query String Primer

Configuration

Your repository must include:

09-sql-joins-relations
├── .eslintrc.json
├── .gitignore
├── LICENSE
├── README.md
├── node_modules
├── package-lock.json
├── package.json
├── public
│   ├── data
│   │   └── hackerIpsum.json
│   ├── index.html
│   ├── new.html
│   ├── scripts
│   │   ├── article.js
│   │   └── articleView.js
│   ├── styles
│   │   ├── base.css
│   │   ├── fonts
│   │   │   ├── icomoon.eot
│   │   │   ├── icomoon.svg
│   │   │   ├── icomoon.ttf
│   │   │   └── icomoon.woff
│   │   ├── icons.css
│   │   ├── layout.css
│   │   └── modules.css
│   └── vendor
│       ├── scripts
│       │   ├── handlebars.js
│       │   ├── highlight.pack.js
│       │   └── marked.js
│       └── styles
│           ├── default.css
│           ├── normalize.css
│           └── railscasts.css
└── server.js

Feature Tasks

Don't forget to set your conString!

As a user, I want more dynamic control over my database so that I can relate similar articles.

  • Write the following SQL queries:
    • Join all data from articles and authors tables on the author_id value of each
    • Insert an author
    • Retrieve an author
    • Update an author
    • Insert an article
    • Retrieve an article
    • Update an article

As a developer, I want to utilize SQL queries so that I can join data together in the database.

  • This means you'll want to be able to do full CRUD on articles in the database. You'll have to use SQL to make a table for articles (and clear out the table for troubleshooting), with a class-level method attached to the constructor function (because it does not apply to any single instance). Then teach each article instance how to write or update itself to the database, or delete itself, via instance methods (available for use as needed in the code).
  • Crucially, you'll need to trace through the app logic, and all those callback functions to determine WHEN is the right time to load data, or convert JSON.
  • Look through the TODOs, which signify areas of the code with varying levels of completeness, and focus initially on writing correct SQL. Once you complete the TODOs, follow the instructions in the adjacent CRUD-testing.md doc to verify that everything works.