Using DBI

[Bradley Baetz]

On Fri, Jan 17, 2003 at 11:01:19AM -0800, Jonathan Schatz wrote:

> does there exist the possibility of keeping the old *SQL functions
> working by changing them to use DBI? i didn't know this was coming, and
> you've magically added an extra week's worth of work to my current
> project. 

Yes; thats why Bugzilla still works :) The compat code is basically
identical to teh old code (Except I changed the fetchahead buffer to use
arrafrefs instead of arrays)

> i'd write this if there is any interest. i personally find DBI to be
> extremely ugly and generally write wrapper classes around it. in fact, i
> don't think i've ever (professionally) used DBI without some kind of
> abstraction level.

Well, we do have an abstraction layer of sorts - stuff like Bug.pm, for
example.

> 
> while i agree that the bugzilla sql subs were ugly, i'm seriously
> dreading a rewrite of the code i've got. is anyone else in this same
> situation?

I'm not suggesting rewriting existing code, although if someone wants to
do that that would be good. Over time, however, stuff will change.

[I do want to get rid of Push/PopGlobalSQLState though, but that only
affects a small handfull of functions]

Bradley