mirror of
https://github.com/php/php-src.git
synced 2025-08-16 14:08:47 +02:00
33 lines
937 B
PHP
33 lines
937 B
PHP
--TEST--
|
|
PDO_sqlite: Testing open flags
|
|
--SKIPIF--
|
|
<?php if (!extension_loaded('pdo_sqlite')) print 'skip not loaded'; ?>
|
|
--FILE--
|
|
<?php
|
|
|
|
$filename = __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_open_flags.db";
|
|
|
|
// Default open flag is read-write|create
|
|
$db = new PDO('sqlite:' . $filename, null, null, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
|
|
|
|
var_dump($db->exec('CREATE TABLE test1 (id INT);'));
|
|
|
|
$db = new PDO('sqlite:' . $filename, null, null, [PDO::SQLITE_ATTR_OPEN_FLAGS => PDO::SQLITE_OPEN_READONLY, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
|
|
|
|
var_dump($db->exec('CREATE TABLE test2 (id INT);'));
|
|
?>
|
|
--CLEAN--
|
|
<?php
|
|
$filename = __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_open_flags.db";
|
|
if (file_exists($filename)) {
|
|
unlink($filename);
|
|
}
|
|
?>
|
|
--EXPECTF--
|
|
int(0)
|
|
|
|
Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in %s
|
|
Stack trace:
|
|
%s
|
|
#1 {main}
|
|
thrown in %s
|