/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DatabaseSeeder::truncateTable('dvds');
factory(\App\Dvd::class, 200)->create()->each(function (\App\Dvd $dvd, $i) {
// 書籍名に連番を付与
$dvd->update(['title' => $dvd->title . ($i + 1)]);
});
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DatabaseSeeder::truncateTable('phones');
$authors = \App\Author::all();
foreach ($authors as $author) {
\App\Phone::create(['author_id' => $author->id, 'phone_number' => '0' . (string) (9099990000 + $author->id)]);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DatabaseSeeder::truncateTable('prefectures');
$prefectures = [1 => '北海道', 2 => '青森県', 3 => '岩手県', 4 => '宮城県', 5 => '秋田県', 6 => '山形県', 7 => '福島県', 8 => '茨城県', 9 => '栃木県', 10 => '群馬県', 11 => '埼玉県', 12 => '千葉県', 13 => '東京都', 14 => '神奈川県', 15 => '新潟県', 16 => '富山県', 17 => '石川県', 18 => '福井県', 19 => '山梨県', 20 => '長野県', 21 => '岐阜県', 22 => '静岡県', 23 => '愛知県', 24 => '三重県', 25 => '滋賀県', 26 => '京都府', 27 => '大阪府', 28 => '兵庫県', 29 => '奈良県', 30 => '和歌山県', 31 => '鳥取県', 32 => '島根県', 33 => '岡山県', 34 => '広島県', 35 => '山口県', 36 => '徳島県', 37 => '香川県', 38 => '愛媛県', 39 => '高知県', 40 => '福岡県', 41 => '佐賀県', 42 => '長崎県', 43 => '熊本県', 44 => '大分県', 45 => '宮崎県', 46 => '鹿児島県', 47 => '沖縄県'];
foreach ($prefectures as $id => $name) {
DB::table('prefectures')->insert(['id' => $id, 'name' => $name]);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DatabaseSeeder::truncateTable('publishers');
factory(\App\Publisher::class, 50)->create();
factory(\App\Publisher::class, 200)->create()->each(function (\App\Publisher $publisher, $key) {
// ローマ字に連番を付与
$publisher->update(['romaji' => $publisher->romaji . ' ' . ($key + 1)]);
});
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DatabaseSeeder::truncateTable('author_author_type');
DatabaseSeeder::truncateTable('author_types');
try {
factory(\App\AuthorType::class, 10)->create();
} catch (\Illuminate\Database\QueryException $e) {
// name カラムの unique index の無視
}
$authors = \App\Author::all();
/** @var \App\Author $author */
foreach ($authors as $author) {
$author_types = \App\AuthorType::all()->random(rand(2, 5));
$author->types()->sync($author_types);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
// (1) データを一旦削除する
DatabaseSeeder::truncateTable('authors');
// (2) DBファサードを利用したデータの挿入
$authors = [];
$now = \Carbon\Carbon::now();
for ($i = 1; $i <= 10; $i++) {
$authors[] = ['name' => '著者名' . $i, 'furigana' => 'フリガナ' . $i, 'romaji' => 'Romaji' . $i];
}
foreach ($authors as $author) {
$author['created_at'] = $now;
$author['updated_at'] = $now;
DB::table('authors')->insert($author);
}
// (3) Eloquentを利用したデータの挿入
for ($i = 11; $i <= 20; $i++) {
\App\Author::create(['name' => '著者名' . $i, 'furigana' => 'フリガナ' . $i, 'romaji' => 'Romaji' . $i]);
}
}