Re: Application setup where each customer has own database

2009-05-18 Thread doze
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

Re: Application setup where each customer has own database

2009-05-17 Thread Dr. Loboto
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:

Re: Application setup where each customer has own database

2009-05-15 Thread doze
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

Application setup where each customer has own database

2009-05-14 Thread doze
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

Re: Application setup where each customer has own database

2009-05-14 Thread Dr. Loboto
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