lithium\tests\cases\data\source\DatabaseTest::testLimit PHP Method

    public function testLimit()
    {
        MockDatabasePost::find('all', array('limit' => 15));
        $result = $this->_db->sql;
        $expected = 'SELECT * FROM {mock_database_posts} AS {MockDatabasePost} LIMIT 15;';
        $this->assertEqual($expected, $result);
        MockDatabasePost::find('all', array('limit' => 10, 'page' => 3));
        $result = $this->_db->sql;
        $expected = 'SELECT * FROM {mock_database_posts} AS {MockDatabasePost} LIMIT 10 OFFSET 20;';
        $this->assertEqual($expected, $result);
    }