Qualifiers on objects to identify class

2020-01-30 Thread Giaccone, Tony
Andrus, et al... I have an accountType enum, which has one of three values. I want two values to generate one type of class, and 1 value to identify a different class in the entity class panel of the modeler accountTypeStr = ("A" or "B") for example, however, the modeler doesn't like that on

Re: Spinning up Cayenne for unit test

2019-01-09 Thread Giaccone, Tony
Andrus, Perfect that worked like a charm, only one small change, addModule, not module. Tony On Wed, Jan 9, 2019 at 10:58 AM Andrus Adamchik wrote: > You may do something like this: > > ServerRuntime.builder() >.module(b -> > b.bind(SchemaUpdateStrategyFactory.class).toInstance(descriptor

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: Partitioning a query result..

2016-12-16 Thread Giaccone, Tony
about new records since the last run? > * On a single instance, do you have an idea of "the main query time" vs > "processing time + any extra queries and commits"? > > Andrus > > > > On Dec 16, 2016, at 8:50 PM, Giaccone, Tony < > anthony.gi

Re: Partitioning a query result..

2016-12-16 Thread Giaccone, Tony
Right so I agree with the partitioning of the database, that's a thing that can be done. Andrus, I'm a bit less confident in the proposal you're suggesting. I want to be able to spin up new instances potentially in new containers and run them in different environments. If we're moving to a cloud b

Re: Reverse engineering and dates

2016-06-27 Thread Giaccone, Tony
Yes, I think that's fine. It's specific to the project. On Sun, Jun 26, 2016 at 4:56 PM, Andrus Adamchik wrote: > > Fair enough. We do need to provide reverse engineering settings. I think > those may be implemented as the properties of the DataMap, like default > package, etc. > > Andrus > > >

Re: LinkETL - soliciting naming ideas

2015-06-12 Thread Giaccone, Tony
I don't think that ETL is strictly devoted to data warehouse. We use ETL transforms from and to our database to drive other processes including external vendors. So ETL in our case is far removed from the warehouse. Now, I will admit that data warehouse functions do an awful lot of ETL but the need