kyleggy
diff --git a/‎Chapter02/BONUS_1_SpringAndJavaRecords/README.md
Lines changed: 19 additions & 0 deletions b/‎Chapter02/BONUS_1_SpringAndJavaRecords/README.md
Lines changed: 19 additions & 0 deletions
diff --git a/‎Chapter02/BONUS_1_SpringAndJavaRecords/nbactions.xml
Lines changed: 46 additions & 0 deletions b/‎Chapter02/BONUS_1_SpringAndJavaRecords/nbactions.xml
Lines changed: 46 additions & 0 deletions
diff --git a/‎Chapter02/BONUS_1_SpringAndJavaRecords/pom.xml
Lines changed: 70 additions & 0 deletions b/‎Chapter02/BONUS_1_SpringAndJavaRecords/pom.xml
Lines changed: 70 additions & 0 deletions
diff --git a/‎Chapter02/BONUS_1_SpringAndJavaRecords/src/main/java/modern/challenge/MainApplication.java
Lines changed: 12 additions & 0 deletions b/‎Chapter02/BONUS_1_SpringAndJavaRecords/src/main/java/modern/challenge/MainApplication.java
Lines changed: 12 additions & 0 deletions
diff --git a/‎Chapter02/BONUS_1_SpringAndJavaRecords/src/main/java/modern/challenge/controller/BookstoreController.java
Lines changed: 26 additions & 0 deletions b/‎Chapter02/BONUS_1_SpringAndJavaRecords/src/main/java/modern/challenge/controller/BookstoreController.java
Lines changed: 26 additions & 0 deletions
diff --git a/‎Chapter02/BONUS_1_SpringAndJavaRecords/src/main/java/modern/challenge/record/Author.java
Lines changed: 8 additions & 0 deletions b/‎Chapter02/BONUS_1_SpringAndJavaRecords/src/main/java/modern/challenge/record/Author.java
Lines changed: 8 additions & 0 deletions
diff --git a/‎Chapter02/BONUS_1_SpringAndJavaRecords/src/main/java/modern/challenge/record/Book.java
Lines changed: 6 additions & 0 deletions b/‎Chapter02/BONUS_1_SpringAndJavaRecords/src/main/java/modern/challenge/record/Book.java
Lines changed: 6 additions & 0 deletions
diff --git a/‎Chapter02/BONUS_1_SpringAndJavaRecords/src/main/java/modern/challenge/service/BookstoreService.java
Lines changed: 27 additions & 0 deletions b/‎Chapter02/BONUS_1_SpringAndJavaRecords/src/main/java/modern/challenge/service/BookstoreService.java
Lines changed: 27 additions & 0 deletions
diff --git a/‎Chapter02/BONUS_1_SpringAndJavaRecords/src/main/resources/application.properties b/‎Chapter02/BONUS_1_SpringAndJavaRecords/src/main/resources/application.properties
diff --git a/‎Chapter02/BONUS_2_SpringAndJavaRecordsInjection/README.md
Lines changed: 19 additions & 0 deletions b/‎Chapter02/BONUS_2_SpringAndJavaRecordsInjection/README.md
Lines changed: 19 additions & 0 deletions
diff --git a/‎Chapter02/BONUS_2_SpringAndJavaRecordsInjection/nbactions.xml
Lines changed: 46 additions & 0 deletions b/‎Chapter02/BONUS_2_SpringAndJavaRecordsInjection/nbactions.xml
Lines changed: 46 additions & 0 deletions
diff --git a/‎Chapter02/BONUS_2_SpringAndJavaRecordsInjection/pom.xml
Lines changed: 70 additions & 0 deletions b/‎Chapter02/BONUS_2_SpringAndJavaRecordsInjection/pom.xml
Lines changed: 70 additions & 0 deletions
diff --git a/‎Chapter02/BONUS_2_SpringAndJavaRecordsInjection/src/main/java/modern/challenge/MainApplication.java
Lines changed: 12 additions & 0 deletions b/‎Chapter02/BONUS_2_SpringAndJavaRecordsInjection/src/main/java/modern/challenge/MainApplication.java
Lines changed: 12 additions & 0 deletions
diff --git a/‎Chapter02/BONUS_2_SpringAndJavaRecordsInjection/src/main/java/modern/challenge/controller/BookstoreController.java
Lines changed: 20 additions & 0 deletions b/‎Chapter02/BONUS_2_SpringAndJavaRecordsInjection/src/main/java/modern/challenge/controller/BookstoreController.java
Lines changed: 20 additions & 0 deletions
@@ -0,0 +1,19 @@
+**[How To Implement Pagination Via `ROW_NUMBER()` Window Function](https://github.com/AnghelLeonard/Hibernate-SpringBoot/tree/master/HibernateSpringBootPaginationRowNumber)**
+ 
+**Description:** This application is an example of using `ROW_NUMBER()` (and `COUNT(*) OVER()` for counting all elements) window function to implement pagination.
+
+**Key points:**
+- use a native query relying on `ROW_NUMBER()`
+- we don't return a page as `Page` or `Slice`, we return it as `List`, therefore `Pageable` is not used
+
+-----------------------------------------------------------------------------------------------------------------------    
+<table>
+     <tr><td><b>If you need a deep dive into the performance recipes exposed in this repository then I am sure that you will love my book "Spring Boot Persistence Best Practices"</b></td><td><b>If you need a hand of tips and illustrations of 100+ Java persistence performance issues then "Java Persistence Performance Illustrated Guide" is for you.</b></td></tr>
+     <tr><td>
+<a href="https://www.apress.com/us/book/9781484256251"><p align="left"><img src="https://github.com/AnghelLeonard/Hibernate-SpringBoot/blob/master/Spring%20Boot%20Persistence%20Best%20Practices.jpg" height="500" width="450"/></p></a>
+</td><td>
+<a href="https://leanpub.com/java-persistence-performance-illustrated-guide"><p align="right"><img src="https://github.com/AnghelLeonard/Hibernate-SpringBoot/blob/master/Java%20Persistence%20Performance%20Illustrated%20Guide.jpg" height="500" width="450"/></p></a>
+</td></tr></table>
+
+-----------------------------------------------------------------------------------------------------------------------    
+
@@ -0,0 +1,46 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<actions>
+        <action>
+            <actionName>run</actionName>
+            <packagings>
+                <packaging>jar</packaging>
+            </packagings>
+            <goals>
+                <goal>process-classes</goal>
+                <goal>org.codehaus.mojo:exec-maven-plugin:1.5.0:exec</goal>
+            </goals>
+            <properties>
+                <exec.args>--enable-preview -classpath %classpath ${packageClassName}</exec.args>
+                <exec.executable>java</exec.executable>
+            </properties>
+        </action>
+        <action>
+            <actionName>debug</actionName>
+            <packagings>
+                <packaging>jar</packaging>
+            </packagings>
+            <goals>
+                <goal>process-classes</goal>
+                <goal>org.codehaus.mojo:exec-maven-plugin:1.5.0:exec</goal>
+            </goals>
+            <properties>
+                <exec.args>-agentlib:jdwp=transport=dt_socket,server=n,address=${jpda.address} --enable-preview -classpath %classpath ${packageClassName}</exec.args>
+                <exec.executable>java</exec.executable>
+                <jpda.listen>true</jpda.listen>
+            </properties>
+        </action>
+        <action>
+            <actionName>profile</actionName>
+            <packagings>
+                <packaging>jar</packaging>
+            </packagings>
+            <goals>
+                <goal>process-classes</goal>
+                <goal>org.codehaus.mojo:exec-maven-plugin:1.5.0:exec</goal>
+            </goals>
+            <properties>
+                <exec.args>--enable-preview -classpath %classpath ${packageClassName}</exec.args>
+                <exec.executable>java</exec.executable>
+            </properties>
+        </action>
+    </actions>
@@ -0,0 +1,70 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
+    <modelVersion>4.0.0</modelVersion>
+
+    <groupId>com.jpa</groupId>
+    <artifactId>BONUS_1_SpringAndJavaRecords</artifactId>
+    <version>1.0</version>
+    <packaging>jar</packaging>
+
+    <name>BONUS_1_SpringAndJavaRecords</name>
+    <description>JPA project for Spring Boot</description>
+
+    <parent>
+        <groupId>org.springframework.boot</groupId>
+        <artifactId>spring-boot-starter-parent</artifactId>
+        <version>2.2.6.RELEASE</version>
+        <relativePath/> <!-- lookup parent from repository -->
+    </parent>
+
+    <properties>
+        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
+        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
+        <java.version>1.8</java.version>
+        <maven.compiler.source>14</maven.compiler.source>
+        <maven.compiler.target>14</maven.compiler.target>
+    </properties>
+
+    <dependencies>        
+        <dependency>
+            <groupId>org.springframework.boot</groupId>
+            <artifactId>spring-boot-starter-web</artifactId>
+        </dependency>             
+        <dependency>
+            <groupId>org.springframework.boot</groupId>
+            <artifactId>spring-boot-starter-test</artifactId>
+            <scope>test</scope>
+        </dependency>
+    </dependencies>
+
+    <build>
+        <plugins>
+            <plugin>
+                <groupId>org.springframework.boot</groupId>
+                <artifactId>spring-boot-maven-plugin</artifactId>
+            </plugin>
+            <plugin>
+                <groupId>org.apache.maven.plugins</groupId>
+                <artifactId>maven-compiler-plugin</artifactId>
+                <version>3.8.1</version>
+                <configuration>				
+                    <release>14</release>
+                    <compilerArgs>
+                        <arg>--enable-preview</arg>
+                    </compilerArgs>
+                    <forceJavacCompilerUse>true</forceJavacCompilerUse>
+                    <parameters>true</parameters>
+                </configuration>
+            </plugin>
+            <plugin>
+                <groupId>org.apache.maven.plugins</groupId>
+                <artifactId>maven-surefire-plugin</artifactId>
+                <version>3.0.0-M3</version>
+                <configuration>
+                    <argLine>--enable-preview</argLine>
+                </configuration>
+            </plugin>
+        </plugins>
+    </build>
+</project>
@@ -0,0 +1,12 @@
+package modern.challenge;
+
+import org.springframework.boot.SpringApplication;
+import org.springframework.boot.autoconfigure.SpringBootApplication;
+
+@SpringBootApplication
+public class MainApplication {
+
+    public static void main(String[] args) {
+        SpringApplication.run(MainApplication.class, args);
+    }
+}
@@ -0,0 +1,26 @@
+package modern.challenge.controller;
+
+import java.util.List;
+import modern.challenge.service.BookstoreService;
+
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+import modern.challenge.record.Author;
+
+@RestController
+public class BookstoreController {
+
+    private final BookstoreService bookstoreService;
+
+    public BookstoreController(BookstoreService bookstoreService) {
+        this.bookstoreService = bookstoreService;
+    }
+
+    @GetMapping("/authors")
+    public List<Author> fetchAuthors() {
+
+        return bookstoreService.fetchAuthors();
+    }
+
+}
@@ -0,0 +1,8 @@
+package modern.challenge.record;
+
+import java.util.List;
+import com.fasterxml.jackson.annotation.JsonProperty;
+
+public record Author(@JsonProperty("name") String name, 
+@JsonProperty("genre") String genre, 
+@JsonProperty("books") List<Book> books) {}
@@ -0,0 +1,6 @@
+package modern.challenge.record;
+
+import com.fasterxml.jackson.annotation.JsonProperty;
+
+public record Book(@JsonProperty("title") String title, 
+@JsonProperty("isbn") String isbn) {}
@@ -0,0 +1,27 @@
+package modern.challenge.service;
+
+import java.util.List;
+import org.springframework.stereotype.Service;
+
+import modern.challenge.record.Author;
+import modern.challenge.record.Book;
+
+@Service
+public class BookstoreService {
+
+    public List<Author> fetchAuthors() {
+
+        List<Author> authors = List.of(
+                new Author("Joana Nimar", "History", List.of(
+                        new Book("History of a day", "JN-001"),
+                        new Book("Prague history", "JN-002")
+                )),
+                        new Author("Mark Janel", "Horror", List.of(
+                                new Book("Carrie", "MJ-001"),
+                                new Book("House of pain", "MJ-002")
+                        )                        
+                ));
+        
+        return authors;
+    }
+}
@@ -0,0 +1,19 @@
+**[How To Implement Pagination Via `ROW_NUMBER()` Window Function](https://github.com/AnghelLeonard/Hibernate-SpringBoot/tree/master/HibernateSpringBootPaginationRowNumber)**
+ 
+**Description:** This application is an example of using `ROW_NUMBER()` (and `COUNT(*) OVER()` for counting all elements) window function to implement pagination.
+
+**Key points:**
+- use a native query relying on `ROW_NUMBER()`
+- we don't return a page as `Page` or `Slice`, we return it as `List`, therefore `Pageable` is not used
+
+-----------------------------------------------------------------------------------------------------------------------    
+<table>
+     <tr><td><b>If you need a deep dive into the performance recipes exposed in this repository then I am sure that you will love my book "Spring Boot Persistence Best Practices"</b></td><td><b>If you need a hand of tips and illustrations of 100+ Java persistence performance issues then "Java Persistence Performance Illustrated Guide" is for you.</b></td></tr>
+     <tr><td>
+<a href="https://www.apress.com/us/book/9781484256251"><p align="left"><img src="https://github.com/AnghelLeonard/Hibernate-SpringBoot/blob/master/Spring%20Boot%20Persistence%20Best%20Practices.jpg" height="500" width="450"/></p></a>
+</td><td>
+<a href="https://leanpub.com/java-persistence-performance-illustrated-guide"><p align="right"><img src="https://github.com/AnghelLeonard/Hibernate-SpringBoot/blob/master/Java%20Persistence%20Performance%20Illustrated%20Guide.jpg" height="500" width="450"/></p></a>
+</td></tr></table>
+
+-----------------------------------------------------------------------------------------------------------------------    
+
@@ -0,0 +1,46 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<actions>
+        <action>
+            <actionName>run</actionName>
+            <packagings>
+                <packaging>jar</packaging>
+            </packagings>
+            <goals>
+                <goal>process-classes</goal>
+                <goal>org.codehaus.mojo:exec-maven-plugin:1.5.0:exec</goal>
+            </goals>
+            <properties>
+                <exec.args>--enable-preview -classpath %classpath ${packageClassName}</exec.args>
+                <exec.executable>java</exec.executable>
+            </properties>
+        </action>
+        <action>
+            <actionName>debug</actionName>
+            <packagings>
+                <packaging>jar</packaging>
+            </packagings>
+            <goals>
+                <goal>process-classes</goal>
+                <goal>org.codehaus.mojo:exec-maven-plugin:1.5.0:exec</goal>
+            </goals>
+            <properties>
+                <exec.args>-agentlib:jdwp=transport=dt_socket,server=n,address=${jpda.address} --enable-preview -classpath %classpath ${packageClassName}</exec.args>
+                <exec.executable>java</exec.executable>
+                <jpda.listen>true</jpda.listen>
+            </properties>
+        </action>
+        <action>
+            <actionName>profile</actionName>
+            <packagings>
+                <packaging>jar</packaging>
+            </packagings>
+            <goals>
+                <goal>process-classes</goal>
+                <goal>org.codehaus.mojo:exec-maven-plugin:1.5.0:exec</goal>
+            </goals>
+            <properties>
+                <exec.args>--enable-preview -classpath %classpath ${packageClassName}</exec.args>
+                <exec.executable>java</exec.executable>
+            </properties>
+        </action>
+    </actions>
@@ -0,0 +1,70 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
+    <modelVersion>4.0.0</modelVersion>
+
+    <groupId>com.jpa</groupId>
+    <artifactId>BONUS_2_SpringAndJavaRecordsInjection</artifactId>
+    <version>1.0</version>
+    <packaging>jar</packaging>
+
+    <name>BONUS_2_SpringAndJavaRecordsInjection</name>
+    <description>JPA project for Spring Boot</description>
+
+    <parent>
+        <groupId>org.springframework.boot</groupId>
+        <artifactId>spring-boot-starter-parent</artifactId>
+        <version>2.2.6.RELEASE</version>
+        <relativePath/> <!-- lookup parent from repository -->
+    </parent>
+
+    <properties>
+        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
+        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
+        <java.version>1.8</java.version>
+        <maven.compiler.source>14</maven.compiler.source>
+        <maven.compiler.target>14</maven.compiler.target>
+    </properties>
+
+    <dependencies>        
+        <dependency>
+            <groupId>org.springframework.boot</groupId>
+            <artifactId>spring-boot-starter-web</artifactId>
+        </dependency>             
+        <dependency>
+            <groupId>org.springframework.boot</groupId>
+            <artifactId>spring-boot-starter-test</artifactId>
+            <scope>test</scope>
+        </dependency>
+    </dependencies>
+
+    <build>
+        <plugins>
+            <plugin>
+                <groupId>org.springframework.boot</groupId>
+                <artifactId>spring-boot-maven-plugin</artifactId>
+            </plugin>
+            <plugin>
+                <groupId>org.apache.maven.plugins</groupId>
+                <artifactId>maven-compiler-plugin</artifactId>
+                <version>3.8.1</version>
+                <configuration>				
+                    <release>14</release>
+                    <compilerArgs>
+                        <arg>--enable-preview</arg>
+                    </compilerArgs>
+                    <forceJavacCompilerUse>true</forceJavacCompilerUse>
+                    <parameters>true</parameters>
+                </configuration>
+            </plugin>
+            <plugin>
+                <groupId>org.apache.maven.plugins</groupId>
+                <artifactId>maven-surefire-plugin</artifactId>
+                <version>3.0.0-M3</version>
+                <configuration>
+                    <argLine>--enable-preview</argLine>
+                </configuration>
+            </plugin>
+        </plugins>
+    </build>
+</project>
@@ -0,0 +1,12 @@
+package modern.challenge;
+
+import org.springframework.boot.SpringApplication;
+import org.springframework.boot.autoconfigure.SpringBootApplication;
+
+@SpringBootApplication
+public class MainApplication {
+
+    public static void main(String[] args) {
+        SpringApplication.run(MainApplication.class, args);
+    }
+}
@@ -0,0 +1,20 @@
+package modern.challenge.controller;
+
+import java.util.List;
+import modern.challenge.service.BookstoreService;
+
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+import modern.challenge.record.Author;
+
+@RestController
+public record BookstoreController(BookstoreService bookstoreService) {
+
+    @GetMapping("/authors")
+    public List<Author> fetchAuthors() {
+
+        return bookstoreService.fetchAuthors();
+    }
+
+}