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::getProfile()
3 
--SKIPIF--
4 
<?php 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 
    $query2xml->startProfiling();
11 
    $dom =& $query2xml->getXML(
12 
        "SELECT
13 
            *
14 
         FROM
15 
            artist
16 
         ORDER BY
17 
            artistid",
18 
        array(
19 
            'rootTag' => 'music_library',
20 
            'rowTag' => 'artist',
21 
            'idColumn' => 'artistid',
22 
            'elements' => array(
23 
                'artistid',
24 
                'name',
25 
                'birth_year',
26 
                'birth_place',
27 
                'genre',
28 
                'albums' => array(
29 
                    'sql' => array(
30 
                        'data' => array(
31 
                            'artistid'
32 
                        ),
33 
                        'query' => 'SELECT * FROM album WHERE artist_id = ? ORDER BY albumid'
34 
                    ),
35 
                    'rootTag' => 'albums',
36 
                    'rowTag' => 'album',
37 
                    'idColumn' => 'albumid',
38 
                    'elements' => array(
39 
                        'albumid',
40 
                        'title',
41 
                        'published_year',
42 
                        'comment'
43 
                    )
44 
                )
45 
            )
46 
        )
47 
    );
48 
    $profile = $query2xml->getProfile();
49 
    print preg_match_all('/SELECT/', $profile, $matches);
50 
?>
51 
--EXPECT--
52 
2