/
vshmidt
/
php
Обзор
Документация
Войти
/
vshmidt
/
php
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
ext/pdo_sqlite/tests/subclasses/pdo_sqlite_createcollation.phpt
35 строк
902 B
Máté Kocsis
Amend PDO driver-specific class names (#14069)
30 май 2024, 21:15
Не верифицирован
30 май 2024, 21:15
6ec4220
Код
Авторство
О чём код?
--TEST-- PDO_sqlite: Testing sqliteCreateCollation() --EXTENSIONS-- pdo_sqlite --FILE-- <?php // This test was copied from the pdo_sqlite test for sqliteCreateCollation $db = new Pdo\Sqlite('sqlite::memory:'); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->query('CREATE TABLE test_pdo_sqlite_createcollation (id INT AUTO INCREMENT, name TEXT)'); $db->query('INSERT INTO test_pdo_sqlite_createcollation VALUES (NULL, "1"), (NULL, "2"), (NULL, "10")'); $db->createCollation('MYCOLLATE', function($a, $b) { return strnatcmp($a, $b); }); $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name COLLATE MYCOLLATE'); foreach ($result as $row) { echo $row['name'] . "\n"; } $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name'); foreach ($result as $row) { echo $row['name'] . "\n"; } ?> --EXPECT-- 1 2 10 1 10 2