Re: MySQL and Generate SQL, and inline bindings problems
Re: MySQL and Generate SQL, and inline bindings problems
- Subject: Re: MySQL and Generate SQL, and inline bindings problems
- From: David LeBer <email@hidden>
- Date: Thu, 9 Oct 2008 22:47:10 -0400
On 9-Oct-08, at 10:24 PM, Lachlan Deck wrote:
On 06/10/2008, at 4:23 PM, Guido Neitzer wrote:
On 05.10.2008, at 17:37, Thomas Worrall wrote:
When I go to do Generate SQL for my EOModel, it does not escape
the table or field names in backticks (`). Because of this, table
names like Order cause SQL errors.
The problem is, that the MySQL plugin doesn't support identifier
quoting. The plugin overall is quite rudimentary ... I guess none
of the "know suspects" in the Wonder team uses MySQL, so there is
not even a Wonder MySQL plugin. Probably because the one from Apple
mainly works as long as you deal with the shortcomings.
In googling, all I could find was a suggestion to name my tables
something else. I can do that, but it seems I shouldn't have to:
regardless of what words are reserved, putting them all in
backticks would solve the problem entirely. Why doesn't EO do that?
Because nobody in the community bothered creating a new plugin for
MySQL when there is an incredibly good and widely supported plugin
for PostgreSQL ... and for the cases when people have to or want to
use MySQL they use the provided one and live with it.
Yep, I've been living with it - or lumping it really. I started
having a look at porting the postgresql plugin a few weeks back but
got bored -- er distracted by work.
Anyone willing to collaborate on this?
I'd be interested in helping out.
You can probably build one yourself. It's not too hard, or file a
bug report with Apple, maybe they invest some time into that.
with regards,
--
Lachlan Deck
;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
twitter: http://twitter.com/rebeld
--
Toronto Area Cocoa / WebObjects developers group:
http://tacow.org
_______________________________________________
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