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