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(): [sql][limit] set to 0
3 
--SKIPIF--
4 
<?php $db_layers = array('MDB2', 'DB'); 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 
    array(
12 
        'query' => 'SELECT * FROM employee WHERE employeeid > 4',
13 
        'limit' => 3,
14 
        'offset' => 2
15 
    ),
16 
    array(
17 
        'rootTag' => 'employees',
18 
        'rowTag' => 'employee',
19 
        'idColumn' => 'employeeid',
20 
        'elements' => array(
21 
            'employeename',
22 
            'sale' => array(
23 
                'idColumn' => 'saleid',
24 
                'sql' => array(
25 
                    'data' => array('employeeid'),
26 
                    'query' => 'SELECT * FROM sale s, album a WHERE s.album_id = a.albumid AND s.employee_id = ?',
27 
                    'limit' => 2,
28 
                    'offset' => 1
29 
                ),
30 
                'value' => 'title'
31 
            )
32 
        )
33 
    )
34 
);
35 
 
36 
$dom->formatOutput = true;
37 
print $dom->saveXML();
38 
?>
39 
--EXPECT--
40 
<?xml version="1.0" encoding="UTF-8"?>
41 
<employees>
42 
  <employee>
43 
    <employeename>Rita Doktor</employeename>
44 
    <sale>New World Order</sale>
45 
    <sale>Curtis</sale>
46 
  </employee>
47 
  <employee>
48 
    <employeename>David Til</employeename>
49 
    <sale>New World Order</sale>
50 
    <sale>Curtis</sale>
51 
  </employee>
52 
  <employee>
53 
    <employeename>Pia Eist</employeename>
54 
    <sale>Curtis</sale>
55 
  </employee>
56 
</employees>