Dataface/ConfigWriter.php

Go to the documentation of this file.

<?php
/*-------------------------------------------------------------------------------
 * Xataface Web Application Framework
 * Copyright (C) 2005-2008 Web Lite Solutions Corp (shannah@sfu.ca)
 * 
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *-------------------------------------------------------------------------------
 */
 
class Dataface_ConfigWriter {

        
        function setupDB(){
                if ( !is_a($this, 'Dataface_ConfigTool') ){
                        throw new Exception('ConfigWriter methods are only to be used via the Dataface_ConfigTool class.', E_USER_ERROR);
                }
                $app =& Dataface_Application::getInstance();
                $config = file_get_contents(DATAFACE_PATH.'/install/dbconfig.sql');
                foreach ( explode(';',$config) as $query){
                        if (!trim($query)) continue;
                        $res = mysql_query($query, $app->db());
                        if ( !$res ){
                                throw new Exception("Could not set up configuration database: ".mysql_error($app->db()), E_USER_ERROR);
                        }
                }
                return true;
        }
        
        function writeConfig($storage=null){
                if ( !is_a($this, 'Dataface_ConfigTool') ){
                        throw new Exception('ConfigWriter methods are only to be used via the Dataface_ConfigTool class.', E_USER_ERROR);
                }
                
                $this->loadAllConfig();
                $app =& Dataface_Application::getInstance();
                
                if ( $storage === null ) $storage = $app->_conf['config_storage'];
                
                switch (strtolower($storage)){
                        case 'db':
                        case 'database':
                        case 'sql':
                                return $this->writeConfigToDB();
                        case 'ini':
                                return $this->writeConfigToINI();
                }
        
        }
        
        function writeConfigToDB(){
                import('Dataface/Table.php');
                import('Dataface/Record.php');
                import('Dataface/IO.php');
                if ( !is_a($this, 'Dataface_ConfigTool') ){
                        throw new Exception('ConfigWriter methods are only to be used via the Dataface_ConfigTool class.', E_USER_ERROR);
                }
                $this->loadAllConfig();
                $app =& Dataface_Application::getInstance();
                // first let's make copies of the current configuration.
                $timestamp = time();
                foreach ( $this->configTypes as $type ){
                        $res = mysql_query("CREATE TABLE `__".addslashes($type)."__".$timestamp."` SELECT * FROM `__".addslashes($type)."__`", $app->db());
                        if ( !$res ){
                                throw new Exception("Failed to make backup of table '__".$type."__'.". mysql_error($app->db()), E_USER_ERROR);
                        }
                }
                
                $res = mysql_query("CREATE TABLE `__properties__".$timestamp."` SELECT * FROM `__properties__`", $app->db());
                if ( !$res ){
                        throw new Exception("Failed to make backup of table '__properties__'.", $app->db());
                }
                
                // Now that we have made our backups, we can continue to write the configuration to the database.
                //print_r($this->config);
                foreach ( $this->configTypes as $type ){
                
                        $res = mysql_query("DELETE FROM `__".addslashes($type)."__`", $app->db());
                        if ( !$res ){
                                throw new Exception("Failed to delete all records from table '__".$type."__'", $app->db());
                        }
                        
                
                        foreach ( $this->config[$type] as $tablename=>$tableConfig ){
                                foreach ( $tableConfig as $sectionname=>$section){
                                        $tableObj =& Dataface_Table::loadTable('__'.$type.'__');
                                        $record = new Dataface_Record('__'.$type.'__', array());
                                        $record->useMetaData = false;  // some of the field names begin with '__' which would conflict with dataface's handling of MetaData fields.
                                        
                                        
                                        foreach ( array_keys($tableObj->fields()) as $fieldname ){
                                                $record->setValue($fieldname, @$section[$fieldname]);
                                                unset($section[$fieldname]);
                                        }
                                        $record->setValue('name',$sectionname);
                                        $record->setValue('table', $tablename);
                                        //echo nl2br("Section name: $sectionname\nTable: $tablename\n");
                                        //print_r($record->strvals());
                                        
                                        echo nl2br("\nWriting section: $sectionname : ");
                                        print_r($record->strvals());
                                        
                                        // now that we have created the record, we write the record
                                        $io = new Dataface_IO('__'.$type.'__');
                                        $res = $io->write($record);
                                        if ( PEAR::isError($res) ){
                                                throw new Exception($res->toString(), E_USER_ERROR);
                                        } else if (!$res ){
                                                throw new Exception("Failure to write to database for unknown reason.", E_USER_ERROR);
                                        }
                                        
                                        // now for the rest of the properties.
                                        foreach ( $section as $propertyName=>$propertyValue ){
                                                $res = mysql_query("
                                                        INSERT INTO 
                                                         `__properties__` 
                                                         (`parent_id`,`parent_type`,`property_name`,`property_value`)
                                                        VALUES
                                                         ('".$record->val($type.'_id')."', 
                                                         '".addslashes($type)."',
                                                         '".addslashes($propertyName)."',
                                                         '".addslashes($propertyValue)."')", $app->db());
                                                if ( !$res ){
                                                        throw new Exception("Failed to add property '$propertyName' to table '__properties__' with value '$propertyValue'".mysql_error($app->db()), E_USER_ERROR);
                                                }
                                        }
                                        
                                        unset($tableObj);
                                        unset($record);
                                        unset($io);
                                }
                        }
                        
                }
        
        }

}