Using multiple databases: Difference between revisions
m Use Multiple Databases in ATK Applications moved to Using multiple databases |
No edit summary |
||
| Line 1: | Line 1: | ||
{{Howto|Advanced|Marlbil}} | |||
Posted on the [http://www.achievo.org/forum/viewtopic.php?t=3121&highlight=multiple+database forum] by user marlbil | Posted on the [http://www.achievo.org/forum/viewtopic.php?t=3121&highlight=multiple+database forum] by user marlbil | ||
Revision as of 22:27, 17 October 2007
|
ATK Howto: Using multiple databases
|
Posted on the forum by user marlbil
1. just add other database in config.inc.php like:
Quote:
$config_db["module1db"]["driver"] = "mysql"; $config_db["module1db"]["host"] = "localhost"; $config_db["module1db"]["db"] = ""; $config_db["module1db"]["user"] = ""; $config_db["module1db"]["password"] = "";
$config_db["module2db"]["driver"] = "mysql"; $config_db["module2db"]["host"] = "localhost"; $config_db["module2db"]["db"] = ""; $config_db["module2db"]["user"] = ""; $config_db["module2db"]["password"] = "";
...
2. then specify the db to use in your nodes:
Quote: $this->setTable("nodename","","module1db"])
3. and, if you use your node in other relations. just add the flag:
for many2one:
Quote: AF_MANYTOONE_LAZY
for one2one:
Quote:
AF_ONETOONE_LAZY
Note that some features (like column sort) in the admin page does not work. So, you may also add the flag:
for many2one and one2one:
Quote: AF_NO_SORT