xref: /plugin/strata/_test/query_sort.test.php (revision 5153720fcc1dd2b6e63035d45f7c2bc32e429371)

<?php
require_once('strataquerytest.inc.php');

/**
 * Tests queries - sorting.
 *
 * @group plugin_strata
 * @group plugins
 */
class query_sort_test extends Strata_Query_UnitTestCase {

    function setup() {
        parent::setup();
    }

    function testNumericSort() {
        $query = array (
            'type' => 'select',
            'grouping'=>array(),
            'group' => array (
                'type' => 'triple',
                'subject' => array (
                    'type' => 'variable',
                    'text' => 'p'
                ),
                'predicate' => array (
                    'type' => 'literal',
                    'text' => 'is rated'
                ),
                'object' => array (
                    'type' => 'variable',
                    'text' => 'rating'
                )
            ),
            'projection' => array (
                'p',
                'rating'
            ),
            'ordering' => array (
                array (
                    'variable' => 'rating',
                    'direction' => 'asc'
                )
            )
        );

        $expected = array (
            array (
                'p' => array('person:carol'),
                'rating' => array('1')
            ),
            array (
                'p' => array('person:bob'),
                'rating' => array('8')
            ),
            array (
                'p' => array('person:alice'),
                'rating' => array('10')
            )
        );

        $this->assertQueryResult($query, $expected);
    }

    function testPartiallyNumericSort() {
        $query = array (
            'type' => 'select',
            'grouping'=>array(),
            'group' => array (
                'type' => 'triple',
                'subject' => array (
                    'type' => 'variable',
                    'text' => 'p'
                ),
                'predicate' => array (
                    'type' => 'literal',
                    'text' => 'tax rate'
                ),
                'object' => array (
                    'type' => 'variable',
                    'text' => 'tax'
                )
            ),
            'projection' => array (
                'p',
                'tax'
            ),
            'ordering' => array (
                array (
                    'variable' => 'tax',
                    'direction' => 'asc'
                )
            )
        );

        // Result might vary depending on database backed, only require that it does not fail
        $this->assertTrue($this->_triples->queryRelations($query));
    }

}