mdbal.class

Ir para a documentação deste ficheiro.

<?php
 
use Doctrine\Common\ClassLoader;
 
class MDbal
{
    private $database;
    private $conn;
    private $conf;
 
    public function __construct($database)
    {
        $MIOLO = MIOLO::getInstance();
        $doctrineDir = $MIOLO->getConf('home.classes') . '/extensions/doctrine-dbal';
        require "$doctrineDir/Doctrine/Common/ClassLoader.php";
 
        $classLoader = new ClassLoader('Doctrine', $doctrineDir);
        $classLoader->register();
        $config = new \Doctrine\DBAL\Configuration();
 
        if ( $database )
        {
            $this->database = $database;
            $this->conf = self::getConf($database);
            $this->connect();
        }
    }
 
    private static function getConf($database)
    {
        if ( !$database )
        {
            return;
        }
        $MIOLO = MIOLO::getInstance();
 
        switch ( $MIOLO->getConf("db.$database.system") )
        {
            case 'mysql':
                $conf['driver'] = 'pdo_mysql';
                $conf['dbname'] = $MIOLO->getConf("db.$database.name");
                $conf['host'] = $MIOLO->getConf("db.$database.host");
                $conf['port'] = $MIOLO->getConf("db.$database.port");
                break;
 
            case 'sqlite':
                $conf['driver'] = 'pdo_sqlite';
                $conf['path'] = $MIOLO->getConf("db.$database.name");
                break;
 
            case 'postgres':
                $conf['driver'] = 'pdo_pgsql';
                $conf['dbname'] = $MIOLO->getConf("db.$database.name");
                $conf['host'] = $MIOLO->getConf("db.$database.host");
                $conf['port'] = $MIOLO->getConf("db.$database.port");
                break;
 
            case 'oracle':
                $conf['driver'] = 'pdo_oci';
                $conf['dbname'] = $MIOLO->getConf("db.$database.name");
                $conf['host'] = $MIOLO->getConf("db.$database.host");
                $conf['port'] = $MIOLO->getConf("db.$database.port");
                break;
        }
 
        $conf['user'] = $MIOLO->getConf("db.$database.user");
        $conf['password'] = $MIOLO->getConf("db.$database.password");
 
        return $conf;
    }
 
    public function connect()
    {
        $this->conn = \Doctrine\DBAL\DriverManager::getConnection($this->conf);
    }
 
    public function disconnect()
    {
        $this->conn->close();
    }
 
    public function prepare($sql)
    {
        return $this->conn->prepare($sql);
    }
 
    public function getConn()
    {
        return $this->conn;
    }
 
    public function getSchemaManager()
    {
        return $this->conn->getSchemaManager();
    }
 
    public function createSchema()
    {
        return $this->conn->getSchemaManager()->createSchema();
    }
 
    public static function createConnection($database)
    {
        $MIOLO = MIOLO::getInstance();
        $doctrineDir = $MIOLO->getConf('home.classes') . '/extensions/doctrine-dbal';
        require "$doctrineDir/Doctrine/Common/ClassLoader.php";
 
        $classLoader = new ClassLoader('Doctrine', $doctrineDir);
        $classLoader->register();
 
        return \Doctrine\DBAL\DriverManager::getConnection(self::getConf($database));
    }
}
?>