This is a web application created with Spring Boot and Spring Initializr which contains a Thymeleaf templated engine. The application use a SQLite JDBC database called Chinook, which is a music database. The database consist of multiple tables which are represented here and here. This application was developed as part of a full stack course at Experis Academy.

The homepage can be accessed on http://localhost:8080/home when the application is running. The website has two views: the home-view and the search-view. The home-view lists five random artists, tracks and genres as a suggestion for the user to check out. The home-view also features a search function where the user can enter a phrase in order to find each track in the database that contain the given phrase. The search function will take the user to the search-view where the user will find information about each track that was found in the database. Screenshots of the two views can be found below.

For this application a couple of endpoints was exposed which can be tested with postman. A collection of postman api calls can be found in the "Apicalls.postman_collection.json". Each endpoint returns its data in json format.

• Returns information about each customer in the database

• Updates the information of a customer in the database

• Creates a new customer and adds it to the database

• Fetch the number of customers from each country

• Fetch the total spendings of all customers

• Fetch the favorite genre of a given customer

• Fetches each track that contain the given search phrase in its name

• Fetches the name of each artist in the database

• Fetches the name of each genre in the database

• Fetches the name of each track in the database

• Expose endpoints with Spring
• Create a templated html page with templated data
• Introduction to SQL queries (SELECT, JOIN, etc.)

This application was developed by Christopher Berglund & Hampus Olsson