| Re: Firebird support [message #787 is a reply to message #786] |
Wed, 25 April 2007 04:57   |
AJM
Messages: 2347
Registered: April 2006
Location: Surrey, UK
|
Senior Member |
|
|
The first thing to need to do is to create a dml.firebird.class.inc file so that you can call the APIs which communicate with that DBMS. Leave interrogation of the INFORMATION_SCHEMA (used used by the data dictionary 'import' functions) till later.
The second step is to take the existing schemas for the MENU, AUDIT, WORKFLOW and DICTIONARY databases, modify them as necessary, then load them into firebird. You may also want to do this with the prototype subsystems as well.
The third step is to load all the data (from the xxx-data.sql files) into the relevant databases.
The fourth step is to change your CONFIG.INI file so that GLOBALS['dbms'] has the value 'firebird'. It is IMPORTANT that this value matces EXACTLY what appears between 'dml.' and '.classes' in the file you created with the first step.
Having done that you should be able to logon to radicore so that you can check that it handles all SELECTs, INSERTs, UPDATEs and DELETEs correctly. It does not matter that at this point you will be using <table>.dict.inc files which were created from a different DBMS.
When this has been done the last step is to modify the various ddl_???() methods in your new database driver so that the dictionary import functions will work.
If you have any more questions please let me know.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
