Le 2011-11-04 à 15:35, James Cicenia a écrit :
> Hmm, how could that be?
Because the built-in MySQL plugin coming with WO is broken, you have to use the
one in Wonder, and to do that, you need to add MySQLPlugIn in your class path,
or else it will use the built-in plugin.
> It actually added some tables before it choked.
>
> James
>
>
>
> On Nov 4, 2011, at 2:30 PM, Chuck Hill wrote:
>
>> DB plugin not added to project.
>>
>>
>> On 2011-11-04, at 12:15 PM, James Cicenia wrote:
>>
>>> Hello -
>>>
>>> I am developing another D2WApp and using Migrations from the very start.
>>>
>>> However, when I first start my application I get this error:
>>>
>>> Executing alter table ERAttachment null available VARCHAR(5) NOT NULL
>>>
>>> I am using ERAttachment and here is my migration file:
>>>
>>> Anything seem obvious?
>>>
>>> James
>>>
>>>
>>> ==============
>>> package com.jimijon.mwf.migrations;
>>>
>>>
>>> import com.webobjects.eocontrol.EOEditingContext;
>>> import com.webobjects.foundation.NSArray;
>>>
>>> import er.extensions.jdbc.ERXSQLHelper.ColumnIndex;
>>> import er.extensions.migration.ERXMigrationDatabase;
>>> import er.extensions.migration.ERXMigrationIndex;
>>> import er.extensions.migration.ERXMigrationTable;
>>> import er.extensions.migration.ERXModelVersion;
>>>
>>> public class MidwestFoodsModel0 extends ERXMigrationDatabase.Migration {
>>> @Override
>>> public NSArray<ERXModelVersion> modelDependencies() {
>>> return null;
>>> }
>>>
>>> @Override
>>> public void downgrade(EOEditingContext editingContext,
>>> ERXMigrationDatabase database) throws Throwable {
>>> // DO NOTHING
>>> }
>>>
>>> @Override
>>> public void upgrade(EOEditingContext editingContext,
>>> ERXMigrationDatabase database) throws Throwable {
>>> ERXMigrationTable foodFamilyTable =
>>> database.newTableNamed("food_family");
>>> foodFamilyTable.newTimestampColumn("add_date", true);
>>> foodFamilyTable.newIntegerColumn("id", false);
>>> foodFamilyTable.newIntegerColumn("main_image_erattachment_id",
>>> true);
>>> foodFamilyTable.newTimestampColumn("mod_date", true);
>>> foodFamilyTable.newStringColumn("name", 255, false);
>>> foodFamilyTable.newIntegerColumn("thumbnail_erattachment_id",
>>> true);
>>> foodFamilyTable.create();
>>> foodFamilyTable.setPrimaryKey("id");
>>>
>>> ERXMigrationTable foodItemTable =
>>> database.newTableNamed("food_item");
>>> foodItemTable.newTimestampColumn("add_date", true);
>>> foodItemTable.newStringColumn("availability_status", 50, true);
>>> foodItemTable.newStringColumn("food_family", 100, true);
>>> foodItemTable.newStringColumn("fruit_or_vegetable_type", 100,
>>> true);
>>> foodItemTable.newIntegerColumn("id", false);
>>> foodItemTable.newIntegerColumn("main_image_erattachment_id",
>>> true);
>>> foodItemTable.newTimestampColumn("mod_date", true);
>>> foodItemTable.newStringColumn("name", 100, false);
>>> foodItemTable.newBigDecimalColumn("price", 38, 4, true);
>>> foodItemTable.newStringColumn("price_status", 50, false);
>>> foodItemTable.newStringColumn("quality_status", 50, false);
>>> foodItemTable.newBooleanColumn("seasonal_second_half_sep",
>>> true);
>>> foodItemTable.newStringColumn("sku", 50, true);
>>> foodItemTable.newIntegerColumn("thumbnail_erattachment_id",
>>> true);
>>> foodItemTable.create();
>>> foodItemTable.setPrimaryKey("id");
>>>
>>> ERXMigrationTable newsItemTable =
>>> database.newTableNamed("news_item");
>>> newsItemTable.newTimestampColumn("add_date", true);
>>> newsItemTable.newDateColumn("entryDate", false);
>>> newsItemTable.newIntegerColumn("food_family_id", false);
>>> newsItemTable.newIntegerColumn("food_item_id", true);
>>> newsItemTable.newIntegerColumn("id", false);
>>> newsItemTable.newTimestampColumn("mod_date", true);
>>> newsItemTable.newStringColumn("name", 255, false);
>>> newsItemTable.create();
>>> newsItemTable.setPrimaryKey("id");
>>>
>>> foodFamilyTable.addForeignKey("main_image_erattachment_id",
>>> "ERAttachment", "id");
>>> foodFamilyTable.addForeignKey("thumbnail_erattachment_id",
>>> "ERAttachment", "id");
>>> foodItemTable.addForeignKey("main_image_erattachment_id",
>>> "ERAttachment", "id");
>>> foodItemTable.addForeignKey("thumbnail_erattachment_id",
>>> "ERAttachment", "id");
>>> newsItemTable.addForeignKey("food_family_id", "food_family",
>>> "id");
>>> newsItemTable.addForeignKey("food_item_id", "food_item", "id");
>>> }
>>> }
>>>
>>> _______________________________________________
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list ([email protected])
>>> Help/Unsubscribe/Update your Subscription:
>>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
>>>
>>> This email sent to [email protected]
>>
>> --
>> Chuck Hill Senior Consultant / VP Development
>>
>> Practical WebObjects - for developers who want to increase their overall
>> knowledge of WebObjects or who are trying to solve specific problems.
>> http://www.global-village.net/products/practical_webobjects
>>
>>
>>
>>
>>
>>
>>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list ([email protected])
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca
>
> This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
