Download the PHP package ferrisbane/eloquent-companion without Composer
On this page you can find all versions of the php package ferrisbane/eloquent-companion. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download ferrisbane/eloquent-companion
More information about ferrisbane/eloquent-companion
Files in ferrisbane/eloquent-companion
Package eloquent-companion
Short Description A quintessential package containing companion helper functions to extend the usefulness of Laravel's Eloquent ORM
License MIT
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package eloquent-companion
Eloquent Companion
A quintessential package containing companion helper functions to extend the usefulness of Laravel's Eloquent ORM
- Installation
- Usage
Installation
To install through composer you can either use composer require ferrisbane/eloquent-companion (while inside your project folder) or include the package in your composer.json.
Then run either composer install or composer update to download the package.
To use the package with Laravel 5 add the service provider to the list of service providers in config/app.php.
Usage
Once the service provider has been added to your projects provider list the companion helpers are ready to use.
withWhereHas
The withWhereHas helper is useful if you wish to run a ->whereHas() query on your model and also want to eager load the same relationship without writing the same query in the ->with() function. Using ->withWhereHas() keeps your code clean and DRY!
For example if you have a user model and want to return only users that have paid order AND also eager load the paid orders:
As a comparison in standard Eloquent you would have to write the query out twice, which can become messy for larger queries and changes to one query will have to be replicated again:
toQuery
When writing Eloquent queries it can be useful to see what SQL query it will run.
Eloquent provides the ->toSql() function to help you with that, however any bindings wont be populated in the output. The ->toQuery() function is here to help!
Taking a look at the above query the standard ->toSql() function would return: SELECT * FROM users WHERE email = ?. We cant just copy and paste that output into our favorite database client.
However with the ->toQuery() function we can, as it will output: SELECT * FROM users where email = '[email protected]'. This is extremely useful when debugging those big queries that can contain 10+ bindings.
