Answers for "laravel run query after migration"

PHP
1

laravel run query after migration

//You should be able to add data to your new fields in your new migration. I'm not sure if it's the best way to go, but I've seen something like this before:

public function up()
{
    Schema::table('my_table', function (Blueprint $table) {
        $table->string('my_column')->nullable();
    });
    $this->updateData();
}

private function updateData()
{
    $allCategories = Category::where('slug', null)->get();

    foreach($allCategories as $singleCategory) {
        $singleCategory->update([
            'slug' => Category::makeSlug($singleCategory->name, $singleCategory->parent_id)
        ]);
    }
}
Posted by: Guest on August-24-2021
1

laravel run query migration

DB::statement("
    CREATE TABLE `your_table` (
        `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
        `status` tinyint(3) unsigned DEFAULT NULL,
        PRIMARY KEY (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
");
Posted by: Guest on August-23-2021

Code answers related to "laravel run query after migration"

Browse Popular Code Answers by Language