WebSVN – lars-tiefland.php_share – Blame – /tests/db_parsedsn.phpt

Revision	Autor	Zeilennr.	Zeile
1	lars	1	`--TEST--`
		2	`DB::parseDSN`
		3	`--SKIPIF--`
		4	`<?php chdir(dirname(__FILE__)); require_once './skipif.inc'; ?>`
		5	`--FILE--`
		6	`<?php // -- C++ --`
		7	`require_once './include.inc';`
		8	`require_once 'DB.php';`
		9
		10	`function test($dsn) {`
		11	`echo "DSN: $dsn\n";`
		12	`print_r(DB::parseDSN($dsn));`
		13	`}`
		14
		15	`function testArray($dsn) {`
		16	`echo "DSN: array\n";`
		17	`print_r(DB::parseDSN($dsn));`
		18	`}`
		19
		20	`print "testing DB::parseDSN...\n\n";`
		21
		22	`test("mysql");`
		23	`test("odbc(mssql)");`
		24	`test('odbc(db2)://user:password@/database');`
		25	`test('odbc(access):///database');`
		26	`test('odbc://admin@/datasourceName');`
		27	`test("mysql://localhost");`
		28	`test("mysql://remote.host.com/db");`
		29	`test("oci8://system:manager@");`
		30	`test("oci8://user:pass@tns-name");`
		31	`test("odbc(solid)://foo:bar@tcp+localhost+1313"); // deprecated`
		32	`test("pgsql://user@unix+localhost/pear"); // deprecated`
		33	`test("ibase://user%40domain:password@host");`
		34	`test("ibase://user@domain:pass@word@/database"); // also supported`
		35	`test("ifx://user@domain:pass@word@host.com//usr/db/general.db");`
		36	`test('ifx://remote.host.com/c:\windows\my.db');`
		37	`test('oci8://SHOOTOUT:******@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.101.161)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TIS)))');`
		38
		39	`// new formats`
		40	`test("odbc(solid)://foo:bar@localhost:1313");`
		41	`test("pgsql://user@unix()/pear");`
		42	`test("mysql://user@unix(/path/to/socket)/pear");`
		43	`test("pgsql://user@tcp()/pear");`
		44	`test("pgsql://user@tcp(somehost)/pear");`
		45	`test("pgsql://user:pass@word@tcp(somehost:7777)/pear");`
		46
		47	`// special backend options`
		48	`test('ibase://user:pass@localhost//var/lib/dbase.dbf?role=foo');`
		49	`test('dbase://@/?role=foo&dialect=bar');`
		50	`test('sqlite:////unix/path/to/database?option=value&anotheroption=anothervalue');`
		51	`test('sqlite:///c:/win/path/to/database?option=value');`
		52
		53	`// some examples from manual`
		54	`test('mysql://username@hostspec');`
		55	`test('mysql://hostspec/database');`
		56	`test('mysql://hostspec');`
		57	`test('mysql:///database');`
		58
		59	`// array tests`
		60	`$array = array(`
		61	`'phptype' => 'mysql',`
		62	`'hostspec' => 'foobar',`
		63	`);`
		64	`testArray($array);`
		65
		66	`?>`
		67	`--GET--`
		68	`--POST--`
		69	`--EXPECT--`
		70	`testing DB::parseDSN...`
		71
		72	`DSN: mysql`
		73	`Array`
		74	`(`
		75	`[phptype] => mysql`
		76	`[dbsyntax] => mysql`
		77	`[username] =>`
		78	`[password] =>`
		79	`[protocol] =>`
		80	`[hostspec] =>`
		81	`[port] =>`
		82	`[socket] =>`
		83	`[database] =>`
		84	`)`
		85	`DSN: odbc(mssql)`
		86	`Array`
		87	`(`
		88	`[phptype] => odbc`
		89	`[dbsyntax] => mssql`
		90	`[username] =>`
		91	`[password] =>`
		92	`[protocol] =>`
		93	`[hostspec] =>`
		94	`[port] =>`
		95	`[socket] =>`
		96	`[database] =>`
		97	`)`
		98	`DSN: odbc(db2)://user:password@/database`
		99	`Array`
		100	`(`
		101	`[phptype] => odbc`
		102	`[dbsyntax] => db2`
		103	`[username] => user`
		104	`[password] => password`
		105	`[protocol] => tcp`
		106	`[hostspec] =>`
		107	`[port] =>`
		108	`[socket] =>`
		109	`[database] => database`
		110	`)`
		111	`DSN: odbc(access):///database`
		112	`Array`
		113	`(`
		114	`[phptype] => odbc`
		115	`[dbsyntax] => access`
		116	`[username] =>`
		117	`[password] =>`
		118	`[protocol] => tcp`
		119	`[hostspec] =>`
		120	`[port] =>`
		121	`[socket] =>`
		122	`[database] => database`
		123	`)`
		124	`DSN: odbc://admin@/datasourceName`
		125	`Array`
		126	`(`
		127	`[phptype] => odbc`
		128	`[dbsyntax] => odbc`
		129	`[username] => admin`
		130	`[password] =>`
		131	`[protocol] => tcp`
		132	`[hostspec] =>`
		133	`[port] =>`
		134	`[socket] =>`
		135	`[database] => datasourceName`
		136	`)`
		137	`DSN: mysql://localhost`
		138	`Array`
		139	`(`
		140	`[phptype] => mysql`
		141	`[dbsyntax] => mysql`
		142	`[username] =>`
		143	`[password] =>`
		144	`[protocol] => tcp`
		145	`[hostspec] => localhost`
		146	`[port] =>`
		147	`[socket] =>`
		148	`[database] =>`
		149	`)`
		150	`DSN: mysql://remote.host.com/db`
		151	`Array`
		152	`(`
		153	`[phptype] => mysql`
		154	`[dbsyntax] => mysql`
		155	`[username] =>`
		156	`[password] =>`
		157	`[protocol] => tcp`
		158	`[hostspec] => remote.host.com`
		159	`[port] =>`
		160	`[socket] =>`
		161	`[database] => db`
		162	`)`
		163	`DSN: oci8://system:manager@`
		164	`Array`
		165	`(`
		166	`[phptype] => oci8`
		167	`[dbsyntax] => oci8`
		168	`[username] => system`
		169	`[password] => manager`
		170	`[protocol] => tcp`
		171	`[hostspec] =>`
		172	`[port] =>`
		173	`[socket] =>`
		174	`[database] =>`
		175	`)`
		176	`DSN: oci8://user:pass@tns-name`
		177	`Array`
		178	`(`
		179	`[phptype] => oci8`
		180	`[dbsyntax] => oci8`
		181	`[username] => user`
		182	`[password] => pass`
		183	`[protocol] => tcp`
		184	`[hostspec] => tns-name`
		185	`[port] =>`
		186	`[socket] =>`
		187	`[database] =>`
		188	`)`
		189	`DSN: odbc(solid)://foo:bar@tcp+localhost+1313`
		190	`Array`
		191	`(`
		192	`[phptype] => odbc`
		193	`[dbsyntax] => solid`
		194	`[username] => foo`
		195	`[password] => bar`
		196	`[protocol] => tcp`
		197	`[hostspec] => localhost+1313`
		198	`[port] =>`
		199	`[socket] =>`
		200	`[database] =>`
		201	`)`
		202	`DSN: pgsql://user@unix+localhost/pear`
		203	`Array`
		204	`(`
		205	`[phptype] => pgsql`
		206	`[dbsyntax] => pgsql`
		207	`[username] => user`
		208	`[password] =>`
		209	`[protocol] => unix`
		210	`[hostspec] =>`
		211	`[port] =>`
		212	`[socket] => localhost`
		213	`[database] => pear`
		214	`)`
		215	`DSN: ibase://user%40domain:password@host`
		216	`Array`
		217	`(`
		218	`[phptype] => ibase`
		219	`[dbsyntax] => ibase`
		220	`[username] => user@domain`
		221	`[password] => password`
		222	`[protocol] => tcp`
		223	`[hostspec] => host`
		224	`[port] =>`
		225	`[socket] =>`
		226	`[database] =>`
		227	`)`
		228	`DSN: ibase://user@domain:pass@word@/database`
		229	`Array`
		230	`(`
		231	`[phptype] => ibase`
		232	`[dbsyntax] => ibase`
		233	`[username] => user@domain`
		234	`[password] => pass@word`
		235	`[protocol] => tcp`
		236	`[hostspec] =>`
		237	`[port] =>`
		238	`[socket] =>`
		239	`[database] => database`
		240	`)`
		241	`DSN: ifx://user@domain:pass@word@host.com//usr/db/general.db`
		242	`Array`
		243	`(`
		244	`[phptype] => ifx`
		245	`[dbsyntax] => ifx`
		246	`[username] => user@domain`
		247	`[password] => pass@word`
		248	`[protocol] => tcp`
		249	`[hostspec] => host.com`
		250	`[port] =>`
		251	`[socket] =>`
		252	`[database] => /usr/db/general.db`
		253	`)`
		254	`DSN: ifx://remote.host.com/c:\windows\my.db`
		255	`Array`
		256	`(`
		257	`[phptype] => ifx`
		258	`[dbsyntax] => ifx`
		259	`[username] =>`
		260	`[password] =>`
		261	`[protocol] => tcp`
		262	`[hostspec] => remote.host.com`
		263	`[port] =>`
		264	`[socket] =>`
		265	`[database] => c:\windows\my.db`
		266	`)`
		267	`DSN: oci8://SHOOTOUT:******@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.101.161)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TIS)))`
		268	`Array`
		269	`(`
		270	`[phptype] => oci8`
		271	`[dbsyntax] => oci8`
		272	`[username] => SHOOTOUT`
		273	`[password] => ******`
		274	`[protocol] => tcp`
		275	`[hostspec] => (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.101.161)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TIS)))`
		276	`[port] =>`
		277	`[socket] =>`
		278	`[database] =>`
		279	`)`
		280	`DSN: odbc(solid)://foo:bar@localhost:1313`
		281	`Array`
		282	`(`
		283	`[phptype] => odbc`
		284	`[dbsyntax] => solid`
		285	`[username] => foo`
		286	`[password] => bar`
		287	`[protocol] => tcp`
		288	`[hostspec] => localhost`
		289	`[port] => 1313`
		290	`[socket] =>`
		291	`[database] =>`
		292	`)`
		293	`DSN: pgsql://user@unix()/pear`
		294	`Array`
		295	`(`
		296	`[phptype] => pgsql`
		297	`[dbsyntax] => pgsql`
		298	`[username] => user`
		299	`[password] =>`
		300	`[protocol] => unix`
		301	`[hostspec] =>`
		302	`[port] =>`
		303	`[socket] =>`
		304	`[database] => pear`
		305	`)`
		306	`DSN: mysql://user@unix(/path/to/socket)/pear`
		307	`Array`
		308	`(`
		309	`[phptype] => mysql`
		310	`[dbsyntax] => mysql`
		311	`[username] => user`
		312	`[password] =>`
		313	`[protocol] => unix`
		314	`[hostspec] =>`
		315	`[port] =>`
		316	`[socket] => /path/to/socket`
		317	`[database] => pear`
		318	`)`
		319	`DSN: pgsql://user@tcp()/pear`
		320	`Array`
		321	`(`
		322	`[phptype] => pgsql`
		323	`[dbsyntax] => pgsql`
		324	`[username] => user`
		325	`[password] =>`
		326	`[protocol] => tcp`
		327	`[hostspec] =>`
		328	`[port] =>`
		329	`[socket] =>`
		330	`[database] => pear`
		331	`)`
		332	`DSN: pgsql://user@tcp(somehost)/pear`
		333	`Array`
		334	`(`
		335	`[phptype] => pgsql`
		336	`[dbsyntax] => pgsql`
		337	`[username] => user`
		338	`[password] =>`
		339	`[protocol] => tcp`
		340	`[hostspec] => somehost`
		341	`[port] =>`
		342	`[socket] =>`
		343	`[database] => pear`
		344	`)`
		345	`DSN: pgsql://user:pass@word@tcp(somehost:7777)/pear`
		346	`Array`
		347	`(`
		348	`[phptype] => pgsql`
		349	`[dbsyntax] => pgsql`
		350	`[username] => user`
		351	`[password] => pass@word`
		352	`[protocol] => tcp`
		353	`[hostspec] => somehost`
		354	`[port] => 7777`
		355	`[socket] =>`
		356	`[database] => pear`
		357	`)`
		358	`DSN: ibase://user:pass@localhost//var/lib/dbase.dbf?role=foo`
		359	`Array`
		360	`(`
		361	`[phptype] => ibase`
		362	`[dbsyntax] => ibase`
		363	`[username] => user`
		364	`[password] => pass`
		365	`[protocol] => tcp`
		366	`[hostspec] => localhost`
		367	`[port] =>`
		368	`[socket] =>`
		369	`[database] => /var/lib/dbase.dbf`
		370	`[role] => foo`
		371	`)`
		372	`DSN: dbase://@/?role=foo&dialect=bar`
		373	`Array`
		374	`(`
		375	`[phptype] => dbase`
		376	`[dbsyntax] => dbase`
		377	`[username] =>`
		378	`[password] =>`
		379	`[protocol] => tcp`
		380	`[hostspec] =>`
		381	`[port] =>`
		382	`[socket] =>`
		383	`[database] =>`
		384	`[role] => foo`
		385	`[dialect] => bar`
		386	`)`
		387	`DSN: sqlite:////unix/path/to/database?option=value&anotheroption=anothervalue`
		388	`Array`
		389	`(`
		390	`[phptype] => sqlite`
		391	`[dbsyntax] => sqlite`
		392	`[username] =>`
		393	`[password] =>`
		394	`[protocol] => tcp`
		395	`[hostspec] =>`
		396	`[port] =>`
		397	`[socket] =>`
		398	`[database] => /unix/path/to/database`
		399	`[option] => value`
		400	`[anotheroption] => anothervalue`
		401	`)`
		402	`DSN: sqlite:///c:/win/path/to/database?option=value`
		403	`Array`
		404	`(`
		405	`[phptype] => sqlite`
		406	`[dbsyntax] => sqlite`
		407	`[username] =>`
		408	`[password] =>`
		409	`[protocol] => tcp`
		410	`[hostspec] =>`
		411	`[port] =>`
		412	`[socket] =>`
		413	`[database] => c:/win/path/to/database`
		414	`[option] => value`
		415	`)`
		416	`DSN: mysql://username@hostspec`
		417	`Array`
		418	`(`
		419	`[phptype] => mysql`
		420	`[dbsyntax] => mysql`
		421	`[username] => username`
		422	`[password] =>`
		423	`[protocol] => tcp`
		424	`[hostspec] => hostspec`
		425	`[port] =>`
		426	`[socket] =>`
		427	`[database] =>`
		428	`)`
		429	`DSN: mysql://hostspec/database`
		430	`Array`
		431	`(`
		432	`[phptype] => mysql`
		433	`[dbsyntax] => mysql`
		434	`[username] =>`
		435	`[password] =>`
		436	`[protocol] => tcp`
		437	`[hostspec] => hostspec`
		438	`[port] =>`
		439	`[socket] =>`
		440	`[database] => database`
		441	`)`
		442	`DSN: mysql://hostspec`
		443	`Array`
		444	`(`
		445	`[phptype] => mysql`
		446	`[dbsyntax] => mysql`
		447	`[username] =>`
		448	`[password] =>`
		449	`[protocol] => tcp`
		450	`[hostspec] => hostspec`
		451	`[port] =>`
		452	`[socket] =>`
		453	`[database] =>`
		454	`)`
		455	`DSN: mysql:///database`
		456	`Array`
		457	`(`
		458	`[phptype] => mysql`
		459	`[dbsyntax] => mysql`
		460	`[username] =>`
		461	`[password] =>`
		462	`[protocol] => tcp`
		463	`[hostspec] =>`
		464	`[port] =>`
		465	`[socket] =>`
		466	`[database] => database`
		467	`)`
		468	`DSN: array`
		469	`Array`
		470	`(`
		471	`[phptype] => mysql`
		472	`[dbsyntax] => mysql`
		473	`[username] =>`
		474	`[password] =>`
		475	`[protocol] =>`
		476	`[hostspec] => foobar`
		477	`[port] =>`
		478	`[socket] =>`
		479	`[database] =>`
		480	`)`

Subversion-Projekte lars-tiefland.php_share

(root)/tests/db_parsedsn.phpt – Revision 1