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 two placeholders
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 
                            ':1'
41 
                        ),
42 
                        'query' => 'SELECT * FROM album WHERE artist_id = ? AND 1=?'
43 
                    ),
44 
                    'rootTag' => 'albums',
45 
                    'rowTag' => 'album',
46 
                    'idColumn' => 'albumid',
47 
                    'elements' => array(
48 
                        'albumid',
49 
                        'title',
50 
                        'published_year',
51 
                        'comment'
52 
                    )
53 
                )
54 
            )
55 
        )
56 
    );
57 
    $query2xml->disableDebugLog();
58 
    echo $debugLogger->data;
59 
?>
60 
--EXPECT--
61 
QUERY: SELECT
62 
            *
63 
         FROM
64 
            artist
65 
DONE
66 
QUERY: SELECT * FROM album WHERE artist_id = ? AND 1=?; DATA:1,1
67 
DONE
68 
QUERY: SELECT * FROM album WHERE artist_id = ? AND 1=?; DATA:2,1
69 
DONE
70 
QUERY: SELECT * FROM album WHERE artist_id = ? AND 1=?; DATA:3,1
71 
DONE
72