odbtools/odbctest/mql/aaa/19extensions/18variable.mql

-- ============================================================
-- 变量替换测试：<now>/<rand>/<keyspace>/'...N Bytes...'/{%t,varname}/{%d,varname}
-- ============================================================

-- 1. <now> 当前时间戳
insert into /test/aaa/test_ext (e_name, e_value, e_text) values ('var_now', 1, <now>)
;

select e_name, e_text from /test/aaa/test_ext where e_name='var_now'
/**
output()
**/
;

-- 2. <rand> 随机数
insert into /test/aaa/test_ext (e_name, e_value, e_text) values ('var_rand', <rand>, 'random number: <rand>')
;

select e_name from /test/aaa/test_ext where e_name='var_rand'
/**
output()
count(1)
**/
;

-- 3. <keyspace> 当前命名空间
insert into /test/aaa/test_ext (e_name, e_text) values ('var_keyspace', <keyspace>)
;

select e_name, e_text from /test/aaa/test_ext where e_name='var_keyspace'
/**
output()
**/
;

-- 4. '...N Bytes...' - N个随机可见字符
insert into /test/aaa/test_ext (e_name, e_text) values ('var_bytes', '...10 Bytes...')
;

select e_name, e_text from /test/aaa/test_ext where e_name='var_bytes'
/**
output()
**/
;

-- 5. {%t,varname} 时间格式化
/**
beforerun(set(my_time, '2024-06-15 12:30:45'))
**/
;

insert into /test/aaa/test_ext (e_name, e_text) values ('var_time_fmt', <my_time>)
;

select e_name, e_text from /test/aaa/test_ext where e_name='var_time_fmt'
/**
output()
**/
;

-- 6. {%d,varname} 数字格式化
/**
beforerun(set(my_num, 1024))
**/
;

insert into /test/aaa/test_ext (e_name, e_value, e_text) values (concat('var_num_fmt_', {%d,my_num}), {%d,my_num}, 'num format test')
;

select e_name, e_value from /test/aaa/test_ext where e_name prefix 'var_num_fmt'
/**
output()
**/
;