So for a fuller example:
databases.yml:
all:
propel:
class: sfPropelDatabase
param:
dsn: 'mysql://pinpoint:[email protected]/pinpoint'
somedomain.org:
class: sfPropelDatabase
param:
dsn: 'mysql://pinpoint:p1np0...@localhost/pinpoint'
somedomain.com:
class: sfPropelDatabase
param:
dsn: 'mysql://pinpoint:[email protected]/pinpoint'
In your Model classes overwrite calls to database by putting inside the
file:
TableNamePeer
public static function doSelect(Criteria $criteria, $con = null)
{
parent::doSelect($criteria, Propel::getConnection(str_replace("www.",
"", sfRequest::getHost())));
}
On Wed, Oct 14, 2009 at 5:47 PM, Carlos Jorge Andrade <
[email protected]> wrote:
>
>
>
>
> On 14, Oct 2009, at 13:48 , Gareth McCumskey wrote:
>
> > First thing that goes through my mind is why you would want to do
> > that? databases.yml is where all database connections are defined
> > and you can create as many as you like in there.
>
> Imagine the exact same codebase to power two different sites.
> Like somesite.com and somesite.org, one document root... depending on
> the domain accessed, the db connection would change. How would one do
> that ?
>
> >
> >
> http://www.lampjunkie.com/2008/04/using-multiple-databases-in-symfony-with-propel/
> >
> > On Wed, Oct 14, 2009 at 1:04 PM, Davide Borsatto <[email protected]>
> > wrote:
> >
> > Hi everybody,
> >
> > Is there a way to specify the connection parameters (those normally
> > specified in databases.yml) via PHP? Maybe in the ProjectConfiguration
> > class, but how?
> >
> >
> >
> >
> > --
> > Gareth McCumskey
> > http://garethmccumskey.blogspot.com
> > twitter: @garethmcc
> >
> > >
>
>
> >
>
--
Gareth McCumskey
http://garethmccumskey.blogspot.com
twitter: @garethmcc
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
