| 1 |
lars |
1 |
--TEST--
|
|
|
2 |
XML_Query2XML::getXML(): simple element - condition prefix with column name
|
|
|
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 |
artist.*,
|
|
|
13 |
album.*,
|
|
|
14 |
'' AS test
|
|
|
15 |
FROM
|
|
|
16 |
artist
|
|
|
17 |
LEFT JOIN album ON album.artist_id = artist.artistid
|
|
|
18 |
ORDER BY
|
|
|
19 |
artistid,
|
|
|
20 |
albumid",
|
|
|
21 |
array(
|
|
|
22 |
'rootTag' => 'music_library',
|
|
|
23 |
'rowTag' => 'artist',
|
|
|
24 |
'idColumn' => 'artistid',
|
|
|
25 |
'elements' => array(
|
|
|
26 |
'artistid',
|
|
|
27 |
'name',
|
|
|
28 |
'birth_year',
|
|
|
29 |
'birth_place',
|
|
|
30 |
'genre',
|
|
|
31 |
'albums' => array(
|
|
|
32 |
'rootTag' => 'albums',
|
|
|
33 |
'rowTag' => 'album',
|
|
|
34 |
'idColumn' => 'albumid',
|
|
|
35 |
'elements' => array(
|
|
|
36 |
'albumid',
|
|
|
37 |
'title',
|
|
|
38 |
'published_year',
|
|
|
39 |
'comment',
|
|
|
40 |
'test' => '?test'
|
|
|
41 |
)
|
|
|
42 |
)
|
|
|
43 |
)
|
|
|
44 |
)
|
|
|
45 |
);
|
|
|
46 |
print $dom->saveXML();
|
|
|
47 |
?>
|
|
|
48 |
--EXPECT--
|
|
|
49 |
<?xml version="1.0" encoding="UTF-8"?>
|
|
|
50 |
<music_library><artist><artistid>1</artistid><name>Curtis Mayfield</name><birth_year>1920</birth_year><birth_place>Chicago</birth_place><genre>Soul</genre><albums><album><albumid>1</albumid><title>New World Order</title><published_year>1990</published_year><comment>the best ever!</comment></album><album><albumid>2</albumid><title>Curtis</title><published_year>1970</published_year><comment>that man's got somthin' to say</comment></album></albums></artist><artist><artistid>2</artistid><name>Isaac Hayes</name><birth_year>1942</birth_year><birth_place>Tennessee</birth_place><genre>Soul</genre><albums><album><albumid>3</albumid><title>Shaft</title><published_year>1972</published_year><comment>he's the man</comment></album></albums></artist><artist><artistid>3</artistid><name>Ray Charles</name><birth_year>1930</birth_year><birth_place>Mississippi</birth_place><genre>Country and Soul</genre><albums/></artist></music_library>
|
|
|
51 |
|