Return to test.inc CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / sybase_ct / tests

Annotation of embedaddon/php/ext/sybase_ct/tests/test.inc, revision 1.1.1.2

1.1       misho       1: <?php
                      2: /* This file is part of PHP test framework for ext/sybase_ct
                      3:  *
1.1.1.2 ! misho       4:  * $Id$ 
1.1       misho       5:  */
                      6: 
                      7:   // Change if needed
                      8:   define('HOST',     getenv('PHP_SYBASE_HOST'));
                      9:   define('USER',     getenv('PHP_SYBASE_USER'));
                     10:   define('PASSWORD', getenv('PHP_SYBASE_PASS'));
                     11:   define('TEMPDB',   'tempdb');
                     12: 
                     13:   // {{{ bool sybase_msg_handler(int msgnumber, int severity, int state, int line, string text)
                     14:   //     Handles server messages
                     15:   function sybase_msg_handler($msgnumber, $severity, $state, $line, $text) {
                     16:     printf(
                     17:       "*** Caught Sybase Server Message #%d [Severity %d, state %d] at line %d\n    '%s'\n",
                     18:       $msgnumber,
                     19:       $severity,
                     20:       $state,
                     21:       $line,
                     22:       chop($text)
                     23:     );
                     24:   }
                     25:   // }}}
                     26: 
                     27:   // {{{ public class sybase
                     28:   class sybase {
                     29:   
                     30:     // {{{ public static bool static_handler(int msgnumber, int severity, int state, int line, string text)
                     31:     //     Handles server messages
                     32:     static function static_handler($msgnumber, $severity, $state, $line, $text) {
                     33:       return sybase_msg_handler($msgnumber, $severity, $state, $line, $text);
                     34:     }
                     35:     // }}}
                     36: 
                     37:     // {{{ public bool static_handler(int msgnumber, int severity, int state, int line, string text)
                     38:     //     Handles server messages
                     39:     function handler($msgnumber, $severity, $state, $line, $text) { 
                     40:       return sybase_msg_handler($msgnumber, $severity, $state, $line, $text);
                     41:     }
                     42:     // }}}
                     43:   }
                     44:   // }}}
                     45: 
                     46:   // {{{ void sybase_set_messagehandler_ex(string handler)
                     47:   //     Sets the sybase message handler and dumps the result
                     48:   function sybase_set_messagehandler_ex($handler) {
                     49:     var_dump(sybase_set_message_handler($handler));
                     50:   }
                     51:   
                     52:   // {{{ resource sybase_connect_ex(string charset= NULL, string appname= NULL, bool new= FALSE)
                     53:   //     Connect to the sybase server using the defines HOST, USER and PASSWORD
                     54:   function sybase_connect_ex($charset= NULL, $appname= NULL, $new= FALSE) {
                     55:     sybase_min_server_severity(11);       // Suppress "changed database context"
                     56:     if (!($db= sybase_connect(HOST, USER, PASSWORD, $charset ? $charset : 'iso_1', $appname, $new))) {
                     57:       die('Connect to '.USER.'@'.HOST.' failed (using password: '.(PASSWORD ? 'yes' : 'no').')');
                     58:     }
                     59:     return $db;
                     60:   }
                     61:   // }}}
                     62: 
                     63:   // {{{ void sybase_select_ex(resource dbh, string query)
                     64:   //     Returns all fetched rows from an SQL query
                     65:   function sybase_select_ex($dbh, $query) {
                     66:     printf(">>> Query: %s\n", $query);
                     67:     $h= sybase_query($query, $dbh);
                     68:     printf("<<< Return: %s\n", gettype($h));
                     69:     flush();
                     70:     if (!is_resource($h)) return $h;
                     71: 
                     72:     $return= array();
                     73:     while ($row= sybase_fetch_assoc($h)) {
                     74:       $return[]= $row;
                     75:     }
                     76:     return $return;
                     77:   }
                     78:   
                     79:   // {{{ mixed sybase_select_single(resource dbh, string query)
                     80:   //     Fires an SQL query and returns the first value from the first row
                     81:   function sybase_select_single($dbh, $query) {
                     82:     $a = sybase_fetch_row(sybase_query($query, $dbh));
                     83:     return array_shift($a);
                     84:   }
                     85:   // }}}
                     86: ?>