PHP MDB::loadFile方法代码示例

 /**
  * Create tables and indexes for the given database type.
  *
  * @throws PhpError
  * @access public
  */
 function createTables()
 {
     MDB::loadFile('Manager');
     $manager =& new MDB_Manager();
     $err = $manager->connect($this->dbConn);
     if (MDB::isError($err)) {
         return $err;
     }
     $filename = dirname(__FILE__) . '/database_schema.xml';
     $err = $manager->updateDatabase($filename, $filename . '.old', array('database' => $this->dbConn->database_name));
     if (MDB::isError($err)) {
         return $err;
     }
     $dsn = $this->dbConn->getDSN();
     if (isset($dsn['phptype']) && $dsn['phptype'] == 'mysql') {
         $this->dbConn->query('CREATE INDEX s_mod_idx ON statements (modelID)');
         $sql = 'CREATE INDEX s_sub_pred_idx ON statements (subject(200),predicate(200))';
         $this->dbConn->query($sql);
         $this->dbConn->query('CREATE INDEX s_obj_idx ON statements (object(250))');
     }
     return true;
 }

<?php

# $Id$
require_once "grab_globals.inc.php";
include "config.inc.php";
include "functions.inc";
require_once "database.inc.php";
MDB::loadFile("Date");
include "{$dbsys}.inc";
function date_time_string($t)
{
    global $twentyfourhour_format;
    if ($twentyfourhour_format) {
        $timeformat = "%H:%M:%S";
    } else {
        # This bit's necessary, because it seems %p in strftime format
        # strings doesn't work
        $ampm = utf8_date("a", $t);
        $timeformat = "%I:%M:%S{$ampm}";
    }
    return utf8_strftime("%A %d %B %Y " . $timeformat, $t);
}
# Convert a start time and end time to a plain language description.
# This is similar but different from the way it is done in view_entry.
function describe_span($starts, $ends)
{
    global $twentyfourhour_format;
    $start_date = utf8_strftime('%A %d %B %Y', $starts);
    if ($twentyfourhour_format) {
        $timeformat = "%H:%M:%S";
    } else {

// Set $db_create to 0 to NOT create the database.
$db_create = 1;
// Communication protocol tu use. For pgsql, you can use 'unix' instead of
// 'tcp' to use Unix Domain Sockets instead of TCP/IP.
$db_protocol = "tcp";
/**************************
* DBMS specific options
***************************/
//****ORACLE*****
// Home directory path where Oracle is installed if it is running in the local machine.
// Default value: value of the environment variable ORACLE_HOME
$oci8_home = "";
/**************************
* End of database settings
***************************/
include_once "MDB.php";
MDB::loadFile("Manager");
$schema_file = "mrbs.schema.xml";
$variables = array("database_name" => $db_database, "database_create" => $db_create);
$dsn = array("phptype" => $dbsys, "username" => $db_login, "password" => $db_password, "hostspec" => $db_host, "protocol" => $db_protocol, "port" => $db_port);
$options = array("HOME" => $oci8_home, "optimize" => 'portability');
$manager = new MDB_manager();
$manager->connect($dsn, $options);
$success = $manager->updateDatabase($schema_file, $schema_file . ".before", $variables);
if (MDB::isError($success)) {
    echo "Error: " . $success->getMessage() . "<BR>";
    echo "Error: " . $success->getUserInfo() . "<BR>";
}
if (count($manager->warnings) > 0) {
    echo "WARNING:<BR>", implode($manager->getWarnings(), "!\n"), "\n";
}

//
// You should have received a copy of the GNU Lesser General Public
// License along with this library; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
/**
 * MDB container for Authentication
 *
 * @package  LiveUser
 * @category authentication
 */
/**
 * Require parent class definition and PEAR::MDB class.
 */
require_once 'LiveUser/Auth/Common.php';
require_once 'MDB.php';
MDB::loadFile('Date');
/**
 * Class LiveUser_Auth_Container_MDB
 *
 * Description:
 * This is a PEAR::MDB backend driver for the LiveUser class.
 * A PEAR::MDB connection object can be passed to the constructor to reuse an
 * existing connection. Alternatively, a DSN can be passed to open a new one.
 *
 * Requirements:
 * - File "LoginManager.php" (contains the parent class "LiveUser")
 * - Array of connection options or a PEAR::MDB connection object must be
 *   passed to the constructor.
 *   Example: array('dsn'                   => 'mysql://user:pass@host/db_name',
 *                  'connection             => &$conn, # PEAR::MDB connection object
 *                  'loginTimeout'          => 0,

//
// MDB test script.
//
// BC hack to define PATH_SEPARATOR for version of PHP prior 4.3
if (!defined('PATH_SEPARATOR')) {
    if (defined('DIRECTORY_SEPARATOR') && DIRECTORY_SEPARATOR == "\\") {
        define('PATH_SEPARATOR', ';');
    } else {
        define('PATH_SEPARATOR', ':');
    }
}
ini_set('include_path', '..' . PATH_SEPARATOR . ini_get('include_path'));
// MDB.php doesnt have to be included since manager.php does that
// manager.php is only necessary for handling xml schema files
require_once 'MDB.php';
MDB::loadFile('Manager');
// only including this to output result data
require_once 'Var_Dump.php';
PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, 'handle_pear_error');
function handle_pear_error($error_obj)
{
    print '<pre><b>PEAR-Error</b><br />';
    echo $error_obj->getMessage() . ': ' . $error_obj->getUserinfo();
    print '</pre>';
}
// just for kicks you can mess up this part to see some pear error handling
$user = 'metapear';
$pass = 'funky';
//$pass = '';
$host = 'localhost';
$db_name = 'metapear_test_db';

// | INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, |
// | BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS|
// |  OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED  |
// | AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT          |
// | LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY|
// | WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE          |
// | POSSIBILITY OF SUCH DAMAGE.                                          |
// +----------------------------------------------------------------------+
// | Author: Manuel Lemos <mlemos@acm.org>                                |
// +----------------------------------------------------------------------+
//
// $Id: setup_test.php,v 1.10.4.1 2004/01/08 13:43:00 lsmith Exp $
//
require 'MDB.php';
MDB::loadFile('Manager');
MDB::loadFile('metabase_wrapper');
/**
 * Part of Metabase test suite
 *
 * @package MDB
 * @category Database
 * @author  Manuel Lemos <mlemos@acm.org>>
 */
function Output($message)
{
    echo $message, "\n";
}
function Dump($output)
{
    echo $output;
}

// $Id: MDB_pear_wrapper_test.php,v 1.21 2003/01/18 21:35:19 lsmith Exp $
//
// MDB test script for the PEAR DB Wrapper.
//
// BC hack to define PATH_SEPARATOR for version of PHP prior 4.3
if (!defined('PATH_SEPARATOR')) {
    if (defined('DIRECTORY_SEPARATOR') && DIRECTORY_SEPARATOR == "\\") {
        define('PATH_SEPARATOR', ';');
    } else {
        define('PATH_SEPARATOR', ':');
    }
}
ini_set('include_path', '..' . PATH_SEPARATOR . ini_get('include_path'));
require_once 'MDB.php';
MDB::loadFile('peardb_wrapper');
require_once 'Var_Dump.php';
// just for kicks you can mess up this part to see some pear error handling
$user = 'metapear';
$pass = 'funky';
//$pass = '';
$host = 'localhost';
$db_name = 'metapear_test_db';
// Data Source Name: This is the universal connection string
$dsn = "mysql://{$user}:{$pass}@{$host}/{$db_name}";
// MDB::connect will return a Pear DB object on success
// or a Pear DB Error object on error
// You can also set to TRUE the second param
// if you want a persistent connection:
// $db = DB::connect($dsn, TRUE);
$db =& DB::connect($dsn);