watchwood/querysugar

There is no license information available for the latest version (1.0) of this package.

Adding some syntactic sugar to Eloquent's query builder

1.0 2017-06-17 03:23 UTC

Requires (Dev)

• illuminate/database: ~5
• illuminate/support: ~5
• phpunit/phpunit: ^6.2

Unknown License

• John Wood

README

Adding some Syntactic Sugar to Eloquent's query builder.

Installation

Run composer require watchwood/QuerySugar to include the package in your Laravel app.

Have your models extend from watchwood/QuerySugar/Model

For convenience, you can have your User model extend from the included watchwood/QuerySugar/UserModel

New Query Builder Commands

Equality

• eq($column, $value)
• equals($column, $value)
• neq($column, $value)
• notEquals($column, $value)

Relativity

• gt($column, $value)

• gte($column, $value)

• greater($column, $value)

• greaterThan($column, $value)

• greaterEquals($column, $value)

• lt($column, $value)

• lte($column, $value)

• lesser($column, $value)

• lessThan($column, $value)

• lesserEquals($column, $value)

Strings

• contains($column, $value)
• like($column, $value)
• starts($column, $value)
• startsWith($column, $value)
• ends($column, $value)
• endsWith($column, $value)

Contributing

If you have anything you'd like to see added to this package, feel free to reach out to me on Github or make a Pull Request with the extra functionality.