Andrus, We have a cayenne data model that we use in our app. We use Postgres as the application DB in production and H2 for testing. To create the database in production, we use DB Deploy. We've captured the SQL that the modeler generated and used that as part of the process. Through the process of doing this it's become clear there are somethings it would be nice to have in Cayenne.
1) Capture generated SQL to a text file. This would make the process slightly more efficient. Easier then a copy paste edit to a text file. 2) There are constraints that we use, that it would be nice to have in the model. So that these constraints could be applied in H2 when the test database is spun up. I could see this as just a set of place holder SQL statements that are executed after the tables and sequences are generated. This could also include things like index creation. We've had test cases pass in dev because the constraints we needed hadn't been applied to the H2 database. I realize that you're a volunteer organization, and that the best way to get this done would be to do it myself. :-) Still I thought I'd make the suggestion just to see what you think. Tony
