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

group AccountEmailSqlDao: EntitySqlDao;

tableName() ::= "account_emails"

historyTableName() ::= "account_email_history"

andCheckSoftDeletionWithComma(prefix) ::= "and is_active"

tableFields(prefix) ::= <<
  account_id
, email
, is_active
, created_by
, created_date
, updated_by
, updated_date
>>


tableValues() ::= <<
  :accountId
, :email
, :isActive
, :createdBy
, :createdDate
, :updatedBy
, :updatedDate
 >>

getEmailByAccountId() ::= <<
select
  
from  t
where t.account_id = :accountId
and t.is_active

;
>>

markEmailAsDeleted() ::= <<
update 
set is_active = false
where  = :id

;
>>