#database #development #eloquent #laravel #php
In some cases when a particular table grows too much it might slow down your Laravel website. You might want to clear old records or archive them to another table so that you could keep your main table as light as possible.
As of the time of writing this post, Laravel does not provide a helper method to move records from one table to another, so here is how you could achieve that!
As an example, I have a posts
table and Model, and I would show you how to copy or move all posts that have not been
updated in the past 5 years to another table called legacy_posts
.
You would also need to have a model ready that you would like to use. For example, I have a small blog with a posts table and Post model that I would be using.
Copy all records from one table to another
The replicate()
method provides an optimized way of creating a clone of an entire instance of a Model.
For this example, I will use my Posts model and copy all posts that have not been updated in the past 5 years to a new
table called legacy_posts
:
Posts::query()
->where('updated_at','<', now()->subYears(5))
->each(function ($oldPost) {
$newPost = $oldPost->replicate();
$newPost->setTable('legacy_posts');
$newPost->save();
});
A quick rundown of the query:
-
First we select all entries from the posts table which have not been updated in the past 5 years using the
where('updated_at','<', now()->subYears(5))
statement -
Then we create a new instance with the
replicate()
method. This would hold the result of the above query -
After that by using the
setTable('legacy_posts')
we specify the new table where we would like to store the results in -
At the end you can see that we use the
save()
method to store all entries in the newlegacy_posts
table.
Note: you need to have the
legacy_posts
table already created in order to use the above, otherwise you would get an error that the table does not exist.
Move all records from one table to another
Let's say that you wanted to not only replicate the records but also remove the old records from your main posts table as well.
In this case you could use the following query:
Posts::query()
->where('updated_at','<', now()->subYears(5))
->each(function ($oldRecord) {
$newPost = $oldRecord->replicate();
$newPost ->setTable('legacy_posts');
$newPost ->save();
$oldPost->delete();
});
This will delete all entries from posts table which have not been updated in the past 5 years and copy them to a new
table called legacy_posts
.
Conclusion
For more information, I would recommend going through the official Laravel documentation regarding Replicating Models.
If this post was enjoyable or useful for you, please share it! If you have comments, questions, or feedback, you can email my personal email. To get new posts, subscribe use the RSS feed.