/**
  * Sets up the fixture, for example, opens a network connection.
  * This method is called before a test is executed.
  *
  * @return void
  */
 protected function setUp()
 {
     parent::setUp();
     $this->db = static::$dbo;
     $this->instance = new RelationDataMapper('flower', 'ww_flower');
     $this->instance->addTable('category', 'ww_categories', 'flower.catid = category.id');
 }
 /**
  * Sets up the fixture, for example, opens a network connection.
  * This method is called before a test is executed.
  */
 protected function setUp()
 {
     parent::setUp();
     $this->db = static::$dbo;
     $this->object = new RelationDataMapper('cont', 'ww_content');
     $this->object->addTable('cat', 'ww_categories', 'cont.catid = cat.id', 'LEFT')->addTable('user', 'ww_users', 'cont.created_by = user.id', 'LEFT');
 }
Exemple #3
0
 /**
  * getLastPost
  *
  * @param int $pk
  *
  * @return  Data
  */
 public function getLastPost($pk)
 {
     $mapper = new RelationDataMapper('post', Table::POSTS);
     $mapper->addTable('topic', Table::TOPICS, 'topic.id = post.topic_id')->addTable('category', LunaTable::CATEGORIES, 'category.id = topic.category_id')->addTable('user', WarderTable::USERS, 'user.id = post.user_id');
     $post = $mapper->findOne(array('category.id' => $pk), 'post.created DESC');
     return $post;
 }