PHP DB::connection方法代码示例

 /**
  * Handle the command
  *
  * @return mixed
  */
 public function fire()
 {
     try {
         /** @var Connection $_db */
         /** @noinspection PhpUndefinedMethodInspection */
         $_db = DB::connection($this->database);
     } catch (\Exception $_ex) {
         throw new \InvalidArgumentException('The database "' . $this->database . '" is invalid.');
     }
     $_database = $this->database;
     $this->_v('* connected to database <info>' . $_database . '</info>.');
     $_tablesWanted = $this->option('tables');
     if (!empty($_tablesWanted)) {
         $_list = explode(',', $_tablesWanted);
         $_tablesWanted = empty($_list) ? false : ($_tablesWanted = $_list);
         $this->_vv('* ' . count($_tablesWanted) . ' table(s) will be scanned.');
     } else {
         $this->_vv('* all tables will be scanned.');
     }
     $_sm = $_db->getDoctrineSchemaManager();
     $_tableNames = $_sm->listTableNames();
     $this->_writeln('* examining ' . count($_tableNames) . ' table(s)...');
     foreach ($_tableNames as $_tableName) {
         if ($_tablesWanted && !in_array($_tableName, $_tablesWanted)) {
             $this->_vvv('  * SKIP table <comment>' . $_tableName . '</comment>.');
             continue;
         }
         $this->_v('  * SCAN table <info>' . $_tableName . '</info>.');
         if ($this->_examineTable($_sm->listTableDetails($_tableName))) {
             $this->_writeln('  * <info>' . $_tableName . '</info> complete.');
         }
     }
     return true;
 }

 /**
  * Define the application's command schedule.
  *
  * @param  \Illuminate\Console\Scheduling\Schedule  $schedule
  * @return void
  */
 protected function schedule(Schedule $schedule)
 {
     $schedule->call(function () {
         $players = DB::connection('game')->table('player_characters')->get();
         foreach ($players as $player) {
             if (!Player::where('id', $player->id)->exists()) {
                 $player_info = ['id' => $player->id, 'name' => $player->given_name, 'level' => $player->level, 'class' => 0, 'gold' => $player->gold, 'family_name' => $player->family_id ? DB::connection('game')->table('family')->where('id', $player->family_id)->first()->name : '-'];
                 Player::create($player_info);
             }
         }
     })->everyTenMinutes();
     $schedule->call(function () {
         $families = DB::connection('game')->table('family')->get();
         foreach ($families as $family) {
             if (!Family::where('id', $family->id)->exists()) {
                 $gold = 0;
                 foreach (DB::connection('game')->table('player_characters')->where('family_id', $family->id)->get() as $player) {
                     $gold += $player->gold;
                 }
                 $family_info = ['id' => $family->id, 'name' => $family->name, 'level' => $family->lv, 'gold' => $gold, 'members' => DB::connection('game')->table('player_characters')->where('family_id', $family->id)->count(), 'leader' => DB::connection('game')->table('player_characters')->where('id', $family->leader_id)->first()->given_name];
                 Family::create($family_info);
             }
         }
     })->everyTenMinutes();
 }

 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function fire(Almaty $almaty, Astana $astana)
 {
     $city = $this->option('city');
     if ($city == 1) {
         $this->city = $almaty;
     } else {
         $this->city = $astana;
     }
     if ($this->city->obman_gps == "0") {
         return false;
     }
     $results = DB::connection($this->city->db)->table('cars')->join('crews', 'crews.car', '=', 'cars.id')->join('crews_inline as ci', 'crews.id', '=', 'ci.id')->join('wialon_cars as wi', 'cars.gn', '=', 'wi.gn')->where('ci.status', '=', 'waiting')->select('crews.driver', 'cars.gn', 'crews.id', 'ci.status', 'wi.pos_x AS wi_lon', 'wi.pos_y AS wi_lat', 'ci.lat AS tm_lat', 'ci.lon AS tm_lon')->get();
     if (!empty($results)) {
         foreach ($results as $v) {
             if (isset($v->tm_lat) && isset($v->tm_lon) && isset($v->wi_lat) && isset($v->wi_lon)) {
                 $diff = Helpers::distance($v->tm_lat, $v->tm_lon, $v->wi_lat, $v->wi_lon) / 1000;
                 $diff = round($diff, 1);
                 if ($diff >= 4.5) {
                     if (isset($v->driver)) {
                         $tm_address = Helpers::get_address_by_coords($v->tm_lat, $v->tm_lon);
                         $wialon_address = Helpers::get_address_by_coords($v->wi_lat, $v->wi_lon);
                         $this->call('drivers:operations', ['driver' => $v->driver, 'op' => 0, 'summ' => $this->city->obman_gps_price, 'reason' => 'Обман GPS', 'time' => time(), 'comment' => "ТМ Адрес: {$tm_address}, Wialon Адрес: {$wialon_address} Разница: {$diff} км", '--city' => $city]);
                     }
                 }
             }
         }
     }
 }

 public function createTable($table)
 {
     // drop existing table
     DB::statement("drop table if exists `{$table}`");
     $header = $this->request->getHeader();
     $listings = $this->getListings();
     $fields = [];
     foreach ($listings as $listing) {
         unset($listing->datajoeEntity);
         foreach ($listing as $k => $v) {
             if (isset($fields[$k])) {
                 $fields[$k] = strlen(print_r($v, TRUE)) > $fields[$k] ? strlen(print_r($v, TRUE)) + 100 : $fields[$k];
             } else {
                 $fields[$k] = strlen(print_r($v, TRUE)) + 100;
             }
         }
     }
     $sql = "CREATE TABLE IF NOT EXISTS `{$table}` (\n\t\t\t`id` MEDIUMINT( 10 ) UNSIGNED NOT NULL,\n\t\t\t`name` VARCHAR( 100 ) NOT NULL COMMENT 'Name',\n";
     foreach ($fields as $k => $v) {
         if ($k != 'name' && $k != 'id') {
             $sql .= "`{$k}` VARCHAR( {$v} ) NOT NULL COMMENT " . str_replace('?', '?', DB::connection()->getPdo()->quote($header->{$k}->label)) . ",\n";
         }
     }
     $sql .= "FULLTEXT KEY `name` (`name`),\n\t\t\tPRIMARY KEY ( `id` )\n\t\t\t) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;";
     DB::statement($sql);
 }

 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function fire()
 {
     $this->info('Begin: ' . date('H:i:s'));
     DB::connection('mysql')->table('snapshot')->truncate();
     $query = "insert into snapshot {$this->getQuery(1, false)}";
     DB::connection('mysql')->statement($query);
     $result = DB::connection('mysql')->select($this->getQuery(2, true));
     $rows = $result[0]->total;
     $this->info("Total de filas: {$rows}");
     $begin = 0;
     $block = 15000;
     $countBlock = 1;
     $fCsv = storage_path('app/snapshots/' . date('Ymd') . '.csv');
     if (file_exists($fCsv)) {
         unlink($fCsv);
     }
     $fp = fopen($fCsv, 'w');
     fputs($fp, "estado,emisor,nombre,organizacion,dni,ruc,codigo,solicitud,fecha_solicitud,fecha_anulado,fecha_gencer,fecha_revocado,fecha_expira \n");
     while ($rows > $begin) {
         $result = DB::connection('mysql')->select($this->getQuery(2, false, $begin, $block));
         foreach ($result as $key => $value) {
             $resultArray = json_decode(json_encode($value), true);
             fputs($fp, str_replace("\n", '', implode($resultArray, ',')) . "\n");
         }
         $this->info("End block {$countBlock}: " . date('H:i:s'));
         $begin += $block;
         $countBlock++;
     }
     fclose($fp);
     $this->info('End export to csv: ' . date('H:i:s'));
     $this->info('End: ' . date('H:i:s'));
 }

 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     foreach ($this->dumpFiles() as $dumpPart) {
         $query = "LOAD DATA LOCAL INFILE '" . str_replace('\\', '/', $dumpPart) . "'\n                    INTO TABLE `" . Config::citiesTableName() . "` \n                        FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"'\n                        LINES TERMINATED BY '\n' IGNORE 1 LINES\n                        (country,\n                        city_ascii,\n                        city,\n                        region,\n                        population,\n                        latitude,\n                        longitude\n                    )";
         DB::connection()->getpdo()->exec($query);
     }
 }

 public static function queryComment($model)
 {
     try {
         $results = DB::connection('mysql_system')->select('select COLUMN_NAME,COLUMN_COMMENT FROM columns WHERE table_schema = ? AND table_name = ?', [env('DB_DATABASE'), with($model)->getTable()]);
     } catch (\Exception $ex) {
         return [];
     }
     $column_names = [];
     foreach ($results as $result) {
         switch ($result->COLUMN_NAME) {
             case 'created_at':
                 $column_names[$result->COLUMN_NAME] = '创建时间';
                 break;
             case 'updated_at':
                 $column_names[$result->COLUMN_NAME] = '修改时间';
                 break;
             case 'deleted_at':
                 $column_names[$result->COLUMN_NAME] = '删除时间';
                 break;
             default:
                 $column_names[$result->COLUMN_NAME] = $result->COLUMN_COMMENT;
                 break;
         }
     }
     return $column_names;
 }

 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function handle()
 {
     $count = 0;
     $pdo = DB::connection()->getPdo();
     $query = "SELECT * FROM archivos_sat;";
     $stmt = $pdo->prepare($query);
     $stmt->execute();
     while ($row = $stmt->fetchObject()) {
         $count++;
         if ($count % 100 == 0) {
             $this->comment("arch sat: " . $count);
         }
         $archivo = ArchivoSat::find($row->id);
         $parser = new ParserCFID($archivo->file);
         $parser->parser();
         $archivo->fecha = $parser->getFecha();
         $archivo->save();
     }
     $count = 0;
     $pdo = DB::connection()->getPdo();
     $query = "SELECT * FROM archivos_empresa;";
     $stmt = $pdo->prepare($query);
     $stmt->execute();
     while ($row = $stmt->fetchObject()) {
         $count++;
         if ($count % 100 == 0) {
             $this->comment("arch emp: " . $count);
         }
         $archivo = ArchivoEmpresa::find($row->id);
         $parser = new ParserCFID($archivo->file);
         $parser->parser();
         $archivo->fecha = $parser->getFecha();
         $archivo->save();
     }
 }

 public function registerDi()
 {
     if ($this->registerDi) {
         return;
     }
     // Register service provider
     $this->container['logger'] = function ($c) {
         $arLogerConf = $c->settings['use_log'] ? $c->settings['register_log'] : [];
         $logger = new LoggerSystem(new Logger('slimcms_core'), $arLogerConf);
         //new Logger('slimcms_core');
         $filename = $c->settings['log_filename'] ? $c->settings['log_filename'] : "app.log";
         $handler = new StreamHandler(ROOT_PATH . "log/" . $filename);
         if ($c['settings']['log_system'] == 'db') {
             $handler = new MySQLHandler(DB::connection()->getPdo(), "logging");
             if (DB::connection()->getDriverName() == 'sqlite') {
                 $handler = new SqliteMonologHandler(DB::connection()->getPdo(), "logging");
             }
         }
         if ($c['settings']['use_log']) {
             $logger->pushHandler($handler);
         }
         return $logger;
     };
     $this->registerDi = true;
 }

 public function getMmPoint(Request $request)
 {
     $key = request('key');
     $mmpointM = DB::connection(DBUtils::getDBName())->table('mmpoint_table')->where('A', $key)->first();
     // Log::info("lenth ".sizeof($mmtrendM));
     return response()->json(['mmpointM' => json_encode($mmpointM)]);
 }

 public function run()
 {
     DB::connection('devaudit')->table('Receipt_History')->delete();
     /*
     * desc Receipt_History;
             +------------+---------------------+------+-----+---------------------+----------------+
             | Field      | Type                | Null | Key | Default             | Extra          |
             +------------+---------------------+------+-----+---------------------+----------------+
             | activityID | bigint(20) unsigned | NO   | PRI | NULL                | auto_increment |
             | PO         | bigint(20)          | NO   |     | NULL                |                |
             | POD        | bigint(20)          | NO   |     | NULL                |                |
             | Article    | bigint(20)          | YES  |     | NULL                |                |
             | UPC        | bigint(20)          | YES  |     | NULL                |                |
             | Inventory  | bigint(20)          | YES  |     | NULL                |                |
             | Tote       | bigint(20)          | YES  |     | NULL                |                |
             | Cart       | bigint(20)          | YES  |     | NULL                |                |
             | Location   | bigint(20)          | YES  |     | NULL                |                |
             | User_Name  | varchar(85)         | NO   |     | NULL                |                |
             | created_at | timestamp           | NO   |     | 0000-00-00 00:00:00 |                |
             | updated_at | timestamp           | NO   |     | 0000-00-00 00:00:00 |                |
             | Activity   | text                | NO   |     | NULL                |                |
             +------------+---------------------+------+-----+---------------------+----------------+
             11 rows in set (0.01 sec)
     */
     ReceiptHistory::create(['PO' => '6232063897', 'POD' => '6232063899', 'Article' => '6217093230', 'UPC' => '6217092826', 'Inventory' => '6231963444', 'Tote' => '6231978189', 'Cart' => '6216954640', 'Location' => '', 'User_Name' => 'pneal', 'Activity' => 'Received UPC into Tote - 2015-02-20 01:05:08, UPC# 63664347409, Tote# 52 0030 3099, (1 of 10)']);
     ReceiptHistory::create(['PO' => '6232063897', 'POD' => '6232063899', 'Article' => '6217093230', 'UPC' => '6217092826', 'Inventory' => '6231963444', 'Tote' => '6231978189', 'Cart' => '6216954640', 'Location' => '', 'User_Name' => 'pneal', 'Activity' => 'Received UPC into Tote - 2015-02-20 01:05:12, UPC# 63664347409, Tote# 52 0030 3099, (2 of 10)']);
     ReceiptHistory::create(['PO' => '6232063897', 'POD' => '6232063899', 'Article' => '6217093230', 'UPC' => '6217092826', 'Inventory' => '6231963444', 'Tote' => '6231978189', 'Cart' => '6216954640', 'Location' => '', 'User_Name' => 'pneal', 'Activity' => 'Received UPC into Tote - 2015-02-20 01:05:17, UPC# 63664347409, Tote# 52 0030 3099, (3 of 10)']);
     ReceiptHistory::create(['PO' => '6232063897', 'POD' => '6232063899', 'Article' => '6217093230', 'UPC' => '6217092826', 'Inventory' => '6231963444', 'Tote' => '6231978189', 'Cart' => '6216954640', 'Location' => '', 'User_Name' => 'pneal', 'Activity' => 'Received UPC into Tote - 2015-02-20 01:05:23, UPC# 63664347409, Tote# 52 0030 3099, (4 of 10)']);
 }

 /**
  * Execute the console command.
  */
 public function handle()
 {
     $file = base_path('resources') . '/new_name.txt';
     $handle = fopen($file, 'r');
     if (!$handle) {
         throw new FileNotFoundException($file);
     }
     while (($line = fgets($handle)) !== false) {
         $data = explode("\t", $line);
         if (count($data) != 2) {
             continue;
         }
         $newName = trim($data[1]);
         if (empty($newName)) {
             continue;
         }
         DB::update('update organizations set fullName=' . DB::connection()->getPdo()->quote($newName) . ' where edrpou=' . DB::connection()->getPdo()->quote($data[0]) . ' limit 1');
         var_dump(1);
         //      if(++$j >= 2000) {
         //        $values = implode(', ', array_map(function($v){
         //          foreach($v as &$vv)
         //            $vv = DB::connection()->getPdo()->quote($vv);
         //          return '('. implode(',', $v) .')';
         //        }, $rows));
         //
         //        DB::insert('insert ignore into `fio` (`name`, `nameRU`) values '. $values .' ON DUPLICATE KEY UPDATE c=c+1');
         //        $j = 0;
         //        $rows = [];
         //      }
     }
     fclose($handle);
 }

 public function __construct()
 {
     $this->schema = DB::connection()->getSchemaBuilder();
     $this->schema->blueprintResolver(function ($table, $callback) {
         return new Blueprint($table, $callback);
     });
 }

 public function diagnosed(Request $request)
 {
     $this->validate($request, ["mrId" => "required", "bldp" => "required", "docId" => "required"]);
     DB::connection("centraldb")->table('MR' . $_POST["patId"])->where('id', $_POST["mrId"])->update(array('flag' => 1, "data" => $_POST["bldp"]));
     General::addToQ($_POST["docId"], $_POST["patId"]);
     return redirect("diag");
 }

 /**
  * Create a new user instance after a valid registration.
  *
  * @param  array  $data
  * @return User
  */
 protected function create(array $data)
 {
     $new_id = User::all()->count() > 0 ? User::orderBy('id', 'desc')->first()->id + 1 : 2400;
     DB::connection('member')->table('tb_user')->insert(['mid' => $data['name'], 'password' => $data['password'], 'pwd' => Hash::make($data['password']), 'idnum' => $new_id]);
     DB::connection('account')->table('accounts')->insert(['id' => $new_id, 'username' => $data['name'], 'password' => $data['password']]);
     return User::create(['id' => $new_id, 'username' => $data['name'], 'password' => Hash::make($data['password']), 'role' => 'member']);
 }