odbtools/odbctest/mql/aaa/18prepare/11prepare_insert.mql

-- ============================================================
-- Prepare Insert 操作测试
-- ============================================================

-- 1. 基本 prepare insert
insert into /test/aaa/test_prepare (p_name, p_text, p_int, p_float, p_double, p_bool, p_ts) values (?, ?, ?, ?, ?, ?, ?)
/**
params("prep_insert_001", "prepare insert test data", 100, 3.14, 3.141592653589793, true, 1711641600000)
**/
;

-- 验证
select * from /test/aaa/test_prepare where p_name='prep_insert_001'
/**
output()
count(1)
match("p_int","100")
**/
;

-- 2. prepare insert 批量数据
insert into /test/aaa/test_prepare (p_name, p_text, p_int) values (?, ?, ?)
/**
params("prep_insert_002", "batch prepare 2", 200)
**/
;

insert into /test/aaa/test_prepare (p_name, p_text, p_int) values (?, ?, ?)
/**
params("prep_insert_003", "batch prepare 3", 300)
**/
;

-- 3. 验证批量数据
select * from /test/aaa/test_prepare where p_name='prep_insert_002' or p_name='prep_insert_003'
/**
output()
count(2)
**/
;

-- 4. prepare insert 带 bigint
insert into /test/aaa/test_prepare (p_name, p_bigint) values (?, ?)
/**
params("prep_bigint_001", 999999999999999999)
**/
;

select p_name, p_bigint from /test/aaa/test_prepare where p_name='prep_bigint_001'
/**
output()
match("p_bigint","999999999999999999")
**/
;

-- 5. prepare insert bool false
insert into /test/aaa/test_prepare (p_name, p_bool) values (?, ?)
/**
params("prep_bool_001", false)
**/
;

select p_name, p_bool from /test/aaa/test_prepare where p_name='prep_bool_001'
/**
output()
match("p_bool","false")
**/
;