[Slashcode-development] Oracle Port Progress

[Stephen C. <the...@wa...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Yee-haw, as they say down south.  install-slashsite now survives without a
single error (using the slashcode theme, anyway).

The placeholder idea I described last week is in here as well, and works as
expected.  All the Slash::DB::MySQL code that hasn't been overridden for Oracle
continues to work, which makes the transition quite a bit easier.  Of course,
cleaning up the MySQL code with the newly-extended functions is still in the
works.  I need to actually fire things up with a MySQL server and make sure
nothing has broken horribly.  I might post a patch with just the
Slash::DB::Utility changes and see if I can get some QA on it.

The most annoying problem at the moment is dealing with the column names that
were altered due to Oracle reserved word conflicts.  I'm very tempted to try 
hacking this in Slash::DB::Utility (letting it surreptitiously alter the field
names passed to the SQL generator functions), because I'm having to override
entire subroutines (that would work otherwise) to change three letters.  Is it
at all possible to synchronize the column names between the different ports?  Or 
are we too far along at this point?  The changes were fairly minor (this ripped
from the notes at the top of my schema create script):

#       - *(uid) => user_id
#       - *(comment) => comment_text
#       - *(mode) => comment_mode
#       - comments(date) => comment_date
#       - pollquestions(date) => poll_date
#       - sessions(session) => session_id

OTOH, there's no guarantee that the next database deserving of a port won't have
conflicts as well, so it's probably a moot point.  I'll try to find some way of 
munging the field names transparently in the sql* functions.

This week I'll actually fire up Apache and see what falls apart -- most likely a
lot :)  Even so, I'm feeling rather triumphant at the moment.  You couldn't 
finish installing on Oracle a week ago :)

- -- 
Stephen Clouse <the...@wa...>
warpcore.org Founder, Chief Megalomaniac, and Evil Overlord

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQA/AwUBOtpEe91EXk7JbKbMEQKDOgCgiX27RLCINORa2w4l5ljyEU1tkGkAoKFL
WEi+ljbw/6rcVLS22atbKEOX
=s3Gq
-----END PGP SIGNATURE-----