forked from influxdata/influxdb-client-php
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathQueryStreamExample.php
73 lines (61 loc) · 1.72 KB
/
QueryStreamExample.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
66
67
68
69
70
71
72
73
<?php
/**
* Shows how to query data into `Stream`
*/
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", "San Francisco")
->addField("temperature", rand(5, 25))
->time($dateNow->getTimestamp());
$pointArray[] = $point;
$dateNow->sub(new DateInterval('P1D'));
}
$writeApi->write($pointArray);
$writeApi->close();
//
// Get query client
//
$queryApi = $client->createQueryApi();
//
// Synchronously executes the Flux query and return stream of FluxRecord
//
$queryApi = $client->createQueryApi();
$query = "from(bucket: \"my-bucket\")
|> range(start: 0)
|> filter(fn: (r) => r[\"_measurement\"] == \"weather\"
and r[\"_field\"] == \"temperature\")";
$result = $queryApi->queryStream($query);
//
// Working with returned data into Stream
//
printf("\n\n----------------------------- Query Stream -------------------------------\n\n");
foreach ($result->each() as $record) {
$location = $record["location"];
$temperature = $record->getValue();
$time = $record->getTime();
$measurement = $record->getMeasurement();
print " $measurement in $location at $time - Temperature is $temperature °C\n";
}
$client->close();