• Home
• com.ning.billing
• killbill-payment
• 0.1.72
• source code
• PaymentMethodSqlDao.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.

com.ning.billing.payment.dao.PaymentMethodSqlDao.sql.stg Maven / Gradle / Ivy

group PaymentMethodSqlDao: EntitySqlDao;



tableName() ::= "payment_methods"

historyTableName() ::= "payment_method_history"

andCheckSoftDeletionWithComma(prefix) ::= "and is_active"

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

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


markPaymentMethodAsDeleted(id) ::= <<
update 
set is_active = 0
where  id = :id

;
>>

unmarkPaymentMethodAsDeleted(id) ::= <<
update 
set is_active = 1
where  id = :id

;
>>

getPaymentMethodIncludedDelete(accountId) ::= <<
select 
from 
where id = :id
;
>>

getByAccountId(accountId) ::= <<
select

from 
where account_id = :accountId
and is_active = 1
;
>>