Laravel 5.2-使用字符串作为雄辩表的自定义主键变为0

我试图使用电子邮件作为我的表的主键，所以我雄辩的代码是-

<?php


namespace App;


use Illuminate\Database\Eloquent\Model;


class UserVerification extends Model
{
protected $table = 'user_verification';
protected $fillable =   [
'email',
'verification_token'
];
//$timestamps = false;
protected $primaryKey = 'verification_token';
}

我的尸体是这样的

enter image description here

但如果我这么做

UserVerification::where('verification_token', $token)->first();

我明白了

{
"email": "sdfsdf@sdfsdf.sdf",
"verification_token": 0,
"created_at": "2016-01-03 22:27:44",
"updated_at": "2016-01-03 22:27:44"
}

所以 核实令牌/主键变成0。

有人能帮忙吗？

143006 次浏览
小开

On the model set $incrementing to false

public $incrementing = false;

This will stop it from thinking it is an auto increment field.

Laravel Docs - Eloquent - Defining Models

小开

Theres two properties on the model you need to set. The first $primaryKey to tell the model what column to expect the primary key on. The second $incrementing so it knows the primary key isn't a linear auto incrementing value.

class MyModel extends Model
{
protected $primaryKey = 'my_column';


public $incrementing = false;
}

For more info see the Primary Keys section in the documentation on Eloquent.

小开
最佳答案

This was added to the upgrade documentation on Dec 29, 2015, so if you upgraded before then you probably missed it.

When fetching any attribute from the model it checks if that column should be cast as an integer, string, etc.

By default, for auto-incrementing tables, the ID is assumed to be an integer in this method:

https://github.com/laravel/framework/blob/5.2/src/Illuminate/Database/Eloquent/Model.php#L2790

So the solution is:

class UserVerification extends Model
{
// if your key name is not 'id'
// you can also set this to null if you don't have a primary key
protected $primaryKey = 'your_key_name';


public $incrementing = false;


// In Laravel 6.0+ make sure to also set $keyType
protected $keyType = 'string';
}
小开

keep using the id 

<?php


namespace App;


use Illuminate\Database\Eloquent\Model;


class UserVerification extends Model
{
protected $table = 'user_verification';
protected $fillable =   [
'id',
'email',
'verification_token'
];
//$timestamps = false;
protected $primaryKey = 'verification_token';
}

and get the email :

$usr = User::find($id);
$token = $usr->verification_token;
$email = UserVerification::find($token);
小开

I was using Postman to test my Laravel API.

I received an error that stated

"SQLSTATE[42S22]: Column not found: 1054 Unknown column" because Laravel was trying to automatically create two columns "created_at" and "updated_at".

I had to enter public $timestamps = false; to my model. Then, I tested again with Postman and saw that an "id" = 0 variable was being created in my database.

I finally had to add public $incrementing false; to fix my API.


提交答案