Re: Generation of primary keys

2018-10-23 Thread Tony
Or given that the schema you generate depends on the data source your using make the datasource selection the first step. That feels like a more normal path. Tony Giaccone On Oct 23, 2018, at 8:58 AM, Andrus Adamchik wrote: >> I guess we can make "autodetect" a default in that dialog. > > H

Re: Generation of primary keys

2018-10-23 Thread Andrus Adamchik
The problem is that we can't generate that PK SQL that you are seeing in "autodetect" mode. Because it is different from DB to DB. So we either need an explicit DB selection or we need to connect to a real DB to do auto-detect before you see any SQL. A. > On Oct 23, 2018, at 4:51 PM, Tony wro

Re: Generation of primary keys

2018-10-23 Thread Tony
You could put a two choice radio button. Choice one autodetect. Choice two choose adaptor. Default to choice one. Enable drop down when choice two is selected. Tony Giaccone On Oct 23, 2018, at 8:58 AM, Andrus Adamchik wrote: >> I guess we can make "autodetect" a default in that dialog. > >

Re: Generation of primary keys

2018-10-23 Thread Andrus Adamchik
> I guess we can make "autodetect" a default in that dialog. Hmm.. we can't. As this dialog is shown before we even connect to DB. Andrus > On Oct 23, 2018, at 3:45 PM, Andrus Adamchik wrote: > > Yeah, you'd need to select the specific adapter right in the generation > dialog. > > I guess

Re: Generation of primary keys

2018-10-23 Thread Andrus Adamchik
Yeah, you'd need to select the specific adapter right in the generation dialog. I guess we can make "autodetect" a default in that dialog. Andrus > On Oct 23, 2018, at 2:22 PM, Tony Giaccone wrote: > > It might be useful for the Modeler to auto-detect as well because if you do > schema genera

Re: Generation of primary keys

2018-10-23 Thread Tony Giaccone
It might be useful for the Modeler to auto-detect as well because if you do schema generation, you end up with different sql from the modeler than the runtime. We started a dbdeploy process, and the sql generated was captured from the modeler with the JDBC plain adaptor for the auto_pk, but then i

Re: Generation of primary keys

2018-10-22 Thread Andrus Adamchik
If you don't set the adapter, Cayenne will auto-detect the DB type in runtime and install a proper adapter. Modeler doesn't do auto-detection, but the runtime does. In fact I don't remember when was the last time I had to specify an adapter explicitly. Andrus > On Oct 23, 2018, at 12:38 AM, T

Generation of primary keys

2018-10-22 Thread Tony Giaccone
I understand that the kind of PK support that Cayenne uses depends on the adaptor you use. When you use: org.apache.cayenne.dba.postgres.PostgresAdapter you get sequences, not the pk_auto table. I see where you can pick the adaptor as part of a database schema generation. What's less clear to me