<?php

use Illuminate\Database\Seeder;

class CategorySeoTitleSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $categories = DB::table('categories')->get();

        foreach ($categories as $category) {
            DB::table('categories')->where('id', $category->id)->update([
                'slug' => str_slug($category->name).'-'.$category->id,
                'meta_title' => $category->name,
                'meta_description' => $category->name,
            ]);
        }
    }
}