-- 12search 目录初始化：搜索功能测试
-- 创建用于搜索测试的 class

create class if not exists /test/aaa/test_search (
    s_name      varchar,
    s_text      text,
    s_int       int,
    s_bigint    bigint,
    s_float     float,
    s_double    double,
    s_bool      bool,
    s_ts        timestamp,

    indexes(s_name, s_text, s_int, s_bigint, s_float, s_double, s_bool, s_ts),
    keys(s_name)
) with core=cassandraonly
;

-- 插入搜索测试数据
insert into /test/aaa/test_search (s_name, s_text, s_int, s_bigint, s_float, s_double, s_bool, s_ts)
values ('search_int_001', 'int search test data', 10, 100, 10.5, 10.555, true, 1700000000000)
;

insert into /test/aaa/test_search (s_name, s_text, s_int, s_bigint, s_float, s_double, s_bool, s_ts)
values ('search_int_002', 'int search test data', 20, 200, 20.5, 20.555, false, 1710000000000)
;

insert into /test/aaa/test_search (s_name, s_text, s_int, s_bigint, s_float, s_double, s_bool, s_ts)
values ('search_int_003', 'int search data', 30, 300, 30.5, 30.555, true, 1720000000000)
;

insert into /test/aaa/test_search (s_name, s_text, s_int, s_bigint, s_float, s_double, s_bool, s_ts)
values ('search_int_004', 'between test', 50, 500, 50.5, 50.555, true, 1730000000000)
;

insert into /test/aaa/test_search (s_name, s_text, s_int, s_bigint, s_float, s_double, s_bool, s_ts)
values ('search_int_005', 'between test data', 60, 600, 60.5, 60.555, false, 1740000000000)
;

insert into /test/aaa/test_search (s_name, s_text, s_int, s_bigint, s_float, s_double, s_bool, s_ts)
values ('search_string_001', 'hello world prefix test', 1, 10, 0.1, 0.001, true, 1750000000000)
;

insert into /test/aaa/test_search (s_name, s_text, s_int, s_bigint, s_float, s_double, s_bool, s_ts)
values ('search_string_002', 'hello mql full search test data', 2, 20, 0.2, 0.002, false, 1760000000000)
;

insert into /test/aaa/test_search (s_name, s_text, s_int, s_bigint, s_float, s_double, s_bool, s_ts)
values ('search_string_003', 'prefix search demo test', 3, 30, 0.3, 0.003, true, 1770000000000)
;

-- 等待数据索引完成
/**
sleep(1s)
**/
;