A trip planner for my future travels

1. Navigate to the projects directory and type 'yarn' into the terminal, to install all of the packages
2. Run the database migrations

yarn knex migrate:latest

3. Seed the database with dummy database

yarn knex seed:run

4. View the data using db sqlite browser, and opening up the 'dev.sqlite3' file in the project folder
5. Type 'yarn start' into the terminal to run the server, and navigate to localhost:3000 in your local browser
6. Destinations, activities and accommodation can be viewed/added/updated and deleted

• Destination: Image (required), City name (required), Country name (required), Dates, Arrival info, Departure info
• Activities: Name (required), Website, Notes
• Accommodation: Name (required), Address, Website, Notes

• https://colorhunt.co/palette/144191

• DONE: "Accommodation" section (separate table in database) - due to potential one-to-many relationship
• DONE: "Activities" section (separate table in database) - due to one-to-many relationship
• DONE: API search to find an image of the city, if the user doesn't provide one themselves
• Login: allows other individuals to also add trips (would each require a unique customer id)

• Learnt how to initialise and set up yarn to install dependencies
• Learnt how to add 'scripts' into package.json to run certain commands (e.g. 'yarn dev' will run 'nodemon index')
• Learnt about the express router (an isolated instance of middleware and routes - can be used as an argument to an "app.use()" method - can add middleware and HTTP method routes to the router object)
• Using Knex.js to set up a SQLite database (including Migrations & Seeding. Migrations are a way to make database changes/updates via generated scripts, like creating or dropping tables, or updating a table with new columns)
• • Good info about Migrations (including adding/dropping columns) and seeds: https://gist.github.com/NigelEarle/70db130cc040cc2868555b29a0278261
• Using Knex.js with SQLite to make database queries
• Used handlebars to set up a main template to render many page layouts, and also to display database information
• Using express route parameters to query the database
• Using Knex.js to create tables with a one-to-many relationship (using migrations + seeding) using foreign keys
• • This article was very helpful: https://medium.com/@jaeger.rob/seed-knex-postgresql-database-with-json-data-3677c6e7c9bc
• Making queries to multiple database tables simultaneously, and displaying the information on screen
• Use the Unsplash Source API + JavaScript to search and display an image based on the user's chosen country input

• Use handlebars to create a main template which can render many page layouts (e.g. the 'add' and 'delete' pages)
• For inspiration, view the views folder here: https://github.com/leslie-alldridge/hbs-practice
• Note: the {{{body}}} tells handlebars to implant the current view into the html body.
• Note: the default layout configuration requires you to add something in server.js file to set up the middleware set up for handlebars (see the above repo)

• Use {{these things}} inside html - E.g. <img src="/pictures/{{id}}"/> to render a specific picture on a page for each object
• Practice the above with images and links

• The dropdowns will fix the most apparent bugs because it will force the user to choose out of what's available
• Otherwise can consider using the ID to select these objects (ID's are a primary key in the database, whereas names are not)
• Note: the data object from the database contains ids so you can type {{id}} into the html to use it.

• Add styling to the website