PHP Connection::statement方法代码示例

 /**
  * function to safely drop trigger db object
  *
  * @param  string $name
  * @return boolean
  */
 public function drop($name)
 {
     if (!$name) {
         return false;
     }
     return $this->connection->statement("\n            declare\n                e exception;\n                pragma exception_init(e,-4080);\n            begin\n                execute immediate 'drop trigger {$name}';\n            exception\n            when e then\n                null;\n            end;");
 }

 /**
  * function to safely drop sequence db object
  *
  * @param  string $name
  * @return boolean
  */
 public function drop($name)
 {
     // check if a valid name and sequence exists
     if (!$name or !$this->exists($name)) {
         return false;
     }
     return $this->connection->statement("\n            declare\n                e exception;\n                pragma exception_init(e,-02289);\n            begin\n                execute immediate 'drop sequence {$name}';\n            exception\n            when e then\n                null;\n            end;");
 }

 /**
  * Run a truncate statement on the table.
  *
  * @return void
  */
 public function truncate()
 {
     foreach ($this->grammar->compileTruncate($this) as $sql => $bindings) {
         $this->connection->statement($sql, $bindings);
     }
 }

 /**
  * Disable foreign key constraints.
  *
  * @return bool
  */
 public function disableForeignKeyConstraints()
 {
     return $this->connection->statement($this->grammar->compileDisableForeignKeyConstraints());
 }

 /**
  * Execute the statements against the database.
  *
  * @param  array $statements
  * @return void
  */
 protected function build($statements)
 {
     foreach ($statements as $statement) {
         $this->connection->statement($statement);
     }
 }

 /**
  * Run the comment on column statement
  *
  * @param  string $table
  * @param  string $column
  * @param  string $comment
  */
 private function commentColumn($table, $column, $comment)
 {
     $table = $this->wrapValue($table);
     $column = $this->wrapValue($column);
     $this->connection->statement("comment on column {$table}.{$column} is '{$comment}'");
 }

 /**
  * @param Connection $db
  * @param array      $creds
  * @param string     $fromServer
  *
  * @return bool
  */
 protected function revokePrivileges($db, $creds, $fromServer)
 {
     return $db->transaction(function () use($db, $creds, $fromServer) {
         //  Create users
         $_users = $this->getDatabaseUsers($creds, $fromServer);
         try {
             foreach ($_users as $_user) {
                 //	Grants for instance database
                 if (!($_result = $db->statement('REVOKE ALL PRIVILEGES ON ' . $creds['database'] . '.* FROM ' . $_user))) {
                     $this->error('[provisioning:database] error revoking privileges from "' . $_user . '"');
                     continue;
                 }
                 $this->debug('[provisioning:database] grants revoked - complete');
                 if (!($_result = $db->statement('DROP USER ' . $_user))) {
                     $this->error('[provisioning:database] error dropping user "' . $_user . '"');
                 }
                 $_result && $this->debug('[provisioning:database] users dropped > ', $_users);
             }
             return true;
         } catch (\Exception $_ex) {
             $this->error('[provisioning:database] revoke grants - failure: ' . $_ex->getMessage());
             return false;
         }
     });
 }

 /**
  * @param \Illuminate\Database\Connection $db
  */
 protected function configurePragma(Connection $db)
 {
     if ($this->configuration['driver'] !== 'sqlite') {
         return;
     }
     // Enable foreign keys for the current connection/file
     $db->statement('PRAGMA foreign_keys = ON;');
     // Create sqlite-journal in memory only (instead of creating disk files)
     $db->statement('PRAGMA journal_mode = MEMORY;');
     // Do not wait for OS after sending write commands
     $db->statement('PRAGMA synchronous = OFF;');
 }

 /**
  * Execute the blueprint against the database.
  *
  * @param  Illuminate\Database\Connection  $connection
  * @param  Illuminate\Database\Schema\Grammars\Grammar $grammar
  * @return void
  */
 public function build(Connection $connection, Grammar $grammar)
 {
     foreach ($this->toSql($grammar) as $statement) {
         $connection->statement($statement);
     }
 }