friendsofhyperf/trigger

The MySQL Trigger component for Hyperf.

v3.1.19 2024-03-19 09:04 UTC

Requires

• php: >=8.1.0
• friendsofhyperf/command-signals: ~3.1.0
• hyperf/collection: ~3.1.0
• hyperf/command: ~3.1.0
• hyperf/conditionable: ~3.1.0
• hyperf/context: ~3.1.0
• hyperf/coordinator: ~3.1.0
• hyperf/coroutine: ~3.1.0
• hyperf/di: ~3.1.0
• hyperf/event: ~3.1.0
• hyperf/process: ~3.1.0
• hyperf/stdlib: ~3.1.0
• hyperf/stringable: ~3.1.0
• hyperf/support: ~3.1.0
• hyperf/tappable: ~3.1.0
• moln/php-mysql-replication: ^1.2

Suggests

• hyperf/redis: Required to use Redis client.
• hyperf/signal: Required to use Signal manager.

MIT

• huangdijia

• hyperf
• v3.1

README

MySQL trigger component for Hyperf, Based on a great work of creators：moln/php-mysql-replication

Installation

• Request

composer require friendsofhyperf/trigger

• Publish

php bin/hyperf.php vendor:publish friendsofhyperf/trigger

Add listener

// config/autoload/listeners.php

return [
    FriendsOfHyperf\Trigger\Listener\BindTriggerProcessesListener::class => PHP_INT_MAX,
];

Define a trigger

namespace App\Trigger;

use FriendsOfHyperf\Trigger\Annotation\Trigger;
use FriendsOfHyperf\Trigger\Trigger\AbstractTrigger;
use MySQLReplication\Event\DTO\EventDTO;

#[Trigger(table:"table", on:"*", connection:"default")]
class FooTrigger extends AbstractTrigger
{
    public function onWrite(array $new)
    {
        var_dump($new);
    }

    public function onUpdate(array $old, array $new)
    {
        var_dump($old, $new);
    }

    public function onDelete(array $old)
    {
        var_dump($old);
    }
}

Define a subscriber

namespace App\Subscriber;

use FriendsOfHyperf\Trigger\Annotation\Subscriber;
use FriendsOfHyperf\Trigger\Subscriber\AbstractEventSubscriber;
use MySQLReplication\Event\DTO\EventDTO;

#[Subscriber(connection:"default")]
class BarSubscriber extends AbstractEventSubscriber
{
    protected function allEvents(EventDTO $event): void
    {
        // some code
    }
}

Contact

• Twitter
• Gmail

License

MIT