Apparently, my problem was simply that the property needs to be set at the last
migration run, rather than the next migration you intend to run. In my case,
it should have been "0" instead of 1.
My inner join didn't do anything, but that's a separate problem.
Andrew
On Jun 18, 2010, at 9:33 AM, webobjects-dev-requ...@lists.apple.com wrote:
> Date: Fri, 18 Jun 2010 09:31:59 -0400
> From: "Andrew R. Kinnie" <akin...@mac.com>
> Subject: Migrations help
> To: WebObjects-Dev List <webobjects-dev@lists.apple.com>
> Message-ID: <232c85f9-3a6f-40e1-9149-fddab132d...@mac.com>
> Content-Type: text/plain; charset="us-ascii"
>
> Greetings,
>
> I am now trying to learn and use migrations for the site I'm working on. The
> site is currently hosted on an Openbase db, and my dev machine has a MySQL
> db. I've managed to get it working on my MySQL db (and obviously it already
> works on the Operbase db). So on my dev machine, I have 2 configurations in
> the EOModel, one points to Openbase, and the other to MySQL. I want to use
> Migrations so that I can make changes to the datamodel on the production
> machine to add minor things like lookup tables instead of strings for states,
> countries, user types, etc. I added the new attributes and Entities to the
> model, and pointed them to column names that I intend the migrations to
> create for me (but which don't currently exist).
>
> What I have done so far is generate a base level model using the original
> EOModel from the version currently running on the production box. This is
> named "Playhouse0.java" (and the EOModel is Playhouse.eomodeled). I have
> created a Playhouse1.java which adds columns to the various tables needing
> foreign keys to the lookup tables. e.g.
>
> ERXMigrationTable userTable =
> database.existingTableNamed("USER");
> userTable.newIntegerColumn("user_type_id", true);
>
> I then create the new tables, e.g.:
>
> ERXMigrationTable UserTypeTable =
> database.newTableNamed("USER_TYPE");
> UserTypeTable.newIntegerColumn("_rowid", false);
> UserTypeTable.newLargeStringColumn("type_name", true);
> UserTypeTable.create();
> UserTypeTable.setPrimaryKey("_rowid");
>
> Then set the foreign key:
>
> userTable.addForeignKey("user_type_id", "USER_TYPE", "_rowid");
>
> Then I run an SQL script to create and types and try and point the old
> User.userType column to the appropriate row:
>
> insert into user_type(_rowid,type_name)
> values(1,'Admin'),(2,'Patron'),(3,'Chef');
>
> and
>
> UPDATE USER
> SET USER.USER_TYPE_ID = USER_TYPE._rowid
> FROM USER
> INNER JOIN USER_TYPE ON USER_TYPE.NAME = USER.USER_TYPE;
>
> etc. I then have another migration Playhouse2.java which was originally set
> to set the default values and set the columns to not allow null, and added
> the following lines to my properties file:
>
> # Migrations
> er.migration.migrateAtStartup=true
> er.migration.createTablesIfNecessary=true
> er.migration.modelNames=Playhouse
> Playhouse.MigrationClassPrefix=playhousecomedy.com.migrations.Playhouse
> Playhouse.InitialMigrationVersion=1
>
> When I ran it, initially I got an exception:
>
> "Your EOSynchronizationFactory does not support the required 'modify allows
> null' operation."
>
> So I commented those lines out (i.e. the ones setting to not allow null),
> which allowed the app to run. However, when I clicked the admin link to go
> to a D2W component, it crashed, because it could not find the new columns.
>
> Jun 18 09:02:28 PlayhouseComedy[9001] INFO er.transaction.adaptor.Exceptions
> - Database Exception occured: Unknown column 't0.user_type_Id' in 'field
> list'at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>
> I looked at the MySQL db and indeed, no additional columns or tables were
> created. This is my first attempt with Migrations, and I'm not an SQL guru,
> so I modeled that code on other code I saw, but it seems straight forward
> enough. I can only assume this means that I am missing a fundamental step.
>
> Thanks in advance
>
> Andrew
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
