lithium\tests\cases\data\source\DatabaseTest::testGroupOnRelation PHP Метод

    public function testGroupOnRelation()
    {
        $query = new Query(array('type' => 'read', 'model' => $this->_comment, 'with' => 'MockDatabasePost', 'group' => array('MockDatabaseComment.id')));
        $sql = 'SELECT * FROM {mock_database_comments} AS {MockDatabaseComment} LEFT JOIN ';
        $sql .= '{mock_database_posts} AS {MockDatabasePost} ON {MockDatabaseComment}.';
        $sql .= '{mock_database_post_id} = {MockDatabasePost}.{id} GROUP BY ';
        $sql .= '{MockDatabaseComment}.{id};';
        $this->assertEqual($sql, $this->_db->renderCommand($query));
    }