Symfony: raw query, get years list for active posts

public function executeIndex(sfWebRequest $request)
  {
    //get years
   $connection = Propel::getConnection();
   $query = '
     SELECT YEAR( %s ) AS myYear
     FROM %s
     WHERE %s = 1
     GROUP BY YEAR( %s )
     ORDER BY myYear DESC
   ';

   $query = sprintf($query,
     PostPeer::PUBLISHED_AT,
     PostPeer::TABLE_NAME,
     PostPeer::IS_PUBLISHED,
     PostPeer::PUBLISHED_AT
   );
   $statement = $connection->prepare($query);
   $statement->execute();
   $years = array();
   while($resultset = $statement->fetch(PDO::FETCH_OBJ))
   {
     $years[] = $resultset->myYear;
   }
   $this->years = $years;
  }

returns array(2009, 2008, 2007...)

Symfony: Propel 1.3 installation

Не сразу заметен пробел после /1.3/

$ cd /path/to/project/root/
$ svn co http://svn.symfony-project.com/plugins/sfPropelPlugin/branches/1.3/[::space::]plugins/sfPropelPlugin

Пользователям "черепашки" обратить внимание.

Symfony: Propel unique validator

$this->validatorSchema->setPostValidator(new
  sfValidatorPropelUnique(array(
      'model' => 'Users', 
      'column' => array('login')),
    array(
      'invalid' => 'Такой логин уже есть.'
    )
));