[FIX][php]: issue when running php artisan migrate --seed

[cyrilmano]

Description:

This issue happened when running the php artisan migrate --seed
The CategoriesTableSeeder tried to truncate the categories table. check screenshot of image below.

Expected Behavior:

The truncating during seeding after the migration, failed due to foreign key constraints on category_product.category_id_foreign

Below the error message;

Database\Seeders\CategoriesTableSeeder .................................................................... RUNNING  

   Illuminate\Database\QueryException 

  SQLSTATE[42000]: Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint (`hng_boilerplate`.`category_product`, CONSTRAINT `category_product_category_id_foreign`) (Connection: mysql, SQL: truncate table `categories`)

  at vendor\laravel\framework\src\Illuminate\Database\Connection.php:829
    825▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    826▕                 );
    827▕             }
    828▕
  ➜ 829▕             throw new QueryException(
    830▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    831▕             );
    832▕         }
    833▕     }

  1   vendor\laravel\framework\src\Illuminate\Database\Connection.php:587
    828▕
  ➜ 829▕             throw new QueryException(
    830▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    831▕             );
    832▕         }
    833▕     }
    828▕
  ➜ 829▕             throw new QueryException(
    830▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    831▕             );
    828▕
  ➜ 829▕             throw new QueryException(
    830▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    828▕
  ➜ 829▕             throw new QueryException(
    828▕
    828▕
  ➜ 829▕             throw new QueryException(
    830▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    831▕             );
    832▕         }
    833▕     }

### Changes to be Made

1. Disable foreign key checks before truncating
2. Use Delete Instead of Truncate
3. Then after which enable foreign key checks after truncating

[cyrilmano]

Expected Behavior: The truncating failed due to foreign key constraints on category_product.category_id_foreign

[cyrilmano]

Issue created by: [email protected]
Slack Display Name: ThankGod Cyril Uche on LinkedIn

[omotomiwa26]

Use This Issue Template

[cyrilmano]

Use This Issue Template

Thank you for the feedback. And I have made used the template as a guide to make adjustment to the description, expected behaviour, and also use the <> code formatting for the error message.