odbtools/odbctest/mql/test/promdb/1.insert_basic.mql

insert into /test/bucketpromdb (id, prom) values (?, ? )
/**
params("bucketpromdb:wecise", [
            {"name": "key1", "value": 2, "timestamp": "2024-03-27 10:04:05", "label": "label1"},
			{"name": "key2", "value": 1.8, "timestamp": "2024-03-27 10:04:05", "label": "label2"},
			{"name": "key3", "value": 2.9, "timestamp": "2024-03-27 10:04:05", "label": "label3"},
			{"name": "keys1", "value": "sss", "timestamp": "2024-03-27 10:04:05", "label": "label4"},
			{"name": "keys2", "value": "这是中文长字符串sssss", "timestamp": "2024-03-27 10:04:05", "label": "label4"},
			{"name": "key48", "value": 2.9, "timestamp": "2024-03-27 10:04:05", "label": "label8"}])
**/
;


insert into /test/bucketpromdb (id, prom) values (?, ? )
/**
params("bucketpromdb:wecise", [
            {"name": "key1", "value": 3, "timestamp": "2024-03-27 15:04:05", "label": "labeloo1"},
			{"name": "key2", "value": 4.8, "timestamp": "2024-03-27 15:04:05", "label": "labeloo2"},
			{"name": "key3", "value": 3.9, "timestamp": "2024-03-27 15:04:05", "label": "labeloo3"},
			{"name": "keys1", "value": "sss", "timestamp": "2024-03-27 15:04:05", "label": "labeloo4"},
			{"name": "keys2", "value": "中文", "timestamp": "2024-03-27 15:04:05", "label": "labeloo4"},
			{"name": "key48", "value": 1.9, "timestamp": "2024-03-27 15:04:05", "label": "labeloo8"}])
**/
;

insert into /test/bucketpromdb (id, prom) values (?, ? )
/**
params("bucketpromdb:wecise", [
		{"name": "key1", "value": 2.7, "timestamp": "2024-03-27 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"},
		{"name": "key2", "value": 2.8, "timestamp": "2024-03-27 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"},
		{"name": "key3", "value": 2.9, "timestamp": "2024-03-27 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
		{"name": "key4", "value": 2.9, "timestamp": "2024-03-27 11:25:19", "disk": "/opt/matrix", "CPU": "CPU4"}])
**/
;

select prom.date('2024-03-27') from /test/bucketpromdb where id = ?
/**
params("bucketpromdb:wecise")
output()
**/
;