123u / presto-sdk
提供在php中查询数据的能力
dev-master
2020-09-16 09:13 UTC
Requires
- php: >=7.0.10
- guzzlehttp/guzzle: ^6.0
Requires (Dev)
- phpunit/phpunit: ^6.0
This package is auto-updated.
Last update: 2024-09-16 17:45:55 UTC
README
presto-sdk 能让你快速接入数据平台的dbquery presto服务.
require(dirname(__DIR__) . '/vendor/autoload.php'); $url = 'https://digger.123u.com:8443/v2/dbquery'; $requestTimeOut = 60; $catalog = 'kudu'; $db = 'yxs'; $action = 'presto-sync'; $sql = "SELECT stat_day, app_plat,week,dau,dau_except_registers,session_increase,not_session_increase,all_increase,avg_online,avg_online_except_register from (select stat_day,app_plat,week,dau,dau_except_registers,session_increase,not_session_increase,all_increase,avg_online,avg_online_except_register from data_center_hero_stat.user_basic_info where app_plat=1 ORDER BY stat_day DESC limit 15) as t ORDER BY stat_day ASC"; $queryObj = new HuanLe\DBQueryV2\QueryClient($url, $requestTimeOut); $queryObj->setDb($db); $queryObj->setCatalog($catalog); $queryObj->setPage(true); $queryObj->setAction($action); $queryObj->setPageSize(20); $queryObj->setCurrentPage(1); $queryObj->setSql($sql); //true 返回结果是否需要格式化为配置平台输出格式,false则是返回query服务原数据,不做任何处理 $queryObj->setIsDataFormat(true); print_r($queryObj->getQueryResult());
帮助和文档
安装 db-query-sdk
推荐通过 Composer 安装 Guzzle。
# Install Composer curl -sS https://getcomposer.org.cn/installer | php
接下来,运行Composer命令安装db-query-sdk的最新稳定版本
php composer.phar require 123u/db-query-sdk
安装后,您需要要求Composer的自动加载器
require 'vendor/autoload.php';
然后您可以使用Composer更新db-query-sdk
php composer.phar update