odbtools/odbctest/mql/basic/24bucket_promdb/1430data4.mql

insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', 
		[{ '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.18, '__timestamp__':'2024-07-27 11:25:18', 'disk':'/opt/matrix/test', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2, '__timestamp__':'2024-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] )
;

insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:24:00.000';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.75, '__timestamp__':'2024-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.001';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.72, '__timestamp__':'2024-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:26:00.002';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':null, '__timestamp__':'2024-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:27:00.003';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2024-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:28:00.004';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.76, '__timestamp__':'2024-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:29:00.005';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:30:00.006';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:31:00.007';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:32:00.008';

insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2, '__timestamp__':'2024-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:24:00.009';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.17, '__timestamp__':'2024-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.010';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':null, '__timestamp__':'2024-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:26:00.011';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:27:00.012';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.27, '__timestamp__':'2024-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:28:00.013';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:29:00.014';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:30:00.015';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.57, '__timestamp__':'2024-11-28 11:31:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:31:00.016';
insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:32:00.017';


insert into /test/bucketpromdb4 (id, prom4) values (?, ? )
/**
params("bucketpromdb4:wecise", [
		{"name": "key1", "value": 2, "timestamp": "2024-07-28 11:24:17"},
		{"name": "key2", "value": 1.8, "timestamp": "2024-07-28 11:25:18"},
		{"name": "key3", "value": 2.9, "timestamp": "2024-07-28 11:25:19"}])
**/
;


insert into /test/bucketpromdb4 (id, prom4) values (?, ? )
/**
params("bucketpromdb4:wecise", [
		{"name": "key1", "value": 2.7, "timestamp": "2024-07-28 12:24:17"},
		{"name": "key2", "value": 1.9, "timestamp": "2024-07-28 12:25:18"},
		{"name": "key3", "value": 3.9, "timestamp": "2024-07-28 12:25:19"},
		{"name": "key48", "value": 3.9, "timestamp": "2024-07-28 12:25:19"}])
**/;


insert into /test/bucketpromdb4 (id, prom4) values (?, ? )
/**
params("bucketpromdb4:wecise", [
		{"name": "key1", "value": 2.9, "timestamp": "2024-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"},
		{"name": "key2", "value": 2.8, "timestamp": "2024-07-29 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"},
		{"name": "key3", "value": 2, "timestamp": "2024-07-29 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"},
		{"name": "key48", "value": 2.9, "timestamp": "2024-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}])
**/;


insert into /test/bucketpromdb4 (id, prom4) values (?, ? )
/**
params("bucketpromdb4:wecise", [
		{"__name__": "key1", "__value__": 5.2, "__timestamp__": "2024-07-30 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"},
		{"__name__": "key2", "__value__": 4.8, "__timestamp__": "2024-07-30 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"},
		{"__name__": "key3", "__value__": 2.9, "__timestamp__": "2024-07-30 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"},
		{"__name__": "key48", "__value__": 2.9, "__timestamp__": "2024-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}])
**/;


insert into /test/bucketpromdb4 (id, prom4) values (?, ? ) at ?
/**
params("bucketpromdb4:wecise", [
		{"__name__": "key1", "__value__": 6.0, "__timestamp__": "2024-07-31 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"},
		{"__name__": "key2", "__value__": 3, "__timestamp__": "2024-07-31 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"},
		{"__name__": "key3", "__value__": 2.9, "__timestamp__": "2024-07-31 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"},
		{"__name__": "key48", "__value__": 2.9, "__timestamp__": "2024-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}], "2024-07-31 11:24:17")
**/;

/**
sleep(1s)
**/
;