Return to sqlite3_25_create_aggregate.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / sqlite3 / tests

Annotation of embedaddon/php/ext/sqlite3/tests/sqlite3_25_create_aggregate.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: SQLite3::createAggregate() test
        !             3: --SKIPIF--
        !             4: <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?>
        !             5: --FILE--
        !             6: <?php
        !             7: 
        !             8: require_once(dirname(__FILE__) . '/new_db.inc');
        !             9: 
        !            10: function sum_list_step($context, $rows, $string) {
        !            11:        if (empty($context))
        !            12:        {
        !            13:                $context = array('total' => 0, 'values' => array());
        !            14:        }
        !            15:        $context['total'] += intval($string);
        !            16:        $context['values'][] = $context['total'];
        !            17:        return $context;
        !            18: }
        !            19: 
        !            20: function sum_list_finalize($context) {
        !            21:        return implode(',', $context['values']);
        !            22: }
        !            23: 
        !            24: echo "Creating Table\n";
        !            25: var_dump($db->exec('CREATE TABLE test (a INTEGER, b INTEGER)'));
        !            26: 
        !            27: echo "INSERT into table\n";
        !            28: var_dump($db->exec("INSERT INTO test (a, b) VALUES (1, -1)"));
        !            29: var_dump($db->exec("INSERT INTO test (a, b) VALUES (2, -2)"));
        !            30: var_dump($db->exec("INSERT INTO test (a, b) VALUES (3, -3)"));
        !            31: var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));
        !            32: var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));
        !            33: 
        !            34: $db->createAggregate('S', 'sum_list_step', 'sum_list_finalize', 1);
        !            35: 
        !            36: print_r($db->querySingle("SELECT S(a), S(b) FROM test", true));
        !            37: 
        !            38: echo "Closing database\n";
        !            39: var_dump($db->close());
        !            40: echo "Done\n";
        !            41: ?>
        !            42: --EXPECTF--
        !            43: Creating Table
        !            44: bool(true)
        !            45: INSERT into table
        !            46: bool(true)
        !            47: bool(true)
        !            48: bool(true)
        !            49: bool(true)
        !            50: bool(true)
        !            51: Array
        !            52: (
        !            53:     [S(a)] => 1,3,6,10,14
        !            54:     [S(b)] => -1,-3,-6,-10,-14
        !            55: )
        !            56: Closing database
        !            57: bool(true)
        !            58: Done