pantertanter / backenda3sem3 Goto Github PK

This project is meant as start code for projects and exercises given in Flow-1+2 (+3 using the security-branch) at http://cphbusiness.dk in the Study Program "AP degree in Computer Science"

Projects which are expected to use this start-code are projects that require all, or most of the following technologies:

• JPA and REST
• Testing, including database test
• Testing, including tests of REST-API's
• CI and CONTINUOUS DELIVERY

In order to use this code, you should have a local developer setup + a "matching" droplet on Digital Ocean as described in the 3. semester guidelines

This document explains how to use this code (build, test and deploy), locally with maven, and remotely with maven controlled by Github actions

• How to use

• open view->too windows->persistence
• open the Database tab and create a new data source (remember to point to a database event though this is already written in the persistence unit. This is necessary in order to use the JPQL console)
• in the persistence window right click the pu or an entity and choose "console"
• write a jpql query in the console and execute it.

• just right click the pu and choose: "Run JPQL query"

• file-> new model
• dobbelclick the mydb icon and change to relevant database (create one first if needed)
• click the Add Diagram icon
• click the table icon in the left side panel and click in the squared area to insert new table
• dobbelclick the new table and change name and add columns (remember to add a check mark in 'ai' for the primary key)
• do the process again to add a second table
• now in the panel choose the 'non identifying relationship' on to many
• click first on the child table (the one that should hold the foreign key) and then on the parent. A new relationship was now added.
• When done with designing - goto top menu: Database->forward engineer.
  • Check that all settings looks right and click continue
  • click continue again (no changes needed here)
  • Make sure the 'Export mysql table objects' is checked and Show filter to make sure that all your tables are in the 'objects to process' window -> click continue
  • Verify that the generated script looks right -> click continue
  • click close and open the database to see the new tables, that was just created.

• From inside the Persistence window:
• Right-click a persistence unit, point to Generate Persistence Mapping and select By Database Schema.
• Select the
  • data source
  • package
  • tick tables to include
  • open tables to see columns and add the ones with mapped type: Collection and SomeEntity
  • click OK.

• Right click project name -> new -> persistence -> Entity classes From Database -> choose database connection from list -> add the tables you need -> Finish