Home > PHP Framework > Laravel > body text

8 Tips for Using Laravel Model Timestamps

藏色散人
Release: 2020-01-20 13:20:53
forward
4187 people have browsed it

By default, the Laravel Eloquent model default data table has two fields: created_at and updated_at. Of course, we can make a lot of custom configurations and implement many interesting functions. Below are examples.

1. Disable timestamp

If the data table does not have these two fields, Model::create($arrayOfValues); when saving the data - you will see SQL error. Laravel cannot find these two fields when automatically filling created_at / updated_at.

Disable automatic filling of timestamps, just add the previous attribute to the Eloquent Model:

class Role extends Model
{
    public $timestamps = FALSE;
    // ... 其他的属性和方法
}
Copy after login

2. Modify the default list of timestamps

If the current What should I do if I am using a non-Laravel database and my timestamp column is named differently? Perhaps, they are called create_time and update_time respectively. Congratulations, you can also define it like this in the model:

class Role extends Model
{
    const CREATED_AT = 'create_time';
    const UPDATED_AT = 'update_time';
Copy after login

3. Modify the timestamp date/time format

The following content refers to the official Laravel documentation:

By default, the timestamp is automatically formatted as 'Y-m-d H:i:s'. If you need a custom timestamp format, you can set the $dateFormat property in your model. This property determines the format in which the date is stored in the database and when serialized into an array or JSON:

class Flight extends Model
{
    /**
     * 日期时间的存储格式
     *
     * @var string
     */
    protected $dateFormat = 'U';
}
Copy after login

4. Many-to-many: Intermediate table with timestamp

When in a many-to-many association, the timestamp will not be automatically filled in, such as the intermediate table role_user between the user table users and the role table roles.

In this model you can define the relationship like this:

class User extends Model
{
    public function roles()
    {
        return $this->belongsToMany(Role::class);
    }
}
Copy after login

Then when you want to add a role to the user, you can use it like this:

$roleID = 1;
$user->roles()->attach($roleID);
Copy after login

By default, this middle The table does not contain timestamps. And Laravel will not try to automatically populate created_at/updated_at

but if you want to automatically save timestamps, you need to add created_at/updated_at in the migration file, and then add ->withTimestamps() in the model's association ;

public function roles()
{
    return $this->belongsToMany(Role::class)->withTimestamps();
}
Copy after login

5. Use latest() and oldest() for timestamp sorting

There are two "shortcut methods" for using timestamp sorting.

Instead:

User::orderBy('created_at', 'desc')->get();
Copy after login

This is faster:

User::latest()->get();
Copy after login

By default, latest() uses created_at sorting.

Correspondingly, there is an oldest(), which will be sorted like created_at ascending

User::oldest()->get();
Copy after login

Of course, you can also use other specified fields to sort. For example, if you want to use updated_at, you can do this:

$lastUpdatedUser = User::latest('updated_at')->first();
Copy after login

6. Do not trigger the modification of updated_at

Whenever an Eloquent record is modified, it will Automatically maintain the updated_at field using the current timestamp, which is a great feature.

But sometimes you don’t want to do this. For example: when adding a certain value, you think this is not a “whole row update”.

So, you can do the same as above - just disable timestamps, remember this is temporary:

$user = User::find(1);
$user->profile_views_count = 123;
$user->timestamps = false;
$user->save();
Copy after login

7. Only update timestamps and associated timestamps

Contrary to the previous example, maybe you need to update only the updated_at field without changing other columns.

So, the following writing method is not recommended:

$user->update(['updated_at' => now()]);
Copy after login

You can use a faster method:

$user->touch();
Copy after login

Another situation, sometimes you not only want to update the current model updated_at, also want to update the records of superior relationships.

For example, if a comment is updated, then you want to update the updated_at of the post table.

Then, you need to define the $touches attribute in the model:

class Comment extends Model {
    protected $touches = ['post'];
    public function post()
    {
        return $this->belongsTo('Post');
    }
}
Copy after login

8. The timestamp field is automatically converted to the Carbon class

The last tip, But more like a reminder because you should already know it.

By default, the created_at and updated_at fields are automatically converted to $dates,

so you don't need to convert them to Carbon instances to use Carbon's methods.

For example:

$user->created_at->addDays(3);
now()->diffInDays($user->updated_at);
Copy after login

That’s it, a quick but hopefully helpful tip!

For more technical articles related to the laravel framework, please visit the laravel tutorial column!

The above is the detailed content of 8 Tips for Using Laravel Model Timestamps. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:learnku.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!