AnyEvent-InfluxDB
view release on metacpan or search on metacpan
],
...
);
Querying Data
select
$cv = AE::cv;
$db->select(
database => 'mydb',
# return time in Unix epoch format
epoch => "s",
# raw query
q => "SELECT count(value) FROM cpu_load"
." WHERE region = 'eu-east' AND time > now() - 14d"
." GROUP BY time(1d) fill(none)"
." ORDER BY time DESC"
." LIMIT 10 OFFSET 3",
# or query created from arguments
}
}
Executes an select query on database "database" created from provided
arguments measurement "measurement", fields to select "fields", optional
"where" clause, grouped by "group_by" and empty values filled with
"fill", ordered by "order_by" with number of results limited to "limit"
with offset "offset". To limit number of returned series use "slimit"
with offset "soffset". If "into" parameter is provided the result of the
query will be copied to specified measurement. If "epoch" is provided
the returned "time" value will in Unix epoch format. Optional
"chunk_size" can be provided to override the default value of 10,000
datapoints.
The required "on_success" code reference is executed if request was
successful, otherwise executes the required "on_error" code reference.
Database Management
create_database
$cv = AE::cv;
$db->create_database(
lib/AnyEvent/InfluxDB.pm view on Meta::CPAN
);
=head2 Querying Data
=head3 select
$cv = AE::cv;
$db->select(
database => 'mydb',
# return time in Unix epoch format
epoch => "s",
# raw query
q => "SELECT count(value) FROM cpu_load"
." WHERE region = 'eu-east' AND time > now() - 14d"
." GROUP BY time(1d) fill(none)"
." ORDER BY time DESC"
." LIMIT 10 OFFSET 3",
# or query created from arguments
lib/AnyEvent/InfluxDB.pm view on Meta::CPAN
}
}
Executes an select query on database C<database> created from provided arguments
measurement C<measurement>, fields to select C<fields>, optional C<where>
clause, grouped by C<group_by> and empty values filled with C<fill>, ordered by
C<order_by> with number of results limited to C<limit> with offset C<offset>.
To limit number of returned series use C<slimit> with offset C<soffset>.
If C<into> parameter is provided the result of the query will be copied to specified
measurement.
If C<epoch> is provided the returned C<time> value will in Unix epoch format.
Optional C<chunk_size> can be provided to override the default value of 10,000 datapoints.
The required C<on_success> code reference is executed if request was successful,
otherwise executes the required C<on_error> code reference.
=head2 Database Management
=head3 create_database
$cv = AE::cv;
xt/author/eol.t view on Meta::CPAN
# this test was generated with Dist::Zilla::Plugin::Test::EOL 0.18
use Test::More 0.88;
use Test::EOL;
my @files = (
'lib/AnyEvent/InfluxDB.pm'
);
eol_unix_ok($_, { trailing_whitespace => 1 }) foreach @files;
done_testing;
( run in 1.282 second using v1.01-cache-2.11-cpan-39bf76dae61 )