org.jooby.querydsl

Class QueryDSL

java.lang.Object

org.jooby.jdbc.Jdbc

org.jooby.querydsl.QueryDSL

All Implemented Interfaces:

org.jooby.Jooby.Module

public class QueryDSL
extends Jdbc

queryDSL

SQL abstraction provided by QueryDSL using plain JDBC underneath.

This module depends on Jdbc module, make sure you read the doc of the Jdbc module before using this module.

usage

 import org.jooby.querydsl.QueryDSL;

 {
   use(new QueryDSL());

   get("/my-api", req  -> {
     SQLQueryFactory queryFactory = req.require(SQLQueryFactory.class);
     // Do something with the database
     ...
   });
 }
 

dialects

Dialect is detected automatically and usually you don't need to do anything. But if the default dialect detector doesn't work and/or you have a custom dialect:

 {
   use(new QueryDSL().with(new MyCustomTemplates());
 }
 

multiple databases

 import org.jooby.querydsl.QueryDSL;

 {
   use(new QueryDSL("db.main"));
   use(new QueryDSL("db.aux"));

   get("/my-api", req  -> {
     SQLQueryFactory queryFactory = req.require("db.main", SQLQueryFactory.class);
     // Do something with the database
   });
 }
 

advanced configuration

This module builds QueryDSL SQLQueryFactories on top of a default Configuration object, a SQLTemplates instance and a DataSource from the Jdbc module.

Advanced configuration can be added by invoking the Jdbc.doWith(BiConsumer) method, adding your own settings to the configuration.

 {
   use(new QueryDSL().doWith(conf  -> {
     conf.set(...);
   });
 }
 

code generation

This module does not provide code generation for DB mapping classes. To learn how to create QueryDSL mapping classes using Maven, please consult the QueryDSL documentation.

Since:

1.0.0.CR

Author:

sjackel

Field Summary

Fields inherited from class org.jooby.jdbc.Jdbc

DB_NAME, dbtype

Constructor Summary

Constructors

Constructor and Description
QueryDSL() Creates a new QueryDSL module
QueryDSL(String name) Creates a new QueryDSL module

Method Summary

Modifier and Type	Method and Description
void	configure(org.jooby.Env env, com.typesafe.config.Config conf, com.google.inject.Binder binder)
QueryDSL	with(com.querydsl.sql.SQLTemplates templates)

Methods inherited from class org.jooby.jdbc.Jdbc

callback, config, configure, doWith, doWith

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

QueryDSL

public QueryDSL(String name)

Creates a new QueryDSL module

Parameters:

name - Database name

QueryDSL

public QueryDSL()

Creates a new QueryDSL module

Method Detail

configure

public void configure(org.jooby.Env env,
                      com.typesafe.config.Config conf,
                      com.google.inject.Binder binder)

Specified by:

configure in interface org.jooby.Jooby.Module

Overrides:

configure in class Jdbc

with

public QueryDSL with(com.querydsl.sql.SQLTemplates templates)