PHPackages                             zenoware/laravel-sql-dump-validator - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Utility & Helpers](/categories/utility)
4. /
5. zenoware/laravel-sql-dump-validator

ActiveLibrary[Utility & Helpers](/categories/utility)

zenoware/laravel-sql-dump-validator
===================================

Recursively finds and validates SQL dump (.sql.gz) files inside a directory.

v0.1.4(2y ago)08MITPHPPHP ^8.1

Since Feb 28Pushed 2y agoCompare

[ Source](https://github.com/Zenoware/laravel-sql-dump-validator)[ Packagist](https://packagist.org/packages/zenoware/laravel-sql-dump-validator)[ RSS](/packages/zenoware-laravel-sql-dump-validator/feed)WikiDiscussions main Synced 1mo ago

READMEChangelogDependencies (4)Versions (6)Used By (0)

Laravel SQL Dump Validator
==========================

[](#laravel-sql-dump-validator)

[![PHPUnit](https://github.com/Zenoware/laravel-sql-dump-validator/actions/workflows/phpunit.yml/badge.svg)](https://github.com/Zenoware/laravel-sql-dump-validator/actions/workflows/phpunit.yml/badge.svg)

This package provides a Laravel command and a service to validate SQL dump files for corruption. It uses the `gunzip -t` command to test the integrity of `.sql.gz` files.

Installation
------------

[](#installation)

Use composer to install the package:

```
composer require zenoware/laravel-sql-dump-validator
```

Requirements
------------

[](#requirements)

The package requires the `gunzip` command to be installed on your system. The command is used to test the integrity of `.sql.gz` files.

Usage
-----

[](#usage)

### Command

[](#command)

You can use the provided command to validate SQL dump files. The command accepts a path and an optional depth parameter.

```
php artisan zenoware:sqldump:validate {path} {--depth=2}
```

Validating SQL dump files in the `storage/app/sqldumps` directory:

```
php artisan zenoware:sqldump:validate storage/app/sqldumps
```

Validating SQL dump files in the `storage/app/sqldumps` directory with a maximum depth of 3:

```
php artisan zenoware:sqldump:validate storage/app/sqldumps --depth=3
```

The `path` argument is the directory where your SQL dump files are located. The `--depth` option is the maximum directory depth for the file search.

The command will print the validation results to the console. If a file is corrupted, it will print an error message with the file path and the error details.

### On Routes and Jobs

[](#on-routes-and-jobs)

Since the command uses `SqlDumpValidatorService` under the hood, you can also listen to events to handle the validation results by just running the command from within a job or a route.

```
# Be wary of timeouts when calling the command from a route or a job
Artisan::call('zenoware:sqldump:validate', ['path' => storage_path('app/sqldumps')]);
```

### Service

[](#service)

You can also use the `SqlDumpValidatorService` directly in your code. The service accepts a path, a depth, and a callback function.

```
$validatorService->validateSqlDumps($path, $depth, function (SqlDumpFileMetadata $metadata, array $errors) {
    // Handle the validation results
});
```

The callback function is called for each file processed. It receives a `SqlDumpFileMetadata` object and an array of errors. If the file is OK, the errors array is empty.

Service Provider
----------------

[](#service-provider)

The package includes a service provider that registers the `SqlDumpValidatorService` and the `IFileAdapter` interface with the Laravel service container.

If you want to use a different file adapter, you can bind your own implementation to the `IFileAdapter` interface in your own service provider.

Listening to Events
-------------------

[](#listening-to-events)

The service used by the command fires an event for each file processed. You can listen/subscribe to events to handle the validation results.

```
class SqlDumpEventSubscriber
{
    public function subscribe($events)
    {
        $events->listen(
            SqlDumpFileOk::class,
            function ($event) {
                Log::info('SqlDumpFileOk event fired', ['metadata' => $event->metadata]);
            }
        );

        $events->listen(
            SqlDumpFileCorrupted::class,
            function ($event) {
                Log::info('SqlDumpFileCorrupted event fired', ['metadata' => $event->metadata, 'errors' => $event->errors]);
            }
        );
    }
}
```

```
class EventServiceProvider extends ServiceProvider
{
    // [...]

    protected $subscribe = [
        SqlDumpEventSubscriber::class,
    ];

    // [...]
}
```

Contributing
------------

[](#contributing)

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

License
-------

[](#license)

[MIT](https://choosealicense.com/licenses/mit/)

###  Health Score

20

—

LowBetter than 14% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity4

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity44

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~0 days

Total

5

Last Release

806d ago

PHP version history (2 changes)v0.1PHP ^7.4|^8.1

v0.1.4PHP ^8.1

### Community

Maintainers

![](https://www.gravatar.com/avatar/db11e567f04b2c48124af50c6a26d5f857a6fef70181b52e2f1271193b25fd28?d=identicon)[zenoware](/maintainers/zenoware)

---

Top Contributors

[![jpcaparas](https://avatars.githubusercontent.com/u/2406808?v=4)](https://github.com/jpcaparas "jpcaparas (23 commits)")

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/zenoware-laravel-sql-dump-validator/health.svg)

```
[![Health](https://phpackages.com/badges/zenoware-laravel-sql-dump-validator/health.svg)](https://phpackages.com/packages/zenoware-laravel-sql-dump-validator)
```

###  Alternatives

[wireui/wireui

TallStack components

1.8k1.3M16](/packages/wireui-wireui)[civicrm/civicrm-core

Open source constituent relationship management for non-profits, NGOs and advocacy organizations.

728272.9k20](/packages/civicrm-civicrm-core)[ramonrietdijk/livewire-tables

Dynamic tables for models with Laravel Livewire

21147.4k](/packages/ramonrietdijk-livewire-tables)[boomcms/boom-core

Core classes for BoomCMS

193.0k6](/packages/boomcms-boom-core)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)