Download the PHP package m-sonmez/laravel-triggers without Composer
On this page you can find all versions of the php package m-sonmez/laravel-triggers. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download m-sonmez/laravel-triggers
More information about m-sonmez/laravel-triggers
Files in m-sonmez/laravel-triggers
Package laravel-triggers
Short Description Database-agnostic fluent trigger builder for Laravel Migrations.
License MIT
Homepage https://github.com/m-sonmez/laravel-triggers
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package laravel-triggers
Laravel Triggers
A database-agnostic fluent trigger builder for Laravel Migrations. Write your trigger logic once in PHP and deploy to SQLite, MySQL, MariaDB, PostgreSQL, or SQL Server (MSSQL).
Why use this?
Laravel's Schema builder doesn't natively support triggers. Usually, you have to write raw SQL strings that vary wildly between database engines. This package allows you to use a fluent API to define triggers that work everywhere.
Requirements
- PHP: ^8.2
- Laravel: ^12.0 or ^13.0
Installation
You can install the package via composer:
Usage
Simple Log Trigger
The most common use case is logging changes to an actions or logs table.
Complex Conditional Logic
Prevent specific actions by throwing database-level exceptions based on conditions.
Incrementing Counters
Keep your counters in sync automatically.
Dropping Triggers
You can easily drop triggers in your down() method.
Checking if a Trigger exists
You can easily check if a trigger exists.
Advanced Examples
Cross-Table Validation
Prevent an action based on a value in another table.
Complex Multi-Statement Logic
Perform multiple actions in a single trigger.
Soft-Delete Handling
Automatically clean up related records when a record is "soft-deleted" (if using a custom flag).
Supported Database Tokens
The package handles the dialect differences for common operations:
Trigger::now(): Current timestamp.Trigger::date(): Current date.Trigger::uuid(): Generates a HEX UUID.Trigger::new('column'): References theNEWrow state.Trigger::old('column'): References theOLDrow state.Trigger::expr('sql'): Wraps raw SQL to prevent quoting.Trigger::call('func', ['arg1', Trigger::new('col')]): Calls a database function with quoted arguments.
Supported Databases
- SQLite (uses
WHENandstrftime) - MySQL / MariaDB (uses
FOR EACH ROW,IF/THEN, andDATE_FORMAT) - PostgreSQL (automatically creates/manages the required
plpgsqlfunctions) - SQL Server (MSSQL) (uses
INSTEAD OFfor BEFORE, andinserted/deletedtables)
IDE Support
This package includes an IDE helper to provide method completion for the Blueprint class. Most IDEs will pick this up
automatically. If your IDE doesn't recognize the trigger, hasTrigger, or dropTrigger methods, you can add a type
hint in your migration:
Testing
Local Development
To set up the project for local development:
This will install all PHP dependencies and set up your environment.
License
The MIT License (MIT). Please see License File for more information.
All versions of laravel-triggers with dependencies
ext-mbstring Version *
illuminate/support Version ^12.0|^13.0
illuminate/database Version ^12.0|^13.0