source: subversion/trunk/roundcubemail/bin/dumpschema.php @ 2237

#!/usr/bin/env php
<?php
/*

 +-----------------------------------------------------------------------+
 | bin/dumpschema.php                                                    |
 |                                                                       |
 | This file is part of the RoundCube Webmail client                     |
 | Copyright (C) 2005-2009, RoundCube Dev. - Switzerland                 |
 | Licensed under the GNU GPL                                            |
 |                                                                       |
 | PURPOSE:                                                              |
 |   Dumps database schema in XML format using MDB2_Schema               |
 |                                                                       |
 +-----------------------------------------------------------------------+
 | Author: Thomas Bruederli <roundcube@gmail.com>                        |
 +-----------------------------------------------------------------------+

 $Id$

*/

if (php_sapi_name() != 'cli') {
    die('Not on the "shell" (php-cli).');
}

define('INSTALL_PATH', realpath(dirname(__FILE__) . '/..') . '/' );
require INSTALL_PATH.'program/include/iniset.php';

/** callback function for schema dump **/
function print_schema($dump)
{
        foreach ((array)$dump as $part)
                echo $dump . "\n";
}

$config = new rcube_config();

// don't allow public access if not in devel_mode
if (!$config->get('devel_mode') && $_SERVER['REMOTE_ADDR']) {
        header("HTTP/1.0 401 Access denied");
        die("Access denied!");
}

$options = array(
        'use_transactions' => false,
        'log_line_break' => "\n",
        'idxname_format' => '%s',
        'debug' => false,
        'quote_identifier' => true,
        'force_defaults' => false,
        'portability' => false,
);

$dsnw = $config->get('db_dsnw');
$dsn_array = MDB2::parseDSN($dsnw);

// set options for postgres databases
if ($dsn_array['phptype'] == 'pgsql') {
        $options['disable_smart_seqname'] = true;
        $options['seqname_format'] = '%s';
}

$schema =& MDB2_Schema::factory($dsnw, $options);
$schema->db->supported['transactions'] = false;


// send as text/xml when opened in browser
if ($_SERVER['REMOTE_ADDR'])
        header('Content-Type: text/xml');


if (PEAR::isError($schema)) {
        $error = $schema->getMessage() . ' ' . $schema->getUserInfo();
}
else {
        $dump_config = array(
                // 'output_mode' => 'file',
                'output' => 'print_schema',
        );
        
        $definition = $schema->getDefinitionFromDatabase();
        $definition['charset'] = 'utf8';

        if (PEAR::isError($definition)) {
                $error = $definition->getMessage() . ' ' . $definition->getUserInfo();
        }
        else {
                $operation = $schema->dumpDatabase($definition, $dump_config, MDB2_SCHEMA_DUMP_STRUCTURE);
                if (PEAR::isError($operation)) {
                        $error = $operation->getMessage() . ' ' . $operation->getUserInfo();
                }
        }
}

$schema->disconnect();

if ($error && !$_SERVER['REMOTE_ADDR'])
        fputs(STDERR, $error);

?>