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

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

tableName() ::= "payment_attempts"

historyTableName() ::= "payment_attempt_history"



tableFields(prefix) ::= <<
  account_id
, payment_method_id
, payment_external_key
, transaction_id
, transaction_external_key
, transaction_type
, state_name
, amount
, currency
, plugin_name
, plugin_properties
, created_by
, created_date
, updated_by
, updated_date
>>

tableValues() ::= <<
  :accountId
, :paymentMethodId
, :paymentExternalKey
, :transactionId
, :transactionExternalKey
, :transactionType
, :stateName
, :amount
, :currency
, :pluginName
, :pluginProperties
, :createdBy
, :createdDate
, :updatedBy
, :updatedDate
>>

getByTransactionExternalKey() ::= <<
select

from 
where transaction_external_key = :transactionExternalKey



;
>>

getByPaymentExternalKey() ::= <<
select

from 
where payment_external_key = :paymentExternalKey



;
>>

/* Does not include tenant info, global */
getByStateNameAcrossTenants(ordering) ::= <<
select

from 
where state_name = :stateName
and created_date \< :createdBeforeDate

order by  
limit :rowCount offset :offset
;
>>

getCountByStateNameAcrossTenants() ::= <<
select
count(1) as count
from 
where state_name = :stateName
and created_date \< :createdBeforeDate

;
>>

updateAttemptWithProperties() ::= <<
update 
set state_name = :stateName
, payment_method_id = :paymentMethodId
, transaction_id = :transactionId
, amount = :amount
, currency = :currency
, plugin_properties = :pluginProperties
, updated_by = :updatedBy
, updated_date = :updatedDate
where id = :id

;
>>