Revize 92577cfd

Seeding

app/Artefact.php

@@ -7 +7 @@
 class Artefact extends Model
 {
     // Table Name
-    protected $table = 'artefacts';//unnecessery?
+    protected $table = 'artefacts';
     // Primary Key
-    public $primaryKey = 'id';//unnecessery?
-
-    /**
-     * The model's default values for attributes.
-     *
-     * @var array
-     */
-    /*protected $attributes = [
-        'likes' => 0,
-    ];*/
+    public $primaryKey = 'id';
 
     /**
      * Indicates if the model should be timestamped.
@@ -50 +41 @@
     {
         return $this->belongsToMany('App\User');
     }
-
-
-
 }

app/Category.php

@@ -9 +9 @@
     // Table Name
     protected $table = 'categories';
     // Primary Key
-    public $primaryKey = 'id';//unnecessery?
-
+    public $primaryKey = 'id';
 
     /**
      * Indicates if the model should be timestamped.
@@ -20 +19 @@
     public $timestamps = false;
 
     /**
-     * Get the artefacts for the catagory.
+     * Get the artefacts for the category.
      */
     public function artefacts()
     {
         return $this->belongsToMany('App\Artefact');
     }
-
-
 }

app/Metadata.php

@@ -7 +7 @@
 class Metadata extends Model
 {
     // Table Name
-    protected $table = 'metadata';//same name could make problems
+    protected $table = 'metadata';
     // Primary Key
-    public $primaryKey = 'id';//unnecessery?
-
-    /**
-     * The model's default values for attributes.
-     *
-     * @var array
-     */
-    /*protected $attributes = [
-        'likes' => 0,
-    ];*/
+    public $primaryKey = 'id';
 
     /**
      * Indicates if the model should be timestamped.

app/User.php

@@ -2 +2 @@
 
 namespace App;
 
-use Illuminate\Contracts\Auth\MustVerifyEmail;
 use Illuminate\Foundation\Auth\User as Authenticatable;
 use Illuminate\Notifications\Notifiable;
 
@@ -13 +12 @@
     // Table Name
     protected $table = 'users';
     // Primary Key
-    public $primaryKey = 'id';//unnecessery?
+    public $primaryKey = 'id';
 
     /**
      * The attributes that are mass assignable.

database/factories/ArtefactFactory.php

@@ +1 @@
+<?php
+
+/** @var Factory $factory */
+/** @var Faker $faker */
+
+use App\Artefact;
+use App\Category;
+use Faker\Generator as Faker;
+use Illuminate\Database\Eloquent\Factory;
+
+$factory->define(Artefact::class, function ($faker) {
+    return [
+        'name' => $faker->opera,
+        'author' => $faker->name,
+        'made_in' => $faker->countryCode,
+        'publisher' => $faker->company,
+        'year' => rand(1800, 2020),
+        'pages' => rand(0, 2000),
+        'main_category_id' => factory(Category::class)->create()->id,
+    ];
+});

database/factories/CategoryFactory.php

@@ +1 @@
+<?php
+
+/** @var Factory $factory */
+
+use App\Category;
+use Faker\Generator as Faker;
+use Illuminate\Database\Eloquent\Factory;
+
+$factory->define(Category::class, function (Faker $faker) {
+    return [
+        'nameCZ' => $faker->colorName,
+        'nameEN' => $faker->hexColor,
+    ];
+});

database/factories/MetadataFactory.php

@@ +1 @@
+<?php
+
+/** @var Factory $factory */
+/** @var Faker $faker */
+
+use App\Artefact;
+use App\Metadata;
+use Faker\Generator as Faker;
+use Illuminate\Database\Eloquent\Factory;
+
+$factory->define(Metadata::class, function ($faker) use ($factory) {
+    return [
+        'name' => $faker->streetName,
+        'noteCZ' => $faker->paragraph,
+        'noteEN' => $faker->paragraph,
+        'page' => rand(0, 2000),
+        'artefact_id' => factory(Artefact::class)->create()->id
+    ];
+});

database/factories/UserFactory.php

@@ -1 +1 @@
 <?php
 
-/** @var \Illuminate\Database\Eloquent\Factory $factory */
+/** @var Factory $factory */
 
 use App\User;
 use Faker\Generator as Faker;
+use Illuminate\Database\Eloquent\Factory;
 use Illuminate\Support\Str;
 
 /*
@@ -22 +23 @@
         'name' => $faker->name,
         'email' => $faker->unique()->safeEmail,
         'email_verified_at' => now(),
-        'password' => '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', // password
+        'password' => bcrypt($faker->unique()->password),
         'remember_token' => Str::random(10),
+        'created_at' => now(),
+        'updated_at' => now(),
     ];
 });

database/seeds/DatabaseSeeder.php

@@ -1 +1 @@
 <?php
 
 use Illuminate\Database\Seeder;
+use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Str;
 
 class DatabaseSeeder extends Seeder
 {
@@ -11 +13 @@
      */
     public function run()
     {
-        // $this->call(UsersTableSeeder::class);
+        DB::table('users')->insert([
+            'name' => 'admin',
+            'email' => '[e-mail]',
+            'email_verified_at' => now(),
+            'password' => bcrypt('admin'),
+            'remember_token' => Str::random(10),
+            'created_at' => now(),
+            'updated_at' => now(),
+        ]);
+
+        // Populate users
+        factory(App\User::class, 19)->create();
+
+        // Populate categories
+        factory(App\Category::class, 80)->create();
+
+        // Populate artefacts with metadata
+        factory(App\Artefact::class, 300)->create()->each(function ($u) {
+            $u->metadata()->saveMany(factory(App\Metadata::class, 10)->make());
+        });
+
+        // Get all the categories attaching up to 1 random categories to each user
+        $categories = App\Category::all();
+
+        // Populate the artefact_category pivot table
+        App\Artefact::all()->each(function ($artefact) use ($categories) {
+            $artefact->categories()->attach(
+                $categories->random(1)->pluck('id')->toArray()
+            );
+        });
+
+        // Get all the metadata attaching up to 50 random metadata to each user
+        $artefacts = App\Metadata::all();
+
+        // Populate the artefact_user pivot table
+        App\User::all()->each(function ($user) use ($artefacts) {
+            $user->likesArtefacts()->attach(
+                $artefacts->random(rand(1, 50))->pluck('id')->toArray()
+            );
+        });
+
+        // Get all the metadata attaching up to 50 random metadata to each user
+        $metadata = App\Metadata::all();
+
+        // Populate the metadata_user pivot table
+        App\User::all()->each(function ($user) use ($metadata) {
+            $user->likesMetadata()->attach(
+                $metadata->random(rand(1, 50))->pluck('id')->toArray()
+            );
+        });
     }
 }