JPA and Docker Compose

Phrdavis · Phrdavis · commit 61064a2b1eee · 2024-03-17T20:30:58.000-03:00
MySQL Docker image in docker-compose and spring configs in application.yml
diff --git a/pom.xml b/pom.xml
@@ -17,11 +17,19 @@
 		<java.version>21</java.version>
 	</properties>
 	<dependencies>
+		<dependency> 
+			<groupId>com.mysql</groupId>
+			<artifactId>mysql-connector-j</artifactId>
+			<scope>runtime</scope>
+		</dependency>
+		<dependency>
+			<groupId>org.springframework.boot</groupId>
+			<artifactId>spring-boot-starter-data-jpa</artifactId>
+		</dependency>
 		<dependency>
 			<groupId>org.springframework.boot</groupId>
 			<artifactId>spring-boot-starter-web</artifactId>
 		</dependency>
-
 		<dependency>
 			<groupId>org.springframework.boot</groupId>
 			<artifactId>spring-boot-devtools</artifactId>
diff --git a/src/main/java/com/springboot/Control/CustomerRepository.java b/src/main/java/com/springboot/Control/CustomerRepository.java
@@ -0,0 +1,11 @@
+package com.springboot.Control;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+
+import com.springboot.Entidades.Customer;
+
+public interface CustomerRepository 
+                extends JpaRepository<Customer, Integer>{
+
+    
+}
diff --git a/src/main/java/com/springboot/Entidades/Customer.java b/src/main/java/com/springboot/Entidades/Customer.java
@@ -1,7 +1,20 @@
-package com.springboot;
+package com.springboot.Entidades;
 
+import jakarta.persistence.Entity;
+import jakarta.persistence.GeneratedValue;
+import jakarta.persistence.GenerationType;
+import jakarta.persistence.Id;
+import jakarta.persistence.SequenceGenerator;
+
+@Entity
 public class Customer {
 
+    @Id
+    @GeneratedValue(
+
+        strategy = GenerationType.IDENTITY
+
+    )
     private Integer id;
     private String name;
     private String email;
diff --git a/src/main/java/com/springboot/Main.java b/src/main/java/com/springboot/Main.java
@@ -1,10 +1,7 @@
 package com.springboot;
 
-import java.util.List;
-
 import org.springframework.boot.SpringApplication;
 import org.springframework.boot.autoconfigure.SpringBootApplication;
-import org.springframework.web.bind.annotation.GetMapping;
 import org.springframework.web.bind.annotation.RestController;
 
 @SpringBootApplication
@@ -17,31 +14,4 @@ public static void main(String[] args){
 
     }
 
-    @GetMapping("/")
-    public GreetResponse greet(){
-
-        return new GreetResponse
-        (
-            "Hello", 
-           List.of("Javascript", "Java", "Python"), 
-            new Person("Davi", 21, 0.1)
-        );
-
-    }
-
-    record Person(String name, int age, double savings){};
-    
-    record GreetResponse(String greet, List<String> favProgrammingLanguages, Person person){
-
-            public GreetResponse(String greet, List<String> favProgrammingLanguages, Person person){
-
-                this.greet = greet; 
-                this.favProgrammingLanguages = favProgrammingLanguages; 
-                this.person = person; 
-
-            }
-
-
-        }
-
 }
diff --git a/src/main/java/com/springboot/docker-compose.yml b/src/main/java/com/springboot/docker-compose.yml
@@ -1,19 +1,11 @@
 services:
     db: 
-      image: mysql:latest
+      container_name: springboot_db
+      image: mysql
       restart: unless-stopped
       environment: 
         MYSQL_ROOT_PASSWORD: Bombinhas123@
-        MYSQL_DATABASE: davi_home
-        MYSQL_TCP_PORT: 3306
       ports:
-        8888: 8888
-      expose:
-        3306
+        - "8080:3306"
       
-
-    adminer:
-      image: adminer
-      restart: unless-stopped
-      ports: 
-        - 8888:8888"
+    
diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
@@ -1,2 +1,18 @@
 server:
-  port: 3000
+  port: 3030
+
+spring:
+  datasource:
+    url: jdbc:mysql://localhost:8080/customer
+    username: root
+    password: Bombinhas123@
+    driver-class-name: com.mysql.cj.jdbc.Driver
+  
+  jpa:
+    database-platform: org.hibernate.dialect.MySQLDialect
+    hibernate: 
+      ddl-auto: update
+    show-sql: true
+  
+  application:
+    name: SPRING_PROJECT
