gregopet

import org.jooq.codegen.GenerationTool
import org.jooq.meta.jaxb.*
import org.jooq.meta.*

// These can also go into gradle.properties
def packageName = "my.package"
def postgresDriverVersion = "42.1.4"
def jooqVersion = "3.11.1"
def debugDatabaseHost="localhost"
def debugDatabasePort=5432

gregopet

jooq.fetchOne("select * from film limit 1");

// type safety for fields
jooq.fetchOne("select * from film limit 1").get(FILM.TITLE);
jooq.fetchOne("select title || ' ' || description from film limit 1").get(0, String.class);

// parameters
jooq
  .fetchOne("select title || ' ' || description from film where title like ? limit 1", "DINOSAUR%")
  .get(0, String.class);

gregopet

select(
    DIRECTOR.NAME.as(PERSON.NAME),
    DIRECTOR.ADDRESS.as(PERSON.ADDRESS)
)
.from(DIRECTOR)
.union(
    select(
        ACTOR.NAME.as(PERSON.NAME),
        castNull(PERSON.ADDRESS).as(PERSON.ADDRESS)
    )

gregopet

defaultTasks 'jooqModel'

buildscript {
	repositories {
		jcenter()
	}

	dependencies {
		classpath "org.postgresql:postgresql:42.1.4"
		classpath "org.jooq:jooq-meta:3.13.1"

gregopet

import org.jooq.codegen.GenerationTool

// To include into main Gradle file, use: apply(from = "jooq.gradle.kts")

val dbHost: String by project
val dbPort: String by project
val dbName: String by project
val dbUser: String by project
val dbPass: String by project

gregopet

openapi: 3.0.0
info:
  version: 1.0.0
  title: Smart City Bikes station protocol
paths: {}
  # No specific paths - one of the events below is either sent via MQTT or pushed via TCP to an IP & port
components:
  schemas:
    GenericEvent:
      description: Common properties present in all station events (see individual subtypes)