Week5_project_database

Subject: database + node.js + dynamic front-end Author: TiC-1 team

General purpose

Create a Todo App using a database. Tasks will be assigned to one or several users. Coding will be assign to 2 different teams: front-end and back-end. Development will be TDD on both client and server side.

User stories

As a user I want to:

• see all current tasks.
• add a new task and assign it to one or more users.
• remove task.
• edit a user (name).

Stretch goals

• see tasks filtered by user(s).
• edit tasks (title and assignment).
• add/remove users (what to do with orphan tasks?).

Repository structure

See 'code-along' branch in https://github.com/turnintocoders/pg-workshop/tree/code-along

• server.js
• public
  • index.html
  • style.css
  • assets
  • images
• src
  • router.js
  • handler.js (could several files)
  • database
    • db_connection.js
    • db_populate.js
    • db_schema.sql
    • db_data.sql
  • queries
• test

Database schema

3 tables:

• users
  • user_id (auto incremental)
  • user_name
• tasks
  • task_id (auto incremental)
  • task_title
• tasks_assignment
  • task_id (from task table)
  • user_id (from task table)