io.github.jklingsporn:vertx-jooq-async-classic

A jOOQ-CodeGenerator to create async vertxified DAOs and POJOs

License

License

Categories

Categories

jOOQ Data Databases
GroupId

GroupId

io.github.jklingsporn
ArtifactId

ArtifactId

vertx-jooq-async-classic
Last Version

Last Version

0.4
Release Date

Release Date

Type

Type

jar
Description

Description

A jOOQ-CodeGenerator to create async vertxified DAOs and POJOs

Download vertx-jooq-async-classic

How to add to project

<!-- https://jarcasting.com/artifacts/io.github.jklingsporn/vertx-jooq-async-classic/ -->
<dependency>
    <groupId>io.github.jklingsporn</groupId>
    <artifactId>vertx-jooq-async-classic</artifactId>
    <version>0.4</version>
</dependency>
// https://jarcasting.com/artifacts/io.github.jklingsporn/vertx-jooq-async-classic/
implementation 'io.github.jklingsporn:vertx-jooq-async-classic:0.4'
// https://jarcasting.com/artifacts/io.github.jklingsporn/vertx-jooq-async-classic/
implementation ("io.github.jklingsporn:vertx-jooq-async-classic:0.4")
'io.github.jklingsporn:vertx-jooq-async-classic:jar:0.4'
<dependency org="io.github.jklingsporn" name="vertx-jooq-async-classic" rev="0.4">
  <artifact name="vertx-jooq-async-classic" type="jar" />
</dependency>
@Grapes(
@Grab(group='io.github.jklingsporn', module='vertx-jooq-async-classic', version='0.4')
)
libraryDependencies += "io.github.jklingsporn" % "vertx-jooq-async-classic" % "0.4"
[io.github.jklingsporn/vertx-jooq-async-classic "0.4"]

Dependencies

compile (4)

Group / Artifact Type Version
io.github.jklingsporn : vertx-jooq-async-shared jar 0.4
io.vertx : vertx-core jar 3.5.0
org.jooq : jooq jar 3.10.1
io.vertx : vertx-mysql-postgresql-client jar 3.5.0

test (3)

Group / Artifact Type Version
junit : junit jar 4.12
com.google.inject : guice jar 4.1.0
ch.qos.logback : logback-classic jar 1.1.3

Project Modules

There are no modules declared in this project.

deprecation warning

I started vertx-jooq-async a couple months after working on vertx-jooq to allow the same features but using the async driver. First, I tried to incorproate it into vertx-jooq but it couldn't be done without a major refactoring (which I didn't have the time for), so I created this repository. In the following weeks it bothered me more and more, that if I had to fix a bug, it had to be done two times. Also both projects shared a similar API: again a lot of duplicate code.

In the last weeks I finally found some time to refactor vertx-jooq so it incorporates now both, the JDBC and the async driver. Because of that, vertx-jooq-async will no longer be maintained.

vertx-jooq-async

The real async version of vertx-jooq: a jOOQ-CodeGenerator to create vertx-ified DAOs and POJOs! This time with a real asynchronous driver. That's right - no JDBC.

differences to vertx-jooq

This project uses jOOQ for code-generation and to render queries. The query execution is done by the AsyncJooqSQLClient which wraps a io.vertx.ext.asyncsql.AsyncSQLClient. The executeAsync-method has been removed from VertxDao, instead you need to call the client() method on the DAO to execute custom SQL-statements (see example below) on the AsyncJooqSQLClient.

example

//Setup your jOOQ configuration
Configuration configuration = new DefaultConfiguration();
configuration.set(SQLDialect.MYSQL); //or SQLDialect.POSTGRES
//no other DB-Configuration necessary because jOOQ is only used to render our statements - not for excecution

//setup Vertx
Vertx vertx = Vertx.vertx();
//setup the client
JsonObject config = new JsonObject().put("host", "127.0.0.1").put("username", "vertx").putNull("password").put("database","vertx");
AsyncJooqSQLClient client = AsyncJooqSQLClient.create(vertx,MySQLClient.createNonShared(vertx, config))

//instantiate a DAO (which is generated for you)
SomethingDao dao = new SomethingDao(configuration);
dao.setVertx(vertx);
dao.setClient(client);

//fetch something with ID 123...
CompletableFuture<Void> sendFuture =
    dao.findByIdAsync(123).
    thenAccept(something->
        vertx.eventBus().send("sendSomething",something.toJson())
    );

//maybe consume it in another verticle
vertx.eventBus().<JsonObject>consumer("sendSomething", jsonEvent->{
    JsonObject message = jsonEvent.body();
    //Convert it back into a POJO...
    Something something = new Something(message);
    //... change some values
    something.setSomeregularnumber(456);
    //... and update it into the DB
    CompletableFuture<Void> updatedFuture = dao.updateAsync(something);

    //or do you prefer writing your own typesafe SQL?
    CompletableFuture<Something> selectFuture = dao.client().fetchOne(DSL.using(dao.configuration()).selectFrom(Tables.SOMETHING).orderBy(Tables.SOMETHING.SOMEID.desc()).limit(1),dao.jsonMapper());
    //check for completion
    selectFuture.whenComplete((something,ex)->{
        if(ex==null){
            System.out.println("It's something! "+something.toJson());
        }else{
            System.err.println("Something failed badly: "+ex.getMessage());
        }
    });
});

callback? future? rx?

Again, this library comes in different flavors:

  • the classic callback-handler style.
  • a API that returns a vertx-ified implementation of java.util.concurrent.CompletableFuture for all async DAO operations and thus makes chaining your async operations easier. It has some limitations which you need to be aware about (see known issues).
  • a RX Java based API

Depending on your needs, you have to include one of the following dependencies into your pom:

maven

<dependency>
  <groupId>io.github.jklingsporn</groupId>
  <artifactId>vertx-jooq-async-future</artifactId>
  <version>0.4</version>
</dependency>

maven code generator configuration example for mysql

The following code-snippet can be copy-pasted into your pom.xml to generate code from your MySQL database schema.

Watch out for placeholders beginning with 'YOUR_xyz' though! E.g. you have to define credentials for DB access and specify the target directory where jOOQ should put the generated code into, otherwise it won't run!

After you replaced all placeholders with valid values, you should be able to run mvn generate-sources which creates all POJOs and DAOs into the target directory you specified.

If you are new to jOOQ, I recommend to read the awesome jOOQ documentation, especially the chapter about code generation.

<project>
...your project configuration here...

  <dependencies>
    ...your other dependencies...
    <dependency>
      <groupId>org.jooq</groupId>
      <artifactId>jooq</artifactId>
      <version>3.9.2</version>
    </dependency>
    <dependency>
      <groupId>io.github.jklingsporn</groupId>
      <artifactId>vertx-jooq-async-future</artifactId>
      <version>0.4</version>
    </dependency>
  </dependencies>
  <build>
    <plugins>
      <plugin>
          <!-- Specify the maven code generator plugin -->
          <groupId>org.jooq</groupId>
          <artifactId>jooq-codegen-maven</artifactId>
          <version>3.9.2</version>

          <!-- The plugin should hook into the generate goal -->
          <executions>
              <execution>
                  <goals>
                      <goal>generate</goal>
                  </goals>
              </execution>
          </executions>

          <dependencies>
              <dependency>
                  <groupId>mysql</groupId>
                  <artifactId>mysql-connector-java</artifactId>
                  <version>5.1.37</version>
              </dependency>
              <dependency>
                  <groupId>io.github.jklingsporn</groupId>
                  <artifactId>vertx-jooq-async-generate</artifactId>
                  <version>0.4</version>
              </dependency>
          </dependencies>

          <!-- Specify the plugin configuration.
               The configuration format is the same as for the standalone code generator -->
          <configuration>
              <!-- JDBC connection parameters -->
              <jdbc>
                  <driver>com.mysql.jdbc.Driver</driver>
                  <url>YOUR_JDBC_URL_HERE</url>
                  <user>YOUR_DB_USER_HERE</user>
                  <password>YOUR_DB_PASSWORD_HERE</password>
              </jdbc>

              <!-- Generator parameters -->
              <generator>
                  <name>io.github.jklingsporn.vertx.jooq.async.generate.future.FutureAsyncVertxGenerator</name>
                  <database>
                      <name>org.jooq.util.mysql.MySQLDatabase</name>
                      <includes>.*</includes>
                      <inputSchema>YOUR_INPUT_SCHEMA</inputSchema>
                      <outputSchema>YOUR_OUTPUT_SCHEMA</outputSchema>
                      <unsignedTypes>false</unsignedTypes>
                      <forcedTypes>
                          <!-- Convert tinyint to boolean -->
                          <forcedType>
                              <name>BOOLEAN</name>
                              <types>(?i:TINYINT)</types>
                          </forcedType>
                          <!-- Convert varchar column with name 'someJsonObject' to a io.vertx.core.json.JsonObject-->
                          <forcedType>
                              <userType>io.vertx.core.json.JsonObject</userType>
                              <converter>io.github.jklingsporn.vertx.jooq.async.shared.JsonObjectConverter</converter>
                              <expression>someJsonObject</expression>
                              <types>.*</types>
                          </forcedType>
                          <!-- Convert varchar column with name 'someJsonArray' to a io.vertx.core.json.JsonArray-->
                          <forcedType>
                              <userType>io.vertx.core.json.JsonArray</userType>
                              <converter>Jio.github.jklingsporn.vertx.jooq.async.shared.sonArrayConverter</converter>
                              <expression>someJsonArray</expression>
                              <types>.*</types>
                          </forcedType>
                      </forcedTypes>
                  </database>
                  <target>
                      <!-- This is where jOOQ will put your files -->
                      <packageName>YOUR_TARGET_PACKAGE_HERE</packageName>
                      <directory>YOUR_TARGET_DIRECTORY_HERE</directory>
                  </target>
                  <generate>
                      <interfaces>true</interfaces>
                      <daos>true</daos>
                      <fluentSetters>true</fluentSetters>
                      <pojosEqualsAndHashCode>true</pojosEqualsAndHashCode>
                  </generate>


                  <strategy>
                      <name>io.github.jklingsporn.vertx.jooq.async.generate.future.FutureAsyncGeneratorStrategy</name>
                  </strategy>
              </generator>

          </configuration>
      </plugin>
    </plugins>
  </build>
</project>

programmatic configuration of the code generator

See the TestTool of how to setup the generator programmatically.

known issues

  • insertReturningPrimary-method only works for MySQL and numeric keys.
  • Only available for MySQL and Postgres.
  • Nobody can prevent you from calling one of the blocking fetch- or execute-methods on the VertxDAO or a jOOQ-query. If you do it, jOOQ will try to execute the query by itself using JDBC (if properly configured). So try to avoid it at any cost.
  • Currently no Guice support

Versions

Version
0.4
0.3
0.2
0.1