Parse unknown functions support in jOOQ CLI

[grey parrot]

Hi, All

 

Does jOOQ CLI support "Parse unknown functions" in https://www.jooq.org/translate/ ?

CLI throws exception when there are custom functions in sql.

Thanks,

Cinyoung

[Lukas Eder]

Hello,

Have you tried running the CLI with the --help parameter? It prints:

Usage:
  -f / --formatted                                                    Format output SQL
  -h / --help                                                         Display this help
  -k / --keyword                                  <RenderKeywordCase> Specify the output keyword case (org.jooq.conf.RenderKeywordCase)
  -i / --identifier                               <RenderNameCase>    Specify the output identifier case (org.jooq.conf.RenderNameCase)
  -Q / --quoted                                   <RenderQuotedNames> Specify the output identifier quoting (org.jooq.conf.RenderQuotedNames)
  -F / --from-dialect                             <SQLDialect>        Specify the input dialect (org.jooq.SQLDialect)
  -T / --to-dialect                               <SQLDialect>        Specify the output dialect (org.jooq.SQLDialect)
  -S / --schema                                   <String>            Specify the input SQL schema
  -s / --sql                                      <String>            Specify the input SQL string

Additional flags:
  --parse-date-format                             <String>
  --parse-locale                                  <Locale>
  --parse-name-case                               <ParseNameCase>
  --parse-named-param-prefix                      <String>
  --parse-retain-comments-between-queries
  --parse-set-commands
  --parse-timestamp-format                        <String>
  --parse-unknown-functions                       <ParseUnknownFunctions>
  --parse-unsupported-syntax                      <ParseUnsupportedSyntax>
  --render-optional-inner-keyword                 <RenderOptionalKeyword>
  --render-optional-outer-keyword                 <RenderOptionalKeyword>
  --render-optional-as-keyword-for-field-aliases  <RenderOptionalKeyword>
  --render-optional-as-keyword-for-table-aliases  <RenderOptionalKeyword>

Commercial distribution only features:
  --render-coalesce-to-empty-string-in-concat
  --transform-patterns
  --transform-ansi-join-to-table-lists
  --transform-qualify                             <Transformation>
  --transform-rownum                              <Transformation>
  --transform-group-by-column-index               <Transformation>
  --transform-inline-cte                          <Transformation>
  --transform-table-lists-to-ansi-join
  --transform-unneeded-arithmetic                 <TransformUnneededArithmeticExpressions>

  -I / --interactive                                               Start interactive mode

I realise the manual seems to be outdated

Thanks,

Lukas

--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/577218fb-b7cb-4fad-8174-16d8226604a6n%40googlegroups.com.

[Lukas Eder]

I have fixed the manual problem for jOOQ versions 3.16, 3.17, 3.18:

https://github.com/jOOQ/jOOQ/issues/14528

The manual will be updated within the next hours.