Re: how to find out column types?

[prev] [thread] [next] [Date index for 2004/12/23]

On Thu, 23 Dec 2004, sf@xxxxxx.xxx wrote:

Stephen Quinney wrote:
>>>If we need to change anything around to make it easier to plug this in,
>>>then I'm happy for that, but if there's a module on CPAN to do all the
>>>work already I'd rather just have an optional thin interface to that.
>>>
>>> something as simple as just having to do a 
>>>
>>>  use Class::DBI::Plugin::TableInfo;
>>>
>>>perhaps with some options if needed, would be ideal...
>> Is this not sort of what Class::DBI::Plugin::Type does? I've never
>> used it myself so I am not sure but I am aware Simon wrote this
>> module, they synopsis is: "Determine type information for columns". I
>> guess if it is someone could take over that module and extend it as
>> needed.
> 
> It seems to me very similar. I'm planning on releasing an updated 
> version next week. Patches, or feedback about what's wrong with 
> CDBI::Plugin::Type are welcome.

Nothing is wrong with it, only with me for not realizing it's out
there.  This will save me a lot of work.  Thanks everyone!!

As a requested feature, can you add the fields that the DBI
column_info tells you, specifically NULLABLE would be nice.  The
current Class::DBI::Plugin::Type perldoc implies we just get a single
piece of information (just the type) about the column.

Thanks!
Ted