User stories to implement when practising joins.
Clone this repo, cd into the new directory and then:
npm i
npx knex migrate:latest
npx knex seed:run
npm run dev
This will create and populate the database with the existing migrations and seeds, and start the server with nodemon.
-
As a user, I would like to see a list of wombles so that I can know who to ask to clean up Wimbledon Commons.
-
As a user, I would like to visit a
viewroute for an individual womble that shows their name and characteristics so that I can identify them on sight.- This will need a join between
womblesandcharacteristics.
- This will need a join between
-
As a user, I would like to visit an
assignmentsroute. This should show a list of wombles and the rubbish they have been assigned to pick up so that I can ensure they are doing their job.- This will need a join between
womblesandrubbish. - There is no
rubbish_idinwombles, so you'll need to make a new migration to add a column to that table (and you'll also need to add data for that new column into your seed data).
- This will need a join between
That's MVP! If you're done already, implement the stories below.
-
As a user, I would like to add wombles to the wombles table as they are born (including their characteristics) so that I may track new wombles.
-
As a user, I would like to delete wombles from the wombles table when one of them croaks.
-
As a user, I would like to modify a womble's characteristics so that they can change costumes when they like.
-
As a user, I would like to change a womble's rubbish type assignment so I can make the best use of their meagre resources.
-
As an administrator, I would like to add new rubbish types because the rubbish collection needs on Wimbledon Commons are always changing.
-
As an administrator, I would like to add new characteristics because wombles must always be stylish.