PHP DB::disconnect方法代码示例

 public function tearDown()
 {
     $this->beforeApplicationDestroyed(function () {
         DB::disconnect();
     });
     parent::tearDown();
 }

 function test_1_create_table()
 {
     DB::query("CREATE TABLE `accounts` (\n    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,\n    `profile_id` INT NOT NULL,\n    `username` VARCHAR( 255 ) NOT NULL ,\n    `password` VARCHAR( 255 ) NULL ,\n    `age` INT NOT NULL DEFAULT '10',\n    `height` DOUBLE NOT NULL DEFAULT '10.0',\n    `favorite_word` VARCHAR( 255 ) NULL DEFAULT 'hi',\n    `birthday` TIMESTAMP NOT NULL\n    ) ENGINE = InnoDB");
     DB::query("CREATE TABLE `profile` (\n    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,\n    `signature` VARCHAR( 255 ) NULL DEFAULT 'donewriting'\n    ) ENGINE = InnoDB");
     $mysqli = DB::get();
     DB::disconnect();
     @$this->assert($mysqli->server_info === null);
 }

function smarty_modifier_getImg($string)
{
    $db = new DB();
    $db->connect();
    $url = $db->getImg($string);
    $db->disconnect();
    return $url;
}

 /**
  * Disconnects from the SQL server and cleans up the connection.
  */
 protected function _disconnect()
 {
     if ($this->_connected) {
         $this->_connected = false;
         $this->_db->disconnect();
         $this->_write_db->disconnect();
     }
 }

 /**
  * Disconnects from the SQL server and cleans up the connection.
  *
  * @access private
  *
  * @return boolean  True on success, false on failure.
  */
 function _disconnect()
 {
     if ($this->_connected) {
         $this->_connected = false;
         $this->_db->disconnect();
         $this->_write_db->disconnect();
     }
     return true;
 }

 public function getTopology()
 {
     $conn = DB::connection('sqlsrvtest');
     $select = "exec GetTopologyRing";
     $result = $conn->select($select);
     $datos = json_encode($result);
     DB::disconnect('sqlsrvtest');
     return $datos;
 }

 public function test_successful_and_bad_login()
 {
     $db = new DB();
     $db->connect();
     $this->assertEquals($db->insertNewUserInTableUsers(new User("DavidTest", new Password("1234"))), true);
     $this->assertEquals($db->checkLogin(new User("DavidTest", new Password("1234"))), true);
     $this->assertEquals($db->checkLogin(new User("fake", new Password("1234"))), false);
     $this->assertEquals($db->checkLogin(new User("DavidTest", new Password("fake"))), false);
     $this->assertEquals($db->checkLogin(new User("fake", new Password("fake"))), false);
     $this->assertEquals($db->deleteUserWithName("DavidTest"), true);
     $db->disconnect();
 }

function mystery_db_disconnect($connection = 'dbh')
{
    // this rarely used function disconnects from the database.  If you have non-persistent
    // connections, this is done automatically at the end of the script so there is no
    // reason to manually disconnect it.
    global $_MYSTERY;
    if (is_resource(@$_MYSTERY[$connection])) {
        $_MYSTERY[$connection] =& DB::disconnect(MYSTERY_DB_CONNECT_STRING);
        if (DB::isError($_MYSTERY[$connection])) {
            trigger_error('Could not connect to database: ' . $_MYSTERY[$connection]->getMessage() . "\n\n" . $_MYSTERY[$connection]->getDebugInfo(), E_USER_WARNING);
        }
    }
}

 public function __construct()
 {
     $this->TestSuite('All Tests');
     $basedir = dirname(__FILE__) . '/';
     foreach (self::$dirs as $dirname) {
         $this->addFile("{$basedir}{$dirname}/test_{$dirname}.php");
     }
     Magnus::init('test');
     DB::disconnect();
     // since we auto-connect in Magnus::init()
     DB::$config['dbname'] = 'timber_test';
     DB::connect();
 }

 private function resetearBD()
 {
     $db_final = Config::get('database.connections.migracion_sasyc.database');
     $this->info("Verificando si sasyc_migracion existe");
     $existe = DB::select("SELECT 1 FROM pg_database WHERE datname = '{$db_final}'");
     if (!empty($existe)) {
         $this->info("Borrando base de datos " . $db_final);
         DB::statement('DROP DATABASE ' . $db_final);
     }
     $this->info("Cerrando conexion con la BD");
     DB::disconnect('sasyc_migracion');
     DB::disconnect('pgsql');
     $this->info("Creando base de datos " . $db_final);
     DB::statement('CREATE DATABASE ' . $db_final);
     $this->info("Corriendo archivos de migrations y seeds");
     $this->call('migrate', ['--database' => 'migracion_sasyc']);
     $this->call('db:seed', ['--database' => 'migracion_sasyc']);
 }

 public function VerReportes()
 {
     $conn = DB::connection('DactoolDB');
     $select = "select * from Reportes";
     $result = $conn->select($select);
     $datos = array();
     foreach ($result as $reporte) {
         $selectautor = "select NombreUsuario from Usuarios where IdUsuario = {$reporte->AutorReporte}";
         $resultautor = $conn->select($selectautor);
         foreach ($resultautor as $autor) {
             $reporte->AutorReporte = $autor->NombreUsuario;
         }
         $datos[] = $reporte;
     }
     $datos = json_encode($datos);
     DB::disconnect('DactoolDB');
     return View::make('ReportesController.listareportes', array('datos' => $datos));
 }

 public function VerNotificaciones()
 {
     $conn = DB::connection('DactoolDB');
     $select = "select * from Notificaciones";
     $result = $conn->select($select);
     $datos = array();
     foreach ($result as $notificacion) {
         $selectautor = "select NombreUsuario from Usuarios where IdUsuario = {$notificacion->AutorNotificacion}";
         $resultautor = $conn->select($selectautor);
         foreach ($resultautor as $autor) {
             $notificacion->AutorNotificacion = $autor->NombreUsuario;
         }
         $notificacion->Destinatarios = $this->GetDestinatarios($notificacion->IdNotificacion, $conn);
         $datos[] = $notificacion;
     }
     $datos = json_encode($datos);
     DB::disconnect('DactoolDB');
     return View::make('NotificacionesController.listanotificaciones', array('datos' => $datos));
 }

 public function VerDependenciaScripts($idscript = null)
 {
     $conn = DB::connection('DactoolDB');
     $select = "select * from ScriptsToScripts where IdScriptHijo = {$idscript}";
     $result = $conn->select($select);
     $datos = array();
     foreach ($result as $script) {
         $detalleScript = "select * from Scripts where IdScript = {$script->IdScriptPadre}";
         $resultD = $conn->select($detalleScript);
         foreach ($resultD as $scriptD) {
             $scriptD->AutorScript = $this->getAuthor($scriptD->AutorScript, $conn);
             $datos[] = $scriptD;
         }
     }
     $selectS = "select * from Scripts where IdScript = {$idscript}";
     $resultS = $conn->select($selectS);
     foreach ($resultS as $script) {
         $nameScript = $script->NombreScript;
     }
     $datosEncode = json_encode($datos);
     DB::disconnect('DactoolDB');
     return View::make('ScriptsController.listascriptspadres', array('datos' => $datosEncode, 'hijo' => $nameScript));
 }

function getSettings($p_mailbox)
{
    global $g_use_database;
    global $g_voicemail_conf_path;
    global $g_db_host, $g_db_name, $g_db_user, $g_db_pass;
    if ($g_use_database == true) {
        // Authenticate with Database
        $my_db = new DB();
        $my_db->construct($g_db_host, $g_db_name, $g_db_user, $g_db_pass);
        $my_db->connect();
        $my_db->select();
        $sql = "SELECT uniqueid,password,fullname,email,saycid,envelope,sendvoicemail,'delete' AS deleteafteremail FROM voicemail WHERE mailbox='{$p_mailbox}';";
        //if ($g_debug) echo("SQL: $sql<br />\n");
        $result = $my_db->query($sql);
        if ($result) {
            if (mysql_num_rows($result) > 0) {
                $row = mysql_fetch_array($result);
                $temp['FullName'] = $row['fullname'];
                $temp['Password'] = $row['password'];
                $temp['SayCallerId'] = $row['saycid'];
                $temp['Envelope'] = $row['envelope'];
                $temp['Email'] = $row['email'];
                $temp['SendToEmail'] = $row['sendvoicemail'];
                $temp['DeleteAfterEmail'] = $row['deleteafteremail'];
            }
            mysql_free_result($result);
        }
        $my_db->disconnect();
    } else {
        // cat the voicemail.conf file, grep for mailbox
        $cmd = "cat " . $g_voicemail_conf_path . " | grep " . $p_mailbox;
        $last_line = exec($cmd, $retvalue);
        // parse out the info - 1001 => 1001,Chris Carey,chris@chriscarey.com
        list($mailbox, $everything_else) = split('=>', $last_line);
        list($password, $name, $email) = split(",", $everything_else);
        // Settings from voicemail.conf
        $temp['FullName'] = $name;
        $temp['Password'] = $password;
        $temp['SayCallerId'] = "true";
        $temp['Envelope'] = "true";
        $temp['Email'] = $email;
        $temp['SendToEmail'] = "true";
        $temp['DeleteAfterEmail'] = "true";
    }
    return $temp;
}

 public function getReporteEstadosGrafica()
 {
     $pais = Input::get('filtro') ? Input::get('filtro') : null;
     $conn = DB::connection('atlas');
     $datosa = array();
     $select = "SELECT DI.Location as Pais, TM.Description, COUNT(*) as Val \n                    FROM [dbo].[DashboardGraficasInterfaces] DI \n                    LEFT JOIN TypeMedio TM ON TM.ID = DI.IdTypeMedio\t\n                    WHERE CAST(DI.[Date] AS DATE) = (SELECT MAX(CAST(DI.[Date] AS DATE)) FROM [DashboardGraficasInterfaces] DI WITH (NOLOCK)) \n                    AND DI.Grafica = 0 ";
     if ($pais['Pais']) {
         $select .= "and DI.Location = '{$pais['Pais']}' ";
     }
     $select .= "GROUP BY DI.Location, TM.Description \n                    ORDER BY Pais ";
     $result = $conn->select($select);
     $labels = array('COLOMBIA', 'ARGENTINA', 'BRASIL', 'MEXICO', 'PERU', 'CHILE', 'ECUADOR', 'PANAMA', 'PUERTORICO', 'URUGUAY', 'USA', 'VENEZUELA');
     $series = array('Cobre', 'Fibra', 'Wireless', 'NoAplica');
     foreach ($result as $estado) {
         $datosa[$estado->Pais][$estado->Description] = $estado->Val;
     }
     $labels = isset($pais['Pais']) ? array($pais['Pais']) : $labels;
     $datospre = array();
     foreach ($series as $serie) {
         foreach ($labels as $label) {
             if (isset($datosa[$label][$serie])) {
                 $datospre[$serie][] = intval($datosa[$label][$serie]);
             } else {
                 $datospre[$serie][] = null;
             }
         }
     }
     $datos = array();
     foreach ($datospre as $value) {
         $datos['data'][] = $value;
     }
     $datos['labels'] = $labels;
     $datos['series'] = $series;
     $datos = json_encode($datos);
     DB::disconnect('atlas');
     return $datos;
 }