[rt-devel] DBI information

[Jesse]

On Wed, Apr 12, 2000 at 04:29:24PM -0700, Dylan Vanderhoof wrote:
> Hello All,
> 	I just started to take a look at the new rt files, and have some
> interesting issues that will need to be dealt with if we're going to port to
> Oracle/DB2/other enterprise DBs.  Looking at the schema.mysql file, it looks
> like we shouldn't have a problem making a similar file for the other DBs.
> MY question is, how abstract is the RT DBI code itself?  I was looking at
> the files in lib/rt/database, and while it's close to being able to work
> with these DBs, there is one real important thing missing off the bat.
> Schema.

Whoa! I think you're looking at RT 1.0's code. are you sure you've got the rightcode? For 2.0, everything lives under lib/RT. (You'll want to look at the DBIx
module in CVS as well, as that's hwere all the abstraction is.)

> 	MySQL doesn't require the schema to be in there (As a matter of
> fact, I think it all falles under a 'mysql.' schema) but the larger DBs do.
> Is that something that there is a planned workaround for, or will we need to
> re-write the lib files as well?
> 	The only other thing I can see, and I don't know how Oracle handles
> this, is that DB2 will puke if you attempt to call a CHAR or VARCHAR column
> without enclosing the values in 's.  Likewise, INT and similar numeric
> columns will puke if you DO enclose them with anything.  If I recall
> correctly, MySQL has no such restraints.  
> 	I'll keep searching through it and see what else I can see.
> 
> Cheers,
> Dylan C. Vanderhoof
> Internal Software Developer
> Semaphore Corporation
> 
> 
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
> 

-- 
jesse reed vincent -- jrvincent at wesleyan.edu -- jesse at fsck.com 
pgp keyprint:  50 41 9C 03 D0 BC BC C8 2C B9 77 26 6F E1 EB 91
--------------------------------------------------------------
There are no supercomputer applications that are solvable that cannot be solved
in finite time using a fucking TRS-80 with approprite disk/tape drives.  Zero.
									-Tanj