MySpaceMusicCatalogue

A type-safe PostgreSQL database binding library generated by pGenie, targeting Java 21.

Statements

• InsertAlbum
• SelectAlbumByFormat
• SelectAlbumById
• SelectAlbumByName
• SelectAlbumFields
• SelectAlbumWithFilters
• SelectAlbumWithTracks
• SelectGenreByArtist
• UpdateAlbumRecordingReturning
• UpdateAlbumReleased

Custom Types

• AlbumFormat
• DiscInfo
• RecordingInfo
• TrackInfo

Usage

Add the generated sources to your Maven project alongside the required runtime dependency:

<dependency>
    <groupId>io.pgenie.artifacts.myspace</groupId>
    <artifactId>music-catalogue</artifactId>
    <version>1.0.0</version>
</dependency>

Obtain a JDBC Connection and execute a statement:

try (Connection conn = dataSource.getConnection()) {
    var result = new io.pgenie.artifacts.myspace.musiccatalogue.statements.InsertAlbum(...).execute(conn);
}

Building

mvn verify

Running Tests

Integration tests use Testcontainers to spin up a PostgreSQL container automatically. Docker must be available on the host.

mvn failsafe:integration-test failsafe:verify