[CDBI] tables with data_type column names

David Baird lists.riverside at gmail.com
Tue Sep 20 08:48:12 BST 2005


On 9/20/05, Paul Makepeace <digitalcraftsmen.net at paulm.com> wrote:
> I'm re-learning CDBI after quite an absence and have discovered a legacy
> system I'm working on has a table with 'data_type' as a column name,
> which clashes with an internal CDBI method.
> 
> The twist is that I'm trying to use the barely-documented
> Class::DBI::Loader.
> 
> http://search.cpan.org/dist/Class-DBI/lib/Class/DBI.pm#Changing_Your_Column_Accessor_Method_Names
> seems like it might've helped otherwise.
> 
> Anyone solved this? Not using ::Loader is an option if there's another
> similarly dynamic option.

I haven't used it yet, but SQL::Translator can generate CDBI classes
from a schema, and it can generate a schema from a DBI connection.
You'd probably have to modify the producer to capture the data_type
column and alter its accessor name. May or may not be easier to patch
CDBI::Loader.

d.




More information about the ClassDBI mailing list