Multiple Databases Example
This project demonstrates how query data in related tables that live in different databases. CakePHP makes it easy using the model's 'useDbConfig' variable as well as a method to change table prefixes on the fly in the controller. Please view the tutorial for a more detailed explanation.
The below links represent tables, all of which live in different databases set up as follows:
- DB1 contains table 'cars'
- DB2 contains table 'dealers'
- DB2 contains table 'dealers_salesmen'
- DB3 contains table 'salesmen'
The relationships are setup as follows:
- Cars belongTo Dealers
- Dealers hasMany Cars
- Dealers hasAndBelongsToMany Salesmen
- Salesmen hasAndBelongsToMany Dealers
In plain english, specific cars are sold at specific dealers. Dealers sell more than one type of car. Dealers have multiple salesmen. Salesmen work at multiple dealers.
The following links present basic find->all queries against these relationships.
