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

group TenantKVSqlDao: EntitySqlDao;

tableName() ::= "tenant_kvs"

andCheckSoftDeletionWithComma(prefix) ::= "and is_active"

tableFields(prefix) ::= <<
  tenant_key
, tenant_value
, is_active
, created_date
, created_by
, updated_date
, updated_by
>>

tableValues() ::= <<
  :tenantKey
, :tenantValue
, :isActive
, :createdDate
, :createdBy
, :updatedDate
, :updatedBy
>>

accountRecordIdFieldWithComma(prefix) ::= ""

accountRecordIdValueWithComma() ::= ""


getTenantValueForKey() ::= <<
select
  
from  t
where t.tenant_key = :tenantKey
and  t.is_active


;
>>

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

;
>>


updateTenantValueKey() ::= <<
update 
set tenant_value = :tenantValue
where id = :id

;
>>