Are you planning to test the generated sql for style? Do wish to trap the generated queries and then see if they can be improved (in performance, not appearance)?

Typically your test code would run the production code (which generates and execute queries) supplying specific parameters with known/expected results. Compare the test's results to the expected.


On 08/24/2017 04:02 PM, Mohan wrote:
Hi,

I am using JOOQ to generate the SQL. These SQL statements which are getting generated are very complex.

I need help/suggestions how to write JUnits to test against a SQL file.

Issues I am running into are below

  * Line Seperator of CRLF vs LF. Seems JOOQ generates in a different
    way.
  * While using the conditon dsl it is adding extra () like
    /(designation = 'MANAGER')/

/
/

Regards,
Mohan
--
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 [email protected] <mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.

--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to