lifetype-1.2/tools/updatedbschema.php

Go to the documentation of this file.

<?php

if (!defined( "PLOG_CLASS_PATH" )) {
    define( "PLOG_CLASS_PATH", dirname(__FILE__)."/");
}

lt_include( PLOG_CLASS_PATH."class/database/db.class.php" );
lt_include( PLOG_CLASS_PATH."class/config/configfilestorage.class.php" );
lt_include( PLOG_CLASS_PATH."install/dbschemas.properties.php" );

$config = new ConfigFileStorage();
// open a connection to the database
$db = PDb::getDriver('mysql');

if( !$db->Connect($config->getValue( "db_host" ), $config->getValue( "db_username" ), $config->getValue( "db_password" ), $config->getValue( "db_database" ), $config->getValue( "db_character_set" ))) {
        die( "could not connect to database!" );
}

$prefix = $config->getValue( "db_prefix" );

$dict = NewPDbDataDictionary( $db );            
$errors = false;
$message = "";
foreach( $Tables as $name => $table ) {
    $errorMessage = "";
    $table_errors = false;
        $upperName = $dict->upperName;
        $tableSchema = $table["schema"];
        if ( isset( $table["options"] ) )
        {
                $tableOptions = $table["options"];
                $options = array ( $upperName => $tableOptions );
        } else {
                $options = array ();
    }
   
    // generate the code with the changes for the table
    $sqlarray = $dict->ChangeTableSQL( $prefix.$name, $tableSchema, $options );
    
    foreach( $sqlarray as $sql ) {
        // and run the query
        if( !$db->Execute( $sql )) {
            $table_errors = true;
            $errors = true;
            $errorMessage .= $db->ErrorMsg()."<br/>";
        }
    }

    if( !$table_errors )
        $message .= "Changes to table <strong>$name</strong> executed successfully.<br/>";
    else {
        $message .= "Error modifying table $name: ".$errorMessage;
    }
}

print($message);

?>

© 2008 LifeType. All rights reserved.	International | Germany | Taiwan | Russia | Ukraine	Sitemap | Contact | Hosting by Lime Daley