/usr/share/doc/php-log/tests/sqlite.phpt is in php-log 1.12.3-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 | --TEST--
Log: Sqlite Handler
--SKIPIF--
<?php if (!function_exists('sqlite_open')) die("skip\n"); ?>
--INI--
date.timezone=UTC
--FILE--
<?php
require_once 'Log.php';
$filename = dirname(__FILE__) . DIRECTORY_SEPARATOR . 'sqlite-log.db';
if (file_exists($filename)) unlink($filename);
$db = sqlite_open($filename, 0666, $error);
$ident = time();
$message = 'logging an event';
$logger = Log::factory('sqlite', 'log_table', $ident, $db);
$logger->log($message, PEAR_LOG_WARNING);
$q = "SELECT message FROM log_table WHERE ident='$ident'";
$res = sqlite_query($db, $q);
if (sqlite_fetch_string($res) == $message) {
echo 'ok';
}
sqlite_close($db);
if (file_exists($filename)) unlink($filename);
--EXPECT--
ok
|