Logging queries executed on Postgres even directly!!!

Installation

You can install the package via composer:

composer require jalallinux/laravel-postgres-audit

You can publish the config file with:

php artisan vendor:publish --provider="JalalLinuX\PostgreAudit\PGAuditServiceProviders"

This is the contents of the published config file:

return [
/**
     * Target database connection
     */
    'connection' => 'pgsql',


    /**
     * Audit log table name
     */
    'table_name' => 'audit_logs',


    /**
     * Target tables for log
     * Set ['*'] to log for all tables
     * Split tables with comma
     */
    'target_tables' => '*',


    /**
     * Except tables for log
     * Except tables has more priority than target tables
     * Split tables with comma
     */
    'except_tables' => 'migrations, password_resets, personal_access_tokens, jobs, failed_jobs, notifications',


    /**
     * Ignore database user activity
     * Example: postgres, forge
     * NULL for logging all users
     * Split tables with comma
     */
    'except_users' => null,


    /**
     * Primary columns
     * Example: id, uuid, slug
     */
    'primary_columns' => 'uuid',


    /**
     * Primary columns type
     * Example: bigint, uuid, varchar
     */
    'primary_columns_type' => 'uuid',


    /**
     * Operations to log
     * Only support INSERT, DELETE, UPDATE
     */
    'operations' => 'INSERT, DELETE, UPDATE'
];

Usage

Setup:

php artisan pg-audit:setup

Model:

Work with PGAudit model.

\JalalLinuX\PostgreAudit\PGAudit::where('table_name', 'users')->get()

Testing

composer test

Changelog

Please see CHANGELOG for more information on what has changed recently.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

• JalalLinuX
• All Contributors

License

The MIT License (MIT). Please see License File for more information.