Subversion-Projekte lars-tiefland.php_share

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
--TEST--
2 
XML_Query2XML::getXML(): Case07
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 
        artist
15 
     ORDER BY
16 
        artistid",
17 
    array(
18 
        'rootTag' => 'music_library',
19 
        'rowTag' => 'artist',
20 
        'idColumn' => 'artistid',
21 
        'elements' => array(
22 
            '*',
23 
            'albums' => array(
24 
                'sql' => array(
25 
                    'data' => array(
26 
                        'artistid'
27 
                    ),
28 
                    'query' => 'SELECT * FROM album WHERE artist_id = ?'
29 
                ),
30 
                'rootTag' => 'albums',
31 
                'rowTag' => 'album',
32 
                'idColumn' => 'albumid',
33 
                'elements' => array(
34 
                    '*',
35 
                    'artist_id' => '?:'
36 
                )
37 
            )
38 
        )
39 
    )
40 
);
41 
 
42 
header('Content-Type: application/xml');
43 
 
44 
$dom->formatOutput = true;
45 
print $dom->saveXML();
46 
?>
47 
--EXPECT--
48 
<?xml version="1.0" encoding="UTF-8"?>
49 
<music_library>
50 
  <artist>
51 
    <artistid>1</artistid>
52 
    <name>Curtis Mayfield</name>
53 
    <birth_year>1920</birth_year>
54 
    <birth_place>Chicago</birth_place>
55 
    <genre>Soul</genre>
56 
    <albums>
57 
      <album>
58 
        <albumid>1</albumid>
59 
        <title>New World Order</title>
60 
        <published_year>1990</published_year>
61 
        <comment>the best ever!</comment>
62 
      </album>
63 
      <album>
64 
        <albumid>2</albumid>
65 
        <title>Curtis</title>
66 
        <published_year>1970</published_year>
67 
        <comment>that man's got somthin' to say</comment>
68 
      </album>
69 
    </albums>
70 
  </artist>
71 
  <artist>
72 
    <artistid>2</artistid>
73 
    <name>Isaac Hayes</name>
74 
    <birth_year>1942</birth_year>
75 
    <birth_place>Tennessee</birth_place>
76 
    <genre>Soul</genre>
77 
    <albums>
78 
      <album>
79 
        <albumid>3</albumid>
80 
        <title>Shaft</title>
81 
        <published_year>1972</published_year>
82 
        <comment>he's the man</comment>
83 
      </album>
84 
    </albums>
85 
  </artist>
86 
  <artist>
87 
    <artistid>3</artistid>
88 
    <name>Ray Charles</name>
89 
    <birth_year>1930</birth_year>
90 
    <birth_place>Mississippi</birth_place>
91 
    <genre>Country and Soul</genre>
92 
    <albums/>
93 
  </artist>
94 
</music_library>