/**
* 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']);
}
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']]);
}
}
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
]);
}
public function run()
{
DB::table('cities_regions')->delete();
City::create(['name' => 'Харьков', 'region_id' => 1]);
City::create(['name' => 'Москва', 'region_id' => 2]);
}
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);
}
