• Home
• com.ning.billing.commons
• killbill-queue
• 0.2.8
• source code
• NotificationSqlDao.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.notificationq.dao.NotificationSqlDao.sql.stg Maven / Gradle / Ivy

group NotificationSqlDao: BaseSqlDao;

extraFieldsWithComma() ::= <<
      , future_user_token
      , effective_date
      , queue_name
>>


extraValuesWithComma() ::= <<
      , :futureUserToken
      , :effectiveDate
      , :queueName
>>

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

readyOrderByClause() ::= <<
        effective_date asc
      , created_date asc
      , record_id
>>

/** Notifications specific queries **/
getReadyQueueEntriesForSearchKey(tableName, searchKey) ::= <<
    select
      
    from 
    where
      queue_name = :queueName
      and processing_state = 'AVAILABLE'
      and  = :searchKey
    order by
      
;
>>


/** Notifications specific queries **/
getCountReadyEntries(tableName, searchKey) ::= <<
    select
     count(*)
    from 
    where
      processing_state = 'AVAILABLE'
      and effective_date \<= :now
      and  = :searchKey
;
>>