Re: Application setup where each customer has own database
Hello,
Just to let you know that I got this setup working.. Thank you very
very much for the help.
I'll write up some article about the setup as I think it can help
somebody other some day.
Thanks!
On May 18, 6:44 am, Dr. Loboto drlob...@gmail.com wrote:
How do you define a link between Models that are not in the same
database? Will Cake check the useDbConfig from the employee
model automatically?
Ordinal association. Cake will load associated model and get all
necessary info from it.
how can I make it work with urls like:
www.domain.com/company1/controller/action
www.domain.com/company2/controller/action
Read about routing again and test it yourself. Looks like something
like this may help you:
Router::connect(
'/:company/:controller/:action/*', // company name, then
controller
name, then action name, then any params
array (), // nothing to specify - controller and action already
pointed
array ('company' = 'a-zA-Z0-9') // regexp for company name check
(also can be omitted, I think)
);
But it may also require explicit map non company-specific URLs before
this rule. Also there can be problems... And will be definitely...
Search this group for named params and prefix routing (_after_ you
check how it works yourself).
On May 15, 11:18 pm,dozedoze...@gmail.com wrote:
Thanks a lot for the answer! That kind of database selection is indeed
perfect for me and much simpler.. don't have to do any custom db
drivers. Thanks again!
I have couple questions though, as this is the first time I'm using
CakePHP and don't know much about it yet.
1. Can I link tables between database configs?
Yes, but Cake will always run separate queries, no any joins.
How do you define a link between Models that are not in the same
database? I know that with useDbConfig I can tell CakePHP that which
database to use for the model, but when I'm creating a link from users
to employees table for example, how can I tell CakePHP that the
employees table is in the other database? Or do I need to tell that
even? Will Cake check the useDbConfig from the employee model
automatically?
E.g. would this simply work:
class User extends AppModel {
var $useDbConfig = 'commondb';
var $name = 'User';
var $hasOne = 'Employee';
}
class Employee extends AppModel {
var $useDbConfig = 'companydb';
var $name = 'Employee';
}
// get employee object from the user object
$employee = $user-Employee;
Then to another question...
You can determine and save database name by something like this (I
assume that routing with param 'company' is used):
I tried to read about the routing in CakePHP, but I didn't quite get
it.. so how can I make it work with urls like:
www.domain.com/company1/controller/actionwww.domain.com/company2/cont...
and take that first part of the url out to save as db name (with
Configure::write like you pointed out) and then use the rest of the
url to navigate normally to the controller / action. I could do it in
the app/webroot/index.php before the $url parameter is passed to the
dispatcher, but I'm guessing that would be the wrong way to do it. Can
I do it with the routing somehow?
These might be quite trivial things for more advanced CakePHP users,
but for me as a newbie, I haven't quite grasped the idea yet..
I'm definitely going to do some write up of the whole setup.
On May 15, 5:44 am, Dr. Loboto drlob...@gmail.com wrote:
1. Can I link tables between database configs?
Yes, but Cake will always run separate queries, no any joins.
2. How to automate the database table selection?
Method on link you provided looks too complex for your situation. If
each company have own databases with completely same structure, the
only thing you need to do for company specific models is to select
appropriate DB config.
You can determine and save database name by something like this (I
assume that routing with param 'company' is used):
class AppController extends Controller {
function constructClasses() {
// Save company name when we already know it but before
models are
created
Configure::write(
'companyDB',
!empty($this-params['company']) ?
$this-params['company'] : false
);
parent::constructClasses();
}
}
Mark all company-specific models like this:
class CompanyProfile extends AppModel {
var $specific = true;
}
And have such AppModel:
class AppModel extends Model {
var $specific = false;
function __construct($id = false, $table = null, $ds = null) {
if ($this-specific) {
// Get saved company/database name
$dbName =
Re: Application setup where each customer has own database
How do you define a link between Models that are not in the same
database? Will Cake check the useDbConfig from the employee
model automatically?
Ordinal association. Cake will load associated model and get all
necessary info from it.
how can I make it work with urls like:
www.domain.com/company1/controller/action
www.domain.com/company2/controller/action
Read about routing again and test it yourself. Looks like something
like this may help you:
Router::connect(
'/:company/:controller/:action/*', // company name, then controller
name, then action name, then any params
array (), // nothing to specify - controller and action already
pointed
array ('company' = 'a-zA-Z0-9')// regexp for company name check
(also can be omitted, I think)
);
But it may also require explicit map non company-specific URLs before
this rule. Also there can be problems... And will be definitely...
Search this group for named params and prefix routing (_after_ you
check how it works yourself).
On May 15, 11:18 pm, doze doze...@gmail.com wrote:
Thanks a lot for the answer! That kind of database selection is indeed
perfect for me and much simpler.. don't have to do any custom db
drivers. Thanks again!
I have couple questions though, as this is the first time I'm using
CakePHP and don't know much about it yet.
1. Can I link tables between database configs?
Yes, but Cake will always run separate queries, no any joins.
How do you define a link between Models that are not in the same
database? I know that with useDbConfig I can tell CakePHP that which
database to use for the model, but when I'm creating a link from users
to employees table for example, how can I tell CakePHP that the
employees table is in the other database? Or do I need to tell that
even? Will Cake check the useDbConfig from the employee model
automatically?
E.g. would this simply work:
class User extends AppModel {
var $useDbConfig = 'commondb';
var $name = 'User';
var $hasOne = 'Employee';
}
class Employee extends AppModel {
var $useDbConfig = 'companydb';
var $name = 'Employee';
}
// get employee object from the user object
$employee = $user-Employee;
Then to another question...
You can determine and save database name by something like this (I
assume that routing with param 'company' is used):
I tried to read about the routing in CakePHP, but I didn't quite get
it.. so how can I make it work with urls like:
www.domain.com/company1/controller/actionwww.domain.com/company2/controller/action
and take that first part of the url out to save as db name (with
Configure::write like you pointed out) and then use the rest of the
url to navigate normally to the controller / action. I could do it in
the app/webroot/index.php before the $url parameter is passed to the
dispatcher, but I'm guessing that would be the wrong way to do it. Can
I do it with the routing somehow?
These might be quite trivial things for more advanced CakePHP users,
but for me as a newbie, I haven't quite grasped the idea yet..
I'm definitely going to do some write up of the whole setup.
On May 15, 5:44 am, Dr. Loboto drlob...@gmail.com wrote:
1. Can I link tables between database configs?
Yes, but Cake will always run separate queries, no any joins.
2. How to automate the database table selection?
Method on link you provided looks too complex for your situation. If
each company have own databases with completely same structure, the
only thing you need to do for company specific models is to select
appropriate DB config.
You can determine and save database name by something like this (I
assume that routing with param 'company' is used):
class AppController extends Controller {
function constructClasses() {
// Save company name when we already know it but before
models are
created
Configure::write(
'companyDB',
!empty($this-params['company']) ?
$this-params['company'] : false
);
parent::constructClasses();
}
}
Mark all company-specific models like this:
class CompanyProfile extends AppModel {
var $specific = true;
}
And have such AppModel:
class AppModel extends Model {
var $specific = false;
function __construct($id = false, $table = null, $ds = null) {
if ($this-specific) {
// Get saved company/database name
$dbName = Configure::read('companyDB');
// Get common company-specific config (should be
present in
database.php)
$config =
ConnectionManager::getDataSource('defaultSpecific')-config;
// Set correct database name
$config['database'] =
Re: Application setup where each customer has own database
Thanks a lot for the answer! That kind of database selection is indeed
perfect for me and much simpler.. don't have to do any custom db
drivers. Thanks again!
I have couple questions though, as this is the first time I'm using
CakePHP and don't know much about it yet.
1. Can I link tables between database configs?
Yes, but Cake will always run separate queries, no any joins.
How do you define a link between Models that are not in the same
database? I know that with useDbConfig I can tell CakePHP that which
database to use for the model, but when I'm creating a link from users
to employees table for example, how can I tell CakePHP that the
employees table is in the other database? Or do I need to tell that
even? Will Cake check the useDbConfig from the employee model
automatically?
E.g. would this simply work:
class User extends AppModel {
var $useDbConfig = 'commondb';
var $name = 'User';
var $hasOne = 'Employee';
}
class Employee extends AppModel {
var $useDbConfig = 'companydb';
var $name = 'Employee';
}
// get employee object from the user object
$employee = $user-Employee;
Then to another question...
You can determine and save database name by something like this (I
assume that routing with param 'company' is used):
I tried to read about the routing in CakePHP, but I didn't quite get
it.. so how can I make it work with urls like:
www.domain.com/company1/controller/action
www.domain.com/company2/controller/action
and take that first part of the url out to save as db name (with
Configure::write like you pointed out) and then use the rest of the
url to navigate normally to the controller / action. I could do it in
the app/webroot/index.php before the $url parameter is passed to the
dispatcher, but I'm guessing that would be the wrong way to do it. Can
I do it with the routing somehow?
These might be quite trivial things for more advanced CakePHP users,
but for me as a newbie, I haven't quite grasped the idea yet..
I'm definitely going to do some write up of the whole setup.
On May 15, 5:44 am, Dr. Loboto drlob...@gmail.com wrote:
1. Can I link tables between database configs?
Yes, but Cake will always run separate queries, no any joins.
2. How to automate the database table selection?
Method on link you provided looks too complex for your situation. If
each company have own databases with completely same structure, the
only thing you need to do for company specific models is to select
appropriate DB config.
You can determine and save database name by something like this (I
assume that routing with param 'company' is used):
class AppController extends Controller {
function constructClasses() {
// Save company name when we already know it but before
models are
created
Configure::write(
'companyDB',
!empty($this-params['company']) ?
$this-params['company'] : false
);
parent::constructClasses();
}
}
Mark all company-specific models like this:
class CompanyProfile extends AppModel {
var $specific = true;
}
And have such AppModel:
class AppModel extends Model {
var $specific = false;
function __construct($id = false, $table = null, $ds = null) {
if ($this-specific) {
// Get saved company/database name
$dbName = Configure::read('companyDB');
// Get common company-specific config (should be
present in
database.php)
$config =
ConnectionManager::getDataSource('defaultSpecific')-config;
// Set correct database name
$config['database'] = $dbName;
// Add new config to registry
ConnectionManager::create($dbName, $config);
// Point model to new config
$this-useDbConfig = $dbName;
}
parent::__construct($id, $table, $ds);
}
}
... So I'd like to use the first part of the url instead.
Read about routing:http://book.cakephp.org/view/46/Routes-Configuration
On May 15, 2:13 am, doze doze...@gmail.com wrote:
Hello,
I would like to get an advice on how to build an application with
CakePHP where there are multiple customers (companies) using the
application and each have their own database, but also some common
tables in another database. Let me explain the database structure:
Tables in common database:
- Users
- Companies
- Common settings
- ...
Tables in company specific database:
- Users extra profile data
- Company employees
- ...
So all users register to the application and the basic information is
stored in a table in the common database. The application lists
companies that are available. When users goes to
Application setup where each customer has own database
Hello, I would like to get an advice on how to build an application with CakePHP where there are multiple customers (companies) using the application and each have their own database, but also some common tables in another database. Let me explain the database structure: Tables in common database: - Users - Companies - Common settings - ... Tables in company specific database: - Users extra profile data - Company employees - ... So all users register to the application and the basic information is stored in a table in the common database. The application lists companies that are available. When users goes to some specific company page for the first time, they need to add extra profile data that the company wants. This data is stored to the company database. So I have couple questions. 1. Can I link tables between database configs? E.g. if you look at the tables above, the users extra profile data table in company database have user_id foreign key what is the ID of the user in Users table in common database. Same goes for the company employees table. It has a user_id foreign key, all employees are just some users with extra fields in that table and employee id. 2. How to automate the database table selection? I briefly checked this article: http://recurser.com/articles/2007/06/04/multiple-dbs-in-cakephp/ That seems to work for me also to some extent. I can adapt that information and then have two database configurations in app/config/ database.php. One config for the common database that never changes and then another config what uses the system from the above article to make the database selection. Does someone have better idea? But the more important question for the database table selection is that how to know what database to select. The article selects the database via user info, but in my application, users are not tied to some specific database. I was going to do it with subdomains. The application would check what subdomain is used and then find the database for that subdomain. It would work all ok, but I need to build an installation system to the application what can be used to add companies easily online. So I'd need to make it add the subdomain also and vhost to apache and restart apache. I don't like the idea of having to restart apache every time a company is added. So I'd like to use the first part of the url instead. There would be urls like this: www.domain.com/company1/home www.domain.com/company2/home So what I'm thinking (without knowing CakePHP capabilities) is to hack app/webroot/index.php and take the company part out from the $url and store it to session and read it from there when it's time to select the database. That way the application would select the correct database based on the url. But it requires modifications to the app/ webroot/index.php and there might be a better way to do this. So is there? :) Could I for example extend the CakePHP dispatcher what would take the first part from the url out and store it somewhere and then use the rest of the url normally to navigate to the controller etc? or...? Thanks in advance if you took the time to read all this :) Sorry for the lengthy post. Oh and environment is: Apache HTTPD 2.2.11 MySQL 5.1.33 PHP 5.2.9 CakePHP 1.2.3.8166 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Application setup where each customer has own database
1. Can I link tables between database configs?
Yes, but Cake will always run separate queries, no any joins.
2. How to automate the database table selection?
Method on link you provided looks too complex for your situation. If
each company have own databases with completely same structure, the
only thing you need to do for company specific models is to select
appropriate DB config.
You can determine and save database name by something like this (I
assume that routing with param 'company' is used):
class AppController extends Controller {
function constructClasses() {
// Save company name when we already know it but before models
are
created
Configure::write(
'companyDB',
!empty($this-params['company']) ?
$this-params['company'] : false
);
parent::constructClasses();
}
}
Mark all company-specific models like this:
class CompanyProfile extends AppModel {
var $specific = true;
}
And have such AppModel:
class AppModel extends Model {
var $specific = false;
function __construct($id = false, $table = null, $ds = null) {
if ($this-specific) {
// Get saved company/database name
$dbName = Configure::read('companyDB');
// Get common company-specific config (should be
present in
database.php)
$config =
ConnectionManager::getDataSource('defaultSpecific')-
config;
// Set correct database name
$config['database'] = $dbName;
// Add new config to registry
ConnectionManager::create($dbName, $config);
// Point model to new config
$this-useDbConfig = $dbName;
}
parent::__construct($id, $table, $ds);
}
}
... So I'd like to use the first part of the url instead.
Read about routing: http://book.cakephp.org/view/46/Routes-Configuration
On May 15, 2:13 am, doze doze...@gmail.com wrote:
Hello,
I would like to get an advice on how to build an application with
CakePHP where there are multiple customers (companies) using the
application and each have their own database, but also some common
tables in another database. Let me explain the database structure:
Tables in common database:
- Users
- Companies
- Common settings
- ...
Tables in company specific database:
- Users extra profile data
- Company employees
- ...
So all users register to the application and the basic information is
stored in a table in the common database. The application lists
companies that are available. When users goes to some specific company
page for the first time, they need to add extra profile data that the
company wants. This data is stored to the company database.
So I have couple questions.
1. Can I link tables between database configs?
E.g. if you look at the tables above, the users extra profile data
table in company database have user_id foreign key what is the ID of
the user in Users table in common database. Same goes for the company
employees table. It has a user_id foreign key, all employees are just
some users with extra fields in that table and employee id.
2. How to automate the database table selection?
I briefly checked this
article:http://recurser.com/articles/2007/06/04/multiple-dbs-in-cakephp/
That seems to work for me also to some extent. I can adapt that
information and then have two database configurations in app/config/
database.php. One config for the common database that never changes
and then another config what uses the system from the above article to
make the database selection. Does someone have better idea?
But the more important question for the database table selection is
that how to know what database to select. The article selects the
database via user info, but in my application, users are not tied to
some specific database. I was going to do it with subdomains. The
application would check what subdomain is used and then find the
database for that subdomain. It would work all ok, but I need to build
an installation system to the application what can be used to add
companies easily online. So I'd need to make it add the subdomain also
and vhost to apache and restart apache. I don't like the idea of
having to restart apache every time a company is added. So I'd like to
use the first part of the url instead. There would be urls like this:
www.domain.com/company1/homewww.domain.com/company2/home
So what I'm thinking (without knowing CakePHP capabilities) is to hack
app/webroot/index.php and take the company part out from the $url and
store it to session and read it from there when it's time to select
the database. That way the application would select the correct
database based on the url. But it
