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

[Alexander Petrossian (PAF) (JIRA)]

[ 
https://issues.apache.org/jira/browse/CAY-2495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16684864#comment-16684864
 ] 

Alexander Petrossian (PAF) commented on CAY-2495:
-

Andrus, thanks.

Cross-linking:

https://lists.apache.org/thread.html/b5a4f2037cd6d0a87b860b369bd6e5b6ad80700cbe120e7d84801dd9@%3Cuser.cayenne.apache.org%3E

> 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)
>Priority: Major
>
> 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)

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

[Alexander Petrossian (PAF) (JIRA)]

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)