HeatingPaymentsInvoker/conf/sqlroot/com/yinjie/heating/business/dao/HeatingDocDao.dql

-- [queryHeatingApp]
select * from $table$;

-- [addHeatingApp]
insert into $table$ (id, appId, appName, appPublicKey,
appPrivateKey, supplyPublicKey, status,
chargeFrom, chargeUserName, verifyKind,
whiteIps, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong ) values ( #{id}, #{appid}, #{appname}, #{apppublickey},
#{appprivatekey}, #{supplypublickey}, #{status},
#{chargefrom}, #{chargeusername}, #{verifykind},
#{whiteips}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

-- [updateHeatingApp]
update $table$ set
appName = #{appname},
appPublicKey = #{apppublickey},
appPrivateKey = #{appprivatekey},
supplyPublicKey = #{supplypublickey},
verifyKind = #{verifykind},
whiteIps = #{whiteips},
updateBy = #{updateby},
updateTime = #{updatetime}
where appId = #{appid};

-- [voidHeatingApp]
update $table$ set
status = #{status},
updateBy = #{updateby},
updateTime = #{updatetime}
where appId = #{appid};

-- [queryHeatingAppInvoker]
select * from $table$
-- trim prefix=WHERE prefixOverrides=AND|OR
  -- isNotEmpty ids
        and idHeatingApp in (/* in ids */)
  -- end
-- end
;

-- [addHeatingAppInvoker]
insert into $table$ (id, appId, appName, invokerName,
invokerCode, description, invokerUrl,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong ) values ( #{id}, #{appid}, #{appname}, #{invokername},
#{invokercode}, #{description}, #{invokerurl},
#{createby}, #{createtime}, #{createtimelong},
#{updateby}, #{updatetime}, #{updatetimelong} );

-- [updateHeatingAppInvoker]
update $table$ set
invokerName = #{invokername},
invokerCode = #{invokercode},
description = #{description},
invokerUrl = #{invokerurl},
updateBy = #{updateby},
updateTime = #{updatetime}
where id = #{id};

-- [deleteHeatingAppInvoker]
delete from $table$ where id = #{id};