grafana

Commit Graph

Author	SHA1	Message	Date
Andres Martinez Gotor	64c8d32fe7	Use sdk pkg for gtime (#39354 )	4 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
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
Arve Knudsen	2bf964c61e	Chore: Fix linting issues caught by ruleguard (#28799 ) * Chore: Fix linting issues caught by ruleguard Signed-off-by: Arve Knudsen <arve.knudsen@gmail.com> * Improve error check Signed-off-by: Arve Knudsen <arve.knudsen@gmail.com>	5 years ago
Arve Knudsen	574553ec7b	Chore: Fix issues found by staticcheck (#28802 ) * Fix linting issues Signed-off-by: Arve Knudsen <arve.knudsen@gmail.com>	5 years ago
Kyle Brandt	e5bf3027fc	Refactor: Move sql_engine to sub package of tsdb (#18991 ) this way importing the tsdb package does not come with xorm dependencies	6 years ago
Bernard Duggan	a0bb01103e	MySQL/Postgres/MSSQL: Add parsing for day, weeks and year intervals in macros (#13086 ) closes #11431	6 years ago
Ander Arguiñano	3801a75131	FIxed syntaxis mistake unixEpochNanoFrom and unixEpochNanoTo	7 years ago
Ander Arguiñano	b4eac406d5	Added previous macros to mssql	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	0254a29e35	Interpolate $__interval in backend for alerting with sql datasources (#13156 ) add support for interpolate $__interval and $__interval_ms in sql datasources	7 years ago
Sven Klemm	8c4d59363e	add $__unixEpochGroup to mssql datasource	7 years ago
Sven Klemm	d81a23becf	Refactor setting fillmode This adds SetupFillmode to the tsdb package to be used by the sql datasources.	7 years ago
Sven Klemm	ee7602ec1f	change fillmode from last to previous	7 years ago
Sven Klemm	bfc66a7ed0	add fillmode "last" to sql datasource This adds a new fill mode last (last observation carried forward) for grafana to the sql datasources. This fill mode will fill in the last seen value in a series when a timepoint is missing or NULL if no value for that series has been seen yet.	7 years ago
Sven Klemm	b71d10a7a4	add $__timeGroupAlias to mysql and mssql	7 years ago
Marcus Efraimsson	4f7882cda2	mssql: use new sql engine	7 years ago
Sven Klemm	f017c04a65	[mssql] fix $__timeGroup rounding (#12470 ) * fix $__timeGroup rounding for mssql * revert enabling of mssql integration tests	7 years ago
Austin Winstanley	a0e8437f8f	Used PostgreSQL TSDB as a model the set up the __timeFilter, __timeFrom, and __timeTo macros for Microsoft SQL and MySQL	7 years ago
Austin Winstanley	105b3d6804	Switched MySQL and MSSQL macros for timeFilter and related to use BETWEEN and calculate UNIX time server side instead of database side. Fixes #11618 #11619	7 years ago
Marcus Efraimsson	a86ee304ff	tsdb: remove unnecessary type casts in sql data sources macro engines	7 years ago
Marcus Efraimsson	f5586b1270	tsdb: sql data sources should handle time ranges before epoch start correctly	7 years ago
ryan	920a0c4fec	skip mssql fix	7 years ago
ryan	7d6c8aa612	add mssql and mysql	7 years ago
Marcus Efraimsson	b0076d4f65	mssql: remove UTC conversion in macro functions Removes the macro function . Macro functions should not do UTC/timezone conversion - they should work in the same way as postgres and mysql datasource implementations. Grafana and Microsft SQL Server should be run on servers with UTC timezones.	7 years ago
Marcus Efraimsson	3ccadff800	mssql: fix timeGroup macro so that it properly creates correct groups Earlier the division of interval was done using whole numbers resulting in that important information was lost/too many time series merged to the same group. Now using division of floating point and rounding up to solve the problem	7 years ago
Marcus Efraimsson	d14946a135	mssql: cleanup and minor refactor	7 years ago
Leonard Gram	571556e1d8	mssql: adds fill to timeGroup macro.	7 years ago
Marcus Efraimsson	c87752102a	mssql datasource: support for timeGroup macro function	7 years ago
linux chips	6e7a067857	adding support for sgl native time datatypes	8 years ago
linux chips	c75f9a1923	MSSQL Data Source	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
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
Brad Lhotsky	a8ac215039	Add a few more MySQL macros: * $__timeFrom() -> Returns the dashboard 'from' suitable for use querying against a MySQL TIMESTAMP field. * $__timeTo() -> Returns the dashboard 'to' suitable for use querying against a MySQL TIMESTAMP field. * $__unixEpochFiler(column) -> If you store timestamps as UNIX epoch's, this builds: column > 'from' AND column < 'to' * $__unixEpochFrom() -> Returns the dashboard 'from' suitable for use querying against a MySQL integer field (UNIX epochs) * $__unixEpochTo() -> Returns the dashboard 'to' suitable for use querying against a MySQL integer field (UNIX epochs)	8 years ago
Denis Doria	41d300f69d	Fix timeInterval for mysql datasource (#8651 ) * Fix timeInterval for mysql datasource This changes the > to >= and the < to <=, so the intervals are inclusive. This should fix the #8635 * Fix validation	8 years ago
Torkel Ödegaard	ae5e004b69	mysql: time filter macro updated	8 years ago
Torkel Ödegaard	fc878bc8ad	build: fixed order	8 years ago
Torkel Ödegaard	11806dfa78	mysql: progress	8 years ago
Torkel Ödegaard	e164eba677	mysql: began work on backend macro engine	8 years ago

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