You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@cayenne.apache.org by "Alexander Petrossian (PAF) (JIRA)" <ji...@apache.org> on 2018/11/12 18:09:00 UTC

[jira] [Created] (CAY-2495) Iterate thought all queries, apply template, get raw SQL

Alexander Petrossian (PAF) created CAY-2495:
-----------------------------------------------

             Summary: Iterate thought all queries, apply template, get raw SQL
                 Key: CAY-2495
                 URL: https://issues.apache.org/jira/browse/CAY-2495
             Project: Cayenne
          Issue Type: Task
          Components: Core Library
    Affects Versions: 3.1.2
            Reporter: Alexander Petrossian (PAF)


Friends, please share your vision.

I got a project with lots of Apache Cayenne mappings (2.0), and database is not documented at all.

All insights about links between tables (about 2 thousands of tables) I can get is only from queries found in Cayenne mappings (several megabytes of those).

Those tables I can quick analyse with JSQLParser. But it needs raw SQLs.

Question: Is there some easy way to programmatically iterate through all queries and apply templates to get those raw SQLs?

(Any hints would be very appreciated!)

 

[https://github.com/JSQLParser/JSqlParser/issues/710]

[https://sourceforge.net/p/jailer/feature-requests/52/]

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)