D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
proc
/
self
/
root
/
usr
/
share
/
grafana
/
public
/
app
/
plugins
/
panel
/
table-old
/
specs
/
Filename :
transformers.test.ts
back
Copy
import { tableDataFormatFilterer, timeSeriesFormatFilterer, transformDataToTable, transformers } from '../transformers'; describe('when transforming time series table', () => { let table: any; describe('given 2 time series', () => { const time = new Date().getTime(); const timeSeries = [ { target: 'series1', datapoints: [ [12.12, time], [14.44, time + 1], ], }, { target: 'series2', datapoints: [[16.12, time]], }, ]; describe('timeseries_to_rows', () => { const panel = { transform: 'timeseries_to_rows', sort: { col: 0, desc: true }, }; beforeEach(() => { table = transformDataToTable(timeSeries, panel); }); it('should return 3 rows', () => { expect(table.rows.length).toBe(3); expect(table.rows[0][1]).toBe('series1'); expect(table.rows[1][1]).toBe('series1'); expect(table.rows[2][1]).toBe('series2'); expect(table.rows[0][2]).toBe(12.12); }); it('should return 3 rows', () => { expect(table.columns.length).toBe(3); expect(table.columns[0].text).toBe('Time'); expect(table.columns[1].text).toBe('Metric'); expect(table.columns[2].text).toBe('Value'); }); }); describe('timeseries_to_columns', () => { const panel = { transform: 'timeseries_to_columns', }; beforeEach(() => { table = transformDataToTable(timeSeries, panel); }); it('should return 3 columns', () => { expect(table.columns.length).toBe(3); expect(table.columns[0].text).toBe('Time'); expect(table.columns[1].text).toBe('series1'); expect(table.columns[2].text).toBe('series2'); }); it('should return 2 rows', () => { expect(table.rows.length).toBe(2); expect(table.rows[0][1]).toBe(12.12); expect(table.rows[0][2]).toBe(16.12); }); it('should be undefined when no value for timestamp', () => { expect(table.rows[1][2]).toBe(undefined); }); }); describe('timeseries_aggregations', () => { const panel = { transform: 'timeseries_aggregations', sort: { col: 0, desc: true }, columns: [ { text: 'Max', value: 'max' }, { text: 'Min', value: 'min' }, ], }; beforeEach(() => { table = transformDataToTable(timeSeries, panel); }); it('should return 2 rows', () => { expect(table.rows.length).toBe(2); expect(table.rows[0][0]).toBe('series1'); expect(table.rows[0][1]).toBe(14.44); expect(table.rows[0][2]).toBe(12.12); }); it('should return 2 columns', () => { expect(table.columns.length).toBe(3); expect(table.columns[0].text).toBe('Metric'); expect(table.columns[1].text).toBe('Max'); expect(table.columns[2].text).toBe('Min'); }); }); }); describe('table data sets', () => { describe('Table', () => { const transform = 'table'; const panel = { transform, }; const time = new Date().getTime(); const nonTableData = [ { type: 'foo', columns: [{ text: 'Time' }, { text: 'Label Key 1' }, { text: 'Value' }], }, ]; const singleQueryData = [ { type: 'table', columns: [{ text: 'Time' }, { text: 'Label Key 1' }, { text: 'Value' }], rows: [[time, 'Label Value 1', 42]], }, ]; const multipleQueriesDataSameLabels = [ { type: 'table', columns: [{ text: 'Time' }, { text: 'Label Key 1' }, { text: 'Label Key 2' }, { text: 'Value #A' }], rows: [[time, 'Label Value 1', 'Label Value 2', 42]], }, { type: 'table', columns: [{ text: 'Time' }, { text: 'Label Key 1' }, { text: 'Label Key 2' }, { text: 'Value #B' }], rows: [[time, 'Label Value 1', 'Label Value 2', 13]], }, { type: 'table', columns: [{ text: 'Time' }, { text: 'Label Key 1' }, { text: 'Label Key 2' }, { text: 'Value #C' }], rows: [[time, 'Label Value 1', 'Label Value 2', 4]], }, { type: 'table', columns: [{ text: 'Time' }, { text: 'Label Key 1' }, { text: 'Label Key 2' }, { text: 'Value #C' }], rows: [[time, 'Label Value 1', 'Label Value 2', 7]], }, ]; describe('getColumns', () => { it('should return data columns given a single query', () => { const columns = transformers[transform].getColumns(singleQueryData); expect(columns[0].text).toBe('Time'); expect(columns[1].text).toBe('Label Key 1'); expect(columns[2].text).toBe('Value'); }); it('should return the union of data columns given a multiple queries', () => { const columns = transformers[transform].getColumns(multipleQueriesDataSameLabels); expect(columns[0].text).toBe('Time'); expect(columns[1].text).toBe('Label Key 1'); expect(columns[2].text).toBe('Label Key 2'); expect(columns[3].text).toBe('Value #A'); expect(columns[4].text).toBe('Value #B'); }); }); describe('transform', () => { it('should throw an error with non-table data', () => { expect(() => transformDataToTable(nonTableData, panel)).toThrow(); }); it('should return 3 columns for single queries', () => { table = transformDataToTable(singleQueryData, panel); expect(table.columns.length).toBe(3); expect(table.columns[0].text).toBe('Time'); expect(table.columns[1].text).toBe('Label Key 1'); expect(table.columns[2].text).toBe('Value'); }); it('should return the union of columns for multiple queries', () => { table = transformDataToTable(multipleQueriesDataSameLabels, panel); expect(table.columns.length).toBe(6); expect(table.columns[0].text).toBe('Time'); expect(table.columns[1].text).toBe('Label Key 1'); expect(table.columns[2].text).toBe('Label Key 2'); expect(table.columns[3].text).toBe('Value #A'); expect(table.columns[4].text).toBe('Value #B'); expect(table.columns[5].text).toBe('Value #C'); }); it('should return 1 row for a single query', () => { table = transformDataToTable(singleQueryData, panel); expect(table.rows.length).toBe(1); expect(table.rows[0][0]).toBe(time); expect(table.rows[0][1]).toBe('Label Value 1'); expect(table.rows[0][2]).toBe(42); }); it('should return 2 rows for a multiple queries with same label values plus one extra row', () => { table = transformDataToTable(multipleQueriesDataSameLabels, panel); expect(table.rows.length).toBe(2); expect(table.rows[0][0]).toBe(time); expect(table.rows[0][1]).toBe('Label Value 1'); expect(table.rows[0][2]).toBe('Label Value 2'); expect(table.rows[0][3]).toBe(42); expect(table.rows[0][4]).toBe(13); expect(table.rows[0][5]).toBe(4); expect(table.rows[1][0]).toBe(time); expect(table.rows[1][1]).toBe('Label Value 1'); expect(table.rows[1][2]).toBe('Label Value 2'); expect(table.rows[1][3]).toBeUndefined(); expect(table.rows[1][4]).toBeUndefined(); expect(table.rows[1][5]).toBe(7); }); }); }); }); describe('doc data sets', () => { describe('JSON Data', () => { const panel = { transform: 'json', columns: [ { text: 'Timestamp', value: 'timestamp' }, { text: 'Message', value: 'message' }, { text: 'nested.level2', value: 'nested.level2' }, ], }; const rawData = [ { type: 'docs', datapoints: [ { timestamp: 'time', message: 'message', nested: { level2: 'level2-value', }, }, ], }, ]; describe('getColumns', () => { it('should return nested properties', () => { const columns = transformers['json'].getColumns(rawData); expect(columns[0].text).toBe('timestamp'); expect(columns[1].text).toBe('message'); expect(columns[2].text).toBe('nested.level2'); }); }); describe('transform', () => { beforeEach(() => { table = transformDataToTable(rawData, panel); }); it('should return 2 columns', () => { expect(table.columns.length).toBe(3); expect(table.columns[0].text).toBe('Timestamp'); expect(table.columns[1].text).toBe('Message'); expect(table.columns[2].text).toBe('nested.level2'); }); it('should return 2 rows', () => { expect(table.rows.length).toBe(1); expect(table.rows[0][0]).toBe('time'); expect(table.rows[0][1]).toBe('message'); expect(table.rows[0][2]).toBe('level2-value'); }); }); }); }); describe('annotation data', () => { describe('Annnotations', () => { const panel = { transform: 'annotations' }; const rawData = { annotations: [ { time: 1000, text: 'hej', tags: ['tags', 'asd'], title: 'title', }, ], }; beforeEach(() => { table = transformDataToTable(rawData, panel); }); it('should return 4 columns', () => { expect(table.columns.length).toBe(4); expect(table.columns[0].text).toBe('Time'); expect(table.columns[1].text).toBe('Title'); expect(table.columns[2].text).toBe('Text'); expect(table.columns[3].text).toBe('Tags'); }); it('should return 1 rows', () => { expect(table.rows.length).toBe(1); expect(table.rows[0][0]).toBe(1000); }); }); }); describe('given time series and table data', () => { const time = new Date().getTime(); const data = [ { target: 'series1', datapoints: [ [12.12, time], [14.44, time + 1], ], }, { columns: [ { type: 'time', text: 'Time', }, { text: 'mean', }, ], type: 'table', rows: [ [time, 13.13], [time + 1, 26.26], ], }, ]; describe('timeseries_to_rows', () => { const panel = { transform: 'timeseries_to_rows', sort: { col: 0, desc: true }, }; beforeEach(() => { table = transformDataToTable(data, panel); }); it('should return 2 rows', () => { expect(table.rows.length).toBe(2); expect(table.rows[0][1]).toBe('series1'); expect(table.rows[1][1]).toBe('series1'); expect(table.rows[0][2]).toBe(12.12); }); it('should return 3 columns', () => { expect(table.columns.length).toBe(3); expect(table.columns[0].text).toBe('Time'); expect(table.columns[1].text).toBe('Metric'); expect(table.columns[2].text).toBe('Value'); }); }); describe('timeseries_to_columns', () => { const panel = { transform: 'timeseries_to_columns', }; beforeEach(() => { table = transformDataToTable(data, panel); }); it('should return 2 columns', () => { expect(table.columns.length).toBe(2); expect(table.columns[0].text).toBe('Time'); expect(table.columns[1].text).toBe('series1'); }); it('should return 2 rows', () => { expect(table.rows.length).toBe(2); expect(table.rows[0][1]).toBe(12.12); }); it('should be undefined when no value for timestamp', () => { expect(table.rows[1][2]).toBe(undefined); }); }); describe('timeseries_aggregations', () => { const panel = { transform: 'timeseries_aggregations', sort: { col: 0, desc: true }, columns: [ { text: 'Max', value: 'max' }, { text: 'Min', value: 'min' }, ], }; beforeEach(() => { table = transformDataToTable(data, panel); }); it('should return 1 row', () => { expect(table.rows.length).toBe(1); expect(table.rows[0][0]).toBe('series1'); expect(table.rows[0][1]).toBe(14.44); expect(table.rows[0][2]).toBe(12.12); }); it('should return 2 columns', () => { expect(table.columns.length).toBe(3); expect(table.columns[0].text).toBe('Metric'); expect(table.columns[1].text).toBe('Max'); expect(table.columns[2].text).toBe('Min'); }); }); }); }); describe('timeSeriesFormatFilterer', () => { describe('when called with an object that contains datapoints property', () => { it('then it should return same object in array', () => { const data: any = { datapoints: [] }; const result = timeSeriesFormatFilterer(data); expect(result).toEqual([data]); }); }); describe('when called with an object that does not contain datapoints property', () => { it('then it should return empty array', () => { const data: any = { prop: [] }; const result = timeSeriesFormatFilterer(data); expect(result).toEqual([]); }); }); describe('when called with an array of series with both timeseries and table data', () => { it('then it should return an array with timeseries', () => { const time = new Date().getTime(); const data: any[] = [ { target: 'series1', datapoints: [ [12.12, time], [14.44, time + 1], ], }, { columns: [ { type: 'time', text: 'Time', }, { text: 'mean', }, ], type: 'table', rows: [ [time, 13.13], [time + 1, 26.26], ], }, ]; const result = timeSeriesFormatFilterer(data); expect(result).toEqual([ { target: 'series1', datapoints: [ [12.12, time], [14.44, time + 1], ], }, ]); }); }); }); describe('tableDataFormatFilterer', () => { describe('when called with an object that contains columns property', () => { it('then it should return same object in array', () => { const data: any = { columns: [] }; const result = tableDataFormatFilterer(data); expect(result).toEqual([data]); }); }); describe('when called with an object that does not contain columns property', () => { it('then it should return empty array', () => { const data: any = { prop: [] }; const result = tableDataFormatFilterer(data); expect(result).toEqual([]); }); }); describe('when called with an array of series with both timeseries and table data', () => { it('then it should return an array with table data', () => { const time = new Date().getTime(); const data: any[] = [ { target: 'series1', datapoints: [ [12.12, time], [14.44, time + 1], ], }, { columns: [ { type: 'time', text: 'Time', }, { text: 'mean', }, ], type: 'table', rows: [ [time, 13.13], [time + 1, 26.26], ], }, ]; const result = tableDataFormatFilterer(data); expect(result).toEqual([ { columns: [ { type: 'time', text: 'Time', }, { text: 'mean', }, ], type: 'table', rows: [ [time, 13.13], [time + 1, 26.26], ], }, ]); }); }); });