Download the PHP package benjamin-rqt/data-watcher-bundle without Composer

benjamin-rqt/data-watcher-bundle

Symfony bundle for database anomaly detection with email notifications and execution history.

Requirements

• PHP >= 8.2
• Symfony 6.3, 7.0 or 8.0

Symfony components

• framework-bundle
• messenger
• mailer
• twig-bundle
• scheduler

Doctrine

• doctrine/dbal ^3.0 or ^4.0
• (Optional) doctrine/orm (if you use AbstractDoctrineCheck)

External dependencies

• dragonmantank/cron-expression (required for cron-based scheduler triggers)

Installation

1. Declare the bundle in composer.json

2. Install

3. Register the bundle (if Flex doesn't do it automatically)

4. Create the bundle configuration

5. Configure Messenger for the scheduler

6. Environment variables (.env.local)

7. Setup the database table

This bundle uses a custom table data_watcher_run to store the history of checks. Run the following command to create it:

Add a check in your application

Create a class in your app (not in the bundle):

With raw SQL

With Doctrine ORM

With a callable

Then declare the handler containing the callable and the detection logic:

Other possible configurations

Increase the number of anomalies to trigger an alert

Specific recipients for a check

Available commands

Start the worker (scheduler)

No configuration is required for the scheduler, it automatically detects CRON expressions defined in checks and executes them at the right time.

Quick CRON expressions