cvs: php-src /ext/sybase_ct/tests test_msghandler_handled.phpt
| From: | Timm Friebe | Date: | Sun, 11 Jul 2004 16:07:07 +0000 |
| Subject: | cvs: php-src /ext/sybase_ct/tests test_msghandler_handled.phpt | ||
| Groups: | php.cvs | ||
| Request: | Send a blank email to php-cvs+get-27781@lists.php.net to get a copy of this message | ||
thekid Sun Jul 11 12:07:07 2004 EDT
Added files:
/php-src/ext/sybase_ct/tests test_msghandler_handled.phpt
Log:
- Initial release
http://cvs.php.net/co.php/php-src/ext/sybase_ct/tests/test_msghandler_handled.phpt?r=1.1&p=1
Index: php-src/ext/sybase_ct/tests/test_msghandler_handled.phpt
+++ php-src/ext/sybase_ct/tests/test_msghandler_handled.phpt
--TEST--
Sybase-CT server message handler
--SKIPIF--
<?php require('skipif.inc'); ?>
--FILE--
<?php
/* This file is part of PHP test framework for ext/sybase_ct
*
* $Id: test_msghandler_handled.phpt,v 1.1 2004/07/11 16:07:07 thekid Exp $
*/
require('test.inc');
// {{{ bool sybase_msg_handler(int msgnumber, int severity, int state, int line, string text)
// Handles server messages
function user_message_handler($msgnumber, $severity, $state, $line, $text) {
switch ($msgnumber) {
case 0: // print message
printf("!!! %s\n", trim($text));
return;
case 174: // The function 'GETDATE' requires 0 arguments.
printf("*** Caught '%s'\n", trim($text));
return;
}
printf("Cannot handle message #%d\n", $msgnumber);
return FALSE; // Indicate we can't handle this
}
// }}}
sybase_set_messagehandler_ex('user_message_handler');
$db= sybase_connect_ex();
sybase_min_server_severity(0);
// These are handled
var_dump(sybase_select_ex($db, 'select getdate(NULL)'));
var_dump(sybase_select_ex($db, 'print "Hi"'));
// These aren't
var_dump(sybase_select_ex($db, 'use NULL'));
var_dump(sybase_select_ex($db, 'select convert(datetime, "notadate")'));
sybase_close($db);
?>
--EXPECTF--
bool(true)
>>> Query: select getdate(NULL)
*** Caught 'The function 'GETDATE' requires 0 arguments.'
<<< Return: boolean
bool(false)
>>> Query: print "Hi"
!!! Hi
<<< Return: boolean
bool(true)
>>> Query: use NULL
Cannot handle message #156
Warning: sybase_query(): Sybase: Server message: Incorrect syntax near the keyword
'NULL'.
(severity 15, procedure N/A) in %s on line %d
<<< Return: boolean
bool(false)
>>> Query: select convert(datetime, "notadate")
Cannot handle message #249
Warning: sybase_query(): Sybase: Server message: Syntax error during explicit conversion of
VARCHAR value 'notadate' to a DATETIME field.
(severity 16, procedure N/A) in %s on line %d
<<< Return: resource
array(0) {
}