123u/presto-sdk

Provides the ability to query data in php

dev-master 2020-09-16 09:13 UTC

Requires

• php: >=7.0.10
• guzzlehttp/guzzle: ^6.0

Requires (Dev)

• phpunit/phpunit: ^6.0

MIT

• sdk
• 123u
• dbquery

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());

Help and docs

• Documentation

Installing db-query-sdk

The recommended way to install Guzzle is through Composer.

# Install Composer
curl -sS https://getcomposer.org/installer | php

Next, run the Composer command to install the latest stable version of db-query-sdk:

php composer.phar require 123u/db-query-sdk

After installing, you need to require Composer's autoloader:

require 'vendor/autoload.php';

You can then later update db-query-sdk using composer:

php composer.phar update

Version Guidance

Version	Status	Packagist	Namespace	PHP Version
1.0.0	EOL	123u/presto-sdk	HuanLe\DBQueryV2	>= 7.0.10