• Home
• org.kill-bill.billing
• killbill-entitlement
• 0.17.8
• source code
• BlockingStateSqlDao.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.entitlement.dao.BlockingStateSqlDao.sql.stg Maven / Gradle / Ivy

group BlockingStateSqlDao: EntitySqlDao;


tableName() ::= "blocking_states"

andCheckSoftDeletionWithComma(prefix) ::= "and is_active"

defaultOrderBy(prefix) ::= <<
order by effective_date ASC,  ASC
>>

tableFields(prefix) ::= <<
  blockable_id
, type
, state
, service
, block_change
, block_entitlement
, block_billing
, effective_date
, is_active
, created_by
, created_date
, updated_by
, updated_date
>>


tableValues() ::= <<
  :blockableId
, :type
, :state
, :service
, :blockChange
, :blockEntitlement
, :blockBilling
, :effectiveDate
, :isActive
, :createdBy
, :createdDate
, :updatedBy
, :updatedDate
>>


getBlockingStateForService() ::= <<
select

from

where blockable_id = :blockableId
and service = :service
and effective_date \<= :effectiveDate
and is_active

-- We want the current state, hence the order desc and limit 1
order by effective_date desc, record_id desc
limit 1
;
>>

getBlockingState() ::= <<
 select
 
 from
  t
 join (
   select max(record_id) record_id
         , service
         from blocking_states
         where blockable_id = :blockableId
         and effective_date \<= :effectiveDate
         and is_active
         
         group by service
 ) tmp
 on t.record_id = tmp.record_id
 
  ;
 >>

getBlockingHistoryForService() ::= <<
select

from

where blockable_id = :blockableId
and service = :service
and is_active


;
>>

unactiveEvent() ::= <<
update

set is_active = false
where id = :id

;
>>