| The jOOQ User Manual. Multiple Pages : SQL building : QueryParts : Pretty printing SQL | previous : next |
All versions: 3.11 | 3.10 | 3.9 | 3.8 | 3.7 | Development versions: 3.12 | Unsupported versions: 3.6 | 3.5 | 3.4 | 3.3 | 3.2 | 2.6
As mentioned in the previous chapter about SQL rendering, there are some elements in the org.jooq.RenderContext that are used for formatting / pretty-printing rendered SQL. In order to obtain pretty-printed SQL, just use the following custom settings:
// Create a factory that will render "formatted" SQL Factory pretty = new Factory(dialect, new Settings().withRenderFormatted(true));
And then, use the above factory to render pretty-printed SQL:
String sql = pretty.select(
AUTHOR.LAST_NAME, count().as("c"))
.from(BOOK)
.join(AUTHOR)
.on(BOOK.AUTHOR_ID.eq(AUTHOR.ID))
.where(BOOK.TITLE.ne("1984"))
.groupBy(AUTHOR.LAST_NAME)
.having(count().eq(2))
.getSQL();
select "TEST"."AUTHOR"."LAST_NAME", count(*) "c" from "TEST"."BOOK" join "TEST"."AUTHOR" on "TEST"."BOOK"."AUTHOR_ID" = "TEST"."AUTHOR"."ID" where "TEST"."BOOK"."TITLE" <> '1984' group by "TEST"."AUTHOR"."LAST_NAME" having count(*) = 2
The section about ExecuteListeners shows an example of how such pretty printing can be used to log readable SQL to the stdout.
