package bucket import ( //"fmt" //"strconv" "fmt" "testing" "time" . "git.wecise.com/wecise/odbserver/odb" "git.wecise.com/wecise/odbserver/odb/test" "git.wecise.com/wecise/util/cast" "gitee.com/wecisecode/util/logger" "github.com/stretchr/testify/assert" "github.com/stretchr/testify/require" ) type BucketPromdbTests struct { Test *testing.T g *Gutil } const PROMDB_SLOT = 5 func BucketPromdbTest(t *testing.T) { g := test.TestG() t.Run("InitG", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.InitG() }) t.Run("Class", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Class() }) time.Sleep(time.Duration(1) * time.Second) t.Run("Data", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Data() }) t.Run("DataCopy", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.DataCopy() }) t.Run("Data2", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Data2() }) t.Run("Data3", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Data3() }) t.Run("Data4", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Data4() }) t.Run("Data5", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Data5() }) t.Run("Data6", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Data6() }) t.Run("Data7", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Data7() }) t.Run("Data8", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Data8() }) t.Run("Data9", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Data9() }) t.Run("Data10", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Data10() }) t.Run("Data11", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Data11() }) t.Run("Datasync", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Data_sync() }) t.Run("Datadelay", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Data_delay() }) t.Run("Datamp", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Data_mp() }) /*t.Run("Valid", func(t *testing.T) { test := &BucketPromdbTests{Test: t, g: g} test.Valid() })*/ } func (t *BucketPromdbTests) InitG() { require.NotNil(t.Test, t.g) } func (t *BucketPromdbTests) Class() { _, _, err := t.g.Query(fmt.Sprintf(` create class if not exists /test () ; create class if not exists /test/bucketpromdb ( host varchar, prom bucket { "type" : "promdb", "ttl" : 2, "dict" : true, "version": 1, "slot" : %d } 'prom', pprom bucket { "type" : "promdb", "ttl" : 2, "dict" : true, "version": 1, "slot" : %d } 'pprom', keys(host), indexes(host) ) with key=manu, nickname='bucketpromdb' `, PROMDB_SLOT, PROMDB_SLOT)) if err != nil { logger.Errorf("%v", err) } require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(fmt.Sprintf(` create class if not exists /test () ; create class if not exists /test/bucketpromdbmp ( host varchar, ip varchar, prommp bucket { "type" : "promdb", "ttl" : 2, "dict" : true, "version": 1, "slot" : %d, "pattern": "{\"partition\":[15]}" } 'prommp', keys(host), indexes(host) ) with key=manu, nickname='bucketpromdbmp', partition=(ip) `, PROMDB_SLOT)) if err != nil { logger.Errorf("%v", err) } require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(fmt.Sprintf(` create class if not exists /test/bucketpromdbdelay ( host varchar, promdelay bucket { "type" : "promdb", "ttl" : 2, "slot" : %d, "collect": 10 } 'delay', keys(host), indexes(host) ) with key=manu, nickname='bucketpromdbdelay' `, PROMDB_SLOT)) if err != nil { logger.Errorf("%v", err) } require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(fmt.Sprintf(` create class if not exists /test/bucketpromdbsync ( host varchar, prom_sync bucket { "type" : "promdb", "syncdc": true, "ttl" : 2, "slot" : %d } 'full', keys(host), indexes(host) ) with key=manu, nickname='bucketpromdbsync' `, PROMDB_SLOT)) if err != nil { logger.Errorf("%v", err) } require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(fmt.Sprintf(` create class if not exists /test/bucketsplit ( host varchar, prom_split bucket { "type" : "promdb", "ttl" : 2, "slot" : %d } 'full', keys(host), indexes(host) ) with key=manu, nickname='bucketsplit' `, PROMDB_SLOT)) if err != nil { logger.Errorf("%v", err) } _, _, err = t.g.Query(fmt.Sprintf(` create class if not exists /test/promdb_string ( host varchar, prom_str bucket { "type" : "promdb", "ttl" : 2, "slot" : %d } 'full', keys(host), indexes(host) ) with key=manu, nickname='promdb_string' `, PROMDB_SLOT)) if err != nil { logger.Errorf("%v", err) } require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(fmt.Sprintf(` create class if not exists /test/promdb_string2 ( host varchar, prom_str2 bucket { "cache" : false, "type" : "promdb", "ttl" : 2, "slot" : %d } 'full', keys(host), indexes(host) ) with key=manu, nickname='promdb_string2' `, PROMDB_SLOT)) if err != nil { logger.Errorf("%v", err) } require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(fmt.Sprintf(` create class if not exists /test/bucketpromdb2 ( host varchar, prom2 bucket { "type" : "promdb", "single": true, "ttl" : 2, "slot" : %d } 'full', keys(host), indexes(host) ) with key=manu, nickname='bucketpromdb2' `, PROMDB_SLOT)) if err != nil { logger.Errorf("%v", err) } _, _, err = t.g.Query(fmt.Sprintf(` create class if not exists /test/bucketpromdb3 ( host varchar, prom3 bucket { "type" : "promdb", "single": true, "share" : true, "ttl" : 2, "slot" : %d } 'full', keys(host), indexes(host) ) with key=manu, nickname='bucketpromdb3' `, PROMDB_SLOT)) if err != nil { logger.Errorf("%v", err) } _, _, err = t.g.Query(fmt.Sprintf(` create class if not exists /test/bucketpromdb4 ( host varchar, prom4 bucket { "type" : "promdb", "share" : true, "ttl" : 2, "slot" : %d } 'full', keys(host), indexes(host) ) with key=manu, nickname='bucketpromdb4' `, PROMDB_SLOT)) if err != nil { logger.Errorf("%v", err) } _, _, err = t.g.Query(fmt.Sprintf(` create class if not exists /test/bucketpromdbnocache ( host varchar, prom_nocache bucket { "type" : "promdb", "cache" : false, "ttl" : 1, "slot" : %d } 'full', keys(host), indexes(host) ) with key=manu, nickname='bucketpromdbnocache' `, PROMDB_SLOT)) if err != nil { logger.Errorf("%v", err) } _, _, err = t.g.Query(` create class if not exists /test/bucketpromdb/subpromdb () with nickname ='subpromdb' ; `) if err != nil { logger.Errorf("%v", err) } _, _, err = t.g.Query(` create class if not exists /test/bucketpromdb/subpromdb2 () with nickname ='subpromdb2' ; `) if err != nil { logger.Errorf("%v", err) } _, _, err = t.g.Query(` create class if not exists /test/bucketpromdb2/subpromdbs() with nickname ='subpromdbs' ; `) if err != nil { logger.Errorf("%v", err) } _, _, err = t.g.Query(` create class if not exists /test/bucketpromdb2/subpromdbss() with nickname ='subpromdbss' ; `) if err != nil { logger.Errorf("%v", err) } _, _, err = t.g.Query(` create class if not exists /test/bucketpromdb2/subpromdbsss() with nickname ='subpromdbsss' ; `) if err != nil { logger.Errorf("%v", err) } } func (t *BucketPromdbTests) Data_mp() { var err error _, _, err = t.g.Query(` insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise11', [{ '__name__':'key1.key2.key0', '__value__':2, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise11', [{ '__name__':'key1.key2.key1', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:01', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise11', [{ '__name__':'key1.key2.key2', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:02', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:03', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:04', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise11', [{ '__name__':'key1.key2.key5', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:05', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise11', [{ '__name__':'key1.key2.key6', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:06', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise11', [{ '__name__':'key1.key2.key7', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:07', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise11', [{ '__name__':'key1.key2.key7', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:08', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise12', [{ '__name__':'key1.key2.key1', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:01', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise12', [{ '__name__':'key1.key2.key2', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:02', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise12', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:03', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise12', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:04', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise12', [{ '__name__':'key1.key2.key5', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:05', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise12', [{ '__name__':'key1.key2.key6', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:06', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise12', [{ '__name__':'key1.key2.key0', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:07', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise12', [{ '__name__':'key1.key2.key7', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:08', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbmp (id, prommp) values ('bucketpromdbmp:wecise12', [{ '__name__':'key1.key2.key7', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; `) require.Nil(t.Test, err, fmt.Sprint(err)) } func (t *BucketPromdbTests) Data_delay() { var err error _, _, err = t.g.Query(` insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise11', [{ '__name__':'key1.key2.key0', '__value__':2, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise11', [{ '__name__':'key1.key2.key1', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:01', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise11', [{ '__name__':'key1.key2.key2', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:02', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:03', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:04', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise11', [{ '__name__':'key1.key2.key5', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:05', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise11', [{ '__name__':'key1.key2.key6', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:06', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise11', [{ '__name__':'key1.key2.key7', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:07', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise11', [{ '__name__':'key1.key2.key7', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:08', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise12', [{ '__name__':'key1.key2.key1', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:01', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise12', [{ '__name__':'key1.key2.key2', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:02', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise12', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:03', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise12', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:04', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise12', [{ '__name__':'key1.key2.key5', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:05', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise12', [{ '__name__':'key1.key2.key6', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:06', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise12', [{ '__name__':'key1.key2.key0', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:07', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise12', [{ '__name__':'key1.key2.key7', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:08', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdbdelay (id, promdelay) values ('bucketpromdbdelay:wecise12', [{ '__name__':'key1.key2.key7', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; `) require.Nil(t.Test, err, fmt.Sprint(err)) } func (t *BucketPromdbTests) Data() { var err error _, _, err = t.g.Query(` insert into /test/bucketpromdb (id ) values ('bucketpromdb:wecisen1' ) `) _, _, err = t.g.Query(` insert into /test/bucketpromdb (id ) values ('bucketpromdb:wecisen2' ) `) _, _, err = t.g.Query(` insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [ { '__name__':'key1', '__value__':1, '__timestamp__':'2023-07-27 00:00:00', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key1', '__value__':1, '__timestamp__':'2023-07-27 00:01:00', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 10:00:00', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key1', '__value__':3, '__timestamp__':'2023-07-27 11:00:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-28 11:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.82, '__timestamp__':'2023-07-28 11:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-28 11:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-28 11:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-29 11:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.83, '__timestamp__':'2023-07-29 11:25:18', 'disk':'/opt/matrix10', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-29 11:25:19', 'disk':'/opt/matrix11', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-29 11:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-30 11:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.84, '__timestamp__':'2023-07-30 11:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-30 11:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-30 11:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-30 23:59:59', 'disk':'/opt/matrix13', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [ { '__name__':'key1', '__value__':1, '__timestamp__':'2023-09-27 00:00:00', 'tags':'mytag1,mytag2', 'CPU':'CPU1'}, { '__name__':'key1', '__value__':1, '__timestamp__':'2023-09-27 00:01:00', 'tags':'mytag2,mytag3', 'CPU':'CPU1'}, { '__name__':'key1', '__value__':2, '__timestamp__':'2023-09-27 10:00:00', 'tags':'mytag3,mytag4', 'CPU':'CPU3'}, { '__name__':'key1', '__value__':3, '__timestamp__':'2023-09-27 11:00:17', 'tags':'mytag4', 'CPU':'CPU1'}, { '__name__':'key1', '__value__':2, '__timestamp__':'2023-09-27 11:24:17', 'tags':'mytag5', 'CPU':'CPU2'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:25:01.555', 'disk':'/opt/matrix/test1', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:02', 'disk':'/opt/matrix/test2', 'CPU':'CPU2'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00.666', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:06', 'disk':'/opt/matrix/test1', 'CPU':'CPU3'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU4'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix/hello', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:10', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:50.999', 'disk':'/opt/matrix/test', 'CPU':'CPU2'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:20', 'disk':'/opt/matrix/test', 'CPU':'CPU3'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:40', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:30.034', 'disk':'/opt/matrix', 'CPU':'CPU2'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:21', 'disk':'/opt/matrix', 'CPU':'CPU3'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:15', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:59', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 23:59:59.017'; `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-28 11:24:17', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.82, '__timestamp__':'2023-07-28 11:25:18', 'disk':'/opt/matrix/test', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-28 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-28 11:26:19', 'disk':'/opt/matrix/test', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-29 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.83, '__timestamp__':'2023-07-29 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-29 11:25:19', 'disk':'/opt/matrix/test', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-29 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-30 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.84, '__timestamp__':'2023-07-30 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-30 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-30 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU2'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU3'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU4'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU2'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU3'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix/test', 'CPU':'CPU3'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU5'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix/test', 'CPU':'CPU4'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdb (id, prom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; `) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr := t.g.Prepare(`insert into /test/bucketpromdb (id, prom) values (?, ? )`) require.Nil(t.Test, errr) for i := 0; i < 6000; i++ { ct, _ := cast.ToDatetimeE("2023-10-28 06:54:17") ct = ct.Add(time.Duration(i) * time.Second) key1 := fmt.Sprintf("key%d", i) key2 := fmt.Sprintf("key_%d", i) key3 := fmt.Sprintf("key_3_%d", i) keys1 := fmt.Sprintf("keys%d", i) keys2 := fmt.Sprintf("keys2_%d", i) key48 := fmt.Sprintf("key48_%d", i) _, _, err = stat.Exec("bucketpromdb:wecise", []map[string]interface{}{ {"name": key1, "value": 2, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": key2, "value": 1.8, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": key3, "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": keys1, "value": "sss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": keys2, "value": "这是中文长字符串sssss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": key48, "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}}) require.Nil(t.Test, err, fmt.Sprint(err)) } for i := 0; i < 1000; i++ { ct, _ := cast.ToDatetimeE("2023-10-28 15:24:17") ct = ct.Add(time.Duration(i) * time.Second) _, _, err = stat.Exec("bucketpromdb:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.7, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key2", "value": 1.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key3", "value": 3.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "keys1", "value": "ssss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "keys2", "value": "ss这是中文长字符串sssss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key48", "value": 3.9, "timestamp": ct.Format("2006-01-02 15:04:05")}}) require.Nil(t.Test, err, fmt.Sprint(err)) } _, _, err = stat.Exec("bucketpromdb:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.9, "timestamp": "2023-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"name": "key2", "value": 2, "timestamp": "2023-07-29 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"name": "key3", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"name": "keys1", "value": "sss", "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"name": "keys2", "value": "这是中文长字符串sssss", "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"name": "key48", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("bucketpromdb:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 5.2, "__timestamp__": "2023-07-30 11:24:17", "disk": "/opt/matrix/test", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 4.8, "__timestamp__": "2023-07-30 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "keys1", "__value__": "sss", "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "keys2", "__value__": "这是中文长字符串sssss", "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr = t.g.Prepare(`insert into /test/bucketpromdb (id, prom) values (?, ? ) at ?`) require.Nil(t.Test, errr) _, _, err = stat.Exec("bucketpromdb:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 6.0, "__timestamp__": "2023-07-31 11:24:17", "disk": "/opt/matrix/test", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 3, "__timestamp__": "2023-07-31 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"__name__": "keys1", "__value__": "sss", "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "keys2", "__value__": "这是中文长字符串sssss", "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}, "2023-07-31 11:24:17") require.Nil(t.Test, errr) } func (t *BucketPromdbTests) DataCopy() { var err error _, _, err = t.g.Query(` insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [ { '__name__':'key1', '__value__':1, '__timestamp__':'2023-07-27 00:00:00', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key1', '__value__':1, '__timestamp__':'2023-07-27 00:01:00', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 10:00:00', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key1', '__value__':3, '__timestamp__':'2023-07-27 11:00:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-28 11:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.82, '__timestamp__':'2023-07-28 11:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-28 11:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-28 11:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-29 11:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.83, '__timestamp__':'2023-07-29 11:25:18', 'disk':'/opt/matrix10', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-29 11:25:19', 'disk':'/opt/matrix11', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-29 11:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-30 11:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.84, '__timestamp__':'2023-07-30 11:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-30 11:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-30 11:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-30 23:59:59', 'disk':'/opt/matrix13', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:25:01.555', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:02', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00.666', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:06', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:10', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:50.999', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:20', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:40', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:30.034', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:21', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:15', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:59', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 23:59:59.017'; `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-28 11:24:17', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.82, '__timestamp__':'2023-07-28 11:25:18', 'disk':'/opt/matrix/test', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-28 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-28 11:26:19', 'disk':'/opt/matrix/test', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-29 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.83, '__timestamp__':'2023-07-29 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-29 11:25:19', 'disk':'/opt/matrix/test', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-29 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-30 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.84, '__timestamp__':'2023-07-30 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-30 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-30 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdb (id, pprom) values ('bucketpromdb:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; `) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr := t.g.Prepare(`insert into /test/bucketpromdb (id, pprom) values (?, ? )`) require.Nil(t.Test, errr) for i := 0; i < 6000; i++ { ct, _ := cast.ToDatetimeE("2023-10-28 06:54:17") ct = ct.Add(time.Duration(i) * time.Second) key1 := fmt.Sprintf("key%d", i) key2 := fmt.Sprintf("key_%d", i) key3 := fmt.Sprintf("key_3_%d", i) keys1 := fmt.Sprintf("keys%d", i) keys2 := fmt.Sprintf("keys2_%d", i) key48 := fmt.Sprintf("key48_%d", i) _, _, err = stat.Exec("bucketpromdb:wecise", []map[string]interface{}{ {"name": key1, "value": 2, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": key2, "value": 1.8, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": key3, "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": keys1, "value": "sss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": keys2, "value": "这是中文长字符串sssss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": key48, "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}}) require.Nil(t.Test, err, fmt.Sprint(err)) } for i := 0; i < 1000; i++ { ct, _ := cast.ToDatetimeE("2023-10-28 15:24:17") ct = ct.Add(time.Duration(i) * time.Second) _, _, err = stat.Exec("bucketpromdb:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.7, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key2", "value": 1.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key3", "value": 3.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "keys1", "value": "ssss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "keys2", "value": "ss这是中文长字符串sssss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key48", "value": 3.9, "timestamp": ct.Format("2006-01-02 15:04:05")}}) require.Nil(t.Test, err, fmt.Sprint(err)) } _, _, err = stat.Exec("bucketpromdb:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.9, "timestamp": "2023-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"name": "key2", "value": 2, "timestamp": "2023-07-29 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"name": "key3", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"name": "keys1", "value": "sss", "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"name": "keys2", "value": "这是中文长字符串sssss", "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"name": "key48", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("bucketpromdb:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 5.2, "__timestamp__": "2023-07-30 11:24:17", "disk": "/opt/matrix/test", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 4.8, "__timestamp__": "2023-07-30 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "keys1", "__value__": "sss", "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "keys2", "__value__": "这是中文长字符串sssss", "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr = t.g.Prepare(`insert into /test/bucketpromdb (id, pprom) values (?, ? ) at ?`) require.Nil(t.Test, errr) _, _, err = stat.Exec("bucketpromdb:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 6.0, "__timestamp__": "2023-07-31 11:24:17", "disk": "/opt/matrix/test", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 3, "__timestamp__": "2023-07-31 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"__name__": "keys1", "__value__": "sss", "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "keys2", "__value__": "这是中文长字符串sssss", "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}, "2023-07-31 11:24:17") require.Nil(t.Test, errr) } func (t *BucketPromdbTests) Data_sync() { var err error _, _, err = t.g.Query(` insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix/test', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-28 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.82, '__timestamp__':'2023-07-28 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-28 11:25:19', 'disk':'/opt/matrix/test', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-28 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-29 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.83, '__timestamp__':'2023-07-29 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-29 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-29 11:26:19', 'disk':'/opt/matrix/test', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-30 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.84, '__timestamp__':'2023-07-30 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-30 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-30 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-28 11:24:17', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.82, '__timestamp__':'2023-07-28 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-28 11:25:19', 'disk':'/opt/matrix/test', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-28 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-29 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.83, '__timestamp__':'2023-07-29 11:25:18', 'disk':'/opt/matrix/test', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-29 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-29 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-30 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.84, '__timestamp__':'2023-07-30 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-30 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-30 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdbsync (id, prom_sync) values ('bucketpromdbsync:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; `) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr := t.g.Prepare(`insert into /test/bucketpromdbsync (id, prom_sync) values (?, ? )`) require.Nil(t.Test, errr) for i := 0; i < 2000; i++ { ct, _ := cast.ToDatetimeE("2023-07-28 11:24:17") ct = ct.Add(time.Duration(i) * time.Second) key1 := fmt.Sprintf("key%d", i) key2 := fmt.Sprintf("key_%d", i) key3 := fmt.Sprintf("key_3_%d", i) keys1 := fmt.Sprintf("keys%d", i) keys2 := fmt.Sprintf("keys2_%d", i) key48 := fmt.Sprintf("key48_%d", i) _, _, err = stat.Exec("bucketpromdbsync:wecise", []map[string]interface{}{ {"name": key1, "value": 2, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": key2, "value": 1.8, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": key3, "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": keys1, "value": "sss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": keys2, "value": "这是中文长字符串sssss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": key48, "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}}) require.Nil(t.Test, err, fmt.Sprint(err)) } _, _, err = stat.Exec("bucketpromdbsync:wecise", []map[string]interface{}{ {"name": "key1", "value": 2, "timestamp": "2023-07-28 12:24:17"}, {"name": "key2", "value": 1.9, "timestamp": "2023-07-28 12:25:18"}, {"name": "key3", "value": 3.9, "timestamp": "2023-07-28 12:25:19"}, {"name": "keys1", "value": "ssss", "timestamp": "2023-07-28 12:25:19"}, {"name": "keys2", "value": "ss这是中文长字符串sssss", "timestamp": "2023-07-28 12:25:19"}, {"name": "key48", "value": 3.9, "timestamp": "2023-07-28 12:25:19"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("bucketpromdbsync:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.9, "timestamp": "2023-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"name": "key2", "value": 2, "timestamp": "2023-07-29 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"name": "key3", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"name": "keys1", "value": "sss", "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"name": "keys2", "value": "这是中文长字符串sssss", "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"name": "key48", "value": 4, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("bucketpromdbsync:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 5.2, "__timestamp__": "2023-07-30 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 4.8, "__timestamp__": "2023-07-30 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"__name__": "keys1", "__value__": "sss", "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "keys2", "__value__": "这是中文长字符串sssss", "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr = t.g.Prepare(`insert into /test/bucketpromdbsync (id, prom_sync) values (?, ? ) at ?`) require.Nil(t.Test, errr) _, _, err = stat.Exec("bucketpromdbsync:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 6.0, "__timestamp__": "2023-07-31 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 3.8, "__timestamp__": "2023-07-31 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"__name__": "keys1", "__value__": "sss", "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "keys2", "__value__": "这是中文长字符串sssss", "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU48"}}, "2023-07-31 11:24:17") require.Nil(t.Test, errr) } func (t *BucketPromdbTests) Data2() { var err error _, _, err = t.g.Query(` insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':18.8, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix/test', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':12.7, '__timestamp__':'2023-07-28 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':18.8, '__timestamp__':'2023-07-28 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':12.9, '__timestamp__':'2023-07-28 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':12.9, '__timestamp__':'2023-07-28 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-29 11:24:17', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.86, '__timestamp__':'2023-07-29 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-29 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-29 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':22.7, '__timestamp__':'2023-07-30 11:24:17', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':28.8, '__timestamp__':'2023-07-30 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':22.9, '__timestamp__':'2023-07-30 11:25:19', 'disk':'/opt/matrix/test', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':22.9, '__timestamp__':'2023-07-30 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.8, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.8, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':null, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.6, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.6, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.6, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.6, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':null, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':3.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':3.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':4.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; `) _, _, err = t.g.Query(` insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-12-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ); insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.8, '__timestamp__':'2023-12-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.8, '__timestamp__':'2023-12-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':null, '__timestamp__':'2023-12-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.6, '__timestamp__':'2023-12-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-12-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.6, '__timestamp__':'2023-12-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-12-28 11:31:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.6, '__timestamp__':'2023-12-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-12-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.6, '__timestamp__':'2023-12-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':null, '__timestamp__':'2023-12-28 11:26:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':3.7, '__timestamp__':'2023-12-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-12-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':3.7, '__timestamp__':'2023-12-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-12-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':4.7, '__timestamp__':'2023-12-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; insert into /test/bucketpromdb2 (id, prom2) values ('bucketpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-12-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) ; `) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr := t.g.Prepare(`insert into /test/bucketpromdb2 (id, prom2) values (?, ? )`) require.Nil(t.Test, errr) _, _, err = stat.Exec("bucketpromdb2:wecise", []map[string]interface{}{ {"name": "key1", "value": 2, "timestamp": "2023-07-28 11:24:17"}, {"name": "key2", "value": 1.8, "timestamp": "2023-07-28 11:25:18"}, {"name": "key3", "value": 2.9, "timestamp": "2023-07-28 11:25:19"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("bucketpromdb2:wecise", []map[string]interface{}{ {"name": "key1", "value": 2, "timestamp": "2023-07-28 12:24:17"}, {"name": "key2", "value": 1.9, "timestamp": "2023-07-28 12:25:18"}, {"name": "key3", "value": 3.9, "timestamp": "2023-07-28 12:25:19"}, {"name": "key48", "value": 3.9, "timestamp": "2023-07-28 12:25:19"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("bucketpromdb2:wecise", []map[string]interface{}{ {"name": "key1", "value": 2, "timestamp": "2023-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"name": "key2", "value": 2.8, "timestamp": "2023-07-29 11:25:18", "disk": "/opt/matrix/test", "CPU": "CPU2"}, {"name": "key3", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"name": "key48", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("bucketpromdb2:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 5.2, "__timestamp__": "2023-07-30 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 4, "__timestamp__": "2023-07-30 11:25:18", "disk": "/opt/matrix/test", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr = t.g.Prepare(`insert into /test/bucketpromdb3 (id, prom3) values (?, ? ) at ?`) require.Nil(t.Test, errr) _, _, err = stat.Exec("bucketpromdb2:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 6.0, "__timestamp__": "2023-07-31 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 3.8, "__timestamp__": "2023-07-31 11:25:18", "disk": "/opt/matrix/test", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 5, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}, "2023-07-31 11:24:17") require.Nil(t.Test, errr) } func (t *BucketPromdbTests) Data3() { var err error _, _, err = t.g.Query(` insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.08, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix/test', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key3', '__value__':12.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key3', '__value__':12.7, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key3', '__value__':null, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.27, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.37, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.57, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key4', '__value__':null, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key4', '__value__':22.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key4', '__value__':12.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdb3 (id, prom3) values ('bucketpromdb3:wecise', [{ '__name__':'key1.key2.key4', '__value__':23.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; `) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr := t.g.Prepare(`insert into /test/bucketpromdb3 (id, prom3) values (?, ? )`) require.Nil(t.Test, errr) _, _, err = stat.Exec("bucketpromdb3:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.6, "timestamp": "2023-07-28 11:24:17"}, {"name": "key2", "value": 1, "timestamp": "2023-07-28 11:25:18"}, {"name": "key3", "value": 2.9, "timestamp": "2023-07-28 11:25:19"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("bucketpromdb3:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.7, "timestamp": "2023-07-28 12:24:17"}, {"name": "key2", "value": 1.9, "timestamp": "2023-07-28 12:25:18"}, {"name": "key3", "value": 3, "timestamp": "2023-07-28 12:25:19"}, {"name": "key48", "value": 3.9, "timestamp": "2023-07-28 12:25:19"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("bucketpromdb3:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.9, "timestamp": "2023-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"name": "key2", "value": 2.8, "timestamp": "2023-07-29 11:25:18", "disk": "/opt/matrix/test", "CPU": "CPU2"}, {"name": "key3", "value": 2, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"name": "key48", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("bucketpromdb3:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 5.2, "__timestamp__": "2023-07-30 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 4.8, "__timestamp__": "2023-07-30 11:25:18", "disk": "/opt/matrix/test", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr = t.g.Prepare(`insert into /test/bucketpromdb3 (id, prom3) values (?, ? ) at ?`) require.Nil(t.Test, errr) _, _, err = stat.Exec("bucketpromdb3:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 6.0, "__timestamp__": "2023-07-31 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 3.8, "__timestamp__": "2023-07-31 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}, "2023-07-31 11:24:17") require.Nil(t.Test, errr) } func (t *BucketPromdbTests) Data4() { var err error _, _, err = t.g.Query(` insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.18, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix/test', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.75, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.72, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':null, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.76, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.17, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':null, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.27, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.57, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdb4 (id, prom4) values ('bucketpromdb4:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; `) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr := t.g.Prepare(`insert into /test/bucketpromdb4 (id, prom4) values (?, ? )`) require.Nil(t.Test, errr) _, _, err = stat.Exec("bucketpromdb4:wecise", []map[string]interface{}{ {"name": "key1", "value": 2, "timestamp": "2023-07-28 11:24:17"}, {"name": "key2", "value": 1.8, "timestamp": "2023-07-28 11:25:18"}, {"name": "key3", "value": 2.9, "timestamp": "2023-07-28 11:25:19"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("bucketpromdb4:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.7, "timestamp": "2023-07-28 12:24:17"}, {"name": "key2", "value": 1.9, "timestamp": "2023-07-28 12:25:18"}, {"name": "key3", "value": 3.9, "timestamp": "2023-07-28 12:25:19"}, {"name": "key48", "value": 3.9, "timestamp": "2023-07-28 12:25:19"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("bucketpromdb4:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.9, "timestamp": "2023-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"name": "key2", "value": 2.8, "timestamp": "2023-07-29 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"name": "key3", "value": 2, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"name": "key48", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("bucketpromdb4:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 5.2, "__timestamp__": "2023-07-30 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 4.8, "__timestamp__": "2023-07-30 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr = t.g.Prepare(`insert into /test/bucketpromdb4 (id, prom3) values (?, ? ) at ?`) require.Nil(t.Test, errr) _, _, err = stat.Exec("bucketpromdb4:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 6.0, "__timestamp__": "2023-07-31 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 3, "__timestamp__": "2023-07-31 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}, "2023-07-31 11:24:17") require.Nil(t.Test, errr) } func (t *BucketPromdbTests) Data5() { var err error _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 11:24:17'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key2', '__value__':8.28, '__timestamp__':'2023-07-27 11:25:18'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 11:25:19'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key2', '__value__':8.38, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.87, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.78, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':null, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':12.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.07, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':null, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.57, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdb/subpromdb (id, prom) values ('subpromdb:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.17, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; `) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr := t.g.Prepare(`insert into /test/bucketpromdb/subpromdb (id, prom) values (?, ? )`) require.Nil(t.Test, errr) for i := 0; i < 1000; i++ { ct, _ := cast.ToDatetimeE("2023-10-28 11:24:17") ct = ct.Add(time.Duration(i) * time.Second) _, _, err = stat.Exec("subpromdb:wecise", []map[string]interface{}{ {"name": "key1", "value": 2, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key2", "value": 1.8, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key3", "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}}) require.Nil(t.Test, err, fmt.Sprint(err)) } _, _, err = stat.Exec("subpromdb:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.7, "timestamp": "2023-07-28 12:24:17"}, {"name": "key2", "value": 1.9, "timestamp": "2023-07-28 12:25:18"}, {"name": "key3", "value": 3, "timestamp": "2023-07-28 12:25:19"}, {"name": "key48", "value": 3.9, "timestamp": "2023-07-28 12:25:19"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("subpromdb:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.9, "timestamp": "2023-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"name": "key2", "value": 2.8, "timestamp": "2023-07-29 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"name": "key3", "value": 2, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"name": "key48", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("subpromdb:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 5.2, "__timestamp__": "2023-07-30 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 4.8, "__timestamp__": "2023-07-30 11:25:18", "disk": "/opt/matrix/test", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr = t.g.Prepare(`insert into /test/bucketpromdb/subpromdb (id, prom3) values (?, ? ) at ?`) require.Nil(t.Test, errr) _, _, err = stat.Exec("subpromdb:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 6.0, "__timestamp__": "2023-07-31 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 3.8, "__timestamp__": "2023-07-31 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}, "2023-07-31 11:24:17") require.Nil(t.Test, errr) } func (t *BucketPromdbTests) Data6() { var err error _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1', '__value__':2.6, '__timestamp__':'2023-07-27 11:24:17'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key2', '__value__':8, '__timestamp__':'2023-07-27 11:25:18'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key5', '__value__':3.9, '__timestamp__':'2023-07-27 11:25:19'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key48', '__value__':100.9, '__timestamp__':'2023-07-27 11:26:19'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1', '__value__':20.7, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key2', '__value__':18.8, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key5', '__value__':22.9, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key48', '__value__':25.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':null, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':null, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdb/subpromdb2 (id, prom) values ('subpromdb2:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; `) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr := t.g.Prepare(`insert into /test/bucketpromdb/subpromdb2 (id, prom) values (?, ? )`) require.Nil(t.Test, errr) for i := 0; i < 1000; i++ { ct, _ := cast.ToDatetimeE("2023-10-28 11:24:17") ct = ct.Add(time.Duration(i) * time.Second) _, _, err = stat.Exec("subpromdb2:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.6, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key2", "value": 1.8, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key3", "value": 2, "timestamp": ct.Format("2006-01-02 15:04:05")}}) require.Nil(t.Test, err, fmt.Sprint(err)) } _, _, err = stat.Exec("subpromdb2:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.7, "timestamp": "2023-07-28 12:24:17"}, {"name": "key2", "value": 1.9, "timestamp": "2023-07-28 12:25:18"}, {"name": "key3", "value": 3.9, "timestamp": "2023-07-28 12:25:19"}, {"name": "key48", "value": 3.9, "timestamp": "2023-07-28 12:25:19"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("subpromdb2:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.9, "timestamp": "2023-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"name": "key2", "value": 2.8, "timestamp": "2023-07-29 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"name": "key3", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"name": "key48", "value": 2, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("subpromdb2:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 5.2, "__timestamp__": "2023-07-30 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 4.8, "__timestamp__": "2023-07-30 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr = t.g.Prepare(`insert into /test/bucketpromdb/subpromdb2 (id, prom3) values (?, ? ) at ?`) require.Nil(t.Test, errr) _, _, err = stat.Exec("subpromdb2:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 6.0, "__timestamp__": "2023-07-31 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 3, "__timestamp__": "2023-07-31 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU48"}}, "2023-07-31 11:24:17") require.Nil(t.Test, errr) } func (t *BucketPromdbTests) Data7() { var err error _, _, err = t.g.Query(` insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.48, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix/test', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.47, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key3', '__value__':null, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.37, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.78, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.27, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key4', '__value__':null, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key4', '__value__':2, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.17, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdb2/subpromdbs (id, prom2) values ('subpromdbs:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; `) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr := t.g.Prepare(`insert into /test/bucketpromdb2/subpromdbs (id, prom2) values (?, ? )`) require.Nil(t.Test, errr) _, _, err = stat.Exec("subpromdbs:wecise", []map[string]interface{}{ {"name": "key1", "value": 2, "timestamp": "2023-07-28 11:24:17"}, {"name": "key2", "value": 1.8, "timestamp": "2023-07-28 11:25:18"}, {"name": "key3", "value": 2.9, "timestamp": "2023-07-28 11:25:19"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("subpromdbs:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.7, "timestamp": "2023-07-28 12:24:17"}, {"name": "key2", "value": 1.9, "timestamp": "2023-07-28 12:25:18"}, {"name": "key3", "value": 3.9, "timestamp": "2023-07-28 12:25:19"}, {"name": "key48", "value": 3.9, "timestamp": "2023-07-28 12:25:19"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("subpromdbs:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.9, "timestamp": "2023-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"name": "key2", "value": 2.8, "timestamp": "2023-07-29 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"name": "key3", "value": 2, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"name": "key48", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("subpromdbs:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 5.2, "__timestamp__": "2023-07-30 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 4.8, "__timestamp__": "2023-07-30 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr = t.g.Prepare(`insert into /test/bucketpromdb3 (id, prom3) values (?, ? ) at ?`) require.Nil(t.Test, errr) _, _, err = stat.Exec("subpromdbs:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 6.0, "__timestamp__": "2023-07-31 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 3, "__timestamp__": "2023-07-31 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}, "2023-07-31 11:24:17") require.Nil(t.Test, errr) } func (t *BucketPromdbTests) Data8() { var err error _, _, err = t.g.Query(` insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.58, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix/test', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key3', '__value__':null, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.117, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key4', '__value__':null, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key4', '__value__':22.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdb2/subpromdbss (id, prom2) values ('subpromdbss:wecise', [{ '__name__':'key1.key2.key4', '__value__':12.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; `) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr := t.g.Prepare(`insert into /test/bucketpromdb2/subpromdbss (id, prom2) values (?, ? )`) require.Nil(t.Test, errr) _, _, err = stat.Exec("subpromdbss:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.6, "timestamp": "2023-07-28 11:24:17"}, {"name": "key2", "value": 1.8, "timestamp": "2023-07-28 11:25:18"}, {"name": "key3", "value": 2.9, "timestamp": "2023-07-28 11:25:19"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("subpromdbss:wecise", []map[string]interface{}{ {"name": "key1", "value": 2, "timestamp": "2023-07-28 12:24:17"}, {"name": "key2", "value": 1.9, "timestamp": "2023-07-28 12:25:18"}, {"name": "key3", "value": 3.9, "timestamp": "2023-07-28 12:25:19"}, {"name": "key48", "value": 3.9, "timestamp": "2023-07-28 12:25:19"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("subpromdbss:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.9, "timestamp": "2023-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"name": "key2", "value": 2.8, "timestamp": "2023-07-29 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"name": "key3", "value": 2, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"name": "key48", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("subpromdbss:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 5.2, "__timestamp__": "2023-07-30 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 4.8, "__timestamp__": "2023-07-30 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr = t.g.Prepare(`insert into /test/bucketpromdb3 (id, prom3) values (?, ? ) at ?`) require.Nil(t.Test, errr) _, _, err = stat.Exec("subpromdbss:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 6.0, "__timestamp__": "2023-07-31 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 3, "__timestamp__": "2023-07-31 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}, "2023-07-31 11:24:17") require.Nil(t.Test, errr) } func (t *BucketPromdbTests) Data9() { var err error stat, _ := t.g.Prepare(`insert into /test/bucketsplit (id, prom_split) values (?, ? )`) for i := 0; i < 24*60; i++ { ct, _ := cast.ToDatetimeE("2023-07-20 00:00:00") ct = ct.Add(time.Duration(i*60) * time.Second) _, _, err = stat.Exec("bucketsplit:wecise", []map[string]interface{}{ {"name": "key1", "value": 2, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key2", "value": 1.8, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key3", "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key4", "value": 2, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key5", "value": 1.8, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key6", "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key7", "value": 2, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key8", "value": 1.8, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key9", "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key1", "disk": "/opt/matrix1", "CPU": "CPU1", "value": 2, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key2", "disk": "/opt/matrix1", "CPU": "CPU1", "value": 1.8, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key3", "disk": "/opt/matrix1", "CPU": "CPU2", "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key4", "disk": "/opt/matrix1", "CPU": "CPU2", "value": 2, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key5", "disk": "/opt/matrix1", "CPU": "CPU3", "value": 1.8, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key6", "disk": "/opt/matrix1", "CPU": "CPU3", "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key7", "disk": "/opt/matrix1", "CPU": "CPU4", "value": 2, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key8", "disk": "/opt/matrix1", "CPU": "CPU4", "value": 1.8, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key9", "disk": "/opt/matrix1", "CPU": "CPU4", "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}}) } require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketsplit (id, prom_split) values ('bucketsplit:wecise', [{ '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-25 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':'2023-07-25 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-25 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-25 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':200, '__timestamp__':'2023-07-25 11:34:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':80.81, '__timestamp__':'2023-07-25 11:35:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':20.9, '__timestamp__':'2023-07-25 11:35:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':20.9, '__timestamp__':'2023-07-25 11:36:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':20, '__timestamp__':'2023-07-26 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':800.81, '__timestamp__':'2023-07-26 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':20.9, '__timestamp__':'2023-07-26 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':200.9, '__timestamp__':'2023-07-26 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':20, '__timestamp__':'2023-07-26 11:34:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':800.81, '__timestamp__':'2023-07-26 11:35:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':20.9, '__timestamp__':'2023-07-26 11:35:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':20.9, '__timestamp__':'2023-07-26 11:36:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':20, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':800.81, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':20.9, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':200.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 11:34:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':'2023-07-27 11:35:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 11:35:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:36:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-28 11:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.82, '__timestamp__':'2023-07-28 11:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-28 11:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-28 11:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-29 11:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.83, '__timestamp__':'2023-07-29 11:25:18', 'disk':'/opt/matrix10', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-29 11:25:19', 'disk':'/opt/matrix11', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-29 11:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-30 11:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.84, '__timestamp__':'2023-07-30 11:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-30 11:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-30 11:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-25 09:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':'2023-07-25 09:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-25 09:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-25 09:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-26 09:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':'2023-07-26 09:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-26 09:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-26 09:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 09:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':'2023-07-27 09:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 09:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 09:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-28 09:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.82, '__timestamp__':'2023-07-28 09:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-28 09:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-28 09:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-29 09:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.83, '__timestamp__':'2023-07-29 09:25:18', 'disk':'/opt/matrix10', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-29 09:25:19', 'disk':'/opt/matrix11', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-29 09:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-30 09:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.84, '__timestamp__':'2023-07-30 09:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-30 09:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-30 09:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) // 2023-07-31 _, _, err = t.g.Query(` insert into /test/bucketsplit (id, prom_split) values ('bucketsplit:wecise', [{ '__name__':'key1', '__value__':2, '__timestamp__':1627702037000.12345, 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':1627702098000.23333, 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':1627702099000.23456, 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':1627702159000.75678, 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2, '__timestamp__':1627701977000.34567, 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':1627702038000.6789, 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':1627702039000.21345, 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':1627702099000.34567, 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2, '__timestamp__':1627701917000.34556, 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':1627701978000.234, 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':1627701979000.234, 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':1627702039000.1, 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':20, '__timestamp__':1627701857000.23423, 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':88.1, '__timestamp__':1627701918000.78, 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':29, '__timestamp__':1627701919000.63, 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':29, '__timestamp__':1627701979000.123, 'disk':'/opt/matrix4', 'CPU':'CPU48'} ] )`) require.Nil(t.Test, err, fmt.Sprint(err)) } func (t *BucketPromdbTests) Data10() { var err error _, _, err = t.g.Query(` insert into /test/promdb_string (id, prom_str) values ('promdb_string:wecise', [{ '__name__':'key1', '__value__':'这是string测试 hello world', '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':'这是string测试 queries: info: client 192.168.174.115#43747', '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':'这是string测试 queries: info: client 192.168.174.115#36176 (rx.thegov.win): query: rx.thegov.win IN A + (192.168.174.124)', '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':'这是string测试', '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':'这是string测试 error', '__timestamp__':'2023-07-28 11:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':'这是string测试 error', '__timestamp__':'2023-07-28 11:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':'这是string测试 host tiger', '__timestamp__':'2023-07-28 11:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':'这是string测试 homeway', '__timestamp__':'2023-07-28 11:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':'这是string测试 error', '__timestamp__':'2023-07-29 11:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':'这是string测试', '__timestamp__':'2023-07-29 11:25:18', 'disk':'/opt/matrix10', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':'这是string测试', '__timestamp__':'2023-07-29 11:25:19', 'disk':'/opt/matrix11', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':'这是string测试 resolver: debug 1: createfetch: deb.thegov.win A', '__timestamp__':'2023-07-29 11:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':"这是string测试 error (network unreachable) resolving './NS/IN': 2001:500:84::b#53", '__timestamp__':'2023-07-30 11:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':'这是string测试', '__timestamp__':'2023-07-30 11:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':'这是string测试', '__timestamp__':'2023-07-30 11:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':'这是string测试', '__timestamp__':'2023-07-30 11:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) // 2023-07-31 _, _, err = t.g.Query(` insert into /test/promdb_string (id, prom_str) values ('promdb_string:wecise', [{ '__name__':'key1', '__value__':'这是string测试 queries: info: client 192.168.174.115#43747', '__timestamp__':1627702037000.123451111, 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':'这是string测试', '__timestamp__':1627702098000.23333, 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':'这是string测试 resolver: debug 1: createfetch: deb.thegov.win A', '__timestamp__':1627702099000.234561111, 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':'这是string测试 queries: info: client 192.168.174.115#36176 (rx.thegov.win): query: rx.thegov.win IN A + (192.168.174.124)', '__timestamp__':1627702159000.756781111, 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':'这是string测试', '__timestamp__':1627701977000.34567111, 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':"这是string测试 error (network unreachable) resolving './NS/IN': 2001:500:84::b#53", '__timestamp__':1627702038000.678911111, 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':'这是string测试', '__timestamp__':1690774039000.2134511111, 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':'这是string测试', '__timestamp__':1627702099000.345671111, 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':'这是string测试', '__timestamp__':1627701917000.345561111, 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':'这是string测试', '__timestamp__':1627701978000.2341111, 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':'这是string测试', '__timestamp__':1627701979000.2341111, 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':'这是string测试', '__timestamp__':1627702039000.111111, 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':'这是string测试', '__timestamp__':1627701857000.234231111, 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':'这是string测试', '__timestamp__':1627701918000.78111111, 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':'这是string测试', '__timestamp__':1627701919000.63111111, 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':'这是string测试', '__timestamp__':1627701979000.123111111, 'disk':'/opt/matrix4', 'CPU':'CPU48'} ] )`) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr := t.g.Prepare(`insert into /test/promdb_string (id, prom_str) values (?, ?)`) require.Nil(t.Test, errr) ct := time.Now() _, _, err = stat.Exec("promdb_string:wecise", []map[string]interface{}{ {"name": "pkey1", "value": 2, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "pkey2", "value": 1.8, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "pkey3", "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "pkeys1", "value": "sss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "pkeys2", "value": "这是中文长字符串sssss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "pkey48", "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}}) require.Nil(t.Test, err, fmt.Sprint(err)) // nocache _, _, err = t.g.Query(` insert into /test/promdb_string2 (id, prom_str2) values ('promdb_string2:wecise', [{ '__name__':'key1', '__value__':'这是string测试 hello world', '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}])`) require.Nil(t.Test, err, fmt.Sprint(err)) // nocache _, _, err = t.g.Query(` insert into /test/promdb_string2 (id, prom_str2) values ('promdb_string2:wecise', [{ '__name__':'key1', '__value__':'这是string测试 hello world', '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':'这是string测试 queries: info: client 192.168.174.115#43747', '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':'这是string测试 queries: info: client 192.168.174.115#36176 (rx.thegov.win): query: rx.thegov.win IN A + (192.168.174.124)', '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':'这是string测试', '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':'这是string测试 error', '__timestamp__':'2023-07-28 11:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':'这是string测试 error', '__timestamp__':'2023-07-28 11:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':'这是string测试 host tiger', '__timestamp__':'2023-07-28 11:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':'这是string测试 homeway', '__timestamp__':'2023-07-28 11:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':'这是string测试 error', '__timestamp__':'2023-07-29 11:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':'这是string测试', '__timestamp__':'2023-07-29 11:25:18', 'disk':'/opt/matrix10', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':'这是string测试', '__timestamp__':'2023-07-29 11:25:19', 'disk':'/opt/matrix11', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':'这是string测试 resolver: debug 1: createfetch: deb.thegov.win A', '__timestamp__':'2023-07-29 11:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':"这是string测试 error (network unreachable) resolving './NS/IN': 2001:500:84::b#53", '__timestamp__':'2023-07-30 11:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':'这是string测试', '__timestamp__':'2023-07-30 11:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':'这是string测试', '__timestamp__':'2023-07-30 11:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':'这是string测试', '__timestamp__':'2023-07-30 11:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'}])`) require.Nil(t.Test, err, fmt.Sprint(err)) } func (t *BucketPromdbTests) Data11() { var err error _, _, err = t.g.Query(` insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-28 11:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.82, '__timestamp__':'2023-07-28 11:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-28 11:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-28 11:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-29 11:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.83, '__timestamp__':'2023-07-29 11:25:18', 'disk':'/opt/matrix10', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-29 11:25:19', 'disk':'/opt/matrix11', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-29 11:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-30 11:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.84, '__timestamp__':'2023-07-30 11:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-30 11:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-30 11:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 12:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':'2023-07-27 12:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 12:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 12:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-28 12:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.82, '__timestamp__':'2023-07-28 12:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-28 12:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-28 12:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-29 12:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.83, '__timestamp__':'2023-07-29 12:25:18', 'disk':'/opt/matrix10', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-29 12:25:19', 'disk':'/opt/matrix11', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-29 12:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-30 12:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.84, '__timestamp__':'2023-07-30 12:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-30 12:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-30 12:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1', '__value__':2, '__timestamp__':'2023-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.81, '__timestamp__':'2023-07-27 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-28 11:24:17', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.82, '__timestamp__':'2023-07-28 11:25:18', 'disk':'/opt/matrix/test', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-28 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-28 11:26:19', 'disk':'/opt/matrix/test', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-29 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.83, '__timestamp__':'2023-07-29 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-29 11:25:19', 'disk':'/opt/matrix/test', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-29 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}, { '__name__':'key1', '__value__':2.7, '__timestamp__':'2023-07-30 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'}, { '__name__':'key2', '__value__':8.84, '__timestamp__':'2023-07-30 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'}, { '__name__':'key5', '__value__':2.9, '__timestamp__':'2023-07-30 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'}, { '__name__':'key48', '__value__':2.9, '__timestamp__':'2023-07-30 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] ) `) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = t.g.Query(` insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.000'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.001'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.002'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.003'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.004'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.005'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.006'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.007'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.008'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:24:00.009'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:25:00.010'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:26:00.011'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:27:00.012'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:28:00.013'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:29:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:29:00.014'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:30:00.015'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:31:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2023-11-28 11:31:00.016'; insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2023-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2023-11-28 11:32:00.017'; `) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr := t.g.Prepare(`insert into /test/bucketpromdbnocache (id, prom_nocache) values (?, ? )`) require.Nil(t.Test, errr) for i := 0; i < 1000; i++ { ct, _ := cast.ToDatetimeE("2023-10-28 11:24:17") ct = ct.Add(time.Duration(i) * time.Second) _, _, err = stat.Exec("bucketpromdbnocache:wecise", []map[string]interface{}{ {"name": "key1", "value": 2, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key2", "value": 1.8, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key3", "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "keys1", "value": "sss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "keys2", "value": "这是中文长字符串sssss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key48", "value": 2.9, "timestamp": ct.Format("2006-01-02 15:04:05")}}) require.Nil(t.Test, err, fmt.Sprint(err)) } for i := 0; i < 1000; i++ { ct, _ := cast.ToDatetimeE("2023-10-28 15:24:17") ct = ct.Add(time.Duration(i) * time.Second) _, _, err = stat.Exec("bucketpromdbnocache:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.7, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key2", "value": 1.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key3", "value": 3.9, "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "keys1", "value": "ssss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "keys2", "value": "ss这是中文长字符串sssss", "timestamp": ct.Format("2006-01-02 15:04:05")}, {"name": "key48", "value": 3.9, "timestamp": ct.Format("2006-01-02 15:04:05")}}) require.Nil(t.Test, err, fmt.Sprint(err)) } _, _, err = stat.Exec("bucketpromdbnocache:wecise", []map[string]interface{}{ {"name": "key1", "value": 2.9, "timestamp": "2023-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"}, {"name": "key2", "value": 2, "timestamp": "2023-07-29 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"name": "key3", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"name": "keys1", "value": "sss", "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"name": "keys2", "value": "这是中文长字符串sssss", "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"name": "key48", "value": 2.9, "timestamp": "2023-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) _, _, err = stat.Exec("bucketpromdbnocache:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 5.2, "__timestamp__": "2023-07-30 11:24:17", "disk": "/opt/matrix/test", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 4.8, "__timestamp__": "2023-07-30 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "keys1", "__value__": "sss", "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "keys2", "__value__": "这是中文长字符串sssss", "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}) require.Nil(t.Test, err, fmt.Sprint(err)) stat, errr = t.g.Prepare(`insert into /test/bucketpromdbnocache (id, prom_nocache) values (?, ? ) at ?`) require.Nil(t.Test, errr) _, _, err = stat.Exec("bucketpromdbnocache:wecise", []map[string]interface{}{ {"__name__": "key1", "__value__": 6.0, "__timestamp__": "2023-07-31 11:24:17", "disk": "/opt/matrix/test", "CPU": "CPU1"}, {"__name__": "key2", "__value__": 3, "__timestamp__": "2023-07-31 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"}, {"__name__": "key3", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"}, {"__name__": "keys1", "__value__": "sss", "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "keys2", "__value__": "这是中文长字符串sssss", "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"}, {"__name__": "key48", "__value__": 2.9, "__timestamp__": "2023-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}}, "2023-07-31 11:24:17") require.Nil(t.Test, errr) } func (t *BucketPromdbTests) Valid() { var err error _, _, err = t.g.Query(`SELECT prom.date('2023-07-27') FROM /test/bucketpromdb`) assert.Nil(t.Test, err) _, _, err = t.g.Query(`SELECT prom.date('2023-07-28') FROM /test/bucketpromdb`) assert.Nil(t.Test, err) _, _, err = t.g.Query(`SELECT prom.date('2023-07-29') FROM /test/bucketpromdb`) assert.Nil(t.Test, err) _, _, err = t.g.Query(`SELECT prom.date('2023-07-30') FROM /test/bucketpromdb`) assert.Nil(t.Test, err) _, _, err = t.g.Query(`SELECT prom.date('2023-07-31') FROM /test/bucketpromdb`) assert.Nil(t.Test, err) _, _, err = t.g.Query(`SELECT prom.time('2023-07-26', '').find(name='key2') FROM /test/bucketpromdb`) assert.Nil(t.Test, err) _, _, err = t.g.Query(`SELECT prom.time('2023-07-26', '').find(name='keys2').find(value ~ '*中文长字*') FROM /test/bucketpromdb`) assert.Nil(t.Test, err) _, _, err = t.g.Query(`SELECT prom.time('2023-07-26', '').find(name='keys2').find(value = '这是中文长字符串sssss') FROM /test/bucketpromdb`) assert.Nil(t.Test, err) _, _, err = t.g.Query(`SELECT prom.time('2023-07-26', '').find(name='keys1').find(value = 'sss') FROM /test/bucketpromdb`) assert.Nil(t.Test, err) _, _, err = t.g.Query(`SELECT prom.time('2023-07-26', '').find(name='keys2').find(value !~ '*中文长字a*') FROM /test/bucketpromdb `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT prom.time('2023-07-26', '').find(name='key1') FROM /test/bucketpromdb `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT prom.time('2023-07-26', '').find(name='key1').find(value = 2.9) FROM /test/bucketpromdb `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT prom.time('2023-07-26', '').find(name='key1').find(value >= 2.9) FROM /test/bucketpromdb `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT prom.time('2023-07-26', '').find(name='key1').find(value <= 2.9) FROM /test/bucketpromdb `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` select prom.time('2023-11-28 11:30', '2023-11-28 11:30').find(name='key1.key2.key4') from /test/bucketpromdb `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT class, id, prom.time('2023-01-01', '').find(name ~ "key1.key2.*") FROM /test/bucketpromdb/ `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT prom.time('2023-07-24', '').find(name in ["key1"]).find(disk in ["/opt/matrix"]) FROM /test/bucketpromdb `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_str.date('2023-07-31').find(value ~ 'info') FROM /test/promdb_string `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_str.date('2023-07-31').find(value !~ 'info') FROM /test/promdb_string `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_str.date('2023-07-31').find(value = '这是string测试') FROM /test/promdb_string `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_str.date('2023-07-31').find(value in ['这是string测试']) FROM /test/promdb_string `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_str.date('2023-07-31').find(value not like '这是string*') FROM /test/promdb_string `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_str.date('2023-07-31').find(value like '这是string*') FROM /test/promdb_string `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_str.date('2023-07-31').find(value like '这是string*').facet("info", "hello").groupby(1h) FROM /test/promdb_string `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_str.date('2023-07-31').find(value like '这是string*').facet("info", "hello").groupby(1h).outlier() FROM /test/promdb_string `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_str.date('2023-07-27', '2023-07-28', '2023-07-29', '2023-07-30', '2023-07-31').find(value like '这是string*').facet("error").groupby(1h) FROM /test/promdb_string`) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_split.date('2023-07-31').time('11:27') FROM /test/bucketsplit `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_split.date('2023-07-26','2023-07-27','2023-07-28','2023-07-29','2023-07-30','2023-07-31') FROM /test/bucketsplit `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_split.date('2023-07-26','2023-07-27','2023-07-28','2023-07-29','2023-07-30','2023-07-31').avg().groupby(1d) FROM /test/bucketsplit `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_split.date('2023-07-26','2023-07-27','2023-07-28','2023-07-29','2023-07-30','2023-07-31').outlier() FROM /test/bucketsplit `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_split.date('2023-07-26','2023-07-27','2023-07-28','2023-07-29','2023-07-30','2023-07-31').time('11:').outlier() FROM /test/bucketsplit `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_split.date('2023-07-26').unit('avg') FROM /test/bucketsplit `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_split.date('2023-07-26','2023-07-27','2023-07-28','2023-07-29','2023-07-30','2023-07-31').sigma("count") FROM /test/bucketsplit `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT id, prom_split.date('2023-07-26','2023-07-27','2023-07-28','2023-07-29','2023-07-30','2023-07-31').sigma("count", 1h) FROM /test/bucketsplit `) assert.Nil(t.Test, err) _, _, err = t.g.Query(` SELECT prom.date('2023-11-28').avg().sigma() FROM /test/bucketpromdb `) assert.Nil(t.Test, err) }