org.killbill.bus.dao.PersistentBusSqlDao.sql.stg Maven / Gradle / Ivy

Go to download
group PersistentBusSqlDao: BaseSqlDao;

extraFieldsWithComma() ::= <<
>>


extraValuesWithComma() ::= <<
>>

readyWhereClause(owner) ::= <<
    processing_state != 'PROCESSED'
    and processing_state != 'REMOVED'
and creating_owner = ''
    and (processing_owner IS NULL OR processing_available_date \<= :now)
>>

readyOrderByClause() ::= <<
    record_id asc
>>

/** Bus Events specific queries **/
getReadyQueueEntriesForSearchKeys(tableName) ::= <<
    select
      
    from 
    where
          processing_state = 'AVAILABLE'
      and search_key1 = :searchKey1
      and search_key2 = :searchKey2
    order by
      
;
>>

getReadyQueueEntriesForSearchKey2(tableName) ::= <<
    select
      
    from 
    where
          processing_state = 'AVAILABLE'
      and search_key2 = :searchKey2
    order by
      
;
>>

getReadyOrInProcessingQueueEntriesForSearchKeys(tableName) ::= <<
    select
      
    from 
    where
          processing_state in ('AVAILABLE', 'IN_PROCESSING')
      and search_key1 = :searchKey1
      and search_key2 = :searchKey2
    order by
      
;
>>

getReadyOrInProcessingQueueEntriesForSearchKey2(tableName) ::= <<
    select
      
    from 
    where
          processing_state in ('AVAILABLE', 'IN_PROCESSING')
      and search_key2 = :searchKey2
    order by
      
;
>>