/java-crudyrestaurants

Primary LanguageHTMLMIT LicenseMIT

Java Reading CRUDy Restaurants

A student that completes this project shows that they can:

  • Perform CRUD operations on an RDBMS using JPA and Hibernate (reading)
  • Implement a data seeding class using JPA and Hibernate
  • Explain and use Spring Data Relationships
  • Use the JsonIgnoreProperties annotation to prevent infinite loops
  • Use H2 Console and H2 IntelliJ integration to explore data

Introduction

This is a basic database scheme with restaurants, menus, payment system. This Java Spring REST API application will provide endpoints for clients to read various data sets contained in the application's data.

Database layout

The table layouts are as follows

  • Restaurant is the driving table.
  • Menus have a Many-To-One relationship with Restaurant. Each Restaurant has many menus. Each menu has only one Restaurant.
  • Payments have a Many-To-Many relationship with Restaurants.

Image of Database Layout

Four different applications exist

  • crudyrestaurants_initial - The beginnings of the application. The basic framework plus the Restaurant class
  • crudyrestaurants_model - The application will all the seed data added and the models for all of the tables
  • crudyrestaurants_read - The application with a representative group of GETs.
  • crudyrestaurants_crud - Finishes the CRUD application by adding Creating, Updating, and Deleting