activedbsoft/webapi-active-query-builder

1.1.8 2016-11-03 13:02 UTC

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

模型文档

授权文档

所有端点不需要授权。

作者

support@activedbsoft.com

源代码

Active Query Builder Web API 所有客户端的完整源代码可在 GitHub 上找到。在此获取 JavaScript 源代码: https://github.com/ActiveDbSoft/webapi-active-query-builder-php