activedbsoft / webapi-active-query-builder
1.1.8
2016-11-03 13:02 UTC
Requires
- php: >=5.4
- ext-curl: *
- ext-json: *
- ext-mbstring: *
Requires (Dev)
- phpunit/phpunit: ~4.8
- satooshi/php-coveralls: ~1.0
- squizlabs/php_codesniffer: ~2.6
This package is not auto-updated.
Last update: 2024-09-23 12:45:48 UTC
README
Active Query Builder Web API 允许使用 RESTful HTTP 请求向云端服务创建、分析和修改不同数据库服务器的 SQL 查询。它需要将 SQL 执行上下文(有关数据库模式和使用的数据库服务器信息)存储在 https://webapi.activequerybuilder.com/ 上注册的账户下。
需求
PHP 5.4.0 及更高版本
手动安装
下载文件并包含 autoload.php
require_once('/path/to/WebApiActiveQueryBuilder/autoload.php');
入门指南
请遵循 安装过程,然后运行以下命令
<?php require_once(__DIR__ . '/vendor/autoload.php'); $api = new WebApiActiveQueryBuilder\ActiveQueryBuilderApi(); $metadataGuid= "b3207f4f-b1f4-4dc2-979b-7724ed2d0221"; $sql = "Select customer_id, first_name From customer"; $query = new WebApiActiveQueryBuilder\SqlQuery(); // \WebApiActiveQueryBuilder\SqlQuery | Information about SQL query and it's context. $query->setGuid($metadataGuid); $query->setText($sql); $columns = $api->getQueryColumnsPost($query); print_r($columns); $transform = new WebApiActiveQueryBuilder\Transform(); $transform->setGuid($metadataGuid); $transform->setSql($sql); $filter = new WebApiActiveQueryBuilder\ConditionGroup(); $condition = new WebApiActiveQueryBuilder\Condition(); $condition->setField('customer_id'); $condition->setConditionOperator('Greater'); $condition->setValues(array(10)); $filter->setConditions(array($condition)); $page = new WebApiActiveQueryBuilder\Pagination(); $page->setSkip(10); $page->setTake(5); $order = new WebApiActiveQueryBuilder\Sorting(); $order->setField('customer_id'); $order->setOrder('asc'); $transform->setFilter($filter); $transform->setPagination($page); $transform->setSortings(array($order)); $result = $api->transformSqlPost($transform); print_r($result); ?>
API 端点文档
所有 URI 都是相对于 https://webapi.activequerybuilder.com
模型文档
授权文档
所有端点不需要授权。
作者
源代码
Active Query Builder Web API 所有客户端的完整源代码可在 GitHub 上找到。在此获取 JavaScript 源代码: https://github.com/ActiveDbSoft/webapi-active-query-builder-php