Etusivu Tutki Apua
Kirjaudu sisään
libf
/
odbtools
1
0
Fork 0
Tiedostot Ongelmat 0 Pull-pyynnöt 0 Wiki
Puu: ec34f1ccd3
Branchit Tagit
odbtools
/
odbctest
/
mql
/
basic
/
24bucket_promdb
/
1830data8.mql

1830data8.mql 7.3 KB
Historia Raaka

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778 
  1. 

  2. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', 
    3. 

  3. 		[{ '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'},
    4. 

  4. 		 { '__name__':'key2', '__value__':8.58, '__timestamp__':'2024-07-27 11:25:18', 'disk':'/opt/matrix/test', 'CPU':'CPU2'},
    5. 

  5. 		 { '__name__':'key5', '__value__':2, '__timestamp__':'2024-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'},
    6. 

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

  7. ;
    8. 

  8. 

  9. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss: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';
    10. 

  10. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:25:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.001';
    11. 

  11. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__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';
    12. 

  12. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss: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';
    13. 

  13. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__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';
    14. 

  14. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss: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';
    15. 

  15. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.117, '__timestamp__':'2024-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:30:00.006';
    16. 

  16. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2024-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:31:00.007';
    17. 

  17. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss: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';
    18. 

  18. 

  19. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss: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';
    20. 

  20. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__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';
    21. 

  21. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss: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';
    22. 

  22. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key4', '__value__':22.7, '__timestamp__':'2024-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:27:00.012';
    23. 

  23. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss: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';
    24. 

  24. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss: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';
    25. 

  25. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:30:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:30:00.015';
    26. 

  26. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss: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';
    27. 

  27. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key4', '__value__':12.7, '__timestamp__':'2024-11-28 11:32:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:32:00.017';
    28. 

  28. 

  29. 

  30. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values (?, ? )
    31. 

  31. /**
    32. 

  32. params("subpromdbss:wecise", [
    33. 

  33. 		{"name": "key1", "value": 2.6, "timestamp": "2024-07-28 11:24:17"},
    34. 

  34. 		{"name": "key2", "value": 1.8, "timestamp": "2024-07-28 11:25:18"},
    35. 

  35. 		{"name": "key3", "value": 2.9, "timestamp": "2024-07-28 11:25:19"}])
    36. 

  36. **/;
    37. 

  37. 

  38. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values (?, ? )
    39. 

  39. /**
    40. 

  40. params("subpromdbss:wecise", [
    41. 

  41. 		{"name": "key1", "value": 2, "timestamp": "2024-07-28 12:24:17"},
    42. 

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

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

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

  45. **/;
    46. 

  46. 

  47. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values (?, ? )
    48. 

  48. /**
    49. 

  49. params("subpromdbss:wecise", [
    50. 

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

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

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

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

  54. **/;
    55. 

  55. 

  56. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values (?, ? )
    57. 

  57. /**
    58. 

  58. params("subpromdbss:wecise", [
    59. 

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

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

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

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

  63. **/;
    64. 

  64. 

  65. 

  66. insert into /test/bucketpromdb2/subpromdbss (id, prom2) values (?, ? ) at ?
    67. 

  67. /**
    68. 

  68. params("subpromdbss:wecise", [
    69. 

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

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

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

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

  73. **/;
    74. 

  74. 

  75. /**
    76. 

  76. sleep(1s)
    77. 

  77. **/
    78. 

  78. ;
    79.