Return to pdo_sqlite_createcollation.phpt CVS log

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

Annotation of embedaddon/php/ext/pdo_sqlite/tests/pdo_sqlite_createcollation.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: PDO_sqlite: Testing sqliteCreateCollation()
        !             3: --SKIPIF--
        !             4: <?php if (!extension_loaded('pdo_sqlite')) print 'skip not loaded'; ?>
        !             5: --FILE--
        !             6: <?php
        !             7: 
        !             8: $db = new pdo('sqlite::memory:');
        !             9: $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        !            10: 
        !            11: $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
        !            12: 
        !            13: $db->query('INSERT INTO foobar VALUES (NULL, "1")');
        !            14: $db->query('INSERT INTO foobar VALUES (NULL, "2")');
        !            15: $db->query('INSERT INTO foobar VALUES (NULL, "10")');
        !            16: 
        !            17: $db->sqliteCreateCollation('MYCOLLATE', function($a, $b) { return strnatcmp($a, $b); });
        !            18: 
        !            19: $result = $db->query('SELECT name FROM foobar ORDER BY name COLLATE MYCOLLATE');
        !            20: foreach ($result as $row) {
        !            21:        echo $row['name'] . "\n";
        !            22: }
        !            23: 
        !            24: $result = $db->query('SELECT name FROM foobar ORDER BY name');
        !            25: foreach ($result as $row) {
        !            26:   echo $row['name'] . "\n";
        !            27: }
        !            28: 
        !            29: $db->query('DROP TABLE foobar');
        !            30: 
        !            31: ?>
        !            32: --EXPECTF--
        !            33: 1
        !            34: 2
        !            35: 10
        !            36: 1
        !            37: 10
        !            38: 2