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
This archive was generated by hypermail 2.0.0 : Wed Apr 15 2009 - 08:24:51 EDT