Commit56e8e6a

committed

Step 1. Migrate from H2 to PostgreSQL

1 parent6b745c7 commit56e8e6aCopy full SHA for 56e8e6a

File tree

+29

-3

lines changed

existing-spring-boot-app-modification/spring-petclinic-main
- build.gradle
- docker-compose.yaml
- src/main/resources
  - application.properties

+29

-3

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -33,6 +33,7 @@ dependencies {`
`33`	`33`	`runtimeOnly'com.h2database:h2'`
`34`	`34`	`developmentOnly'org.springframework.boot:spring-boot-devtools'`
`35`	`35`	`testImplementation'org.springframework.boot:spring-boot-starter-test'`
	`36`	`+ runtimeOnly'org.postgresql:postgresql'`
`36`	`37`	`}`
`37`	`38`
`38`	`39`	`tasks.named('test') {`

Lines changed: 20 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,20 @@`
	`1`	`+services:`
	`2`	`+postgres:`
	`3`	`+image:postgres:16.3`
	`4`	`+restart:always`
	`5`	`+ports:`
	`6`	`+ -"5432:5432"`
	`7`	`+volumes:`
	`8`	`+ -postgres_data:/var/lib/postgresql/data`
	`9`	`+environment:`
	`10`	`+POSTGRES_USER:root`
	`11`	`+POSTGRES_PASSWORD:root`
	`12`	`+POSTGRES_DB:spring-petclinic`
	`13`	`+healthcheck:`
	`14`	`+test:pg_isready -U $$POSTGRES_USER -d $$POSTGRES_DB`
	`15`	`+interval:10s`
	`16`	`+timeout:5s`
	`17`	`+start_period:10s`
	`18`	`+retries:5`
	`19`	`+volumes:`
	`20`	`+postgres_data:`

Lines changed: 8 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`# database init, supports mysql too`
`2`		`-database=h2`
	`2`	`+database=postgres`
`3`	`3`	`spring.sql.init.schema-locations=classpath*:db/${database}/schema.sql`
`4`	`4`	`spring.sql.init.data-locations=classpath*:db/${database}/data.sql`
`5`	`5`	`spring.sql.init.mode=always`
`@@ -8,9 +8,10 @@ spring.sql.init.mode=always`
`8`	`8`	`spring.thymeleaf.mode=HTML`
`9`	`9`
`10`	`10`	`# JPA`
`11`		`-spring.jpa.hibernate.ddl-auto=none`
	`11`	`+spring.jpa.hibernate.ddl-auto=validate`
`12`	`12`	`spring.jpa.open-in-view=true`
`13`	`13`
	`14`	`+spring.jpa.show-sql=true`
`14`	`15`	`# Internationalization`
`15`	`16`	`spring.messages.basename=messages/messages`
`16`	`17`
`@@ -19,6 +20,10 @@ management.endpoints.web.exposure.include=*`
`19`	`20`
`20`	`21`	`# Logging`
`21`	`22`	`logging.level.org.springframework=INFO`
`22`		`-`
	`23`	`+#Datasource configuration`
	`24`	`+spring.datasource.url=jdbc:postgresql://localhost/spring-petclinic`
	`25`	`+spring.datasource.username=root`
	`26`	`+spring.datasource.password=root`
	`27`	`+spring.datasource.driver-class-name=org.postgresql.Driver`
`23`	`28`	`# Maximum time static resources should be cached`
`24`	`29`	`spring.web.resources.cache.cachecontrol.max-age=12h`

Comments

(0)