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() with $options['sql_options']['cached'] = true
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 * FROM artist',
23 
        array(
24 
            'rootTag' => 'music_library',
25 
            'rowTag' => 'artist',
26 
            'idColumn' => 'artistid',
27 
            'elements' => array(
28 
                'artistid',
29 
                'name',
30 
                'birth_year',
31 
                'birth_place',
32 
                'genre',
33 
                'albums' => array(
34 
                    'sql' => array(
35 
                        'data' => array(
36 
                            'artistid'
37 
                        ),
38 
                        'query' => 'SELECT * FROM album WHERE artist_id = ?'
39 
                    ),
40 
                    'rootTag' => 'albums',
41 
                    'rowTag' => 'album',
42 
                    'idColumn' => 'albumid',
43 
                    'elements' => array(
44 
                        'albumid',
45 
                        'title',
46 
                        'published_year',
47 
                        'comment'
48 
                    )
49 
                )
50 
            )
51 
        )
52 
    );
53 
    $query2xml->disableDebugLog();
54 
    echo $debugLogger->data;
55 
?>
56 
--EXPECT--
57 
QUERY: SELECT * FROM artist
58 
DONE
59 
QUERY: SELECT * FROM album WHERE artist_id = ?; DATA:1
60 
DONE
61 
QUERY: SELECT * FROM album WHERE artist_id = ?; DATA:2
62 
DONE
63 
QUERY: SELECT * FROM album WHERE artist_id = ?; DATA:3
64 
DONE