| FazBrowse GitHub Viewer | Trending | | Home |
| Tools: [Download Repo ZIP] [Original HTTPS Page] |
| Name | Name | Last commit date | ||
|---|---|---|---|---|
ByteFerry RQL-Parser is used for parsing the RQL text to the paramaters with PHP array structure for the calling of php methods.
This library consists of the following parts:
$ composer requrire byteferry/rql-Parseruse ByteFerry/RqlParser/Parser;
$rql_string = 'any(User,columns(id,name,age,gender,address),filter(eq(age,19)))';
try{
$query = Parser::parse( $rql_string);
}catch(\Exception $e){
// will catch errror of parse or grammer checking.
}if sucess, it will return a QueryInterface.
use ByteFerry/RqlParser/Parser;
$rql_string = 'filter(eq(age,19))';
try{
$query = Parser::parse( $rql_string, true);
}catch(\Exception $e){
// will catch errror of parse or grammer checking.
}Here is a complex example. (Not a real query, but returns all properties)
$rql_str= 'all(User,aggr(id,name,age,gender,address,avg(age)),filter(is(created_at, null()), search(Jhon),sort(-id,+age),having(gt(sum(amount),0)),limit(0,20)))'; //, //,
$result = Parser::parse($rql_str);
// Returns:
/** array (
0 =>
ByteFerry\RqlParser\Query::__set_state(array(
'container' =>
array (
'resource' => 'User',
'columns' =>
array (
0 => 'id',
1 => 'name',
2 => 'age',
3 => 'gender',
4 => 'address',
5 => 'avg(age)',
),
'columns_operator' => 'aggr',
'group_by' =>
array (
0 => 'id',
1 => 'name',
2 => 'age',
3 => 'gender',
4 => 'address',
),
'filter' =>
array (
0 => ' created_at is null ',
),
'paramaters' =>
array (
'created_at' => NULL,
'sum(amount)' => '0',
),
'search' => 'Jhon%',
'sort' =>
array (
0 =>
array (
0 => 'id',
1 => 'DESC',
),
1 =>
array (
0 => 'age',
1 => 'ASC',
),
),
'having' =>
array (
0 => ' sum(amount) > 0 ',
),
'limit' =>
array (
0 => '0',
1 => '20',
),
'operator' => 'all',
'query_type' => 'Q_READ',
),
)),
)
*/We could see that the parser add groupby automatically, and returns the property parematers for validation.
If you find this project useful, you can buy author a glass of juice 🍹
MIT
Copyright [2020] ByteFerry byteferry@qq.com
| Back | FazBrowse Home | New Git URL |