I've got an Oracle version of phpESP ready for review.
Would I be able to check in the source code somewhere?
Hopefully, this will lead into further work on porting phpESP to PEARDB.
I noticed following obstacles in porting to Oracle:
Some of the SQL didn't translate directly from MySQL to Oracle due to:
- No corresponding functions like PASSWORD() and NOW() in Oracle, so I just
removed the functions from the Oracle version. NOW() was replaced with
'sysdate'.
- The MySQL bit manipulation did'nt transfer directly to Oracle so I translated
to use the Oracle bitand() function.
Where the Oracle calls have been abstracted out to the oracleInc.php routine -
it may be easier to use this to abstract to PEAR DB.
My sites use TWiki as the front end CGI script to present the web site. As
such, I had to write what's termed an Application Framework which is a PERL
routine that calls programs written in other languages - currently php, java or
PERL. For the programs, they need to function with the argv argument. I had
to therefore modify the phpESP to use command-line arguments. Though, I did
maintain the original phpESP call interface using HTTP_POST_VARS and
HTTP_GET_VARS - There's a flag in the phpESP.ini.php routine that can be used to
switch the Application Framework wrapper interface on and off. When off, phpESP
should work as a stand-alone application as originally designed, albeit now with
Oracle rather than MySQL.
I've included an /admin/docs/Oracle_install.txt file to show you how to move
from MySQL to Oracle. And in the /script/db/process_phpesp_tables.pl, there
the stuff to actually take a MySQL dump file and translate it to Oracle. This
PERL script translates the MySQL dump file into a bunch of .sql files that can
be used to create and populate the Oracle tables for this version of phpESP.
Couple of questions now.
Hopefully, this work I've done won't become obsolete. I've tried to make is a
simple process, by following the instructions in the Oracle_install.txt file on
how to move from MySQL to Oracle.
Is anyone still interested in porting this to PEAR DB?
Last time I tried to access the CVS repository, I got some access denied
errors. How would you suggest that I submit this Oracle version of phpESP?
I've a newbie to source-forge, so please have patience with me on this one.
Charlie :)
|
