Changeset ea7b12a for database

Timestamp:

10/19/21 17:46:21 (3 years ago)

Author:

beratkjufliju <kufliju@…>

Branches:

develop, master

Children:

6b95845

Parents:

b9c4a92

Message:

added files crud in table

Location:

database

Files:

• factories/DepartmentFactory.php (modified) (1 diff)
• factories/DocumentFactory.php (modified) (1 diff)
• migrations/2021_10_10_103309_create_files_table.php (modified) (1 diff)
• seeders/DatabaseSeeder.php (modified) (1 diff)
• seeders/DepartmentsTableSeeder.php (modified) (1 diff)
• seeders/DocumentsTableSeeder.php (modified) (1 diff)

database/factories/DepartmentFactory.php

@@ -24 +24 @@
     public function definition()
     {
-        $location = $this->faker->randomNumber('1', '1');
+        $location = $this->faker->unique()->numberBetween('1', '9');
         Storage::disk('local')->makeDirectory('Departments/' . $location);
         return [

database/factories/DocumentFactory.php

@@ -26 +26 @@
     {
 
-        $deptID = "1";
+        $deptID = "5";
         $name = $this->faker->unique()->firstName();
         Storage::disk('local')->makeDirectory('Departments' . DIRECTORY_SEPARATOR . $deptID . DIRECTORY_SEPARATOR . $name);

database/migrations/2021_10_10_103309_create_files_table.php

@@ -16 +16 @@
         Schema::create('files', function (Blueprint $table) {
             $table->bigIncrements('id');
-            $table->bigInteger('document_id')->unsigned()->nullable();
-            $table->string("link");
+            $table->bigInteger('document_id')->unsigned();
+            $table->string("name");
+            $table->string("location");
             $table->foreign("document_id")->references("id")->on("documents");
             $table->timestamps();

database/seeders/DatabaseSeeder.php

@@ -19 +19 @@
         $this->call(UsersTableSeeder::class);
         $this->call(DepartmentsTableSeeder::class);
-        $this->call(DocumentsTableSeeder::class);
+        //$this->call(DocumentsTableSeeder::class);
     }
 }

database/seeders/DepartmentsTableSeeder.php

@@ -16 +16 @@
     public function run()
     {
-        Department::factory()->count(10)->create();
+        Department::factory()->count(8)->create();
     }
 }

database/seeders/DocumentsTableSeeder.php

@@ -106 +106 @@
 //            ],
 //        ]);
-        Document::factory()->count(300)->create();
+        Document::factory()->count(10)->create();
     }
 }