grafana

Commit Graph

Author	SHA1	Message	Date
Julien NOEL	f4b6c4019c	PostgreSQL: __unixEpochGroup to support arithmetic expression as argument (#46764 ) * __unixEpochGroup to support arithmetic argument Following call generates wrong expression : $__unixEpochGroupAlias(height+42,$__interval) => floor(height+42/60)60 AS "time" instead of => floor((height+42)/60)60 AS "time" * Update test of __unixEpochGroup related to issue #46764	3 years ago
ying-jeanne	c989f0fbbe	SQL: Migrate to use SDK contracts (#36635 ) * convert SQLs to use sdk contracts * make draft * postgres * intermedia * get datasourceinfo filled at the beginning of the service * move the interval into package because of cyclict import and fix all postgres tests * fix mysql test * fix mssql * fix the test for pr https://github.com/grafana/grafana/issues/35839 * fix some issue about intervalv2 package * update sql test * wire migration for SQLs * add sqls to the background process * make it register instead of register and start * revert formatting * fix tests * fix linter * remove integration test * Postgres test fix Co-authored-by: Marcus Efraimsson <marcus.efraimsson@gmail.com>	4 years ago
Marcus Efraimsson	0611207f3b	Postgres/MySQL/MSSQL: Fix concurrent map writes panic (#35510 ) Fixes panic/fatal error concurrent map writes in SQL data sources when multiple queries are executed concurrently and you interpolate SQL query before executing it. Fixes #35469	4 years ago
ying-jeanne	0b97cdcee1	fix postgres to have precision of ms (#33853 )	4 years ago
Marcus Efraimsson	dd0ba96d7c	Postgres: Fix time group macro when TimescaleDB is enabled and interval is less than a second (#33153 ) Fixing a special case with time group macro when using TimescaleDB and interval is lower than a second. Fixes #33124	4 years ago
Arve Knudsen	b79e61656a	Introduce TSDB service (#31520 ) * Introduce TSDB service Signed-off-by: Arve Knudsen <arve.knudsen@gmail.com> Co-authored-by: Erik Sundell <erik.sundell87@gmail.com> Co-authored-by: Will Browne <will.browne@grafana.com> Co-authored-by: Torkel Ödegaard <torkel@grafana.org> Co-authored-by: Will Browne <wbrowne@users.noreply.github.com> Co-authored-by: Zoltán Bedi <zoltan.bedi@gmail.com>	4 years ago
Ricky Putra	d56c5285e2	Postgres: Fix timeGroup macro converts long intervals to invalid numbers when TimescaleDB is enabled (#31179 ) Fixes #27253	4 years ago
Arve Knudsen	41d432b5ae	Chore: Enable whitespace linter (#25903 ) Signed-off-by: Arve Knudsen <arve.knudsen@gmail.com>	5 years ago
Ander Arguiñano	3801a75131	FIxed syntaxis mistake unixEpochNanoFrom and unixEpochNanoTo	7 years ago
Ander Arguiñano	9105625f24	Added unixEpochNanoTo and unixEpochNanoFrom macros to postgresql	7 years ago
Ander Arguiñano	4d8d2a9690	Renamed unixEpochFilterNano to unixEpochNanoFilter	7 years ago
Sven Klemm	4c51e8df20	Don't cut off subsecond precision for postgres macros Change time format to RFC3339Nano for $__timeFilter, $__timeFrom and $__timeTo macros	7 years ago
Ander Arguiñano	1a67a8db80	Nanosecond timestamp support postgresql	7 years ago
Marcus Efraimsson	624e5e5b3d	let each sql datasource handle timeFrom and timeTo macros	7 years ago
Sven Klemm	94d6d51726	move timeFrom, timeTo, unixEpochFrom and unixEpochTo macros to sql_engine	7 years ago
Sven Klemm	837388d13e	Use variable in newPostgresMacroEngine	7 years ago
Sven Klemm	3955133f7e	Don't pass datasource to newPostgresMacroEngine	7 years ago
Sven Klemm	3552a4cb86	refactor timescaledb handling in MacroEngine	7 years ago
Sven Klemm	bfe28ee061	Add $__unixEpochGroup macro to postgres datasource	7 years ago
Sven Klemm	d2984f3b0f	fix rebase error	7 years ago
Sven Klemm	c3aad10047	change timescaledb to checkbox instead of select	7 years ago
Sven Klemm	b987aee7cf	add timescaledb option to postgres datasource This adds an option to the postgres datasource config for timescaledb support. When set to auto it will check for timescaledb when testing the datasource. When this option is enabled the $__timeGroup macro will use the time_bucket function from timescaledb to group times by an interval. This also passes the datasource edit control to testDatasource to allow for setting additional settings, this might be useful for other datasources aswell which have optional or version dependant features which can be queried.	7 years ago
Sven Klemm	dc22e24642	add compatibility code to handle pre 5.3 usage	7 years ago
Sven Klemm	42f1892826	Add $__timeGroupAlias to postgres macros	7 years ago
Sven Klemm	43295f9c18	remove alias from postgres $__timeGroup macro	7 years ago
Marcus Efraimsson	2f3851b915	postgres: use new sql engine	7 years ago
Sven Klemm	c2c22c142b	[postgres] fix timeGroup macro rounding (#12468 ) * fix timeGroup tests to check for correct grouping * do explicit floor rounding in $__timeGroup macro * fix typo in comments	7 years ago
Sven Klemm	5dc36afe71	calculate datetime for timeFrom and timeTo macro in go	7 years ago
Sven Klemm	6d3da9a73d	remove postgresversion and convert unix timestamp in go	7 years ago
Sven Klemm	9b61ffb48a	make timefilter macro aware of pg version	7 years ago
Marcus Efraimsson	f5586b1270	tsdb: sql data sources should handle time ranges before epoch start correctly	7 years ago
ryan	1c9ebd5bd8	fix test	7 years ago
ryan	113bfb3d3e	don't convert to uint64	7 years ago
Sven Klemm	f1ba9137c0	remove spaces around arguments before calling macro expansion	7 years ago
Sven Klemm	b6df91d56b	pass Query to MacroEngine Interpolate	8 years ago
Sven Klemm	ce809de1ed	postgres: change $__timeGroup macro to include "AS time" column alias (#10119 ) * change $__timeGroup macro to include column alias * update docs and help text for $__timeGroup macro	8 years ago
Sven Klemm	34da0711ab	add __timeGroup macro for mysql (#9596 ) * add __timeGroup macro for mysql * put example __timeGroup query in frontend help * do __timeGroup interval parsing in go similar to mysql * ignore whitespace around interval	8 years ago
Sven Klemm	b2d880c6de	modify $__timeGroup macro so it can be used in select clause (#9527 ) * modify $__timeGroup macro so it can be used in select clause * fix $__interval_ms for postgres datasource * use $__timeGroup macro in documentation * fix annotation template query remove title since its no longer used and add tags instead * change __timeFilter macro to work on postgresql < 8.1 and redshift	8 years ago
Daniel Lee	d1c9760fa8	Postgres Data Source (#9475 ) * add postgresql datasource * add rest of files for postgres datasource * fix timeseries query, remove unused code * consistent naming, refactoring * s/mysql/postgres/ * s/mysql/postgres/ * couple more tests * tests for more datatypes * fix macros for postgres * add __timeSec macro * add frontend for postgres datasource * adjust documentation * fix formatting * add proper plugin description * merge editor changes from mysql * port changes from mysql datasource * set proper defaultQuery for postgres * add time_sec to timeseries query accept int for value for timeseries query * revert allowing time_sec and handle int or float values as unix timestamp for "time" column * fix tslint error * handle decimal values in timeseries query * allow setting sslmode for postgres datasource * use type switch for handling data types * fix value for timeseries query * refactor timeseries queries to make them more flexible * remove debug statement from inner loop in type conversion * use plain for loop in getTypedRowData * fix timeseries queries * adjust postgres datasource to tsdb refactoring * adjust postgres datasource to frontend changes * update lib/pq to latest version * move type conversion to getTypedRowData * handle address types cidr, inet and macaddr * adjust response parser and docs for annotations * convert unknown types to string * add documentation for postgres datasource * add another example query with metric column * set more helpful default query * update help text in query editor * handle NULL in value column of timeseries query * add __timeGroup macro * add test for __timeGroup macro * document __timeGroup and set proper default query for annotations * fix typos in docs * add postgres to list of datasources * add postgres to builtInPlugins * mysql: refactoring as prep for merging postgres Refactors out the initialization of the xorm engine and the query logic for an sql data source. * mysql: rename refactoring + test update * postgres:refactor to use SqlEngine(same as mysql) Refactored to use a common base class with the MySql data source. Other changes from the original PR: - Changed time column to be time_sec to allow other time units in the future and to be the same as MySQL - Changed integration test to test the main Query method rather than the private transformToTable method - Changed the __timeSec macro name to __timeEpoch - Renamed PostgresExecutor to PostgresQueryEndpoint Fixes #9209 (the original PR) * postgres: encrypt password on config page With some other cosmetic changes to the config page: - placeholder texts - reset button for the password after it has been encrypted. - default value for the sslmode field. * postgres: change back col name to time from time_sec * postgres mysql: remove annotation title Title has been removed from annotations * postgres: fix images for docs page * postgres mysql: fix specs	8 years ago

41 Commits (#45948-entity-events-trigger)