Home Explore Help
Sign In
libf
/
odbtools
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: ec34f1ccd3
Branches Tags
odbtools
/
odbctest
/
mql
/
basic
/
24bucket_promdb
/
1630data6.mql

1630data6.mql 8.1 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107 
  1. 

  2. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', 
    3. 

  3. 		[{ '__name__':'key1', '__value__':2.6, '__timestamp__':'2024-07-27 11:24:17'}] )
    4. 

  4. ;
    5. 

  5. 

  6. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', 
    7. 

  7. 		[{ '__name__':'key2', '__value__':8, '__timestamp__':'2024-07-27 11:25:18'}] )
    8. 

  8. ;
    9. 

  9. 

  10. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', 
    11. 

  11. 		[{ '__name__':'key5', '__value__':3.9, '__timestamp__':'2024-07-27 11:25:19'}] )
    12. 

  12. ;
    13. 

  13. 

  14. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', 
    15. 

  15. 		[{ '__name__':'key48', '__value__':100.9, '__timestamp__':'2024-07-27 11:26:19'}] )
    16. 

  16. ;
    17. 

  17. 

  18. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', 
    19. 

  19. 		[{ '__name__':'key1', '__value__':20.7, '__timestamp__':'2024-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}] )
    20. 

  20. ;
    21. 

  21. 

  22. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', 
    23. 

  23. 		[{ '__name__':'key2', '__value__':18.8, '__timestamp__':'2024-07-27 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}] )
    24. 

  24. ;
    25. 

  25. 

  26. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', 
    27. 

  27. 		[{ '__name__':'key5', '__value__':22.9, '__timestamp__':'2024-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}] )
    28. 

  28. ;
    29. 

  29. 

  30. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', 
    31. 

  31. 		[{ '__name__':'key48', '__value__':25.9, '__timestamp__':'2024-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] )
    32. 

  32. ;
    33. 

  33. 

  34. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2: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';
    35. 

  35. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__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';
    36. 

  36. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2024-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:26:00.002';
    37. 

  37. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':null, '__timestamp__':'2024-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:27:00.003';
    38. 

  38. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:28:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:28:00.004';
    39. 

  39. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2: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';
    40. 

  40. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2: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';
    41. 

  41. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2: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';
    42. 

  42. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2: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';
    43. 

  43. 

  44. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__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';
    45. 

  45. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:25:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.010';
    46. 

  46. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2: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';
    47. 

  47. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:27:00.012';
    48. 

  48. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__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';
    49. 

  49. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2: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';
    50. 

  50. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2: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';
    51. 

  51. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:31:00.016';
    52. 

  52. insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2: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';
    53. 

  53. 

  54. 

  55. insert into /test/bucketpromdb/subpromdb2 (id, prom) values (?, ? )
    56. 

  56. /**
    57. 

  57. beforerun(
    58. 

  58.     set(ct,"2024-10-28 11:24:17"),
    59. 

  59.     add(ct,mqli,second)
    60. 

  60. )
    61. 

  61. params("subpromdb2:wecise", [
    62. 

  62. 			{"name": "key1", "value": 2.6, "timestamp": "{%t,ct}"},
    63. 

  63. 			{"name": "key2", "value": 1.8, "timestamp": "{%t,ct}"},
    64. 

  64. 			{"name": "key3", "value": 2, "timestamp": "{%t,ct}"}])
    65. 

  65. **/;
    66. 

  66. 

  67. 

  68. insert into /test/bucketpromdb/subpromdb2 (id, prom) values (?, ? )
    69. 

  69. /**
    70. 

  70. params("subpromdb2:wecise", [
    71. 

  71. 		{"name": "key1", "value": 2.7, "timestamp": "2024-07-28 12:24:17"},
    72. 

  72. 		{"name": "key2", "value": 1.9, "timestamp": "2024-07-28 12:25:18"},
    73. 

  73. 		{"name": "key3", "value": 3.9, "timestamp": "2024-07-28 12:25:19"},
    74. 

  74. 		{"name": "key48", "value": 3.9, "timestamp": "2024-07-28 12:25:19"}])
    75. 

  75. **/;
    76. 

  76. 

  77. insert into /test/bucketpromdb/subpromdb2 (id, prom) values (?, ? )
    78. 

  78. /**
    79. 

  79. params("subpromdb2:wecise", [
    80. 

  80. 		{"name": "key1", "value": 2.9, "timestamp": "2024-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"},
    81. 

  81. 		{"name": "key2", "value": 2.8, "timestamp": "2024-07-29 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"},
    82. 

  82. 		{"name": "key3", "value": 2.9, "timestamp": "2024-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
    83. 

  83. 		{"name": "key48", "value": 2, "timestamp": "2024-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}])
    84. 

  84. **/;
    85. 

  85. 

  86. insert into /test/bucketpromdb/subpromdb2 (id, prom) values (?, ? )
    87. 

  87. /**
    88. 

  88. params("subpromdb2:wecise", [
    89. 

  89. 		{"__name__": "key1", "__value__": 5.2, "__timestamp__": "2024-07-30 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"},
    90. 

  90. 		{"__name__": "key2", "__value__": 4.8, "__timestamp__": "2024-07-30 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"},
    91. 

  91. 		{"__name__": "key3", "__value__": 2.9, "__timestamp__": "2024-07-30 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"},
    92. 

  92. 		{"__name__": "key48", "__value__": 2, "__timestamp__": "2024-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}])
    93. 

  93. **/;
    94. 

  94. 

  95. insert into /test/bucketpromdb/subpromdb2 (id, prom) values (?, ? ) at ?
    96. 

  96. /**
    97. 

  97. params("subpromdb2:wecise", [
    98. 

  98. 		{"__name__": "key1", "__value__": 6.0, "__timestamp__": "2024-07-31 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"},
    99. 

  99. 		{"__name__": "key2", "__value__": 3, "__timestamp__": "2024-07-31 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"},
    100. 

  100. 		{"__name__": "key3", "__value__": 2.9, "__timestamp__": "2024-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
    101. 

  101. 		{"__name__": "key48", "__value__": 2.9, "__timestamp__": "2024-07-31 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU48"}], "2024-07-31 11:24:17")
    102. 

  102. **/;
    103. 

  103. 

  104. /**
    105. 

  105. sleep(1s)
    106. 

  106. **/
    107. 

  107. ;
    108.