通过
搜索
搜索recca0120 / eloquent-dumper
v0.7.0
2024-03-12 21:00 UTC
Requires
- ext-pdo: *
- doctrine/sql-formatter: ^1.1
- illuminate/database: ^5.8|^6.0|^7.0|^8.0|^9.0|^10.0|^11.0
Requires (Dev)
- mikey179/vfsstream: ^1.6
- mockery/mockery: ^1.3
- orchestra/testbench: ^3.5|^4.1|^5.2|^6.2|^7.0|^8.0|^9.0
- phpunit/phpunit: ^5.4|^6.1|^7.0|^8.0|^9.1|^10.0|^11.0
- symfony/var-dumper: ^3.2|^4.0|^5.4|^6.0|^7.0
README
安装
composer install
composer require recca0120/eloquent-dumper
发布配置
php artisan vendor:publish --tag="eloquent-dumper"
配置
当你在PHPUnit中使用sqlite并且需要MySQL版本的sql时，你可以将驱动设置为mysql，它将输出MySQL版本的sql
// eloquent-dumper.php return [ /* * Supported: "pdo", "mysql", "sqlite", "pgsql", "sqlsrv" */ 'driver' => env('ELOQUENT_DUMPER_GRAMMAR', 'pdo'), ];
如何使用
var_dump( User::where('name', 'foo') ->where('password', 'bar') ->sql() ); User::where('name', 'foo') ->where('password', 'bar') ->dumpSql() ->get(); // output: // SELECT // * // FROM // `users` // WHERE // `name` = 'foo' AND `password` = 'bar'