felipe Thu May 14 01:29:37 2009 UTC Added files: (Branch: PHP_5_2) /php-src/ext/odbc/tests odbc_columnprivileges_001.phpt odbc_columns_001.phpt odbc_data_source_001.phpt odbc_exec_002.phpt odbc_free_result_001.phpt odbc_tables_001.phpt Log: - New tests
http://cvs.php.net/viewvc.cgi/php-src/ext/odbc/tests/odbc_columnprivileges_001.phpt?view=markup&rev=1.1 Index: php-src/ext/odbc/tests/odbc_columnprivileges_001.phpt +++ php-src/ext/odbc/tests/odbc_columnprivileges_001.phpt --TEST-- odbc_columnprivileges(): Basic test --SKIPIF-- <?php include 'skipif.inc'; ?> --FILE-- <?php include 'config.inc'; $conn = odbc_connect($dsn, $user, $pass); var_dump($result = odbc_columnprivileges($conn, '', '', '', '')); var_dump(odbc_fetch_row($result)); var_dump($result = odbc_columnprivileges($conn, NULL, NULL, NULL, NULL)); var_dump(odbc_fetch_row($result)); var_dump($result = odbc_columnprivileges($conn, 'FOO', 'FOO', 'FOO', 'FOO')); var_dump(odbc_fetch_row($result)); ?> --EXPECTF-- resource(%d) of type (odbc result) bool(false) resource(%d) of type (odbc result) bool(false) resource(%d) of type (odbc result) bool(false) http://cvs.php.net/viewvc.cgi/php-src/ext/odbc/tests/odbc_columns_001.phpt?view=markup&rev=1.1 Index: php-src/ext/odbc/tests/odbc_columns_001.phpt +++ php-src/ext/odbc/tests/odbc_columns_001.phpt --TEST-- odbc_columns(): Basic test --SKIPIF-- <?php include 'skipif.inc'; ?> --FILE-- <?php include 'config.inc'; $conn = odbc_connect($dsn, $user, $pass); var_dump($result = odbc_columns($conn, '', '', '', '')); var_dump(odbc_fetch_row($result)); var_dump($result = odbc_columns($conn, NULL, NULL, NULL, NULL)); var_dump(odbc_fetch_row($result)); var_dump($result = odbc_columns($conn, 'FOO', 'FOO', 'FOO', 'FOO')); var_dump(odbc_fetch_row($result)); ?> --EXPECTF-- resource(%d) of type (odbc result) bool(false) resource(%d) of type (odbc result) bool(false) Warning: odbc_columns(): SQL error: Failed to fetch error message, SQL state HY000 in SQLColumns in %s on line %d bool(false) Warning: odbc_fetch_row() expects parameter 1 to be resource, boolean given in %s on line %d NULL http://cvs.php.net/viewvc.cgi/php-src/ext/odbc/tests/odbc_data_source_001.phpt?view=markup&rev=1.1 Index: php-src/ext/odbc/tests/odbc_data_source_001.phpt +++ php-src/ext/odbc/tests/odbc_data_source_001.phpt --TEST-- odbc_data_source(): Basic test --SKIPIF-- <?php include 'skipif.inc'; ?> --FILE-- <?php include 'config.inc'; $conn = odbc_connect($dsn, $user, $pass); var_dump(odbc_data_source($conn, NULL)); var_dump(odbc_data_source($conn, '')); var_dump(odbc_data_source($conn, SQL_FETCH_FIRST)); ?> --EXPECTF-- Warning: odbc_data_source(): Invalid fetch type (0) in %s on line %d bool(false) Warning: odbc_data_source() expects parameter 2 to be long, string given in %s on line %d NULL array(%d) { %a } http://cvs.php.net/viewvc.cgi/php-src/ext/odbc/tests/odbc_exec_002.phpt?view=markup&rev=1.1 Index: php-src/ext/odbc/tests/odbc_exec_002.phpt +++ php-src/ext/odbc/tests/odbc_exec_002.phpt --TEST-- odbc_exec(): Getting data from query --SKIPIF-- <?php include 'skipif.inc'; ?> --FILE-- <?php include 'config.inc'; $conn = odbc_connect($dsn, $user, $pass); odbc_exec($conn, 'CREATE DATABASE odbcTEST'); odbc_exec($conn, 'CREATE TABLE FOO (TEST INT)'); odbc_exec($conn, 'INSERT INTO FOO VALUES (1)'); odbc_exec($conn, 'INSERT INTO FOO VALUES (2)'); $res = odbc_exec($conn, 'SELECT * FROM FOO'); var_dump(odbc_fetch_row($res)); var_dump(odbc_result($res, 'test')); var_dump(odbc_fetch_array($res)); odbc_exec($conn, 'DROP TABLE FOO'); odbc_exec($conn, 'DROP DATABASE odbcTEST'); ?> --EXPECTF-- bool(true) string(1) "1" array(1) { ["TEST"]=> string(1) "2" } http://cvs.php.net/viewvc.cgi/php-src/ext/odbc/tests/odbc_free_result_001.phpt?view=markup&rev=1.1 Index: php-src/ext/odbc/tests/odbc_free_result_001.phpt +++ php-src/ext/odbc/tests/odbc_free_result_001.phpt --TEST-- odbc_free_result(): Basic test --SKIPIF-- <?php include 'skipif.inc'; ?> --FILE-- <?php include 'config.inc'; $conn = odbc_connect($dsn, $user, $pass); odbc_exec($conn, 'CREATE DATABASE odbcTEST'); odbc_exec($conn, 'CREATE TABLE FOO (TEST INT)'); odbc_exec($conn, 'ALTER TABLE FOO ADD PRIMARY KEY FOO(TEST)'); odbc_exec($conn, 'INSERT INTO FOO VALUES (1)'); odbc_exec($conn, 'INSERT INTO FOO VALUES (2)'); $res = odbc_exec($conn, 'SELECT * FROM FOO'); var_dump(odbc_fetch_row($res)); var_dump(odbc_result($res, 'test')); var_dump(odbc_free_result($res)); var_dump(odbc_free_result($conn)); var_dump(odbc_free_result(NULL)); var_dump(odbc_fetch_row($res)); var_dump(odbc_result($res, 'test')); odbc_exec($conn, 'DROP TABLE FOO'); odbc_exec($conn, 'DROP DATABASE odbcTEST'); ?> --EXPECTF-- bool(true) string(1) "1" bool(true) Warning: odbc_free_result(): supplied resource is not a valid ODBC result resource in %s on line %d bool(false) Warning: odbc_free_result() expects parameter 1 to be resource, null given in %s on line %d NULL Warning: odbc_fetch_row(): %d is not a valid ODBC result resource in %s on line %d bool(false) Warning: odbc_result(): %d is not a valid ODBC result resource in %s on line %d bool(false) http://cvs.php.net/viewvc.cgi/php-src/ext/odbc/tests/odbc_tables_001.phpt?view=markup&rev=1.1 Index: php-src/ext/odbc/tests/odbc_tables_001.phpt +++ php-src/ext/odbc/tests/odbc_tables_001.phpt --TEST-- odbc_tables(): Basic test --SKIPIF-- <?php include 'skipif.inc'; ?> --FILE-- <?php include 'config.inc'; $conn = odbc_connect($dsn, $user, $pass); var_dump($result = odbc_tables($conn, '', '', '', '')); var_dump(odbc_fetch_row($result)); var_dump($result = odbc_tables($conn, NULL, NULL, NULL, NULL)); var_dump(odbc_fetch_row($result)); var_dump($result = odbc_tables($conn, 'FOO', 'FOO', 'FOO', 'FOO')); var_dump(odbc_fetch_row($result)); ?> --EXPECTF-- resource(%d) of type (odbc result) bool(false) resource(%d) of type (odbc result) bool(false) resource(%d) of type (odbc result) bool(false) -- PHP CVS Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php