sql-model
Used in:
components
- OverviewOverview
- VersionsVersions
- DependentsDependents
- DependenciesDependencies
<dependency>
<groupId>com.northdata.schema</groupId>
<artifactId>sql-model</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.4.0</version>
</parent>
<groupId>com.northdata.schema</groupId>
<artifactId>sql-model</artifactId>
<version>1.2.0</version>
<name>SQL Model for North Data</name>
<description>SQL Model for North Data</description>
<properties>
<jdbc.url>jdbc:postgresql://localhost/northdata</jdbc.url>
<jdbc.user>sa</jdbc.user>
<jdbc.password>sa</jdbc.password>
<maven.compiler.target>17</maven.compiler.target>
<maven.compiler.source>17</maven.compiler.source>
<maven.compiler.release>17</maven.compiler.release>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<skipJooq>false</skipJooq>
<version.ch.qos.logback>1.4.5</version.ch.qos.logback>
<version.org.assertj>3.25.3</version.org.assertj>
<version.org.flywaydb>10.7.1</version.org.flywaydb>
<version.org.jooq>3.19.3</version.org.jooq>
<version.org.postgresql>42.7.1</version.org.postgresql>
<version.org.slf4j>2.0.11</version.org.slf4j>
</properties>
<scm>
<connection>scm:git:git@github.com:northdata/sql-model.git</connection>
<developerConnection>scm:git:git@github.com:northdata/sql-model.git</developerConnection>
<url>http://github.com/northdata/sql-model/tree/master</url>
<tag>HEAD</tag>
</scm>
<url>http://github.com/northdata/sql-model</url>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>org.junit</groupId>
<artifactId>junit-bom</artifactId>
<version>5.10.2</version>
<scope>import</scope>
<type>pom</type>
</dependency>
</dependencies>
</dependencyManagement>
<dependencies>
<dependency>
<groupId>org.jooq</groupId>
<artifactId>jooq</artifactId>
<version>${version.org.jooq}</version>
</dependency>
<dependency>
<groupId>org.assertj</groupId>
<artifactId>assertj-core</artifactId>
<version>${version.org.assertj}</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.junit.jupiter</groupId>
<artifactId>junit-jupiter-engine</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>io.fabric8</groupId>
<artifactId>docker-maven-plugin</artifactId>
<version>0.43.4</version>
<configuration>
<removeVolumes>true</removeVolumes>
<images>
<image>
<alias>db</alias>
<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>
<url>${jdbc.url}</url>
<user>${jdbc.user}</user>
<password>${jdbc.password}</password>
<locations>
<location>filesystem:src/main/resources/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>
<skip>${skipJooq}</skip>
<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>
<inputSchema>public</inputSchema>
</database>
<target>
<packageName>com.northdata.sql.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>Open source consumption has exploded, with estimates placing this year’s downloads at over 6.6 trillion. This reliance on open source components, now making up to 90% of the modern software application, has ushered in both unprecedented innovation and complex challenges for software supply chains.
View the Report