-- ============================================================
-- bucket logs 测试
-- ============================================================

-- 1. 插入数据到 bucket logs
insert into /test/aaa/test_bucket_logs (name, msg, n) values ('log_001', 'log message 1', 1)
;

-- 2. 查询 bucket logs
select * from /test/aaa/test_bucket_logs where name='log_001'
/**
output()
count(1)
**/
;

-- 3. 批量插入 bucket logs
insert into /test/aaa/test_bucket_logs (name, msg, n) values ('log_002', 'log message 2', 2)
;

insert into /test/aaa/test_bucket_logs (name, msg, n) values ('log_003', 'log message 3', 3)
;

-- 4. 全表查询 bucket logs
select * from /test/aaa/test_bucket_logs
/**
output()
**/
;

-- 5. count bucket logs
select count(*) from /test/aaa/test_bucket_logs
/**
output()
**/
;

-- 6. update bucket logs
update /test/aaa/test_bucket_logs set msg='updated log' where name='log_001'
;

select msg from /test/aaa/test_bucket_logs where name='log_001'
/**
output()
match("msg","updated log")
**/
;

-- 7. delete bucket logs
delete from /test/aaa/test_bucket_logs where name='log_003'
;

select * from /test/aaa/test_bucket_logs where name='log_003'
/**
output()
count(0)
**/
;