Download the PHP package elipzis/laravel-pastable-model without Composer

Cut/Copy & Paste Laravel Eloquent models into another table

Enable your models to regularly cut/copy & paste their data into another table.

• Cut & Paste or Copy & Paste
• Scheduled Jobs available to regularly & asynchronously run
• Cut & Paste in chunks, to split potential long-running processes
• Store data e.g. into logging or daily tables and keep the production data clean

Installation

You can install the package via composer:

You can publish the config file with:

This is the contents of the published config file:

Usage

To make your model copy & pastable, add the trait CopyPastable. It will copy & paste your configured query result into the target table.

To make your model cut & pastable, add the trait CutPastable. It will cut (delete) & paste your configured query result into the target table. If more rows than the chunk size (limit) are affected, it will respawn its own job until completed.

Configuration

To use any trait, you need to configure two settings:

• the target table
• the query to read its data from

Target table (mandatory)

You must define the target table name.

or by overriding the getter function, to e.g. create dynamic table names

If the table does not exist, you can use the configuration setting autoCreate and set it to true to have the system try to create the table from your query source.

It is recommended for you to create the table manually or via migration, as the automation is not fully tested and functional to any database system and table structure.

Query (mandatory)

You must define the query to use to read data and cut/copy & paste into the target table.

You can use any query that returns a Builder object.

In the case of cut & paste, the default chunkSize is used as a limiter. You can set your own limit by adding ->limit() to the query or override the configuration setting in general.

Connection (optional)

You can give a separate connection if you want the target table to be generated and filled in e.g. another database.

Run

After implementation and configuration, you got three options to trigger the cut/copy & paste jobs:

• Manually dispatching the jobs
• Scheduled dispatch
• Running a command to trigger it manually

Scheduled

The preferred way is to run the job on a schedule, configured via the Kernel, e.g. daily:

Via Command

You may also trigger the execution manually by using the command(s):

• All cut/copy & pastable model classes: php artisan pastable:all
• Only copy & pastable model classes: php artisan pastable:copy
• Only cut & pastable model classes: php artisan pastable:cut

Manual dispatch

The final option is to trigger the job manually inside any of your functions, any logic, any application code:

Testing

Notes

This package is heavily inspired by two incredible resources:

• Laravel Prunable
• Flare's cleaning big tables

Kudos and Thanks to both for the inspiration.

Changelog

Please see CHANGELOG for more information on what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

• elipZis GmbH
• NeA
• All Contributors

License

The MIT License (MIT). Please see License File for more information.