WebSVN – lars-tiefland.php_share – Blame – /tests/XML_Query2XML/tests/XML_Query2XML/AllDBLayers/getXML/case05.phpt

Revision	Autor	Zeilennr.	Zeile
1	lars	1	`--TEST--`
		2	`XML_Query2XML::getXML(): Case05`
		3	`--SKIPIF--`
		4	`<?php require_once dirname(dirname(__FILE__)) . '/skipif.php'; ?>`
		5	`--FILE--`
		6	`<?php`
		7	`require_once 'XML/Query2XML.php';`
		8	`require_once dirname(dirname(__FILE__)) . '/db_init.php';`
		9	`$query2xml = XML_Query2XML::factory($db);`
		10	`$dom = $query2xml->getXML(`
		11	`"SELECT`
		12	`*`
		13	`FROM`
		14	`customer c`
		15	`LEFT JOIN sale s ON c.customerid = s.customer_id`
		16	`LEFT JOIN album al ON s.album_id = al.albumid`
		17	`LEFT JOIN artist ar ON al.artist_id = ar.artistid`
		18	`ORDER BY`
		19	`c.customerid,`
		20	`s.saleid,`
		21	`al.albumid,`
		22	`ar.artistid",`
		23	`array(`
		24	`'rootTag' => 'music_store',`
		25	`'rowTag' => 'customer',`
		26	`'idColumn' => 'customerid',`
		27	`'elements' => array(`
		28	`'customerid',`
		29	`'first_name',`
		30	`'last_name',`
		31	`'email',`
		32	`'sales' => array(`
		33	`'rootTag' => 'sales',`
		34	`'rowTag' => 'sale',`
		35	`'idColumn' => 'saleid',`
		36	`'elements' => array(`
		37	`'saleid',`
		38	`'timestamp',`
		39	`'date' => '#Callbacks::getFirstWord()',`
		40	`'time' => '#Callbacks::getSecondWord()',`
		41	`'album' => array(`
		42	`'rootTag' => '',`
		43	`'rowTag' => 'album',`
		44	`'idColumn' => 'albumid',`
		45	`'elements' => array(`
		46	`'albumid',`
		47	`'title',`
		48	`'published_year',`
		49	`'comment',`
		50	`'artist' => array(`
		51	`'rootTag' => '',`
		52	`'rowTag' => 'artist',`
		53	`'idColumn' => 'artistid',`
		54	`'elements' => array(`
		55	`'artistid',`
		56	`'name',`
		57	`'birth_year',`
		58	`'birth_place',`
		59	`'genre'`
		60	`) //artist elements`
		61	`) //artist array`
		62	`) //album elements`
		63	`) //album array`
		64	`) //sales elements`
		65	`) //sales array`
		66	`) //root elements`
		67	`) //root`
		68	`); //getXML method call`
		69
		70	`$root = $dom->firstChild;`
		71	`$root->setAttribute('date_generated', '2005-08-23T14:52:50');`
		72
		73	`header('Content-Type: application/xml');`
		74
		75	`$dom->formatOutput = true;`
		76	`print $dom->saveXML();`
		77
		78	`class Callbacks`
		79	`{`
		80	`function getFirstWord($record)`
		81	`{`
		82	`return substr($record['timestamp'], 0, strpos($record['timestamp'], ' '));`
		83	`}`
		84
		85	`function getSecondWord($record)`
		86	`{`
		87	`return substr($record['timestamp'], strpos($record['timestamp'], ' ') + 1);`
		88	`}`
		89	`}`
		90	`?>`
		91	`--EXPECT--`
		92	`<?xml version="1.0" encoding="UTF-8"?>`
		93	`<music_store date_generated="2005-08-23T14:52:50">`
		94	`<customer>`
		95	`<customerid>1</customerid>`
		96	`<first_name>Jane</first_name>`
		97	`<last_name>Doe</last_name>`
		98	`<email>jane.doe@example.com</email>`
		99	`<sales>`
		100	`<sale>`
		101	`<saleid>1</saleid>`
		102	`<timestamp>2005-05-25 16:32:00</timestamp>`
		103	`<date>2005-05-25</date>`
		104	`<time>16:32:00</time>`
		105	`<album>`
		106	`<albumid>1</albumid>`
		107	`<title>New World Order</title>`
		108	`<published_year>1990</published_year>`
		109	`<comment>the best ever!</comment>`
		110	`<artist>`
		111	`<artistid>1</artistid>`
		112	`<name>Curtis Mayfield</name>`
		113	`<birth_year>1920</birth_year>`
		114	`<birth_place>Chicago</birth_place>`
		115	`<genre>Soul</genre>`
		116	`</artist>`
		117	`</album>`
		118	`</sale>`
		119	`<sale>`
		120	`<saleid>11</saleid>`
		121	`<timestamp>2005-05-25 16:23:00</timestamp>`
		122	`<date>2005-05-25</date>`
		123	`<time>16:23:00</time>`
		124	`<album>`
		125	`<albumid>2</albumid>`
		126	`<title>Curtis</title>`
		127	`<published_year>1970</published_year>`
		128	`<comment>that man's got somthin' to say</comment>`
		129	`<artist>`
		130	`<artistid>1</artistid>`
		131	`<name>Curtis Mayfield</name>`
		132	`<birth_year>1920</birth_year>`
		133	`<birth_place>Chicago</birth_place>`
		134	`<genre>Soul</genre>`
		135	`</artist>`
		136	`</album>`
		137	`</sale>`
		138	`</sales>`
		139	`</customer>`
		140	`<customer>`
		141	`<customerid>2</customerid>`
		142	`<first_name>John</first_name>`
		143	`<last_name>Doe</last_name>`
		144	`<email>john.doe@example.com</email>`
		145	`<sales>`
		146	`<sale>`
		147	`<saleid>2</saleid>`
		148	`<timestamp>2005-06-05 12:56:00</timestamp>`
		149	`<date>2005-06-05</date>`
		150	`<time>12:56:00</time>`
		151	`<album>`
		152	`<albumid>1</albumid>`
		153	`<title>New World Order</title>`
		154	`<published_year>1990</published_year>`
		155	`<comment>the best ever!</comment>`
		156	`<artist>`
		157	`<artistid>1</artistid>`
		158	`<name>Curtis Mayfield</name>`
		159	`<birth_year>1920</birth_year>`
		160	`<birth_place>Chicago</birth_place>`
		161	`<genre>Soul</genre>`
		162	`</artist>`
		163	`</album>`
		164	`</sale>`
		165	`<sale>`
		166	`<saleid>16</saleid>`
		167	`<timestamp>2005-06-05 12:56:12</timestamp>`
		168	`<date>2005-06-05</date>`
		169	`<time>12:56:12</time>`
		170	`<album>`
		171	`<albumid>3</albumid>`
		172	`<title>Shaft</title>`
		173	`<published_year>1972</published_year>`
		174	`<comment>he's the man</comment>`
		175	`<artist>`
		176	`<artistid>2</artistid>`
		177	`<name>Isaac Hayes</name>`
		178	`<birth_year>1942</birth_year>`
		179	`<birth_place>Tennessee</birth_place>`
		180	`<genre>Soul</genre>`
		181	`</artist>`
		182	`</album>`
		183	`</sale>`
		184	`</sales>`
		185	`</customer>`
		186	`<customer>`
		187	`<customerid>3</customerid>`
		188	`<first_name>Susan</first_name>`
		189	`<last_name>Green</last_name>`
		190	`<email>susan.green@example.com</email>`
		191	`<sales>`
		192	`<sale>`
		193	`<saleid>3</saleid>`
		194	`<timestamp>2005-07-10 11:03:00</timestamp>`
		195	`<date>2005-07-10</date>`
		196	`<time>11:03:00</time>`
		197	`<album>`
		198	`<albumid>1</albumid>`
		199	`<title>New World Order</title>`
		200	`<published_year>1990</published_year>`
		201	`<comment>the best ever!</comment>`
		202	`<artist>`
		203	`<artistid>1</artistid>`
		204	`<name>Curtis Mayfield</name>`
		205	`<birth_year>1920</birth_year>`
		206	`<birth_place>Chicago</birth_place>`
		207	`<genre>Soul</genre>`
		208	`</artist>`
		209	`</album>`
		210	`</sale>`
		211	`<sale>`
		212	`<saleid>12</saleid>`
		213	`<timestamp>2005-07-10 11:56:00</timestamp>`
		214	`<date>2005-07-10</date>`
		215	`<time>11:56:00</time>`
		216	`<album>`
		217	`<albumid>2</albumid>`
		218	`<title>Curtis</title>`
		219	`<published_year>1970</published_year>`
		220	`<comment>that man's got somthin' to say</comment>`
		221	`<artist>`
		222	`<artistid>1</artistid>`
		223	`<name>Curtis Mayfield</name>`
		224	`<birth_year>1920</birth_year>`
		225	`<birth_place>Chicago</birth_place>`
		226	`<genre>Soul</genre>`
		227	`</artist>`
		228	`</album>`
		229	`</sale>`
		230	`</sales>`
		231	`</customer>`
		232	`<customer>`
		233	`<customerid>4</customerid>`
		234	`<first_name>Victoria</first_name>`
		235	`<last_name>Alt</last_name>`
		236	`<email>victory.alt@example.com</email>`
		237	`<sales>`
		238	`<sale>`
		239	`<saleid>4</saleid>`
		240	`<timestamp>2005-07-10 10:03:00</timestamp>`
		241	`<date>2005-07-10</date>`
		242	`<time>10:03:00</time>`
		243	`<album>`
		244	`<albumid>1</albumid>`
		245	`<title>New World Order</title>`
		246	`<published_year>1990</published_year>`
		247	`<comment>the best ever!</comment>`
		248	`<artist>`
		249	`<artistid>1</artistid>`
		250	`<name>Curtis Mayfield</name>`
		251	`<birth_year>1920</birth_year>`
		252	`<birth_place>Chicago</birth_place>`
		253	`<genre>Soul</genre>`
		254	`</artist>`
		255	`</album>`
		256	`</sale>`
		257	`<sale>`
		258	`<saleid>17</saleid>`
		259	`<timestamp>2005-07-10 10:03:32</timestamp>`
		260	`<date>2005-07-10</date>`
		261	`<time>10:03:32</time>`
		262	`<album>`
		263	`<albumid>3</albumid>`
		264	`<title>Shaft</title>`
		265	`<published_year>1972</published_year>`
		266	`<comment>he's the man</comment>`
		267	`<artist>`
		268	`<artistid>2</artistid>`
		269	`<name>Isaac Hayes</name>`
		270	`<birth_year>1942</birth_year>`
		271	`<birth_place>Tennessee</birth_place>`
		272	`<genre>Soul</genre>`
		273	`</artist>`
		274	`</album>`
		275	`</sale>`
		276	`</sales>`
		277	`</customer>`
		278	`<customer>`
		279	`<customerid>5</customerid>`
		280	`<first_name>Will</first_name>`
		281	`<last_name>Rippy</last_name>`
		282	`<email>will.wippy@example.com</email>`
		283	`<sales>`
		284	`<sale>`
		285	`<saleid>5</saleid>`
		286	`<timestamp>2005-07-10 13:03:00</timestamp>`
		287	`<date>2005-07-10</date>`
		288	`<time>13:03:00</time>`
		289	`<album>`
		290	`<albumid>1</albumid>`
		291	`<title>New World Order</title>`
		292	`<published_year>1990</published_year>`
		293	`<comment>the best ever!</comment>`
		294	`<artist>`
		295	`<artistid>1</artistid>`
		296	`<name>Curtis Mayfield</name>`
		297	`<birth_year>1920</birth_year>`
		298	`<birth_place>Chicago</birth_place>`
		299	`<genre>Soul</genre>`
		300	`</artist>`
		301	`</album>`
		302	`</sale>`
		303	`<sale>`
		304	`<saleid>13</saleid>`
		305	`<timestamp>2005-07-10 13:12:00</timestamp>`
		306	`<date>2005-07-10</date>`
		307	`<time>13:12:00</time>`
		308	`<album>`
		309	`<albumid>2</albumid>`
		310	`<title>Curtis</title>`
		311	`<published_year>1970</published_year>`
		312	`<comment>that man's got somthin' to say</comment>`
		313	`<artist>`
		314	`<artistid>1</artistid>`
		315	`<name>Curtis Mayfield</name>`
		316	`<birth_year>1920</birth_year>`
		317	`<birth_place>Chicago</birth_place>`
		318	`<genre>Soul</genre>`
		319	`</artist>`
		320	`</album>`
		321	`</sale>`
		322	`</sales>`
		323	`</customer>`
		324	`<customer>`
		325	`<customerid>6</customerid>`
		326	`<first_name>Tim</first_name>`
		327	`<last_name>Raw</last_name>`
		328	`<email>tim.raw@example.com</email>`
		329	`<sales>`
		330	`<sale>`
		331	`<saleid>6</saleid>`
		332	`<timestamp>2005-07-10 14:03:00</timestamp>`
		333	`<date>2005-07-10</date>`
		334	`<time>14:03:00</time>`
		335	`<album>`
		336	`<albumid>1</albumid>`
		337	`<title>New World Order</title>`
		338	`<published_year>1990</published_year>`
		339	`<comment>the best ever!</comment>`
		340	`<artist>`
		341	`<artistid>1</artistid>`
		342	`<name>Curtis Mayfield</name>`
		343	`<birth_year>1920</birth_year>`
		344	`<birth_place>Chicago</birth_place>`
		345	`<genre>Soul</genre>`
		346	`</artist>`
		347	`</album>`
		348	`</sale>`
		349	`<sale>`
		350	`<saleid>18</saleid>`
		351	`<timestamp>2005-07-10 14:03:52</timestamp>`
		352	`<date>2005-07-10</date>`
		353	`<time>14:03:52</time>`
		354	`<album>`
		355	`<albumid>3</albumid>`
		356	`<title>Shaft</title>`
		357	`<published_year>1972</published_year>`
		358	`<comment>he's the man</comment>`
		359	`<artist>`
		360	`<artistid>2</artistid>`
		361	`<name>Isaac Hayes</name>`
		362	`<birth_year>1942</birth_year>`
		363	`<birth_place>Tennessee</birth_place>`
		364	`<genre>Soul</genre>`
		365	`</artist>`
		366	`</album>`
		367	`</sale>`
		368	`</sales>`
		369	`</customer>`
		370	`<customer>`
		371	`<customerid>7</customerid>`
		372	`<first_name>Nick</first_name>`
		373	`<last_name>Fallow</last_name>`
		374	`<email>nick.fallow@example.com</email>`
		375	`<sales>`
		376	`<sale>`
		377	`<saleid>7</saleid>`
		378	`<timestamp>2005-07-10 15:03:00</timestamp>`
		379	`<date>2005-07-10</date>`
		380	`<time>15:03:00</time>`
		381	`<album>`
		382	`<albumid>1</albumid>`
		383	`<title>New World Order</title>`
		384	`<published_year>1990</published_year>`
		385	`<comment>the best ever!</comment>`
		386	`<artist>`
		387	`<artistid>1</artistid>`
		388	`<name>Curtis Mayfield</name>`
		389	`<birth_year>1920</birth_year>`
		390	`<birth_place>Chicago</birth_place>`
		391	`<genre>Soul</genre>`
		392	`</artist>`
		393	`</album>`
		394	`</sale>`
		395	`<sale>`
		396	`<saleid>14</saleid>`
		397	`<timestamp>2005-07-10 15:09:00</timestamp>`
		398	`<date>2005-07-10</date>`
		399	`<time>15:09:00</time>`
		400	`<album>`
		401	`<albumid>2</albumid>`
		402	`<title>Curtis</title>`
		403	`<published_year>1970</published_year>`
		404	`<comment>that man's got somthin' to say</comment>`
		405	`<artist>`
		406	`<artistid>1</artistid>`
		407	`<name>Curtis Mayfield</name>`
		408	`<birth_year>1920</birth_year>`
		409	`<birth_place>Chicago</birth_place>`
		410	`<genre>Soul</genre>`
		411	`</artist>`
		412	`</album>`
		413	`</sale>`
		414	`</sales>`
		415	`</customer>`
		416	`<customer>`
		417	`<customerid>8</customerid>`
		418	`<first_name>Ed</first_name>`
		419	`<last_name>Burton</last_name>`
		420	`<email>ed.burton@example.com</email>`
		421	`<sales>`
		422	`<sale>`
		423	`<saleid>8</saleid>`
		424	`<timestamp>2005-07-10 16:03:00</timestamp>`
		425	`<date>2005-07-10</date>`
		426	`<time>16:03:00</time>`
		427	`<album>`
		428	`<albumid>1</albumid>`
		429	`<title>New World Order</title>`
		430	`<published_year>1990</published_year>`
		431	`<comment>the best ever!</comment>`
		432	`<artist>`
		433	`<artistid>1</artistid>`
		434	`<name>Curtis Mayfield</name>`
		435	`<birth_year>1920</birth_year>`
		436	`<birth_place>Chicago</birth_place>`
		437	`<genre>Soul</genre>`
		438	`</artist>`
		439	`</album>`
		440	`</sale>`
		441	`<sale>`
		442	`<saleid>19</saleid>`
		443	`<timestamp>2005-07-10 16:03:01</timestamp>`
		444	`<date>2005-07-10</date>`
		445	`<time>16:03:01</time>`
		446	`<album>`
		447	`<albumid>3</albumid>`
		448	`<title>Shaft</title>`
		449	`<published_year>1972</published_year>`
		450	`<comment>he's the man</comment>`
		451	`<artist>`
		452	`<artistid>2</artistid>`
		453	`<name>Isaac Hayes</name>`
		454	`<birth_year>1942</birth_year>`
		455	`<birth_place>Tennessee</birth_place>`
		456	`<genre>Soul</genre>`
		457	`</artist>`
		458	`</album>`
		459	`</sale>`
		460	`</sales>`
		461	`</customer>`
		462	`<customer>`
		463	`<customerid>9</customerid>`
		464	`<first_name>Jack</first_name>`
		465	`<last_name>Woo</last_name>`
		466	`<email>jack.woo@example.com</email>`
		467	`<sales>`
		468	`<sale>`
		469	`<saleid>9</saleid>`
		470	`<timestamp>2005-07-10 18:03:00</timestamp>`
		471	`<date>2005-07-10</date>`
		472	`<time>18:03:00</time>`
		473	`<album>`
		474	`<albumid>1</albumid>`
		475	`<title>New World Order</title>`
		476	`<published_year>1990</published_year>`
		477	`<comment>the best ever!</comment>`
		478	`<artist>`
		479	`<artistid>1</artistid>`
		480	`<name>Curtis Mayfield</name>`
		481	`<birth_year>1920</birth_year>`
		482	`<birth_place>Chicago</birth_place>`
		483	`<genre>Soul</genre>`
		484	`</artist>`
		485	`</album>`
		486	`</sale>`
		487	`<sale>`
		488	`<saleid>15</saleid>`
		489	`<timestamp>2005-07-10 18:49:00</timestamp>`
		490	`<date>2005-07-10</date>`
		491	`<time>18:49:00</time>`
		492	`<album>`
		493	`<albumid>2</albumid>`
		494	`<title>Curtis</title>`
		495	`<published_year>1970</published_year>`
		496	`<comment>that man's got somthin' to say</comment>`
		497	`<artist>`
		498	`<artistid>1</artistid>`
		499	`<name>Curtis Mayfield</name>`
		500	`<birth_year>1920</birth_year>`
		501	`<birth_place>Chicago</birth_place>`
		502	`<genre>Soul</genre>`
		503	`</artist>`
		504	`</album>`
		505	`</sale>`
		506	`</sales>`
		507	`</customer>`
		508	`<customer>`
		509	`<customerid>10</customerid>`
		510	`<first_name>Maria</first_name>`
		511	`<last_name>Gonzales</last_name>`
		512	`<email>maria.gonzales@example.com</email>`
		513	`<sales>`
		514	`<sale>`
		515	`<saleid>10</saleid>`
		516	`<timestamp>2005-07-10 19:03:00</timestamp>`
		517	`<date>2005-07-10</date>`
		518	`<time>19:03:00</time>`
		519	`<album>`
		520	`<albumid>1</albumid>`
		521	`<title>New World Order</title>`
		522	`<published_year>1990</published_year>`
		523	`<comment>the best ever!</comment>`
		524	`<artist>`
		525	`<artistid>1</artistid>`
		526	`<name>Curtis Mayfield</name>`
		527	`<birth_year>1920</birth_year>`
		528	`<birth_place>Chicago</birth_place>`
		529	`<genre>Soul</genre>`
		530	`</artist>`
		531	`</album>`
		532	`</sale>`
		533	`<sale>`
		534	`<saleid>20</saleid>`
		535	`<timestamp>2005-07-10 19:03:50</timestamp>`
		536	`<date>2005-07-10</date>`
		537	`<time>19:03:50</time>`
		538	`<album>`
		539	`<albumid>3</albumid>`
		540	`<title>Shaft</title>`
		541	`<published_year>1972</published_year>`
		542	`<comment>he's the man</comment>`
		543	`<artist>`
		544	`<artistid>2</artistid>`
		545	`<name>Isaac Hayes</name>`
		546	`<birth_year>1942</birth_year>`
		547	`<birth_place>Tennessee</birth_place>`
		548	`<genre>Soul</genre>`
		549	`</artist>`
		550	`</album>`
		551	`</sale>`
		552	`</sales>`
		553	`</customer>`
		554	`</music_store>`

Subversion-Projekte lars-tiefland.php_share

(root)/tests/XML_Query2XML/tests/XML_Query2XML/AllDBLayers/getXML/case05.phpt – Revision 1