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