elipzis / laravel-pastable-model
Cut/Copy & Paste Laravel Eloquent model data into another table
Requires
- php: ^8.2
- illuminate/contracts: ^10.0|^11.0
- spatie/laravel-package-tools: ^1.14.0
Requires (Dev)
- laravel/pint: ^1.0
- nunomaduro/collision: ^7.8
- nunomaduro/larastan: ^2.0.1
- orchestra/testbench: ^8.8
- pestphp/pest: ^2.0
- pestphp/pest-plugin-arch: ^2.0
- pestphp/pest-plugin-laravel: ^2.0
- phpstan/extension-installer: ^1.1
- phpstan/phpstan-deprecation-rules: ^1.0
- phpstan/phpstan-phpunit: ^1.0
- spatie/laravel-ray: ^1.26
README
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:
composer require elipzis/laravel-pastable-model
You can publish the config file with:
php artisan vendor:publish --tag="pastable-model-config"
This is the contents of the published config file:
return [ //The default cut&paste chunk size (limit) 'chunkSize' => 1000, //Auto-create tables, if not existing 'autoCreate' => false, //Enable detailed logging to any accepted and configured level 'logging' => [ 'enabled' => false, 'level' => null, ], ];
Usage
To make your model copy & pastable, add the trait CopyPastable
.
It will copy & paste your configured query result into the target table.
... use ElipZis\Pastable\Models\Traits\CopyPastable; ... class YourModel extends Model { use CopyPastable; ...
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.
... use ElipZis\Pastable\Models\Traits\CutPastable; ... class YourModel extends Model { use CutPastable; ...
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.
... class YourModel extends Model { ... protected string $pastableTable = 'log_something'; ...
or by overriding the getter function, to e.g. create dynamic table names
... class YourModel extends Model { ... public function getPastableTable(): string { return 'log_something_' . Carbon::now()->format('Y_m_d'); } ...
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.
... class YourModel extends Model { ... public function getPastableQuery(): Builder { return static::query()->where('created_at', '<=', now()->subDay()); } ...
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.
... class YourModel extends Model { ... protected string $pastableConnection = 'logging'; ...
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:
namespace App\Console; ... use ElipZis\Pastable\Jobs\PastableJob; ... class Kernel extends ConsoleKernel ... protected function schedule(Schedule $schedule) { ... $schedule->job(PastableJob::class)->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:
... use ElipZis\Pastable\Jobs\PastableJob; ... class YourClass ... protected function yourFunction() { ... PastableJob::dispatch(); ... } ...
Testing
composer test
Notes
This package is heavily inspired by two incredible resources:
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
License
The MIT License (MIT). Please see License File for more information.