jabrena / spring-boot-relational-database-poc Goto Github PK

CREATE TABLE film (
    film_id integer DEFAULT nextval('film_film_id_seq'::regclass) NOT NULL,
CREATE TABLE film (
    film_id bigint DEFAULT nextval('film_film_id_seq'::regclass) NOT NULL,
CREATE TABLE actor (
    actor_id integer DEFAULT nextval('actor_actor_id_seq'::regclass) NOT NULL,
CREATE TABLE actor (
    actor_id bigint DEFAULT nextval('actor_actor_id_seq'::regclass) NOT NULL,

Design the Feature 4 about Complex queries including join operations

Analyze a developer methodology to work with SQL queries

Use frantiseks/postgres-sakila image for tests

Reduce testing time

Update the project using jdbcClient

Review other comparisons

https://github.com/bwajtr/java-persistence-frameworks-comparison

Scenarios analized:

Fetch single entity based on primary key
Fetch list of entities based on condition
Save new single entity and return primary key
Batch insert multiple entities of the same type and return generated keys
Update single existing entity - update all fields of entity at once
Fetch many-to-one relation (Company for Department)
Fetch one-to-many relation (Departments for Company)
Update entities one-to-many relation (Departments in Company) - add two items, update two items and delete one item - all at once
Complex select - construct select where conditions based on some boolean conditions + throw in some JOINs
Call stored procedure/function and process results
Execute query using JDBC simple Statement (not PreparedStatement)
Remove single entity based on primary key

Define OpenAPI Spec

Implement OAS at Controller level

https://openapi-generator.tech/docs/generators/spring

Try jib-maven-plugin

			<!-- Jib -->
			<plugin>
				<groupId>com.google.cloud.tools</groupId>
				<artifactId>jib-maven-plugin</artifactId>
				<version>${jib-maven-plugin.version}</version>
				<configuration>
					<container>
						<ports>
							<port>8080</port>
						</ports>
					</container>
					<from>
						<image>LATEST-IMAGE</image>
					</from>
					<to>
						<image>jabrena/bla-bla-bla:${project.version}</image>
					</to>
				</configuration>
				<executions>
					<execution>
						<phase>package</phase>
						<goals>
							<goal>build</goal>
						</goals>
					</execution>
				</executions>
			</plugin>