Date index for Jan 2004
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [achievo] Oracle support for Achievo
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello,
Joop van de Wege wrote:
> I have been digging around in Achievo-1.0.1 to see if I can add Oracle
> support to it and I'm stuck at how it is supposed to be.
> Can somebody point me in the right direction for this?
To make the setup script work, a file called class.atkoci9ddl.inc must
be implemented. Currently, the database abstraction layer has these files:
class.atk*db.inc -> takes care of connections, commits, executing
queries, retrieving results
class.atk*query.inc -> takes care of generating vendor specific
sql insert, update, delete and select
statements
class.atk*ddl.inc -> takes care of generating vendor specific ddl
statements (create/alter/drop table etc)
Where '*' can be something like 'oci8', 'mysql', 'pgsql', 'oci9' etc.
All files are located in the atk/db subdirectory.
As you can see, the *query and *db classes are already implemented for
several versions of oracle.
What's missing is the ddl class. If this is implemented properly,
setup.php should be able to install oracle databases.
The other problem is 'hardcoded' queries in Achievo. There are some that
are generic enough to be usable in other environments than myqsl, others
may need some tweaking.
Greetings,
Ivo
- --
Ivo Jansch <ivo dot
http://www.oeli.org
PGP Key-id: 0x256AB35C
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE/9cHZ0a30MCVqs1wRAs+/AKCPRVQW+SWtMUYZC3nnjKsNL9Uz4QCfTgH+
pcoy60Dt6EAs92Is36aVeM8=
=jQXc
-----END PGP SIGNATURE-----