org.killbill.billing.util.broadcast.dao.BroadcastSqlDao.sql.stg Maven / Gradle / Ivy
tableName() ::= "service_broadcasts"
tableFields(prefix) ::= <<
service_name
, type
, event
, created_date
, created_by
>>
allTableFields(prefix) ::= <<
record_id
,
>>
tableValues() ::= <<
:serviceName
, :type
, :event
, :createdDate
, :createdBy
>>
allTableValues() ::= <<
:recordId
,
>>
defaultOrderBy(prefix) ::= <<
order by record_id ASC
>>
create() ::= <<
insert into (
)
values (
)
;
>>
getLatestEntries() ::= <<
select
from t
where record_id > :recordId
;
>>
getLatestEntry() ::= <<
select
from t
where record_id = (select max(record_id) from )
;
>>