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

Johnny Morano jmorano at moretrix.com
Thu May 11 11:23:09 CEST 2006


Hey All,

A couple of days ago, I found a link on the Internet (sorry, can't find
it anymore, I've forgotten my google search query ;) ) which was talking
about a patch, which would add extra information to the column_info (in
DBIx::Class::ResultSource).

Amongst others, it would create a $info->{'data_set'} field (if $info =
$resultsource->column_info($column) ) which would contain, in the case
of an ENUM type, the values of that ENUM field. I mean: the possible
values of that field. Which is also viewable if you do a plain
describe/explain (in mysql) in a sql query...

Will functionality like this be added to that method (column_info) or
was the patch rejected, ... ?

I think (but who am i) this information is quite relevant, especially
when creating constraints, automatically creating html widgets from the
database (I'm very lazy), error handling, ... but I could also be very
wrong ;)

If this has been asked before, just say "look into the archive for
month/year" ;-)

Thanx!
Johnny





More information about the Dbix-class mailing list