Re: Entity Modeler SQL Generation - differences between WO 5.3 and 5.4
Re: Entity Modeler SQL Generation - differences between WO 5.3 and 5.4
- Subject: Re: Entity Modeler SQL Generation - differences between WO 5.3 and 5.4
- From: David LeBer <email@hidden>
- Date: Tue, 15 Apr 2008 14:16:19 -0400
On 15-Apr-08, at 2:09 PM, J Stephanos wrote:
When I use Mike's WO53 -> WO54 script (See
http://lists.apple.com/archives/Webobjects-dev/2007/Oct/msg00357.html)
to switch between 5.3 and 5.4, here are the differences seen in
Entity Modeler when used to Generate SQL:
MySQL 5.0.51a
Eclipse 3.3.1.1
WOLips 5085
with WO 5.3
-------------------
CREATE TABLE Address ( address1 varchar(40), address2 varchar(40),
city varchar(30), zip char(10), identifier bigint NOT NULL,
retailStoreID bigint NOT NULL, state varchar(30) );
ALTER TABLE Address ADD PRIMARY KEY (identifier);
with WO 5.4
-------------------
CREATE TABLE Address ("address1" varchar(40), "address2" varchar(40),
"city" varchar(30), "zip" varchar(10), "identifier" bigint NOT NULL,
"retailStoreID" bigint NOT NULL, "state" varchar(30) );
ALTER TABLE Address ADD PRIMARY KEY (identifier);
ALTER TABLE Address ADD CONSTRAINT Address_retailStore_FK FOREIGN KEY
(retailStoreID) REFERENCES RetailStore (identifier);
5.4 adds quotes - fails to create the table in MySQL. Adds all the
FK constraints.
5.3 does not generate FK constraint.
Is there a workaround to generate sql correctly with 5.4.
There are known issues with SQL generation in 5.4 - they are
apparently resolved in the next release from Apple.
So, workaround 1: Wait for WO 5.4.next
Of course,
I could generate with 5.4 and remove quotes - is this advisable?
Workaround 2: This, or manually generate your SQL.
;david
--
David LeBer
Codeferous Software
'co-def-er-ous' adj. Literally 'code-bearing'
site: http://codeferous.com
blog: http://davidleber.net
profile: http://www.linkedin.com/in/davidleber
--
Toronto Area Cocoa / WebObjects developers group:
http://tacow.org
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
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