Ejemplo n.º 1
0
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     DB::table('Cities')->delete();
     City::create(['id' => 1, 'city_name' => 'Vilnius']);
     City::create(['id' => 2, 'city_name' => 'Kaunas']);
     City::create(['id' => 3, 'city_name' => 'Klaipeda']);
     City::create(['id' => 4, 'city_name' => 'Kita']);
 }
Ejemplo n.º 2
0
 public function run()
 {
     DB::table('users')->delete();
     $VK = new VK(env('VK_APP_ID'), env('VK_KEY_SECRET'));
     $vkCities = $VK->api('database.getCities', ['need_all' => 1, 'count' => 1000, 'lang' => 'ru']);
     while (count($vkCities) == 1000) {
         foreach ($vkCities['response'] as $country) {
             City::create(['id' => $country['id'], 'title' => $country['title']]);
         }
         $vkCities = $VK->api('database.getCities', ['need_all' => 1, 'count' => 1000, 'lang' => 'ru']);
     }
     foreach ($vkCities['response'] as $country) {
         City::create(['id' => $country['id'], 'title' => $country['title']]);
     }
 }
Ejemplo n.º 3
0
  public function run ()
  {
  
    DB::table('cities')->delete();

    City::create([
    
      'cname' => '上海',

      'ename' => 'ShangHai',

      'code' => 1,

      'country_code' => 1,

      'province_code' => 1,

      'post_code' => 200001,

      'active' => 1
    
    ]);
  
  }
Ejemplo n.º 4
0
 public function run()
 {
     DB::table('cities_regions')->delete();
     City::create(['name' => 'Харьков', 'region_id' => 1]);
     City::create(['name' => 'Москва', 'region_id' => 2]);
 }
Ejemplo n.º 5
0
 private function processUpdate()
 {
     $ids = $this->getRandomsNumbers(50, 50000, 1);
     $ids2 = $this->getRandomsNumbers(50);
     $queryesExecution = array();
     $peoples = array();
     foreach ($ids as $key => $id) {
         Debug::timer();
         // SELECT + UPDATE DATA
         $people = Models\People::find($id);
         $city = Models\City::findByName($this->peoplesData[$ids2[$key]]['city']);
         if ($city == NULL) {
             $city = Models\City::create($this->peoplesData[$ids2[$key]]['city']);
         }
         $people->setName($this->peoplesData[$ids2[$key]]['name'])->setStreet($this->peoplesData[$ids2[$key]]['street'])->setCity($city)->setMail($this->peoplesData[$ids2[$key]]['mail']);
         $peoples[] = $people->save();
         $queryesExecution[] = number_format(Debug::timer() * 1000, 2);
     }
     return array($queryesExecution, $peoples);
 }