You can view the project here.
Gal, Georgia, Konstantina, Laura
We created a community film database, allowing users to input a film via name, year, director, and a selection of genres. An id is created for each entry.
The database has the following structure:
| id | name | year | director | genre_id |
|---|---|---|---|---|
| 1 | Jaws | 1975 | Steven Spielberg | 1 |
| 2 | Star Wars | 1977 | George Lucas | 2 |
| 3 | The Empire Strikes Back | 1980 | Ivan Kershner | 2 |
Make sure you have Git and Node (v18) installed.
- Clone this repo and cd into the directory
- Run
npm installto install all the dependencies - Run
npm run devto start the server.
To run tests, ensure setup steps are followed and run npm run test << ENSURE CORRECT
- As a user, I want to: submit information to your site for anyone to see
- As a user, I want to: come back to your site later and see what I posted is still there
- I want to submit a film to the database
- I want to find films within the database
- I want to explore films in the database
- A form for users to submit data
- A page showing all the data
- Semantic form elements with correctly associated labels
- A SQLite database
- A schema describing your database in your README
- Tests for server routes and database access
- Not process user input as SQL commands
- Hidden environment variables (i.e. not on GitHub)
- A way to view filtered/sorted data, instead of just all of it
- GitHub Actions CI setup to run your tests when you push