Setup POSTGRESQL dan Quarkus dengan Gradle

Pada build.gradle tambahkan

dependencies {
    implementation 'io.quarkus:quarkus-jdbc-postgresql'
    implementation 'io.quarkus:quarkus-hibernate-orm-panache'

Pada application.properties tambahkan

quarkus.datasource.jdbc.url=jdbc:postgresql://localhost:5432/qyboilerplate_db
quarkus.datasource.username=postgres
quarkus.datasource.password=postgres
quarkus.hibernate-orm.log.sql=true

 Entity

package com.yoesoff.plate.entity;

import io.quarkus.hibernate.orm.panache.PanacheEntity;
import jakarta.persistence.Entity;
import jakarta.persistence.Table;

@Entity
@Table(name = "app_users")
public class User extends PanacheEntity {
    public String username;
    public String password;
    public String email;

    // Default constructor
    public User() {
    }

    // Constructor with parameters
    public User(String username, String password, String email) {
        this.username = username;
        this.password = password;
        this.email = email;
    }

    // Getters and setters can be added if needed
}

 

 Hasil Di Database

-- public.app_users definition

-- Drop table

-- DROP TABLE public.app_users;

CREATE TABLE public.app_users ( id int8 NOT NULL, email varchar(255) NULL, "password" varchar(255) NULL, username varchar(255) NULL, CONSTRAINT app_users_pkey PRIMARY KEY (id));