cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CAY-2495) Iterate thought all queries, apply template, get raw SQL
Date Tue, 13 Nov 2018 05:27:00 GMT

    [ 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)

Mime
View raw message