morrislaptop/laravel-query-builder-dump

Adds the ability to dump the query builder inline

v0.2.1 2017-12-01 16:24 UTC

This package is auto-updated.

Last update: 2024-11-26 04:21:09 UTC


README

Screenshot of code

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"
]

Latest Version on Packagist Build Status Quality Score Total Downloads

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:

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

The package will automatically register itself.

Usage

Simply call dump anywhere when constructing your query.

$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

$ composer test

Contributing

Please see CONTRIBUTING for details.

Security

If you discover any security related issues, please email cr@igmorr.is instead of using the issue tracker.

Credits

License

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