Halaman utama Jelajahi Bantuan
Masuk
libf
/
odbtools
1
0
Fork 0
Berkas Masalah 0 Tarik Permintaan 0 Wiki
Pohon: ec34f1ccd3
Ranting Tag
odbtools
/
odbctest
/
mql
/
basic
/
24bucket_promdb
/
1530data5.mql

1530data5.mql 8.1 KB
Riwayat Mentahan

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108 
  1. 

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

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

  4. ;
    5. 

  5. 

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

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

  8. ;
    9. 

  9. 

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

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

  12. ;
    13. 

  13. 

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

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

  16. ;
    17. 

  17. 

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

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

  20. ;
    21. 

  21. 

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

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

  24. ;
    25. 

  25. 

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

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

  28. ;
    29. 

  29. 

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

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

  32. ;
    33. 

  33. 

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

  35. insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.87, '__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/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.78, '__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/subpromdb (id, prom) values ('subpromdb: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';
    38. 

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

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

  43. 

  44. insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb: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/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.07, '__timestamp__':'2024-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.010';
    46. 

  46. insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb: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/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2, '__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/subpromdb (id, prom) values ('subpromdb: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/subpromdb (id, prom) values ('subpromdb: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/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.57, '__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/subpromdb (id, prom) values ('subpromdb: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/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.17, '__timestamp__':'2024-11-28 11:32:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:32:00.017';
    53. 

  53. 

  54. 

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

  56. /**
    57. 

  57. loop(1000)
    58. 

  58. beforerun(
    59. 

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

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

  61. )
    62. 

  62. params("subpromdb:wecise", [
    63. 

  63. 			{"name": "key1", "value": 2, "timestamp": "{%t,ct}"},
    64. 

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

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

  66. **/;
    67. 

  67. 

  68. 

  69. insert into /test/bucketpromdb/subpromdb (id, prom) values (?, ? )
    70. 

  70. /**
    71. 

  71. params("subpromdb:wecise", [
    72. 

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

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

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

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

  76. **/;
    77. 

  77. 

  78. insert into /test/bucketpromdb/subpromdb (id, prom) values (?, ? )
    79. 

  79. /**
    80. 

  80. params("subpromdb:wecise", [
    81. 

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

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

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

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

  85. **/;
    86. 

  86. 

  87. insert into /test/bucketpromdb/subpromdb (id, prom) values (?, ? )
    88. 

  88. /**
    89. 

  89. params("subpromdb:wecise", [
    90. 

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

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

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

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

  94. **/;
    95. 

  95. 

  96. insert into /test/bucketpromdb/subpromdb (id, prom) values (?, ? ) at ?
    97. 

  97. /**
    98. 

  98. params("subpromdb:wecise", [
    99. 

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

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

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

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

  103. **/;
    104. 

  104. 

  105. /**
    106. 

  106. sleep(1s)
    107. 

  107. **/
    108. 

  108. ;
    109.