вт, 13 нояб. 2018 г. в 20:02, Giaccone, Tony <anthony.giacc...@nytimes.com>:
> 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 mappings. Guys only did hundreds of queries. > If you have the mapping file, you can always open that map with the Cayenne > Modeler. It with that you can generate all the SQL for all the schema, of > your database. You can even create a diagram of the database and the > relationships between the tables using the Cayenne Modeler. Can't do that. There are no relationships defined in mapping files ;) > If you have the java classes that the modeler creates, you can also start > looking in the java class files for the relationships between the objects. > If there were no relationships defined inside mapping files I feel there would be nothing defined in code? > Again a daunting task, but certainly possible. I'm sure you can find a > java tool, maybe class-visualizer, to document the relationships between > the objects. > I have no access to source code, but one can reverse .class files, I guess. Haven't tried that yet. Thanks for the pointer. > If you don't have a mapping file with classes, but and just have a huge map > with many sql statements in it, you could always pull them out of the map > directly. > Tony, as I've indicated, I can give SQL statements to analyser (part of jailer, done with JSQLParser project). But I have hard time fighting with SQL templates. Maybe there is some easy [ ;) ] way to ask Cayenne to explode all those templates for me? remove #result, solve all #chain and #chunk and do #ifs (all via true side) and anything else I forgot here. I need "some valid SQL" queries. Alexander > https://github.com/JSQLParser/JSqlParser/issues/710 > https://sourceforge.net/p/jailer/feature-requests/52/ > Tony > > On Tue, Nov 13, 2018 at 3:25 AM Alexander Petrossian (PAF) < > alexander.petross...@gmail.com> wrote: > > > 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/ > > > > -- > > PAF > > > > P.S. tried to discuss it here first: > > https://jira.apache.org/jira/browse/CAY-2495 > > > -- PAF
