Configuration — ConformaESG Integration Service

Datasource

Property	Type	Default	Description
`quarkus.datasource.db-kind`	string	`postgresql`	Use `h2` for testing
`quarkus.datasource.username`	string	—	PostgreSQL username
`quarkus.datasource.password`	string	—	PostgreSQL password
`quarkus.datasource.jdbc.url`	string	—	JDBC connection URL

Hibernate ORM

Property	Type	Default	Description
`quarkus.hibernate-orm.database.generation`	string	`validate`	`none`, `validate`, `update`, `drop-and-create`
`quarkus.hibernate-orm.log.sql`	boolean	`false`	Log SQL to console

Example `app/src/main/resources/application.properties`

Properties
1%prod.quarkus.datasource.db-kind=postgresql
2%prod.quarkus.datasource.username=${DB_USER}
3%prod.quarkus.datasource.password=${DB_PASSWORD}
4%prod.quarkus.datasource.jdbc.url=jdbc:postgresql://${DB_HOST:localhost}:5432/${DB_NAME:conformaesg}
5%prod.quarkus.hibernate-orm.database.generation=validate
6
7quarkus.datasource.devservices.image-name=postgres:16-alpine
8%dev.quarkus.hibernate-orm.database.generation=update
9
10quarkus.swagger-ui.always-include=true
11quarkus.smallrye-openapi.info-title=ConformaESG Integration Service API
12quarkus.smallrye-openapi.info-version=1.1.0

Database Migrations (Flyway)

The purchase and product modules use Flyway for schema migrations:

Migration	Module	Description
`V1__add_product_origin_country_fields.sql`	`product`	`product_origin_country`, `raw_material_origin_country`
`V1__add_product_logistics_and_availability_fields.sql`	`product`	`quantity_available`, `lead_time_days`, `unit_of_measure`
`V2__replace_purchase_year_with_purchase_date.sql`	`purchase`	Replaces `purchase_year` with `purchase_date`
`V1__add_document_tracking_fields_to_purchases.sql`	`purchase`	PO, invoice, DDT, TC, batch number fields
`V3__add_delivery_dates_and_purchase_status.sql`	`purchase`	Delivery dates, status, status change log table

Warning

Always back up your database before running migrations in production.

Datasource

Hibernate ORM

Example app/src/main/resources/application.properties

Database Migrations (Flyway)

Example `app/src/main/resources/application.properties`