Re: Getting columns in DB order

[prev] [thread] [next] [Date index for 2005/06/14]

--On June 14, 2005 1:06:46 PM -0400 Sam Tregar <sam@xxxxxx.xxx> wrote:

> Hello all.  I'm using Class::DBI::mysql to automatically create
> Class::DBI classes for my tables.  Now I'm working on writing routines
> to output my objects into CSV files and I'm having trouble getting the
> column ordering right.  Here's what I'm doing:

<pragmatic>
If you need your CDBI module to track the order of columns in the table so 
that it stays in sync with outside tools, it may be easiest to use set_sql 
and a parse the result of DESCRIBE, much like C:D:Mysql's set_up_table() 
does.  In fact, if you know you're going to need the information and want 
to keep it around, just override set_up_table() in you base class and store 
the order of columns as class metadata or in a package variable.
</pragmatic>

--
Regards,
Charles Bailey  < bailey _at_ newman _dot_ upenn _dot_ edu >
Newman Center at the University of Pennsylvania