CREATE TABLE "koala"(
"id" serial PRIMARY KEY,
"name" VARCHAR(100),
"gender" VARCHAR (2),
"age" INTEGER,
"readyfortransfer" BOOLEAN,
"notes" VARCHAR(500)
);
Router:
- '/koalas':
- GET - returns {id (int) ,name (str),gender (str), age(int),readyfortransfer (bool), notes (str)}
- GET - /:id, returns koala at row id
- DELETE - /:id, removes koala with row id
- POST - accepts {name (str),gender (str), age(int),readyForTransfer(bool), notes (str)}
- PUT - /:id, accepts {name (str),gender (str), age(int),readyForTransfer(bool), notes (str)}, updates koala with row id
- PUT - '/ready/:id', sets "readyfortransfer" of koala in row id to true
Our client, Koala Holla (1976 Llama Comma Drive, Walla Walla WA) is a non-profit dedicated to the ethical transitioning of koalas from the outdoors (whereupon they may be rained) to urban areas where roofs exist. Your team has been hired build a web app to handle their terrarium residents.
- JQuery
- Node
- Express
- SQL
Koala Holla has provided a TSV (tab separated values) spreadsheet of their current inventory. They want a database table that houses this information and can be viewed at any time. You should add this table to your existing deneb database. After importing the data, create a web app to display the Koalas. Users should be able to add new Koalas to the database through the provided HTML form.
They have also provided their logo and the source code from when Lou (a KH employee) tried to spin up a JEN stack project to support this, but had to leave for foraging school in Finland before he could finally finish. (JEN is short for jQuery, Express & Node).
-
Ability for mark Koala ready for transfer. Add a button to each row that reads 'Ready for Transfer'. When the user clicks on the button, it should update the database for the specific Koala. The 'Ready for Transfer' button should only appear for Koalas that haven't yet been marked ready for transfer.
-
Ability to delete Koalas from the database.
-
Add some styling with bootstrap.
- Ability to edit information for existing Koalas in the db.
- Ability to toggle the display of Koalas ready for transfer.
- Add form validation, additional styling and a README.md.
Upon completion of the project you'll need to provide not only the source (via GitHub url), but also instructions on how the database table should be set up. This can be in a simple databaseSetup.sql file in the repo.
Your final product may look something like this: