morrislaptop/laravel-query-builder-dump

Adds the ability to dump the query builder inline

Query Builder Dump

, _(*1)

``` php array:3 [ "bindings" => array:6 [ "select" => [] "join" => [] "where" => array:1 [ 0 => Illuminate\Support\Carbon {#736 +"date": "2017-11-24 15:10:26.000000" +"timezone_type": 3 +"timezone": "UTC" } ] "having" => [] "order" => [] "union" => [] ] "sql" => "select * from prizes where comment_id is null and release_at < ? order by release_at asc" "raw" => "select * from prizes where comment_id is null and release_at < '2017-11-24 15:10:26' order by release_at asc" ], <sub>(*2)</sub>

[![Latest Version on Packagist](https://img.shields.io/packagist/v/morrislaptop/laravel-query-builder-dump.svg?style=flat-square)](https://packagist.org/packages/morrislaptop/laravel-query-builder-dump)
[![Build Status](https://img.shields.io/travis/morrislaptop/laravel-query-builder-dump/master.svg?style=flat-square)](https://travis-ci.org/morrislaptop/laravel-query-builder-dump)
[![Quality Score](https://img.shields.io/scrutinizer/g/morrislaptop/laravel-query-builder-dump.svg?style=flat-square)](https://scrutinizer-ci.com/g/morrislaptop/laravel-query-builder-dump)
[![Total Downloads](https://img.shields.io/packagist/dt/morrislaptop/laravel-query-builder-dump.svg?style=flat-square)](https://packagist.org/packages/morrislaptop/laravel-query-builder-dump)

This repository contains a dump method for the query builder, allowing you to dump your query inline. Similar to `$collection->dump();`

## Installation

You can pull in the package via composer:

``` bash
composer require morrislaptop/laravel-query-builder-dump --dev

The package will automatically register itself., <sub>(*3)</sub>

Usage

Simply call dump anywhere when constructing your query., <sub>(*4)</sub>

$users = DB::table('users')
           ->select('name', 'email as user_email')
           ->join('contacts', 'users.id', '=', 'contacts.user_id')
           ->union($first)
           ->dump()
           ->where('something', 'true')
           ->orWhere('name', 'John')
           ->orderBy('name', 'desc')
           ->groupBy('account_id')
           ->dump()
           ->offset(10)
           ->limit(5)
           ->having('account_id', '>', 100)
           ->get();

Testing

bash $ composer test, <sub>(*5)</sub>

Contributing

Please see CONTRIBUTING for details., <sub>(*6)</sub>

Security

If you discover any security related issues, please email cr@igmorr.is instead of using the issue tracker., <sub>(*7)</sub>

Credits

• Freek Van der Herten
• Sebastian De Deyne
• All Contributors

License

The MIT License (MIT). Please see License File for more information., <sub>(*8)</sub>