cgarcia/audit-bundle

Audit bundle for symfony2 and doctrine orm, logs any database change

v0.1.5 2016-06-10 06:22 UTC

Requires

• php: >=5.4.0
• doctrine/orm: ~2.4
• symfony/framework-bundle: ~2.6|~3.0

Requires (Dev)

• php: >=5.6.0
• ext-pdo: *
• ext-pdo_sqlite: *
• data-dog/pager-bundle: ~0.2
• doctrine/doctrine-bundle: ~1.5
• doctrine/doctrine-fixtures-bundle: ~2.2.0
• doctrine/orm: ~2.5.0
• knplabs/knp-menu-bundle: ~2.0
• knplabs/knp-time-bundle: ~1.3
• phpunit/phpunit: ~4.7.0
• sensio/framework-extra-bundle: ~3.0.9
• symfony/symfony: ~2.7.0|~3.0

MIT

• DataDog Team
• Symfony2 Community

• log
• orm
• Symfony2
• bundle
• doctrine
• Audit

README

This bundle creates an audit log for all doctrine ORM database related changes:

• inserts and updates including their diffs and relation field diffs.
• many to many relation changes, association and dissociation actions.
• if there is an user in token storage, it will link him to the log.
• the audit entries are inserted within the same transaction during flush, if something fails the state remains clean.

Basically you can track any change from these log entries if they were managed through standard ORM operations.

NOTE: audit cannot track DQL or direct SQL updates or delete statement executions.

Install

First, install it with composer:

composer require cgarcia/audit-bundle

Then, add it in your AppKernel bundles.

// app/AppKernel.php
public function registerBundles()
{
    $bundles = array(
        ...
        new DataDog\AuditBundle\DataDogAuditBundle(),
        ...
    );
    ...
}

Finally, create the database tables used by the bundle:

Using Doctrine Migrations Bundle:

php app/console doctrine:migrations:diff
php app/console doctrine:migrations:migrate

Using Doctrine Schema:

php app/console doctrine:schema:update --force

Demo

The best way to see features is to see the actual demo. Just clone the bundle and run:

make

Visit http://localhost:8000/audit to see the log actions.

The demo application source is available in example directory and it is a basic symfony application.

Usage

audit entities will be mapped automatically if you run schema update or similar. And all the database changes will be reflected in the audit log afterwards.

Unaudited Entities

Sometimes, you might not want to create audit log entries for particular entities. You can achieve this by listing those entities under the unaudired_entities configuuration key in your config.yml, for example:

data_dog_audit:
    unaudited_entities:
        - AppBundle\Entity\NoAuditForThis

Screenshots

All paginated audit log:

Clicked on history reference for specific resource:

Showing insert data:

License

The audit bundle is free to use and is licensed under the MIT license