Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-1633

[PATCH] add Migrations API for creating and updating DB schema

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 3.1B1
    • Fix Version/s: None
    • Component/s: Core Library
    • Labels:
    • Environment:
      Mac 10.6

      Description

      This patch adds classes to create an API for creating and updating DB schema over time by allowing the user to define Migrations that update the database from one version to the next. The API is designed to closely match the SQL syntax used to manipulate tables so it is very intuitive. The patch includes unit tests for most functionality, although more could still be done. There is also a code generator to generate the initial migration that will create the database for the first time using the information provided in the DataMaps. In the future this would be a great addition to CayenneModeler along with a generator to create a migration for delta changes to existing schemas.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              johnthuss John Huss
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Remaining Estimate - 24h
                24h
                Logged:
                Time Spent - Not Specified
                Not Specified