Download the PHP package fattureincloud/api-filter without Composer
On this page you can find all versions of the php package fattureincloud/api-filter. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download fattureincloud/api-filter
More information about fattureincloud/api-filter
Files in fattureincloud/api-filter
Package api-filter
Short Description A PHP parser for a sql-like filter
License MIT
Homepage https://github.com/fattureincloud/api-filter
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 api-filter
FattureInCloud API Filter
This PHP library makes possible to parse a string parameter and use it to initialize a Filter that can be used on REST APIs; the input string is based on a simplified SQL-like WHERE clause, making it easy to understand and use.
The library returns a class-based representation of the filter, that can be used to generate the actual filter to apply to your API requests.
Disclaimer
This library is currently focused on parsing and building the representation of the query, it does not validate the query itself. For example, it doesn't check if a field exists or if it is supported by your filters, and it doesn't enforce permissions checks on the query. You should take care of it on your own.
Even if this filter uses a grammar that should reduce the risk of SQL Injection, you should adopt some strategy to validate the filters and avoid executing unsafe queries.
Install
Via Composer
Usage
To parse a filter string, you can use the FattureInCloud\ApiFilter\FilterFactory class:
The returned filter will be a composition of the classes contained in the FattureInCloud\ApiFilter\Filter package.
The string is based on triplets:
The field is a lowercase string, with dots and underscores.
The op is one of the following (unquoted):
- Equal: '='
- Greater than: '>'
- Greater than or equal to: '>='
- Less than: '<'
- Less than or equal to: '<='
- Not equal: '<>', '!='
The value can be one of:
- String: 'value'
- Booleam: true, false
- Int: 46
- Double: 12.34
You can escape the single quote in a string value by doubling it. The filter will take care of returning the expected string.
It is also possible to match a String against a Pattern using one of those operators:
- Like: 'like', 'LIKE'
- Contains: 'contains', 'CONTAINS'
- Starts With: 'starts with', 'STARTS WITH'
- Ends With: 'ends with', 'ENDS WITH'
Like and Contains can also be negated:
- Not Like: 'not like', 'NOT LIKE'
- Not Contains: 'not contains', 'NOT CONTAINS'
Additionally, it is possible to check if field has a value or not, using NULL:
- Null field: 'IS NULL', 'is null', '= null', '= NULL'
- Not Null field: 'IS NOT NULL', 'is not null', '<> null', '!= null', '<> NULL', '!= NULL'
It is possible to use the following operators:
- Conjunction: 'and', 'AND'
- Disjunction: 'or', 'OR'
Parenthesis can be used to compose complex expressions.
For example:
Testing
Parser generation
The parser was generated automatically using ANTLR and the PHP target; it is placed in the FattureInCloud\ApiFilter\Parser repository. Usually you should not directly manage the parser: the FilterFactory class is a wrapper that manages it for you.
The grammar is placed under the /grammar folder, if needed you can trigger the parser generation using docker and composer:
If needed, you can generate a parser in another language changing the ANTLR target in the entrypoint.sh file.
License
The MIT License (MIT).
