friendsofhyperf/trigger

The MySQL Trigger component for Hyperf.

v3.1.48.1 2024-12-05 11:09 UTC

Requires

• php: >=8.2.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
• krowinski/php-mysql-replication: 7.0 || ^8.0
• ramsey/uuid: ^4.7

Suggests

• hyperf/redis: Required to use Redis client.(~3.1.0)
• hyperf/signal: Required to use Signal manager.(~3.1.0)

MIT

• huangdijia

• hyperf
• v3.1

README

MySQL trigger component for Hyperf, Based on a great work of creators：krowinski/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", events:["*"], 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\AbstractSubscriber;
use MySQLReplication\Event\DTO\EventDTO;

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

Contact

• Twitter
• Gmail

License

MIT