Return to sqlite3_36_create_collation.phpt CVS log

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

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

1.1     ! misho       1: --TEST--
        !             2: Test SQLite3::createCollation() by adding strnatcmp() as an SQL COLLATE sequence
        !             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: $db->createCollation('NAT', 'strnatcmp');
        !            11: 
        !            12: $db->exec('CREATE TABLE t (s varchar(4))');
        !            13: 
        !            14: $stmt = $db->prepare('INSERT INTO t VALUES (?)');
        !            15: foreach(array('a1', 'a10', 'a2') as $s){
        !            16:        $stmt->bindParam(1, $s);
        !            17:        $stmt->execute();
        !            18: }
        !            19: 
        !            20: $defaultSort = $db->query('SELECT s FROM t ORDER BY s');             //memcmp() sort
        !            21: $naturalSort = $db->query('SELECT s FROM t ORDER BY s COLLATE NAT'); //strnatcmp() sort
        !            22: 
        !            23: echo "default\n";
        !            24: while ($row = $defaultSort->fetchArray()){
        !            25:        echo $row['s'], "\n";
        !            26: }
        !            27: 
        !            28: echo "natural\n";
        !            29: while ($row = $naturalSort->fetchArray()){
        !            30:        echo $row['s'], "\n";
        !            31: }
        !            32: 
        !            33: $db->close();
        !            34: 
        !            35: ?>
        !            36: --EXPECT--
        !            37: default
        !            38: a1
        !            39: a10
        !            40: a2
        !            41: natural
        !            42: a1
        !            43: a2
        !            44: a10