[Dbix-class] DBIx::Class 0.08009 for testing

Marc Mims marc at questright.com
Tue Jan 22 15:18:30 GMT 2008


* Matt S Trout <dbix-class at trout.me.uk> [080122 04:00]:
> On Mon, Jan 21, 2008 at 10:49:43AM -0800, Marc Mims wrote:
> > * Michael Higgins <linux at evolone.org> [080121 10:40]:
> > > On Sun, 20 Jan 2008 13:44:50 +0000 (GMT)
> > > Jess Robinson <castaway at desert-island.me.uk> wrote:
> > > 
> > > > 
> > > > http://desert-island.me.uk:8888/perldists/DBIx-Class-0.08009.tar.gz
> > > > 
> > > > Changes:
> > > >          - Added Storage::DBI subclass for MSSQL over ODBC.
> > > > 
> > > > Please poke this tarball some, so we can put it on CPAN!
> > > 
> > > Doing my best to be helpful here.
> > > 
> > > There was another addition to this (mentioned above) that I assumed
> > > would be added in this next release, so I guess I should jump in.
> > > 
> > > This:
> > > 
> > > sub build_datetime_parser {
> > >   my $self = shift;
> > >   my $type = "DateTime::Format::Strptime";
> > >   eval "use ${type}";
> > >   $self->throw_exception("Couldn't load ${type}: $@") if $@; 
> > >   return $type->new( pattern => '%Y-%m-%d %T' );
> > > }
> > > 
> > > ... is missing. (Perhaps Marc Mims is the one to contact, as he added
> > > the module, but hasn't, it would seem, committed this other key piece.)
> > 
> > Hi, Michael.
> > 
> > I'm trying to find time to finish work on the DateTime issue.  I know
> > the build_datetime_parser you quoted above is working for you, but I'm
> > not sure it's sufficient for all cases.  I believe it needs to handled
> > dates as well, not just timestamps.
> > 
> > I've done a bit of research and it seems the timestamp format you get
> > from MSSQL through ODBC may be a standard ODBC format, not an MSSQL
> > format.  I see a similar format, differing only in number of digits in
> > the fractional seconds, for DB2 over ODBC.  That leads me to believe
> > that build_datetime_parser might be best in ::DBI::ODBC with both
> > ::DBI::ODBC::DB2_400_SQL and ::DBI::ODBC::MSSQL derived from it.
> 
> Ok, I need you to ask yourself three questions:
> 
> (1) Is this broken now?
> (2) Will committing what you have so far be less broken?
> (3) If you do, will there be anything that appears to work that will change
> behaviour in a surprising fashion when you commit the complete version?
> 
> If your answers are yes, yes, and no, commit it and document that it's only
> a partial solution. Better half-works than not at all provided it won't cause
> an impediment to getting to "works 100%".

Yes. Yes. No. Committed with an appropriate note in the documentation.

Fear of commitment?  (Don't tell my spouse!)

	-Marc



More information about the DBIx-Class mailing list