public static function getRequestsByUserId($userId)
{
$join = new Sabel_Db_Join("Request");
$join->setCondition("Request.request_id", $userId);
$join->setOrderBy("Request.created_at", "desc");
return $join->add("User")->select();
}
public static function getFriends($userId, $limit)
{
$join = new Sabel_Db_Join(new self());
$join->add("Users", "", array("id" => "uid", "fkey" => "follow_id"));
$join->setCondition("Follower.user_id", $userId);
$join->setOrderBy("Follower.created_at");
$join->setLimit($limit);
return $join->select();
}
public function testBridgeWithCondition()
{
$join = new Sabel_Db_Join("StudentCourse");
$join->setOrderBy("StudentCourse.student_id")->setOrderBy("StudentCourse.course_id");
$join->setCondition("Student.id", 1);
$r = $join->add("Student")->add("Course")->select();
$this->assertEquals(2, count($r));
$this->assertEquals("yamada", $r[0]->Student->name);
$this->assertEquals("Mathematics", $r[0]->Course->name);
$this->assertEquals("yamada", $r[1]->Student->name);
$this->assertEquals("Physics", $r[1]->Course->name);
}
