[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