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::setGlobalOption(): setting the hidden_container_prefix
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 
    $query2xml->setGlobalOption('hidden_container_prefix', 'SKIPME');
11 
    $dom =& $query2xml->getXML(
12 
        "SELECT
13 
            *
14 
         FROM
15 
            artist
16 
            LEFT JOIN album ON album.artist_id = artist.artistid
17 
         ORDER BY
18 
            artistid,
19 
            albumid",
20 
        array(
21 
            'rootTag' => 'music_library',
22 
            'rowTag' => 'artist',
23 
            'idColumn' => 'artistid',
24 
            'elements' => array(
25 
                'artistid',
26 
                'name',
27 
                'birth_year',
28 
                'birth_place',
29 
                'genre',
30 
                'albums' => array(
31 
                    'rootTag' => 'SKIPME_albums',
32 
                    'rowTag' => 'album',
33 
                    'idColumn' => 'albumid',
34 
                    'elements' => array(
35 
                        'albumid',
36 
                        'title',
37 
                        'published_year',
38 
                        'comment'
39 
                    )
40 
                )
41 
            )
42 
        )
43 
    );
44 
 
45 
    $dom->formatOutput = true;
46 
    print $dom->saveXML();
47 
?>
48 
--EXPECT--
49 
<?xml version="1.0" encoding="UTF-8"?>
50 
<music_library>
51 
  <artist>
52 
    <artistid>1</artistid>
53 
    <name>Curtis Mayfield</name>
54 
    <birth_year>1920</birth_year>
55 
    <birth_place>Chicago</birth_place>
56 
    <genre>Soul</genre>
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 
  </artist>
70 
  <artist>
71 
    <artistid>2</artistid>
72 
    <name>Isaac Hayes</name>
73 
    <birth_year>1942</birth_year>
74 
    <birth_place>Tennessee</birth_place>
75 
    <genre>Soul</genre>
76 
    <album>
77 
      <albumid>3</albumid>
78 
      <title>Shaft</title>
79 
      <published_year>1972</published_year>
80 
      <comment>he's the man</comment>
81 
    </album>
82 
  </artist>
83 
  <artist>
84 
    <artistid>3</artistid>
85 
    <name>Ray Charles</name>
86 
    <birth_year>1930</birth_year>
87 
    <birth_place>Mississippi</birth_place>
88 
    <genre>Country and Soul</genre>
89 
  </artist>
90 
</music_library>