ngabor84 / lumen-api-query-parser by ngabor84

A query parser for REST-APIs based on laravel's lumen framework
1,468
3
1
Package Data
Maintainer Username: ngabor84
Maintainer Contact: negabor@gmail.com (Gábor Németh)
Package Create Date: 2017-04-26
Package Last Update: 2022-04-22
Language: PHP
License: MIT
Last Refreshed: 2024-04-23 03:12:06
Package Statistics
Total Downloads: 1,468
Monthly Downloads: 0
Daily Downloads: 0
Total Stars: 3
Total Watchers: 1
Total Forks: 5
Total Open Issues: 4

Lumen API query parser

Codeship Status for ngabor84/lumen-api-query-parser

Description

This is a simple request query parameter parser for REST-APIs based on Laravel's Lumen framework.

Requirements

  • PHP >=7.1
  • Lumen framework >= 5.4
  • Mockery >= 0.9 (dev)
  • PHPUnit >= 6.1 (dev)
  • PHP CodeSniffer >= 3.0.0 RC4 (dev)

Installation

  • Add ngabor84/lumen-api-query-parser to your composer.json and make composer update, or composer require ngabor84/lumen-api-query-parser ~1.0
  • Setup the service provider: in bootstrap/app.php add the following line:
    $app->register(LumenApiQueryParser\Provider\RequestQueryParserProvider::class);
    

Usage

    // app/API/V1/Models/UserController.php
    namespace App\Api\V1\Http\Controllers;
    
    use App\Api\V1\Models\User;
    use App\Api\V1\Transformers\UserTransformer;
    use LumenApiQueryParser\ResourceQueryParserTrait;
    use LumenApiQueryParser\BuilderParamsApplierTrait;
    
    class UserController extends Controller
    {
        use ResourceQueryParserTrait;
        use BuilderParamsApplierTrait;
                
        public function index(Request $request)
        {
            $params = $this->parseQueryParams($request);
            $query = User::query();
            $userPaginator = $this->applyParams($query, $params);
            
            $this->response->paginator($userPaginator, new UserTransformer, ['key' => 'users']);
        }
    }

Query syntax

Eager loading

Q: /users?connection[]=profile
R: will return the collection of the users with their profiles included

Filtering

Q: /users?filter[]=name:ct:admin
R: will return the collection of the users whose names contains the admin string

Available filter options

| Operator | Description | Example | | ------------- | --------------------- | ------- | | ct | String contains | name:ct:Peter | | nct | String NOT contains | name:nct:Peter | | sw | String starts with | username:sw:admin | | ew | String ends with | email:ew:gmail.com | | eq | Equals | level:eq:3 | | ne | Not equals | level:ne:4 | | gt | Greater than | level:gt:2 | | ge | Greater than or equal | level:ge:3 | | lt | Lesser than | level:lt:4 | | le | Lesser than or equal | level:le:3 | | in | In array | level:in:1|2|3 |

Sorting

Q: /users?sort[]=name:ASC
R: will return the collection of the users sort by their names ascending

Pagination

Q: /users?limit=10&page=3
R: will return a part of the collection of the users (from the 21st to 30th)