[Dbix-class] ENUM values from MySQL using the column_info()

Matt S Trout dbix-class at trout.me.uk
Mon May 15 19:04:54 CEST 2006


Stephan Szabo wrote:
> On Mon, 15 May 2006, Matt S Trout wrote:
> 
>> Zbigniew Lukasiak wrote:
>>> Hi,
>>>
>>> The reason I was against to code even a bit more than some basic rules
>>> is that I wanted adding the new column info fields, and or other
>>> databases (not covered by the current two cases) to be simple so that
>>> people would continue the work.   Perhaps I should not fear the
>>> complexity so much or try to shift it to one place.  But still this
>>> whole issue is pretty idiosyncrastic and I would not consider
>>> case-insensitivity as a 'design error', but rather as a common ground
>>> for all the databases.
>> Some databases are case-sensitive. Somewhere, out there, somebody will
>> be stuck with a legacy schema that uses this fact in stupid and horrific
>> ways. I still want them to be able to use DBIx::Class, and I still want
>> them to be able to take advantage of columns_info_for and any code that
>> depends on it.
>>
>> Databases suck. Database designers suck. Legacy schemas suck. We get to
>> make them work anyway. Fun, isn't it? :)
>>
>>> Just for your information I tried quoting - but all I've got is:
>> You set quote_char but not name_sep.
> 
> Hmm, how should we handle the column name for something like create table
> test("a.b" varchar(5))? It's another bizarre case, but as long as we're
> talking about them...

Not in this thread we aren't. Number one, the subject line is even more 
wrong. Number two, this thread has fundamentally been utterly pointless 
and I want to see it die and zby go away and write some code so we have 
something to base a discussion on (and so I don't confuse the hell out 
of myself and everybody else trying to discuss in the abstract and 
failing). Number three, I'm running out of screen space for the thread 
depth :p

Interesting question though. Ask it again in a new thread please.



More information about the Dbix-class mailing list