insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', 
		[
		 { '__name__':'key1', '__value__':1, '__timestamp__':'2024-07-27 00:00:00', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key1', '__value__':1, '__timestamp__':'2024-07-27 00:01:00', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-27 10:00:00', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key1', '__value__':3, '__timestamp__':'2024-07-27 11:00:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-27 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-27 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-27 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-27 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-28 11:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.82, '__timestamp__':'2024-07-28 11:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-28 11:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-28 11:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-29 11:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.83, '__timestamp__':'2024-07-29 11:25:18', 'disk':'/opt/matrix10', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-29 11:25:19', 'disk':'/opt/matrix11', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-29 11:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-30 11:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.84, '__timestamp__':'2024-07-30 11:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-30 11:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-30 11:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-30 23:59:59', 'disk':'/opt/matrix13', 'CPU':'CPU48'}] ) 
;


insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb: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/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2024-11-28 11:25:01.555', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.001';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:26:02', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:26:00.002';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:27:00.666', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:27:00.003';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:28:06', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:28:00.004';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:29:00.005';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb: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/bucketpromdb (id, pprom) values ('bucketpromdb: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/bucketpromdb (id, pprom) values ('bucketpromdb: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/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:24:10', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:24:00.009';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:25:50.999', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.010';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:26:20', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:26:00.011';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:27:40', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:27:00.012';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:28:30.034', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:28:00.013';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb: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/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:30:21', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:30:00.015';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:31:15', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:31:00.016';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb: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/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:32:59', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 23:59:59.017';

insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', 
		[{ '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-27 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__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'},
		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-28 11:24:17', 'disk':'/opt/matrix/test', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.82, '__timestamp__':'2024-07-28 11:25:18', 'disk':'/opt/matrix/test', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-28 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-28 11:26:19', 'disk':'/opt/matrix/test', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-29 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.83, '__timestamp__':'2024-07-29 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-29 11:25:19', 'disk':'/opt/matrix/test', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-29 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'},
		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-30 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'},
		 { '__name__':'key2', '__value__':8.84, '__timestamp__':'2024-07-30 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'},
		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-30 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'},
		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-30 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] )
;

insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2024-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:24:00.000';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.001';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:26:00.002';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:27:00.003';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:28:00.004';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:29:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:29:00.005';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__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/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__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/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:32:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:32:00.008';

insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:24:00.009';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.010';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:26:00.011';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__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/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:28:00.013';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:29:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:29:00.014';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__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/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:31:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:31:00.016';
insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__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/bucketpromdb (id, pprom) values (?, ? )
/**
beforerun(
    set(ct,"2024-10-28 06:54:17"),
    add(ct,mqli,second)
)
loop(1000)
params("bucketpromdb:wecise", [
			{"name": "key1{%d,mqli}", "value": 2, "timestamp": "{%t,ct}"},
			{"name": "key2_{%d,mqli}", "value": 1.8, "timestamp": "{%t,ct}"},
			{"name": "key_3_{%d,mqli}", "value": 2.9, "timestamp": "{%t,ct}"},
			{"name": "keys1{%d,mqli}", "value": "sss", "timestamp": "{%t,ct}"},
			{"name": "keys2_{%d,mqli}", "value": "这是中文长字符串sssss", "timestamp": "{%t,ct}"},
			{"name": "key48_{%d,mqli}", "value": 2.9, "timestamp": "{%t,ct}"}])
**/
;

insert into /test/bucketpromdb (id, pprom) values (?, ? )
/**
set(ct,"2024-10-28 15:24:17")
beforerun(
    add(ct,1,second)
)
loop(1000)
params("bucketpromdb:wecise", [
			{"name": "key1", "value": 2.7, "timestamp": "{%2006-01-02 15:04:05,ct}"},
			{"name": "key2", "value": 1.9, "timestamp": "{%2006-01-02 15:04:05,ct}"},
			{"name": "key3", "value": 3.9, "timestamp": "{%2006-01-02 15:04:05,ct}"},
			{"name": "keys1", "value": "sss", "timestamp": "{%2006-01-02 15:04:05,ct}"},
			{"name": "keys2", "value": "这是中文长字符串sssss", "timestamp": "{%2006-01-02 15:04:05,ct}"},
			{"name": "key48", "value": 3.9, "timestamp": "{%2006-01-02 15:04:05,ct}"}])
**/
;

insert into /test/bucketpromdb (id, pprom) values (?, ? )
/**
params("bucketpromdb:wecise", [
		{"name": "key1", "value": 2.9, "timestamp": "2024-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"},
		{"name": "key2", "value": 2, "timestamp": "2024-07-29 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"},
		{"name": "key3", "value": 2.9, "timestamp": "2024-07-29 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"},
		{"name": "keys1", "value": "sss", "timestamp": "2024-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
		{"name": "keys2", "value": "这是中文长字符串sssss", "timestamp": "2024-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
		{"name": "key48", "value": 2.9, "timestamp": "2024-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}])
**/
;

insert into /test/bucketpromdb (id, pprom) values (?, ? )
/**
params("bucketpromdb:wecise", [
		{"__name__": "key1", "__value__": 5.2, "__timestamp__": "2024-07-30 11:24:17", "disk": "/opt/matrix/test", "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", "CPU": "CPU3"},
		{"__name__": "keys1", "__value__": "sss", "__timestamp__": "2024-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
		{"__name__": "keys2", "__value__": "这是中文长字符串sssss", "__timestamp__": "2024-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
		{"__name__": "key48", "__value__": 2.9, "__timestamp__": "2024-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}])
**/
;

insert into /test/bucketpromdb (id, pprom) values (?, ? ) at ?
/**
params("bucketpromdb:wecise", [
		{"__name__": "key1", "__value__": 6.0, "__timestamp__": "2024-07-31 11:24:17", "disk": "/opt/matrix/test", "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__": "keys1", "__value__": "sss", "__timestamp__": "2024-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
		{"__name__": "keys2", "__value__": "这是中文长字符串sssss", "__timestamp__": "2024-07-31 11:25:19", "disk": "/opt/matrix", "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)
**/
;