odbtools/odbctest/mql/test/promdb/2.insert_loop.mql

insert into /test/bucketpromdb (id, prom) values (?, ? )
/**
params("bucketpromdb:wecise09999", [
    {"name": "key100009", "value": 1, "timestamp": "2024-03-28 11:25:15", "CPU": "CPU1"},
    {"name": "key200009", "value": 1, "timestamp": "2024-03-28 11:25:15", "CPU": "CPU2"},
    {"name": "key300009", "value": 1, "timestamp": "2024-03-28 11:25:15", "CPU": "CPU3"},
    {"name": "key400009", "value": 1, "timestamp": "2024-03-28 11:25:15", "CPU": "CPU4"},
    {"name": "key500009", "value": 1, "timestamp": "2024-03-28 11:25:15", "CPU": "CPU5"},
    {"name": "key600009", "value": 1, "timestamp": "2024-03-28 11:25:15", "CPU": "CPU6"},
    {"name": "key700009", "value": 1, "timestamp": "2024-03-28 11:25:15", "CPU": "CPU7"},
    {"name": "key800009", "value": 1, "timestamp": "2024-03-28 11:25:15", "CPU": "CPU8"},
    {"name": "key900009", "value": 1, "timestamp": "2024-03-28 11:25:15", "CPU": "CPU9"},
    {"name": "keya00009", "value": 1, "timestamp": "2024-03-28 11:25:15", "CPU": "CPUa"}])
loop(1000)
**/
;


select prom.time('2024-03-28 11:25:15','2099-03-28 12:25').count() from /test/bucketpromdb where id = ?
/**
params("bucketpromdb:wecise")
output()
**/
;