and you are using the MYSQL plugin from WO 5.4 as Pascal is suggesting?
On Jun 24, 2014, at 4:21 PM, Ray Kiddy <r...@ganymede.org> wrote:
> On Tue, 24 Jun 2014 16:17:51 -0400
> Theodore Petrosky <tedp...@yahoo.com> 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 <r...@ganymede.org> 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 (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com
>
> This email sent to tedp...@yahoo.com
_______________________________________________
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:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
