gpt4 book ai didi

php - laravel工厂插入外键

转载 作者:行者123 更新时间:2023-12-02 20:54:55 24 4
gpt4 key购买 nike

大家好,所有试图提供帮助的人,

我正在尝试创建工厂文件来播种我的数据库,但我有一个问题如何从已播种的表中插入外键?工厂代码是把所有的都放在同一个文件中吗?有什么好的做法吗?

文件

模型用户

<?php

namespace App\Models;

use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable
{

protected $table = 'user'; //name of the table in database
protected $primaryKey = 'Id'; //Primary Key of the table

/**
* Relations between tables
*/
public function GetLoginInfo()
{
return $this->hasMany('App\Models\LoginInfo', 'UserId');
}

public function getStatus()
{
return $this->belongsTo('App\Models\AccountStatus');
}

}

模型帐户状态

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class AccountStatus extends Model
{
protected $table = 'account_status'; //name of the table in database
protected $primaryKey = 'Id'; //primary Key of the table
public $timestamps = false; //true if this table have timestaps
/**
* Relations between tables
*/
public function GetUsers()
{
return $this->hasMany('App\Models\Users', 'StatusId');
}
}

工厂文件:

<?php
/** @var \Illuminate\Database\Eloquent\Factory $factory */

//Factory for Account Status table
$factory->define(App\Models\AccountStatus::class, function (Faker\Generator $faker) {
return [
'Description' => $faker->word,
];
});

//Factory for user table
$factory->define(App\Models\User::class, function (Faker\Generator $faker) {
return [
'Username' => $faker->unique()->userName,
'Password' => bcrypt('test'),
'Email' => $faker->unique()->safeEmail,
'Name' => $faker->name,
'StatusId' => Factory(App\Models\AccountStatus::class)->create()->id,
];
});

这就是我正在尝试做的事情,如您所见:Factory(App\Models\AccountStatus::class)->create()->id 但不起作用

最佳答案

$factory->define(App\Models\User::class, function (Faker\Generator $faker) {
return [
'Username' => $faker->unique()->userName,
'Password' => bcrypt('test'),
'Email' => $faker->unique()->safeEmail,
'Name' => $faker->name,
'StatusId' => factory(App\Models\AccountStatus::class)->create()->id,
];
});

我在工厂看到一个大写的 F..

$factory->define(App\Models\User::class, function (Faker\Generator $faker) {

$accountStatus = factory(App\Models\AccountStatus::class)->create()

return [
'Username' => $faker->unique()->userName,
'Password' => bcrypt('test'),
'Email' => $faker->unique()->safeEmail,
'Name' => $faker->name,
'StatusId' => $accountStatus->id,
];
});

编辑(改进)

如果您有一个模型依赖于另一模型。您可以这样做,使用回调函数来创建相关的。

像这样

$factory->define(App\Models\User::class, function (Faker\Generator $faker) {
return [
'Username' => $faker->unique()->userName,
'Password' => bcrypt('test'),
'Email' => $faker->unique()->safeEmail,
'Name' => $faker->name,
'StatusId' => function () {
return factory(App\Models\AccountStatus::class)->create()->id;
}
];
});

您需要记住的一件事是,如果相关(状态模型)具有依赖于父级(用户模型)的模型,这将进入无限循环。

关于php - laravel工厂插入外键,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/40850476/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com