Blog: Symfony and Doctrine: Behaviors

ki_table_proxy.php

public function retrieveByKiTableProxy($ki) {
  
    $table = $this->getInvoker()->getTable();
    
    return Doctrine_Query::create()
      ->from($table->getComponentName() . ' t')
      ->where('t.ki = ?', $ki)
      ->fetchOne();

}

kiable_behavior_yaml.php

DeviceType:
  actAs: { Timestampable: ~, Kiable: ~ }

kiable_listener.php

class KiableListener extends Doctrine_Record_Listener {
  
  public function preSave(Doctrine_Event $event) {
    
    // Get the object that invoke the listener
    $invoker = $event->getInvoker();
    if ($invoker->isNew() && !strlen($invoker->getKi())) {
      // Get the name
      $name = $invoker->getName();
      
      // Slug the name for the ki (replace spaces with _, remove special chars, etc)
      $ki = Slugify::makeSlug($name);
      $invoker->setKi($ki);
    }
    
  }
  
}

kiable_template.php

class Kiable extends Doctrine_Template {
  
  public function setTableDefinition() {
   
    // Add the field
    $this->_table->setColumn('ki', 'string', 50, array('notnull' => true, 'unique' => true), true);
    
    // Add the listener
    $this->addListener(new KiableListener());
  }

  public function setup() {

  }
  
}

retrieve_by_ki.php

Doctrine::getTable('FooTable')->retrieveByKi('the_ki');