File: sqlite.phpt

package info (click to toggle)
php-log 1.10.0-1
  • links: PTS
  • area: main
  • in suites: lenny
  • size: 404 kB
  • ctags: 592
  • sloc: php: 1,822; xml: 237; sql: 8; makefile: 3
file content (29 lines) | stat: -rw-r--r-- 687 bytes parent folder | download | duplicates (3)
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
--TEST--
Log: Sqlite Handler
--SKIPIF--
<?php if (!function_exists('sqlite_open')) die("skip\n"); ?>
--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