Sākums Izpētīt Palīdzība
Pierakstīties
libf
/
odbtest
1
0
Atdalīts 0
Faili Problēmas 0 Izmaiņu pieprasījumi 0 Vikivietne
Atzars: master
Atzari Tagi
odbtest
/
test
/
unit
/
mql
/
bucket
/
bucket_promedb.go

bucket_promedb.go 15 KB
Patstāvīgā saite Vēsture Neapstrādāts

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265 
  1. package bucket
    2. 

  2. 

  3. import (
    4. 

  4. 	//"fmt"
    5. 

  5. 	//"strconv"
    6. 

  6. 	"fmt"
    7. 

  7. 	"testing"
    8. 

  8. 	"time"
    9. 

  9. 

  10. 	. "git.wecise.com/wecise/odbserver/odb"
    11. 

  11. 	"git.wecise.com/wecise/odbserver/odb/test"
    12. 

  12. 	"gitee.com/wecisecode/util/logger"
    13. 

  13. 	"github.com/stretchr/testify/assert"
    14. 

  14. 	"github.com/stretchr/testify/require"
    15. 

  15. )
    16. 

  16. 

  17. type BucketPromedbTests struct {
    18. 

  18. 	Test *testing.T
    19. 

  19. 	g    *Gutil
    20. 

  20. }
    21. 

  21. 

  22. func BucketPromedbTest(t *testing.T) {
    23. 

  23. 

  24. 	g := test.TestG()
    25. 

  25. 

  26. 	t.Run("InitG", func(t *testing.T) {
    27. 

  27. 		test := &BucketPromedbTests{Test: t, g: g}
    28. 

  28. 		test.InitG()
    29. 

  29. 	})
    30. 

  30. 

  31. 	t.Run("Class", func(t *testing.T) {
    32. 

  32. 		test := &BucketPromedbTests{Test: t, g: g}
    33. 

  33. 		test.Class()
    34. 

  34. 	})
    35. 

  35. 

  36. 	time.Sleep(time.Duration(1) * time.Second)
    37. 

  37. 

  38. 	t.Run("Data", func(t *testing.T) {
    39. 

  39. 		test := &BucketPromedbTests{Test: t, g: g}
    40. 

  40. 		test.Data()
    41. 

  41. 	})
    42. 

  42. 

  43. 	/*t.Run("Valid", func(t *testing.T) {
    44. 

  44. 		test := &BucketPromedbTests{Test: t, g: g}
    45. 

  45. 		test.Valid()
    46. 

  46. 	})*/
    47. 

  47. }
    48. 

  48. 

  49. func (t *BucketPromedbTests) InitG() {
    50. 

  50. 	require.NotNil(t.Test, t.g)
    51. 

  51. }
    52. 

  52. 

  53. func (t *BucketPromedbTests) Class() {
    54. 

  54. 

  55. 	_, _, err := t.g.Query(`
    56. 

  56. 	create class if not exists /test/bucketpromedb (
    57. 

  57.    		
    58. 

  58. 		host varchar,
    59. 

  59. 		
    60. 

  60. 		prom  bucket {
    61. 

  61. 				 "type"  :  "promdb",
    62. 

  62. 				 "ttl"   :   365
    63. 

  63. 			 } 'full',
    64. 

  64. 

  65. 		keys(host),
    66. 

  66. 		indexes(host)
    67. 

  67. 	
    68. 

  68. 	) with key=manu, nickname='bucketpromedb'
    69. 

  69. 

  70. 	`)
    71. 

  71. 

  72. 	if err != nil {
    73. 

  73. 		logger.Errorf("%v", err)
    74. 

  74. 	}
    75. 

  75. 

  76. 	require.Nil(t.Test, err, fmt.Sprint(err))
    77. 

  77. }
    78. 

  78. 

  79. func (t *BucketPromedbTests) Data() {
    80. 

  80. 

  81. 	var err error
    82. 

  82. 	_, _, err = t.g.Query(` insert into /test/bucketpromedb (id, prom) values ('bucketpromedb:wecise', [ ["key1", 2.6, {"disk":"/opt/matrix", "memory":"CPU1"}]] ) at '2020-07-24 10:24:17' `)
    83. 

  83. 	if err != nil {
    84. 

  84. 		logger.Error(err)
    85. 

  85. 	}
    86. 

  86. 	require.Nil(t.Test, err, fmt.Sprint(err))
    87. 

  87. 

  88. 	_, _, err = t.g.Query(` insert into /test/bucketpromedb (id, prom) values ('bucketpromedb:wecise', [ ["key1", 2.7, "2020-07-25 11:24:17", {"disk":"/opt/matrix", "memory":"CPU1"}]] ) `)
    89. 

  89. 	require.Nil(t.Test, err, fmt.Sprint(err))
    90. 

  90. 

  91. 	_, _, err = t.g.Query(` insert into /test/bucketpromedb (id, prom) values ('bucketpromedb:wecise', [   ["key1", 2.7, "2020-07-26 11:24:17", {"disk":"/opt/matrix", "CPU":"CPU1"}],
    92. 

  92. 																										   ["key2", 2.8, "2020-07-26 11:25:18", {"disk":"/opt/matrix", "CPU":"CPU2"}],
    93. 

  93. 																										   ["key3", 2.9, "2020-07-26 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU3"}],
    94. 

  94. 																										   ["key4", 2.9, "2020-07-26 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU4"}],
    95. 

  95. 																										   ["key5", 2.9, "2020-07-26 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU5"}],
    96. 

  96. 																										   ["key6", 2.9, "2020-07-26 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU6"}],
    97. 

  97. 																										   ["key7", 2.9, "2020-07-26 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU7"}],
    98. 

  98. 																										   ["key8", 2.9, "2020-07-26 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU8"}],
    99. 

  99. 																										   ["key9", 2.9, "2020-07-26 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU9"}],
    100. 

  100. 																										   ["key10", 2.9, "2020-07-26 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU10"}],
    101. 

  101. 																										   ["key11", 2.9, "2020-07-26 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU11"}],
    102. 

  102. 																										   ["key12", 2.9, "2020-07-26 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU12"}],
    103. 

  103. 																										   ["key13", 2.9, "2020-07-26 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU13"}],
    104. 

  104. 																										   ["key14", 2.9, "2020-07-26 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU14"}],
    105. 

  105. 																										   ["key15", 2.9, "2020-07-27 12:25:18", {"disk":"/opt/matrix", "CPU":"CPU15"}],
    106. 

  106. 																										   ["key16", 2.9, "2020-07-27 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU16"}],
    107. 

  107. 																										   ["key17", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU17"}],
    108. 

  108. 																										   ["key18", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU18"}],
    109. 

  109. 																										   ["key19", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU19"}],
    110. 

  110. 																										   ["key20", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU20"}],
    111. 

  111. 																										   ["key21", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU21"}],
    112. 

  112. 																										   ["key22", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU22"}],
    113. 

  113. 																										   ["key23", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU23"}],
    114. 

  114. 																										   ["key24", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU24"}],
    115. 

  115. 																										   ["key25", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU25"}],
    116. 

  116. 																										   ["key26", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU26"}],
    117. 

  117. 																										   ["key27", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU27"}],
    118. 

  118. 																										   ["key28", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU28"}],
    119. 

  119. 																										   ["key29", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU29"}],
    120. 

  120. 																										   ["key30", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU30"}],
    121. 

  121. 																										   ["key31", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU31"}],
    122. 

  122. 																										   ["key32", 2.9, "2020-07-23 10:24:19", {"disk":"/opt/matrix", "CPU":"CPU32"}],
    123. 

  123. 																										   ["key33", 2.9, "2020-07-23 10:25:19", {"disk":"/opt/matrix", "CPU":"CPU33"}],
    124. 

  124. 																										   ["key34", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU34"}],
    125. 

  125. 																										   ["key35", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU35"}],
    126. 

  126. 																										   ["key36", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU36"}],
    127. 

  127. 																										   ["key37", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU37"}],
    128. 

  128. 																										   ["key38", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU38"}],
    129. 

  129. 																										   ["key39", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU39"}],
    130. 

  130. 																										   ["key40", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU40"}],
    131. 

  131. 																										   ["key41", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU41"}],
    132. 

  132. 																										   ["key42", 2.9, "2020-07-23 09:25:18", {"disk":"/opt/matrix", "CPU":"CPU42"}],
    133. 

  133. 																										   ["key43", 2.9, "2020-07-23 09:25:19", {"disk":"/opt/matrix", "CPU":"CPU43"}],
    134. 

  134. 																										   ["key44", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU44"}],
    135. 

  135. 																										   ["key45", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU45"}],
    136. 

  136. 																										   ["key46", 2.9, "2020-07-23 08:25:18", {"disk":"/opt/matrix", "CPU":"CPU46"}],
    137. 

  137. 																										   ["key47", 2.9, "2020-07-23 08:25:19", {"disk":"/opt/matrix", "CPU":"CPU47"}],
    138. 

  138. 																										   ["key48", 2.9, "2020-07-23 11:25:19", {"disk":"/opt/matrix", "CPU":"CPU48"}]
    139. 

  139. 																										  ] ) `)
    140. 

  140. 	require.Nil(t.Test, err, fmt.Sprint(err))
    141. 

  141. 

  142. 	stat, errr := t.g.Prepare(`insert into /test/bucketpromedb (id, prom) values (?, ? ) at ? `)
    143. 

  143. 	require.Nil(t.Test, errr)
    144. 

  144. 

  145. 	_, _, err = stat.Exec("bucketpromedb:wecise", [][]interface{}{{"key1", 2.6, map[string]string{"disk": "/opt/matrix", "memory": "CPU1"}}}, "2020-07-29 10:24:17")
    146. 

  146. 	require.Nil(t.Test, err, fmt.Sprint(err))
    147. 

  147. 

  148. 	stat, err = t.g.Prepare(`insert into /test/bucketpromedb (id, prom) values (?, ? )`)
    149. 

  149. 	require.Nil(t.Test, err, fmt.Sprint(err))
    150. 

  150. 

  151. 	_, _, err = stat.Exec("bucketpromedb:wecise", [][]interface{}{{"key1", 2.7, "2020-07-26 11:24:17", map[string]string{"disk": "/opt/matrix", "CPU": "CPU1"}},
    152. 

  152. 		{"key2", 2.8, "2020-07-26 11:25:18", map[string]string{"disk": "/opt/matrix", "CPU": "CPU2"}},
    153. 

  153. 		{"key3", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU3"}},
    154. 

  154. 		{"key4", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU4"}},
    155. 

  155. 		{"key5", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU5"}},
    156. 

  156. 		{"key6", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU6"}},
    157. 

  157. 		{"key7", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU7"}},
    158. 

  158. 		{"key8", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU8"}},
    159. 

  159. 		{"key9", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU9"}},
    160. 

  160. 		{"key10", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU10"}},
    161. 

  161. 		{"key11", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU11"}},
    162. 

  162. 		{"key12", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU12"}},
    163. 

  163. 		{"key13", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU13"}},
    164. 

  164. 		{"key14", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU14"}},
    165. 

  165. 		{"key15", 2.9, "2020-07-27 12:25:18", map[string]string{"disk": "/opt/matrix", "CPU": "CPU15"}},
    166. 

  166. 		{"key16", 2.9, "2020-07-27 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU16"}},
    167. 

  167. 		{"key17", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU17"}},
    168. 

  168. 		{"key18", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU18"}},
    169. 

  169. 		{"key19", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU19"}},
    170. 

  170. 		{"key20", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU20"}},
    171. 

  171. 		{"key21", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU21"}},
    172. 

  172. 		{"key22", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU22"}},
    173. 

  173. 		{"key23", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU23"}},
    174. 

  174. 		{"key24", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU24"}},
    175. 

  175. 		{"key25", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU25"}},
    176. 

  176. 		{"key26", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU26"}},
    177. 

  177. 		{"key27", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU27"}},
    178. 

  178. 		{"key28", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU28"}},
    179. 

  179. 		{"key29", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU29"}},
    180. 

  180. 		{"key30", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU30"}},
    181. 

  181. 		{"key31", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU31"}},
    182. 

  182. 		{"key32", 2.9, "2020-07-26 10:24:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU32"}},
    183. 

  183. 		{"key33", 2.9, "2020-07-26 10:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU33"}},
    184. 

  184. 		{"key34", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU34"}},
    185. 

  185. 		{"key35", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU35"}},
    186. 

  186. 		{"key36", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU36"}},
    187. 

  187. 		{"key37", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU37"}},
    188. 

  188. 		{"key38", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU38"}},
    189. 

  189. 		{"key39", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU39"}},
    190. 

  190. 		{"key40", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU40"}},
    191. 

  191. 		{"key41", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU41"}},
    192. 

  192. 		{"key42", 2.9, "2020-07-26 09:25:18", map[string]string{"disk": "/opt/matrix", "CPU": "CPU42"}},
    193. 

  193. 		{"key43", 2.9, "2020-07-26 09:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU43"}},
    194. 

  194. 		{"key44", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU44"}},
    195. 

  195. 		{"key45", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU45"}},
    196. 

  196. 		{"key46", 2.9, "2020-07-26 08:25:18", map[string]string{"disk": "/opt/matrix", "CPU": "CPU46"}},
    197. 

  197. 		{"key47", 2.9, "2020-07-26 08:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU47"}},
    198. 

  198. 		{"key48", 2.9, "2020-07-26 11:25:19", map[string]string{"disk": "/opt/matrix", "CPU": "CPU48"}}})
    199. 

  199. 	require.Nil(t.Test, err, fmt.Sprint(err))
    200. 

  200. 

  201. 	/*_, _, err = stat.Exec("buckettsdb:wecise", [][]interface{}{[]interface{}{1, nil, 3.3, 6.5, strconv.Itoa(66666), " abcdefghhhhh"}, []interface{}{1, nil, 3.3, 6.5, strconv.Itoa(77777), " abcdefghhhhh"}, []interface{}{1, nil, 3.3, 6.5, strconv.Itoa(88888), " abcdefghhhhh"}}, []string{"2020-08-01 10:24:17", "2020-08-02 10:24:17", "2020-08-03 10:24:17"})
    202. 

  202. 	if err != nil {
    203. 

  203. 		logger.Errorf("%v", err)
    204. 

  204. 	}
    205. 

  205. 

  206. 	_, _, err = t.g.Query(`insert into /test/buckettsdb (id, bk2[ 'iparam1", 'iparam2", 'fparam1", 'fparam2", 'sparam1", 'vparam1']) values ('buckettsdb:wecise", [[1, nil, 3.3, 6.5, '2234567890", 'abcdefghhhhh'}, [1, nil, 3.3, 6.5, '3234567890", 'abcdefghhhhh'}, [1, nil, 3.3, 6.5, '4234567890", 'abcdefghhhhh'] ] ) at {"2020-07-25 10:24:17", "2020-07-26 10:24:17", "2020-07-27 10:24:17'] `)
    207. 

  207. 

  208. 	if err != nil {
    209. 

  209. 		logger.Errorf("%v", err)
    210. 

  210. 	}
    211. 

  211. 	require.Nil(t.Test, err, fmt.Sprint(err))*/
    212. 

  212. }
    213. 

  213. 

  214. func (t *BucketPromedbTests) Valid() {
    215. 

  215. 

  216. 	var err error
    217. 

  217. 	_, _, err = t.g.Query(`SELECT prom FROM /test/bucketpromedb`)
    218. 

  218. 	assert.Nil(t.Test, err)
    219. 

  219. 

  220. 	/*_, _, err = t.g.Query(`SELECT bk2[-1 - 1] FROM /test/buckettsdb`)
    221. 

  221. 	assert.Nil(t.Test, err)
    222. 

  222. 

  223. 	_, _, err = t.g.Query(`SELECT bk2[1 - -1] FROM /test/buckettsdb`)
    224. 

  224. 	assert.Nil(t.Test, err)
    225. 

  225. 

  226. 	_, _, err = t.g.Query(`SELECT bk2[ 4-3] FROM /test/buckettsdb`)
    227. 

  227. 	assert.Nil(t.Test, err)
    228. 

  228. 

  229. 	_, _, err = t.g.Query(`SELECT bk2[ 'iparam1", 3-1, 4] FROM /test/buckettsdb`)
    230. 

  230. 	assert.Nil(t.Test, err)
    231. 

  231. 

  232. 	_, _, err = t.g.Query(`SELECT bk2[ 'iparam1", 1-3, 4] FROM /test/buckettsdb`)
    233. 

  233. 	assert.Nil(t.Test, err)
    234. 

  234. 

  235. 	_, _, err = t.g.Query(`SELECT bk2[ 'iparam1", 'iparam2", 2-3, 4 ].time("2020-04-22 08:10", '').(iparam1=1).count()  as iparam1  FROM /test/buckettsdb `)
    236. 

  236. 	assert.Nil(t.Test, err)
    237. 

  237. 

  238. 	_, _, err = t.g.Query(`SELECT bk2[  3-4, 5 ].time("2020-05-23 22:24:15", '').([1]=1).title()  FROM /test/buckettsdb `)
    239. 

  239. 	assert.Nil(t.Test, err)
    240. 

  240. 

  241. 	_, _, err = t.g.Query(`SELECT bk2[ 'iparam1", 1-3, 4 ].time("2020-04-22", '').find(fparam1 >= 0.992315).find(iparam1 = 56).find(fparam2 != 0.418309)  as iparam1  FROM /test/buckettsdb `)
    242. 

  242. 	assert.Nil(t.Test, err)
    243. 

  243. 

  244. 	_, _, err = t.g.Query(`SELECT bk2.time("2020-04-22", '').find(fparam1 >= 0.992315).find(iparam1 = 56).find(fparam2 <> 0.418309)  as iparam1  FROM /test/buckettsdb `)
    245. 

  245. 	assert.Nil(t.Test, err)
    246. 

  246. 

  247. 	_, _, err = t.g.Query(`SELECT bk2.time("2020-04-22", '').(fparam1 >= 0.992315).(iparam1 in [56,99]) FROM /test/buckettsdb `)
    248. 

  248. 	assert.Nil(t.Test, err)
    249. 

  249. 

  250. 	_, _, err = t.g.Query(` SELECT bk2[-1 - 1].time("2020-07-24", '').find(fparam1 >= 0.992315).count() as iparm1 FROM /test/buckettsdb `)
    251. 

  251. 	assert.Nil(t.Test, err)
    252. 

  252. 

  253. 	_, _, err = t.g.Query(`  SELECT id, bk2 FROM 	/test/buckettsdb `)
    254. 

  254. 	assert.Nil(t.Test, err)
    255. 

  255. 

  256. 	_, _, err = t.g.Query(` SELECT bk2[-1 - 1].date("2020-07-24').find(fparam1=3.3) FROM /test/buckettsdb `)
    257. 

  257. 	assert.Nil(t.Test, err)
    258. 

  258. 

  259. 	_, _, err = t.g.Query(` SELECT bk2.date("2020-07-24") FROM /test/buckettsdb `)
    260. 

  260. 	assert.Nil(t.Test, err)
    261. 

  261. 

  262. 	_, _, err = t.g.Query(` SELECT id FROM /test/buckettsdb where bk2.date("2020-07-24").assert(iparam1=1)`)
    263. 

  263. 	assert.Nil(t.Test, err)*/
    264. 

  264. 

  265. }
    266.