Laravel Migration - 创建从现有列填充的新列 - 编程

I'm trying to create a migration that makes a new column and fills it with data from existing column.

我正在尝试创建一个迁移，创建一个新列并使用现有列中的数据填充它。

I want to turn the name column into a slug (using the helper function) and save that in a slug column.

我想将名称列转换为slug（使用辅助函数）并将其保存在slug列中。

I've tried this but no luck:

我试过这个但没有运气：

public function up()
{
    Schema::table('teams', function(Blueprint $table)
    {
        //
        $table->string('slug', 100);
    });

    $teams = DB::table('teams')->get();

    foreach ($teams as $team)
    {
        $team->slug = str_slug($team->name, "-");
        $team->save();
    }
}

Am i being an idiot? Can i make this work?

我是个白痴吗？我可以做这个工作吗？

Thanks

谢谢

2 个解决方案

#1

Assuming you have a Team model:

假设你有一个团队模型：

$teams = App\Team::all();

foreach($teams as $team) {
    $team->slug =  str_slug($team->name, "-");
    $team->save();
}

You're trying to use Eloquent ORM syntax ($team->save) in a code that is actually using Query Builder. You'd better choose one or the other (ORM or Query building). My version uses Eloquent ORM. Of course you could have used Query Builder syntax all the way, like this:

您正尝试在实际使用查询生成器的代码中使用Eloquent ORM语法（$ team-> save）。您最好选择其中一个（ORM或Query构建）。我的版本使用了Eloquent ORM。当然，您可以一直使用Query Builder语法，如下所示：

$teams = DB::table('teams');
foreach($teams as $team) {
    DB::table('teams')
            ->where('id', $team->id)
            ->update(['slug' => str_slug($team->name)]);
}

And basically a Query Builder select command (like $teams = DB::table('teams');) will return an array of stdClass objects (which have not a "save" method) , whereas Eloquent ORM select will return a collection of objects of the specified model, which do have the "save" method.

基本上Query Builder select命令（如$ teams = DB :: table（'teams'）;）将返回一个stdClass对象数组（没有“save”方法），而Eloquent ORM select将返回一个具有“save”方法的指定模型的对象。

Laravel Migration - 创建从现有列填充的新列

2 个解决方案

#1

更多相关文章

随机推荐