Re: basic use of migrations with MySQL...
Re: basic use of migrations with MySQL...
- Subject: Re: basic use of migrations with MySQL...
- From: Ray Kiddy <email@hidden>
- Date: Tue, 24 Jun 2014 13:37:23 -0700
On Tue, 24 Jun 2014 16:29:01 -0400
Theodore Petrosky <email@hidden> wrote:
> and you are using the MYSQL plugin from WO 5.4 as Pascal is
> suggesting?
Well, of course I had. Duh!
And then ... I have just double-checked. I had put the framework into
the build path, but not high enough up to over-ride the non-working
functionality. Urf!
Well, I am still going to add a document to the wocommunity site which
is just about Migrations.
I bet the Wonder migrations code can check, if it is using a MySQL
plugin, that the class it is using is the correct version. At the very
least, this would make for a better error message. There should be a
way to stop people from stubbing their toe on this.
- ray
>
> On Jun 24, 2014, at 4:21 PM, Ray Kiddy <email@hidden> wrote:
>
> > On Tue, 24 Jun 2014 16:17:51 -0400
> > Theodore Petrosky <email@hidden> wrote:
> >
> >> Ray,
> >>
> >> If I understand, (It always seems that I don’t understand the
> >> question), you want to alter a table through migrations. I have
> >> always done it like this.
> >>
> >>
> >> ERXMigrationTable theTable =
> >> database.existingTableNamed(“theTableIWantToAlter");
> >>
> >> theTable.existingColumnNamed(“theColumnName").setAllowsNull(false);
> >>
> >> Is this what you are looking for?
> >>
> >> Ted
> >
> > This code:
> >
> > ERXMigrationTable skuTable =
> > database.existingTableNamed("product_skus");
> > skuTable.newStringColumn("tag", 63, true);
> >
> > Generates this SQL:
> >
> > alter table skus null column tag varchar(63);
> >
> > - ray
> >
> >> On Jun 24, 2014, at 3:59 PM, Ray Kiddy <email@hidden> wrote:
> >>
> >>>
> >>> I should have been using migrations for a long time, but I have
> >>> not. I have just never had the time to add another thing that
> >>> might break. But you know. But I thought I knew the theory of it.
> >>>
> >>> So, the only place I am seeing basic documentation on the
> >>> wocommunity site is in the page on creating an ERRest application.
> >>> Is this right? Did I miss something? I know there have been WOWODC
> >>> presentations, but that is not completely a replacement for a
> >>> simple how-to document.
> >>>
> >>> But starting out, migrations seemed pretty easy to use. Ok,
> >>> setting the encoding of the tables to latin1 instead of utf-8 was
> >>> not amazingly helpful, but I can deal.
> >>>
> >>> But then I tried my first table change, as opposed to a create.
> >>>
> >>> alter table foo_table null column1 column2 varchar(10);
> >>>
> >>> Hm. Not helpful. I guess falling back to reasonable defaults is
> >>> not what happens here. I tried adding things to my classpath,
> >>> such as the Wonder MySQL plugin framework. No difference.
> >>>
> >>> So, I now use my migration java sources as a convenient place for
> >>> the comments which give me the SQL I have to execute manually to
> >>> make this work. This is probably not the best use of this feature,
> >>> though.
> >>>
> >>> Any obvious things I am missing before I try to debug this and,
> >>> perhaps, put some basic documentation on the site?
> >>>
> >>> thanx - ray
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden