php-api-wrapper icon indicating copy to clipboard operation
php-api-wrapper copied to clipboard

Adds support for query comparison operators

Open jorbascrumps opened this issue 3 years ago • 1 comments

Resolves #39

Queries can still be performed without explicitly setting an operator:

Entity::where('active', true)->get();

Or queries can have an operator specified:

Entity::where('created_at', '>', Carbon::now())->get();

Queries can even use a combination:

Entity::where('published', true)
    ->where([
        ['numComments', '>', 1],
        'author', 8)
    ])
    ->limit(10)
    ->get();

If an operator is not specified its value is set to = by default. Supported operators are: =, <, >, <=, >=, <>, !=, <=>.

Services will now have access to the column, operator, and value that has been set in the query:

public function getEntities(array $where)
{
    foreach ($where as [$column, $operator, $value]) {
        // ...
    }
}

jorbascrumps avatar May 13 '22 14:05 jorbascrumps

@TZK- Any thoughts on this?

jorbascrumps avatar Jul 11 '22 15:07 jorbascrumps