async def test_grant_stmt(self):
qb = QueryGenerator(SiriGrammar, {
'regex_map': k_map,
'replace_map': {
'r_singleq_str': ''
}})
for q in qb.generate_queries('grant_stmt'):
await self.client0.query(q)
async def test_drop_stmt(self):
qb = QueryGenerator(SiriGrammar, {
'regex_map': k_map,
'replace_map': {
'r_singleq_str': '',
'drop_server': '', # not possible
}})
for q in qb.generate_queries('drop_stmt'):
await self.client0.query(q)
async def test_alter_stmt(self):
qb = QueryGenerator(SiriGrammar, {
'regex_map': k_map,
'replace_map': {
'r_singleq_str': '',
'k_now': '', # not possible (set expiration num/log)
'set_name': '', # skip
'set_address': '', # not possible
'set_port': '', # not possible
'set_timezone': '', # same value error
'set_log_level': '', # not required, but skip to keep log level
}})
for q in qb.generate_queries('alter_stmt'):
await self.client0.query(q)
async def test_select_stmt(self):
qb = QueryGenerator(SiriGrammar, {
'regex_map': k_map,
'replace_map': {
'r_singleq_str': '',
'k_filter': '', # skip because only number type series
'k_prefix': '', # skip
'k_suffix': '', # skip
'k_merge': '', # skip
'k_where': '', # skip
'after_expr': '', # skip
'before_expr': '', # skip
'between_expr': '', # skip
}
})
for q in qb.generate_queries('select_stmt'):
await self.client0.query(q)
async def test_all_stmts(self, client):
qb = QueryGenerator(SiriGrammar, {
'regex_map': k_map,
'replace_map': {
'r_singleq_str': '',
'r_comment': '',
'k_timeit': '',
'select_stmt': '',
'list_stmt': '',
'count_stmt': '',
'alter_group': '',
#'drop_group': '',
'alter_server': '',
'drop_server': '',
'alter_user': '',
'drop_user': '',
#'set_address': '',
#'set_port': '',
'set_timezone': '',
'set_log_level': '', # not required, skip to keep log level
'set_expiration_num': '',
'set_expiration_log': '',
'k_prefix': '',
'k_suffix': '',
'k_filter': '',
#'k_where': '',
'after_expr': '',
'before_expr': '',
'between_expr': '',
'k_merge': '',
}})
for q in qb.generate_queries():
await self.client0.query(q)