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::enableDebugLog()
3 
--SKIPIF--
4 
<?php require_once dirname(dirname(__FILE__)) . '/skipif.php'; ?>
5 
--FILE--
6 
<?php
7 
    class MyLogger
8 
    {
9 
        public $data = '';
10 
        public function log($str)
11 
        {
12 
            $this->data .= $str . "\n";
13 
        }
14 
    }
15 
 
16 
    require_once 'XML/Query2XML.php';
17 
    require_once dirname(dirname(__FILE__)) . '/db_init.php';
18 
    $query2xml =& XML_Query2XML::factory($db);
19 
    $debugLogger = new MyLogger();
20 
    $query2xml->enableDebugLog($debugLogger);
21 
    $dom =& $query2xml->getXML(
22 
        "SELECT
23 
            *
24 
         FROM
25 
            artist",
26 
        array(
27 
            'rootTag' => 'music_library',
28 
            'rowTag' => 'artist',
29 
            'idColumn' => 'artistid',
30 
            'elements' => array(
31 
                'artistid',
32 
                'name',
33 
                'birth_year',
34 
                'birth_place',
35 
                'genre',
36 
                'albums' => array(
37 
                    'sql' => array(
38 
                        'data' => array(
39 
                            'artistid'
40 
                        ),
41 
                        'query' => 'SELECT * FROM album WHERE artist_id = ?'
42 
                    ),
43 
                    'rootTag' => 'albums',
44 
                    'rowTag' => 'album',
45 
                    'idColumn' => 'albumid',
46 
                    'elements' => array(
47 
                        'albumid',
48 
                        'title',
49 
                        'published_year',
50 
                        'comment'
51 
                    )
52 
                )
53 
            )
54 
        )
55 
    );
56 
    $query2xml->disableDebugLog();
57 
    echo $debugLogger->data;
58 
?>
59 
--EXPECT--
60 
QUERY: SELECT
61 
            *
62 
         FROM
63 
            artist
64 
DONE
65 
QUERY: SELECT * FROM album WHERE artist_id = ?; DATA:1
66 
DONE
67 
QUERY: SELECT * FROM album WHERE artist_id = ?; DATA:2
68 
DONE
69 
QUERY: SELECT * FROM album WHERE artist_id = ?; DATA:3
70 
DONE
71