• Home
• org.kill-bill.billing
• killbill-subscription
• 0.18.0
• source code
• BundleSqlDao.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.subscription.engine.dao.BundleSqlDao.sql.stg Maven / Gradle / Ivy

group BundleSqlDao: EntitySqlDao;

tableName() ::= "bundles"


tableFields(prefix) ::= <<
  external_key
, account_id
, last_sys_update_date
, original_created_date
, created_by
, created_date
, updated_by
, updated_date
>>

tableValues() ::= <<
  :externalKey
, :accountId
, :lastSysUpdateDate
, :originalCreatedDate
, :createdBy
, :createdDate
, :updatedBy
, :updatedDate
>>

updateBundleLastSysTime()  ::= <<
update 
set
last_sys_update_date = :lastSysUpdateDate
, updated_by = :createdBy
, updated_date = :updatedDate
where id = :id

;
>>

updateBundleExternalKey()  ::= <<
update 
set
external_key = :externalKey
, updated_by = :createdBy
, updated_date = :updatedDate
where id = :id

;
>>

getBundlesForKey() ::= <<
select 
from bundles
where
external_key = :externalKey


;
>>

getBundlesFromAccountAndKey() ::= <<
select 
from bundles
where
external_key = :externalKey
and account_id = :accountId


;
>>

getBundleFromAccount() ::= <<
select 
from bundles
where
account_id = :accountId


;
>>

searchQuery(prefix) ::= <<
      = :searchKey
  or external_key = :searchKey
  or account_id = :searchKey
>>