-
Notifications
You must be signed in to change notification settings - Fork 47
/
QueryRawExample.php
65 lines (53 loc) · 1.42 KB
/
QueryRawExample.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
<?php
/**
* Shows how to query data into `string`
*/
require __DIR__ . '/../vendor/autoload.php';
use InfluxDB2\Client;
use InfluxDB2\Point;
$org = 'my-org';
$bucket = 'my-bucket';
$token = 'my-token';
//
// Creating client
//
$client = new Client([
"url" => "http://localhost:8086",
"token" => $token,
"bucket" => $bucket,
"org" => $org,
"precision" => InfluxDB2\Model\WritePrecision::S
]);
//
// Write test data into InfluxDB
//
$writeApi = $client->createWriteApi();
$pointArray = [];
$dateNow = new DateTime('NOW');
for ($i = 1; $i <= 10; $i++) {
$point = Point::measurement("weather")
->addTag("location", "Sydney")
->addField("temperature", rand(15, 30))
->time($dateNow->getTimestamp());
$pointArray[] = $point;
$dateNow->sub(new DateInterval('P1D'));
}
$writeApi->write($pointArray);
$writeApi->close();
//
// Get query client
//
$queryApi = $client->createQueryApi();
//
// Synchronously executes query and return result as unprocessed String
//
$result = $queryApi->queryRaw(
"from(bucket: \"my-bucket\")
|> range(start: 0)
|> filter(fn: (r) => r[\"_measurement\"] == \"weather\"
and r[\"_field\"] == \"temperature\"
and r[\"location\"] == \"Sydney\")"
);
printf("\n\n-------------------------- Query Raw ----------------------------\n\n");
printf($result);
$client->close();