import "org/killbill/billing/util/entity/dao/EntitySqlDao.sql.stg"

tableName() ::= "tenant_broadcasts"

tableFields(prefix) ::= <<
  <prefix>target_record_id
, <prefix>target_table_name
, <prefix>type
, <prefix>user_token
, <prefix>created_date
, <prefix>created_by
, <prefix>updated_date
, <prefix>updated_by
>>

tableValues() ::= <<
  :targetRecordId
, :targetTableName
, :type
, :userToken
, :createdDate
, :createdBy
, :updatedDate
, :updatedBy
>>

/* No account_record_id field */
accountRecordIdFieldWithComma(prefix) ::= ""
accountRecordIdValueWithComma() ::= ""


getLatestEntries() ::= <<
select
  <allTableFields("t.")>
from <tableName()> t
where record_id > :recordId
<defaultOrderBy("t.")>
;
>>


getLatestEntry() ::= <<
select
  <allTableFields("t.")>
from <tableName()> t
where record_id = (select max(record_id) from <tableName()>)
;
>>
