Description

<dependency>
    <groupId>com.northdata.schema</groupId>
    <artifactId>scr</artifactId>
    <version>1.2.0</version>
</dependency>

<project xmlns="http://maven.apache.org/POM/4.0.0"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>

	<parent>
		<groupId>com.northdata</groupId>
		<artifactId>superpom</artifactId>
		<version>1.8.0</version>
	</parent>

	<groupId>com.northdata.schema</groupId>
	<artifactId>scr</artifactId>
	<version>1.2.0</version>

	<name>SQL Model for Scottish Charity Register data</name>

	<description>SQL Model for Scottish Charity Register data</description>

	<properties>
		<!-- Use Cloud SQL via proxy: -->
		<!-- cloud_sql_proxy -instances=nd-staging:europe-west3:nd-staging-risika=tcp:0.0.0.0:5432 -->
		<jdbc.url>jdbc:postgresql://localhost/scr</jdbc.url>
		<jdbc.user>sa</jdbc.user>
		<jdbc.password>sa</jdbc.password>

		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<version.ch.qos.logback>1.4.5</version.ch.qos.logback>
		<version.org.flywaydb>11.8.2</version.org.flywaydb>
		<version.org.jooq>3.20.3</version.org.jooq>
		<version.org.postgresql>42.7.10</version.org.postgresql>
		<version.org.slf4j>2.0.17</version.org.slf4j>
	</properties>

	<scm>
		<connection>scm:git:git@github.com:northdata/schema-scr.git</connection>
		<developerConnection>scm:git:git@github.com:northdata/schema-scr.git</developerConnection>
		<url>http://github.com/northdata/schema-scr/tree/master</url>
		<tag>HEAD</tag>
	</scm>

	<url>http://github.com/northdata/schema-scr</url>

	<dependencies>
		<dependency>
			<groupId>org.jooq</groupId>
			<artifactId>jooq</artifactId>
			<version>${version.org.jooq}</version>
		</dependency>
		<dependency>
			<groupId>org.postgresql</groupId>
			<artifactId>postgresql</artifactId>
			<version>${version.org.postgresql}</version>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-api</artifactId>
			<version>${version.org.slf4j}</version>
		</dependency>
		<dependency>
			<groupId>com.google.cloud.sql</groupId>
			<artifactId>postgres-socket-factory</artifactId>
			<version>1.28.2</version>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>io.fabric8</groupId>
				<artifactId>docker-maven-plugin</artifactId>
				<version>0.48.1</version>
				<configuration>
					<removeVolumes>true</removeVolumes>
					<images>
						<image>
							<alias>db</alias>
							<name>postgres:18.3</name>
							<external>
								<type>compose</type>
								<basedir>src/main/docker/postgres</basedir>
								<composeFile>docker-compose.yml</composeFile>
							</external>
							<run>
								<wait>
									<time>15000</time>
								</wait>
							</run>
						</image>
					</images>
				</configuration>
				<executions>
					<execution>
						<id>start</id>
						<goals>
							<goal>start</goal>
						</goals>
						<phase>validate</phase>
					</execution>
					<execution>
						<id>stop</id>
						<goals>
							<goal>stop</goal>
						</goals>
						<phase>post-integration-test</phase>
					</execution>
				</executions>
			</plugin>
			<plugin>
				<groupId>org.flywaydb</groupId>
				<artifactId>flyway-maven-plugin</artifactId>
				<version>${version.org.flywaydb}</version>
				<executions>
					<execution>
						<phase>generate-sources</phase>
						<goals>
							<goal>migrate</goal>
						</goals>
					</execution>
				</executions>
				<configuration>
					<skip>false</skip>
					<url>${jdbc.url}</url>
					<user>${jdbc.user}</user>
					<password>${jdbc.password}</password>
					<locations>
						<location>filesystem:src/main/resources/scr-migration</location>
					</locations>
				</configuration>
				<dependencies>
					<dependency>
						<groupId>org.flywaydb</groupId>
						<artifactId>flyway-database-postgresql</artifactId>
						<version>${version.org.flywaydb}</version>
					</dependency>
					<dependency>
						<groupId>org.postgresql</groupId>
						<artifactId>postgresql</artifactId>
						<version>${version.org.postgresql}</version>
					</dependency>
				</dependencies>
			</plugin>
			<plugin>
				<groupId>org.jooq</groupId>
				<artifactId>jooq-codegen-maven</artifactId>
				<version>${version.org.jooq}</version>
				<executions>
					<execution>
						<goals>
							<goal>generate</goal>
						</goals>
					</execution>
				</executions>
				<dependencies>
					<dependency>
						<groupId>org.postgresql</groupId>
						<artifactId>postgresql</artifactId>
						<version>${version.org.postgresql}</version>
					</dependency>
				</dependencies>
				<configuration>
					<jdbc>
						<driver>org.postgresql.Driver</driver>
						<url>${jdbc.url}</url>
						<user>${jdbc.user}</user>
						<password>${jdbc.password}</password>
					</jdbc>
					<generator>
						<database>
							<name>org.jooq.meta.postgres.PostgresDatabase</name>
							<!-- override schema names to get nice Java package names -->
							<schemata>
								<schema>
									<inputSchema>scr</inputSchema>
									<outputSchema>scr</outputSchema>
								</schema>
							</schemata>
						</database>
						<target>
							<packageName>com.northdata.scr.model</packageName>
							<directory>target/generated-sources/jooq</directory>
						</target>
					</generator>
				</configuration>
			</plugin>
			<plugin>
				<groupId>org.codehaus.mojo</groupId>
				<artifactId>build-helper-maven-plugin</artifactId>
				<executions>
					<execution>
						<id>add-source</id>
						<phase>generate-sources</phase>
						<goals>
							<goal>add-source</goal>
						</goals>
						<configuration>
							<sources>
								<source>${project.build.directory}/generated-sources/jooq</source>
							</sources>
						</configuration>
					</execution>
				</executions>
			</plugin>
		</plugins>
	</build>
</project>