[
https://issues.apache.org/jira/browse/CAY-2495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16684738#comment-16684738
]
Andrus Adamchik commented on CAY-2495:
--------------------------------------
Relationships mapped in Cayenne model are usually helpful for an imperfect
schema comprehension. Also I don't think there's a direct answer to your
question, and trying to solve it (not necessarily in the way above) may require
some discussion. Instead of using Jira (which is mainly for bug/task tracking),
I would recommend to subscribe and send a message to Cayenne user list (
[https://cayenne.apache.org/mailing-lists.html] ). You will likely get more
answers there.
> 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)
