cayenne-commits mailing list archives

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


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
( [] ). You will likely get more answers there.

> Iterate thought all queries, apply template, get raw SQL
> --------------------------------------------------------
>                 Key: CAY-2495
>                 URL:
>             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!)
> []
> []

This message was sent by Atlassian JIRA

View raw message