Using a different Connection within Doctrine_Table in symfony 1.4 / sfMasterSlavePlugin

Answer 1

What you can do is this:

public function fetchByLoginFromMaster($login)
{
  $conn = ProjectConfiguration::getActive()->getMasterConnection();
  $q = Doctrine_Query::create($conn)
                ->from('User')
                ->where('login = ?', $login)
                ->fetchOne();
  return $q;
}

Answer 2

Hi,

i also tried to set the connection explicitly to master before doing the query. But again, the slave connection was used to execute the query.

I tried the following:

public function fetchByLoginFromMaster($login)
{
    $masterConn = ProjectConfiguration::getActive()->getMasterConnection();

    $this->setConnection($masterConn);

    $q = $this->createQuery()
                ->from('User')
                ->where('login = ?', $login)
                ->fetchOne();

    return $q;
}

Thank you, Stephan