cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <>
Subject [jira] Created: (CAY-1193) Auto load schema on startup
Date Thu, 12 Mar 2009 13:34:17 GMT
Auto load schema on startup

                 Key: CAY-1193
             Project: Cayenne
          Issue Type: New Feature
          Components: Cayenne Core Library, CayenneModeler GUI
    Affects Versions: 3.0M5
            Reporter: Andrus Adamchik
            Assignee: Andrus Adamchik

This feature would allow Cayenne to bootstrap the DB schema on startup if needed. I can see
the following options for schema update:

1. Skip schema update. This is the current behavior.
2. Create if no existing tables are found. This is the most reliable but less powerful option.
It will skip schema creation if at least on eof the tables modeled in Cayenne already exist
in DB. No exceptions will be thrown (maybe just an INFO log message). This will use DbGenerator.
3. Throw if partial schema detected. This will check for schema changes compared to the model
and throw an exception if differences are found in the tables mapped in the DataMap (i.e.
if there are more tables than mapped in Cayenne, it will NOT throw). This will use the merge

(I wonder if "4. Attempt to merge schema changes" makes any sense at all)

This will have a modeler component - a dropdown at the DataNode level listing schema generation
strategies. It will be saved in the XML as "schema-update-strategy" attribute for the "node"

Runtime component will consist of strategy instantiation, and an intercept of DB operations
run through the DataNode, passing it to an appropriate strategy. Still undecided whether the
strategy should be a DataNode attribute or a DbAdapter attribute (prolly DataNode).

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message