PHP DB::getDriverName方法代码示例

 public function release($id)
 {
     $locks_remaining = $this->popLock($id);
     if ($locks_remaining > 0) {
         return true;
     }
     $driver_name = DB::getDriverName();
     if ($driver_name == 'mysql') {
         $released = $this->release_Mysql($id);
     } else {
         $released = $this->release_Memory($id);
     }
     return $released;
 }

 /**
  * Datatable filtering
  *
  * @return null
  */
 private function filtering()
 {
     $columns = $this->clean_columns($this->columns, false);
     if (Input::get('sSearch', '') != '') {
         $copy_this = $this;
         $copy_this->columns = $columns;
         $this->query->where(function ($query) use($copy_this) {
             $db_prefix = $copy_this->database_prefix();
             for ($i = 0, $c = count($copy_this->columns); $i < $c; $i++) {
                 if (Input::get('bSearchable_' . $i) == "true") {
                     $column = $copy_this->columns[$i];
                     if (stripos($column, ' AS ') !== false) {
                         $column = substr($column, stripos($column, ' AS ') + 4);
                     }
                     $keyword = '%' . Input::get('sSearch') . '%';
                     if (Config::get('datatables.search.use_wildcards', false)) {
                         $keyword = $copy_this->wildcard_like_string(Input::get('sSearch'));
                     }
                     // Check if the database driver is PostgreSQL
                     // If it is, cast the current column to TEXT datatype
                     $cast_begin = null;
                     $cast_end = null;
                     if (DB::getDriverName() === 'pgsql') {
                         $cast_begin = "CAST(";
                         $cast_end = " as TEXT)";
                     }
                     $column = $db_prefix . $column;
                     if (Config::get('datatables.search.case_insensitive', false)) {
                         $query->orwhere(DB::raw('LOWER(' . $cast_begin . $column . $cast_end . ')'), 'LIKE', strtolower($keyword));
                     } else {
                         $query->orwhere(DB::raw($cast_begin . $column . $cast_end), 'LIKE', $keyword);
                     }
                 }
             }
         });
     }
     $db_prefix = $this->database_prefix();
     for ($i = 0, $c = count($columns); $i < $c; $i++) {
         if (Input::get('bSearchable_' . $i) == "true" && Input::get('sSearch_' . $i) != '') {
             $keyword = '%' . Input::get('sSearch_' . $i) . '%';
             if (Config::get('datatables.search.use_wildcards', false)) {
                 $keyword = $copy_this->wildcard_like_string(Input::get('sSearch_' . $i));
             }
             if (Config::get('datatables.search.case_insensitive', false)) {
                 $column = $db_prefix . $columns[$i];
                 $this->query->where(DB::raw('LOWER(' . $column . ')'), 'LIKE', strtolower($keyword));
             } else {
                 $col = strstr($columns[$i], '(') ? DB::raw($columns[$i]) : $columns[$i];
                 $this->query->where($col, 'LIKE', $keyword);
             }
         }
     }
 }

 protected function setForeignKeyChecks($enable = false)
 {
     switch (DB::getDriverName()) {
         case 'mysql':
             $status = $enable ? 1 : 0;
             DB::statement("SET FOREIGN_KEY_CHECKS={$status};");
             break;
         case 'sqlite':
             $status = $enable ? 'ON' : 'OFF';
             DB::statement("PRAGMA foreign_keys = {$status}");
             break;
     }
 }

 /**
  * Get all the tables present in the database
  * @param  string $dbname The name of the database
  * @return array          An array of table names present
  */
 protected function getAllTables($dbname)
 {
     $tables = array();
     if (DB::getDriverName() === 'mysql') {
         $tableRows = DB::select('SHOW tables');
         $column = "Tables_in_{$dbname}";
         foreach ($tableRows as $row) {
             $tables[] = $row->{$column};
         }
     } else {
         if (DB::getDriverName() === 'pgsql') {
             $tableRows = DB::select("SELECT table_name FROM information_schema.tables\n                  WHERE table_type = 'BASE TABLE'\n                  AND table_schema = 'public'\n                  ORDER BY table_type, table_name");
             foreach ($tableRows as $row) {
                 $tables[] = $row->table_name;
             }
         }
     }
     return $tables;
 }

 public function exportAllTranslations()
 {
     $select = '';
     switch (DB::getDriverName()) {
         case 'mysql':
             $select = 'DISTINCT `group`';
             break;
         default:
             $select = 'DISTINCT "group"';
             break;
     }
     $groups = Translation::whereNotNull('value')->select(DB::raw($select))->get('group');
     foreach ($groups as $group) {
         $this->exportTranslations($group->group);
     }
 }

 /**
  * Insert entries in a table
  *
  * @param string $table
  * @param array  $entries
  */
 protected function insertEntries($table, $entries)
 {
     $slices = array($entries);
     // If the engine is SQLite and we have a lot of seeded entries
     // We'll split the results to not overflow the variable limit
     if (DB::getDriverName() === 'sqlite') {
         $slicer = floor(999 / sizeof($entries[0]));
         $slices = array_chunk($entries, $slicer);
     }
     if ($this->command) {
         $this->command->comment('Insert entries');
     }
     $this->progressIterator($slices, function ($entries) use($table) {
         DB::table($table)->insert($entries);
     });
 }

 /**
  * Datatable filtering
  *
  * @return null
  */
 protected function filtering()
 {
     // copy of $this->columns without columns removed by remove_column
     $columns_copy = $this->columns;
     for ($i = 0, $c = count($columns_copy); $i < $c; $i++) {
         if (in_array($this->getColumnName($columns_copy[$i]), $this->excess_columns)) {
             unset($columns_copy[$i]);
         }
     }
     $columns_copy = array_values($columns_copy);
     // copy of $this->columns cleaned for database queries
     $columns_clean = $this->clean_columns($columns_copy, false);
     $columns_copy = $this->clean_columns($columns_copy, true);
     // global search
     if ($this->input['search']['value'] != '') {
         $_this = $this;
         $this->query->where(function ($query) use(&$_this, $columns_copy, $columns_clean) {
             $db_prefix = $_this->database_prefix();
             for ($i = 0, $c = count($_this->input['columns']); $i < $c; $i++) {
                 if (isset($columns_copy[$i]) && $_this->input['columns'][$i]['searchable'] == "true") {
                     // if filter column exists for this columns then use user defined method
                     if (isset($_this->filter_columns[$columns_copy[$i]])) {
                         // check if "or" equivalent exists for given function
                         // and if the number of parameters given is not excess
                         // than call the "or" equivalent
                         $method_name = 'or' . ucfirst($_this->filter_columns[$columns_copy[$i]]['method']);
                         if (method_exists($query->getQuery(), $method_name) && count($_this->filter_columns[$columns_copy[$i]]['parameters']) <= with(new \ReflectionMethod($query->getQuery(), $method_name))->getNumberOfParameters()) {
                             call_user_func_array(array($query, $method_name), $_this->inject_variable($_this->filter_columns[$columns_copy[$i]]['parameters'], $_this->input['search']['value']));
                         }
                     } else {
                         $keyword = '%' . $_this->input['search']['value'] . '%';
                         if (Config::get('datatables::search.use_wildcards', false)) {
                             $keyword = $_this->wildcard_like_string($_this->input['search']['value']);
                         }
                         // Check if the database driver is PostgreSQL
                         // If it is, cast the current column to TEXT datatype
                         $cast_begin = null;
                         $cast_end = null;
                         if (DB::getDriverName() === 'pgsql') {
                             $cast_begin = "CAST(";
                             $cast_end = " as TEXT)";
                         }
                         $column = $db_prefix . $columns_clean[$i];
                         if (Config::get('datatables::search.case_insensitive', false)) {
                             $query->orwhere(DB::raw('LOWER(' . $cast_begin . $column . $cast_end . ')'), 'LIKE', strtolower($keyword));
                         } else {
                             $query->orwhere(DB::raw($cast_begin . $column . $cast_end), 'LIKE', $keyword);
                         }
                     }
                 }
             }
         });
     }
     $db_prefix = $this->database_prefix();
     // column search
     for ($i = 0, $c = count($this->input['columns']); $i < $c; $i++) {
         if (isset($columns_copy[$i]) && $this->input['columns'][$i]['orderable'] == "true" && $this->input['columns'][$i]['search']['value'] != '') {
             // if filter column exists for this columns then use user defined method
             if (isset($this->filter_columns[$columns_copy[$i]])) {
                 call_user_func_array(array($this->query, $this->filter_columns[$columns_copy[$i]]['method']), $this->inject_variable($this->filter_columns[$columns_copy[$i]]['parameters'], $this->input['columns'][$i]['search']['value']));
             } else {
                 $keyword = '%' . $this->input['columns'][$i]['search']['value'] . '%';
                 if (Config::get('datatables::search.use_wildcards', false)) {
                     $keyword = $this->wildcard_like_string($this->input['columns'][$i]['search']['value']);
                 }
                 if (Config::get('datatables::search.case_insensitive', false)) {
                     $column = $db_prefix . $columns_clean[$i];
                     $this->query->where(DB::raw('LOWER(' . $column . ')'), 'LIKE', strtolower($keyword));
                 } else {
                     $col = strstr($columns_clean[$i], '(') ? DB::raw($columns_clean[$i]) : $columns_clean[$i];
                     $this->query->where($col, 'LIKE', $keyword);
                 }
             }
         }
     }
 }