lxy-kit/tpl/DictSqlTpl.sql
2019-03-13 16:03:59 +08:00

14 lines
371 B
SQL

#for(m : maps)
#set(
arr = m.key.split("[|]"),
remark = arr.length >= 2 ? arr[1] : arr[0],
dic_type = arr.length >= 3 ? arr[2] : remark
)
# #(arr[0]).#(remark)
INSERT INTO `sys_cfg_dictionary`(app_id,dic_key,dic_value,dic_type,remark) VALUES
#for(x : m.value)
(23, "#(x.code)", "#(x.name)","#(dic_type)","#(remark)")#if(for.last);#else ,#end
#end
#end