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