felipe Thu May 14 01:28:23 2009 UTC
Added files:
/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
