On 15/04/2009, at 9:28 PM, Tore Halset wrote:
What about multi-column information? I want to store information
about db indexes that have a name, can span multiple columns and be
of different types. I know this is probably out of scope for cayenne
as a ORM, but very useful for us since we already store all other
schema-related information in the model.
If we go with a generic property map with string values, such
information could be encoded into the String, but it will not be
very pretty..
dbEntity.setProperty("DB-INDEX", "name: myindex, type: unique,
columns: col1, col2");
In my opinion indexes are a very useful thing to store in the model,
can tie into reverse engineering, be part of a database migration and
might even be used by Cayenne to produce warnings that unindexed
columns are being used for a query. I think they should be stored as
their own first class items in the map and not as a generic string key-
value.
Hey, there's a GSoC project... modify Cayenne modeler to store these
indexes.
Ari Maniatis
-------------------------->
ish
http://www.ish.com.au
Level 1, 30 Wilson Street Newtown 2042 Australia
phone +61 2 9550 5001 fax +61 2 9550 4001
GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
