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::getXML(): check for XML_Query2XML_DBException - $sql argument contains invalid query
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 
    try {
10 
        $query2xml =& XML_Query2XML::factory($db);
11 
        $query2xml->getXML(
12 
            "SELECT
13 
                *
14 
             FROM
15 
                artist
16 
                LEFT JOIN non_existing_table ON non_existing_table.artist_id = artist.artistid",
17 
            array(
18 
                'rootTag' => 'music_library',
19 
                'rowTag' => 'artist',
20 
                'idColumn' => 'artistid',
21 
                'elements' => array(
22 
                    'artistid',
23 
                    'name',
24 
                    'birth_year',
25 
                    'birth_place',
26 
                    'genre',
27 
                    'albums' => array(
28 
                        'rootTag' => 'albums',
29 
                        'rowTag' => 'album',
30 
                        'idColumn' => 'albumid',
31 
                        'elements' => array(
32 
                            'albumid',
33 
                            'title',
34 
                            'published_year',
35 
                            'comment'
36 
                        )
37 
                    )
38 
                )
39 
            )
40 
        );
41 
    } catch (XML_Query2XML_DBException $e) {
42 
        echo get_class($e) . ': ' . str_replace(' prepare ', ' execute ', substr($e->getMessage(), 0, 210));
43 
    }
44 
?>
45 
--EXPECT--
46 
XML_Query2XML_DBException: [sql]: Could not execute the following SQL query: SELECT
47 
                *
48 
             FROM
49 
                artist
50 
                LEFT JOIN non_existing_table ON non_existing_table.artist_id = artist.artistid