trAvis - MANAGER

Edit File: db_parsedsn.phpt

--TEST-- DB::parseDSN --SKIPIF-- <?php require_once dirname(__FILE__) . '/skipif.inc'; ?> --FILE-- <?php // -*- C++ -*- require_once dirname(__FILE__) . '/include.inc'; require_once 'DB.php'; function reparseDSN($dsn) { $parsed = DB::parseDSN($dsn); $reparsed = DB::parseDSN(DB::getDSNString($dsn, false)); if (count($diff = array_diff($parsed, $reparsed)) > 0) { echo "Parsing the original DSN and the DSN generated by getDSNString results in differences:\n"; printf("%-20s%-29s%-29s\n", 'Field', 'Parsed', 'Reparsed'); printf("%-20s%-29s%-29s\n", '-----', '------', '--------'); foreach ($parsed as $key => $value) { printf("%-20s%-29s%-29s\n", $key, $value, $reparsed[$key]); } echo "The reparsed DSN was: ".DB::getDSNString($dsn, false)."\n"; } } function test($dsn) { echo "DSN: $dsn\n"; print_r(DB::parseDSN($dsn)); reparseDSN($dsn); } function testArray($dsn) { echo "DSN: array\n"; print_r(DB::parseDSN($dsn)); reparseDSN($dsn); } print "testing DB::parseDSN...\n\n"; test("mysql"); test("odbc(mssql)"); test('odbc(db2)://user:password@/database'); test('odbc(access):///database'); test('odbc://admin@/datasourceName'); test("mysql://localhost"); test("mysql://remote.host.com/db"); test("oci8://system:manager@"); test("oci8://user:pass@tns-name"); test("odbc(solid)://foo:bar@tcp+localhost+1313"); // deprecated test("pgsql://user@unix+localhost/pear"); // deprecated test("ibase://user%40domain:password@host"); test("ibase://user@domain:pass@word@/database"); // also supported test("ifx://user@domain:pass@word@host.com//usr/db/general.db"); test('ifx://remote.host.com/c:\windows\my.db'); test('oci8://SHOOTOUT:******@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.101.161)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TIS)))'); // new formats test("odbc(solid)://foo:bar@localhost:1313"); test("pgsql://user@unix()/pear"); test("mysql://user@unix(/path/to/socket)/pear"); test("pgsql://user@tcp()/pear"); test("pgsql://user@tcp(somehost)/pear"); test("pgsql://user:pass@word@tcp(somehost:7777)/pear"); // special backend options test('ibase://user:pass@localhost//var/lib/dbase.dbf?role=foo'); test('dbase://@/?role=foo&dialect=bar'); test('sqlite:////unix/path/to/database?option=value&anotheroption=anothervalue'); test('sqlite:///c:/win/path/to/database?option=value'); // some examples from manual test('mysql://username@hostspec'); test('mysql://hostspec/database'); test('mysql://hostspec'); test('mysql:///database'); // array tests $array = array( 'phptype' => 'mysql', 'hostspec' => 'foobar', ); testArray($array); ?> --GET-- --POST-- --EXPECT-- testing DB::parseDSN... DSN: mysql Array ( [phptype] => mysql [dbsyntax] => mysql [username] => [password] => [protocol] => [hostspec] => [port] => [socket] => [database] => ) DSN: odbc(mssql) Array ( [phptype] => odbc [dbsyntax] => mssql [username] => [password] => [protocol] => [hostspec] => [port] => [socket] => [database] => ) DSN: odbc(db2)://user:password@/database Array ( [phptype] => odbc [dbsyntax] => db2 [username] => user [password] => password [protocol] => tcp [hostspec] => [port] => [socket] => [database] => database ) DSN: odbc(access):///database Array ( [phptype] => odbc [dbsyntax] => access [username] => [password] => [protocol] => tcp [hostspec] => [port] => [socket] => [database] => database ) DSN: odbc://admin@/datasourceName Array ( [phptype] => odbc [dbsyntax] => odbc [username] => admin [password] => [protocol] => tcp [hostspec] => [port] => [socket] => [database] => datasourceName ) DSN: mysql://localhost Array ( [phptype] => mysql [dbsyntax] => mysql [username] => [password] => [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => ) DSN: mysql://remote.host.com/db Array ( [phptype] => mysql [dbsyntax] => mysql [username] => [password] => [protocol] => tcp [hostspec] => remote.host.com [port] => [socket] => [database] => db ) DSN: oci8://system:manager@ Array ( [phptype] => oci8 [dbsyntax] => oci8 [username] => system [password] => manager [protocol] => tcp [hostspec] => [port] => [socket] => [database] => ) DSN: oci8://user:pass@tns-name Array ( [phptype] => oci8 [dbsyntax] => oci8 [username] => user [password] => pass [protocol] => tcp [hostspec] => tns-name [port] => [socket] => [database] => ) DSN: odbc(solid)://foo:bar@tcp+localhost+1313 Array ( [phptype] => odbc [dbsyntax] => solid [username] => foo [password] => bar [protocol] => tcp [hostspec] => localhost+1313 [port] => [socket] => [database] => ) DSN: pgsql://user@unix+localhost/pear Array ( [phptype] => pgsql [dbsyntax] => pgsql [username] => user [password] => [protocol] => unix [hostspec] => [port] => [socket] => localhost [database] => pear ) DSN: ibase://user%40domain:password@host Array ( [phptype] => ibase [dbsyntax] => ibase [username] => user@domain [password] => password [protocol] => tcp [hostspec] => host [port] => [socket] => [database] => ) DSN: ibase://user@domain:pass@word@/database Array ( [phptype] => ibase [dbsyntax] => ibase [username] => user@domain [password] => pass@word [protocol] => tcp [hostspec] => [port] => [socket] => [database] => database ) DSN: ifx://user@domain:pass@word@host.com//usr/db/general.db Array ( [phptype] => ifx [dbsyntax] => ifx [username] => user@domain [password] => pass@word [protocol] => tcp [hostspec] => host.com [port] => [socket] => [database] => /usr/db/general.db ) DSN: ifx://remote.host.com/c:\windows\my.db Array ( [phptype] => ifx [dbsyntax] => ifx [username] => [password] => [protocol] => tcp [hostspec] => remote.host.com [port] => [socket] => [database] => c:\windows\my.db ) DSN: oci8://SHOOTOUT:******@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.101.161)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TIS))) Array ( [phptype] => oci8 [dbsyntax] => oci8 [username] => SHOOTOUT [password] => ****** [protocol] => tcp [hostspec] => (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.101.161)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TIS))) [port] => [socket] => [database] => ) DSN: odbc(solid)://foo:bar@localhost:1313 Array ( [phptype] => odbc [dbsyntax] => solid [username] => foo [password] => bar [protocol] => tcp [hostspec] => localhost [port] => 1313 [socket] => [database] => ) DSN: pgsql://user@unix()/pear Array ( [phptype] => pgsql [dbsyntax] => pgsql [username] => user [password] => [protocol] => unix [hostspec] => [port] => [socket] => [database] => pear ) DSN: mysql://user@unix(/path/to/socket)/pear Array ( [phptype] => mysql [dbsyntax] => mysql [username] => user [password] => [protocol] => unix [hostspec] => [port] => [socket] => /path/to/socket [database] => pear ) DSN: pgsql://user@tcp()/pear Array ( [phptype] => pgsql [dbsyntax] => pgsql [username] => user [password] => [protocol] => tcp [hostspec] => [port] => [socket] => [database] => pear ) DSN: pgsql://user@tcp(somehost)/pear Array ( [phptype] => pgsql [dbsyntax] => pgsql [username] => user [password] => [protocol] => tcp [hostspec] => somehost [port] => [socket] => [database] => pear ) DSN: pgsql://user:pass@word@tcp(somehost:7777)/pear Array ( [phptype] => pgsql [dbsyntax] => pgsql [username] => user [password] => pass@word [protocol] => tcp [hostspec] => somehost [port] => 7777 [socket] => [database] => pear ) DSN: ibase://user:pass@localhost//var/lib/dbase.dbf?role=foo Array ( [phptype] => ibase [dbsyntax] => ibase [username] => user [password] => pass [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => /var/lib/dbase.dbf [role] => foo ) DSN: dbase://@/?role=foo&dialect=bar Array ( [phptype] => dbase [dbsyntax] => dbase [username] => [password] => [protocol] => tcp [hostspec] => [port] => [socket] => [database] => [role] => foo [dialect] => bar ) DSN: sqlite:////unix/path/to/database?option=value&anotheroption=anothervalue Array ( [phptype] => sqlite [dbsyntax] => sqlite [username] => [password] => [protocol] => tcp [hostspec] => [port] => [socket] => [database] => /unix/path/to/database [option] => value [anotheroption] => anothervalue ) DSN: sqlite:///c:/win/path/to/database?option=value Array ( [phptype] => sqlite [dbsyntax] => sqlite [username] => [password] => [protocol] => tcp [hostspec] => [port] => [socket] => [database] => c:/win/path/to/database [option] => value ) DSN: mysql://username@hostspec Array ( [phptype] => mysql [dbsyntax] => mysql [username] => username [password] => [protocol] => tcp [hostspec] => hostspec [port] => [socket] => [database] => ) DSN: mysql://hostspec/database Array ( [phptype] => mysql [dbsyntax] => mysql [username] => [password] => [protocol] => tcp [hostspec] => hostspec [port] => [socket] => [database] => database ) DSN: mysql://hostspec Array ( [phptype] => mysql [dbsyntax] => mysql [username] => [password] => [protocol] => tcp [hostspec] => hostspec [port] => [socket] => [database] => ) DSN: mysql:///database Array ( [phptype] => mysql [dbsyntax] => mysql [username] => [password] => [protocol] => tcp [hostspec] => [port] => [socket] => [database] => database ) DSN: array Array ( [phptype] => mysql [dbsyntax] => mysql [username] => [password] => [protocol] => [hostspec] => foobar [port] => [socket] => [database] => )