odbtest/test/unit/mql/bucket/bucket_promdb.go

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)

}