• Home
• org.kill-bill.billing
• killbill-util
• 0.24.8
• source code
• NodeInfoSqlDao.sql.stg

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

org.killbill.billing.util.nodes.dao.NodeInfoSqlDao.sql.stg Maven / Gradle / Ivy

tableName() ::= "node_infos"

tableFields(prefix) ::= <<
  node_name
, boot_date
, updated_date
, node_info
, is_active
>>

allTableFields(prefix) ::= <<
  record_id
, 
>>


tableValues() ::= <<
  :nodeName
, :bootDate
, :updatedDate
, :nodeInfo
, :isActive
>>

allTableValues() ::= <<
  :recordId
, 
>>

create() ::= <<
insert into  (

)
values (

)
;
>>

getByNodeName() ::= <<
select 
from 
where node_name = :nodeName
and updated_date \> :updatedDate
and is_active = TRUE
;
>>

getAll() ::= <<
select 
from 
where is_active = TRUE
and updated_date \> :updatedDate
order by node_name asc
;
>>

updateNodeInfo() ::= <<
update 
set node_info = :nodeInfo
, updated_date = :updatedDate
where node_name = :nodeName
;
>>

setUpdatedDate() ::= <<
update 
set updated_date = :updatedDate
where node_name = :nodeName
;
>>

delete() ::= <<
delete
from 
where node_name = :nodeName
;
>>