guidofaecke / jsondbquery
从URL json查询字符串生成SQL
dev-master
2018-06-12 15:32 UTC
Requires
- php: ^7.1
Requires (Dev)
- beberlei/assert: ~2.9
- doctrine/doctrine-orm-module: ^2.1
- phpunit/phpunit: ^6.1
- squizlabs/php_codesniffer: ^3.2
- zendframework/zend-db: ^2.9
Suggests
- doctrine/doctrine-orm-module: Needed to use JsonDbQuery with Doctrine ORM
- zendframework/zend-db: Needed to use JsonDbQuery with ZendFramework DB
This package is auto-updated.
Last update: 2024-09-12 09:52:12 UTC
README
使用JSON通过REST和RPC调用来构建简单查询。
计划支持
- Doctrine
- Zend-Db
- 原始SQL
使用示例
(尚未最终确定)
http://<your_system>/api/get_some_data?query={"field" : {"$not" : val}} http://<your_system>/api/get_some_data?query={"field" : {"$in" : [value1, value2, ...]}} http://<your_system>/api/get_some_data?query={"$or": [{"status": "BLUE"}, {"status": "RED"}]} http://<your_system>/api/get_some_data?query={"amount": {"$gt": 500}} http://<your_system>/api/get_some_data?query={"amount": {"$lte": 500}} http://<your_system>/api/get_some_data?query={"amount": {"$bt": [300, 640]}}