public function test_has_many_with_sql_clause_options() { Venue::$has_many[0] = array('events', 'select' => 'type', 'group' => 'type', 'limit' => 2, 'offset' => 1); Venue::first()->events; $this->assert_sql_has($this->conn->limit("SELECT type FROM events WHERE venue_id=? GROUP BY type", 1, 2), Event::table()->last_sql); }
public function test_has_many_with_sql_clause_options() { Venue::$has_many[0] = array('events', 'group' => 'type', 'order' => 'title desc', 'limit' => 2, 'offset' => 1); Venue::first()->events; $this->assert_true(strpos(Event::table()->last_sql, 'WHERE venue_id=? GROUP BY type ORDER BY title desc LIMIT 1,2') !== false); }