Re: Iterate thought all queries, apply template, get raw SQL

2018-11-13 Thread John Huss
On Tue, Nov 13, 2018 at 11:34 AM Alexander Petrossian (PAF) < alexander.petross...@gmail.com> wrote: > вт, 13 нояб. 2018 г. в 20:02, Giaccone, Tony >: > > > This is going to be a pretty big task, because of the number of tables no > > matter what you do. Is the problem that there are no foreign k

Re: Iterate thought all queries, apply template, get raw SQL

2018-11-13 Thread Alexander Petrossian (PAF)
вт, 13 нояб. 2018 г. в 20:02, Giaccone, Tony : > This is going to be a pretty big task, because of the number of tables no > matter what you do. Is the problem that there are no foreign key > relationships between your tables? > Yep. This is my primary problem. No doc/FK/relationships in cayenne

Re: Iterate thought all queries, apply template, get raw SQL

2018-11-13 Thread Alexander Petrossian (PAF)
John, this app was not created by me. And I don't have it's source codes. And these people didn't bother to declare FK or relationships in model. And I can't make app to do 100% of queries in mappings. Only few clicks here and there. But thanks for the logging hint! Alexander вт, 13 нояб. 2018

Re: Iterate thought all queries, apply template, get raw SQL

2018-11-13 Thread Giaccone, Tony
Alexander This is going to be a pretty big task, because of the number of tables no matter what you do. Is the problem that there are no foreign key relationships between your tables? If you have the mapping file, you can always open that map with the Cayenne Modeler. It with that you can genera

Re: Iterate thought all queries, apply template, get raw SQL

2018-11-13 Thread John Huss
I'm not really sure what you want. The DB should have foreign keys to define the related tables. Similarly, the Cayenne .map.xml file should have relationships defined between tables to indicate their relationships (via foreign keys). If you have unit tests, running those with SQL logging enable

Iterate thought all queries, apply template, get raw SQL

2018-11-13 Thread 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