org.cyclos.impl.sql

Interface NativeQueryHandler

All Superinterfaces:

org.cyclos.impl.CustomBean

public interface NativeQueryHandler
extends org.cyclos.impl.CustomBean

Single place which contains the native queries

Author:

luis

Method Summary

Methods

Modifier and Type	Method and Description
org.cyclos.impl.locks.Lock	createLock(org.cyclos.impl.locks.LockType type, java.lang.Long id, long timeoutMillis) Creates a database lock for the given type and entity identifier, waiting the maximum time as the given timeout in millis
org.cyclos.impl.banking.NativeAccountStatus	getAccountStatus(Account account, java.util.Date date) Returns the native account status at a given date
com.mysema.query.jpa.JPQLTemplates	getJpaQueryTemplates() Returns the templates used for jpa queries
long	insertAccountsPendingToCharge(AccountFeeLog log) Inserts the references for the accounts pending to charge the given account fee log
long	insertMailings(MailingList mailingList) Inserts mailings for all users for a given mailing list message
void	insertTransferInitialStatus(TransferType transferType, TransferStatus status) Inserts the relation for current status and a log for each transfer of the given type
void	insertUserIncomingMessages(SendMessageDTO sendMessage, MessageOwner messageOwner, User sendingUser, OutgoingMessage outgoing) Inserts incoming messages for users for a given outgoing message
com.mysema.commons.lang.CloseableIterator<java.lang.Long>	iterateUserIds(UserQuery query) Iterates user ids according to the given query parameters
com.mysema.commons.lang.CloseableIterator<User>	iterateUsers(UserQuery query) Iterates user entities according to the given query parameters
java.util.List<java.lang.Long>	nextAccountIdsToClose(int maxCount, java.util.Date limit, int paymentsThreshold) Returns up to the maximum count of account ids to close balance, limiting to accounts which have been closed at most at the given date, and having at minimum the given number of payments pending closing
void	reindexTranslations() Reindex translation files, allowing searching for keys which are not customized
void	removeFromContacts(User user) Removes all rows in the contacts relation where the given user is on either side
Page<BasicAdVO>	searchAds(BasicAdQuery params) Searches for advertisement according to the given query
Page<Record>	searchRecords(RecordQuery params) Searches for user records according to the given query parameters
Page<TranslationKeyVO>	searchTranslationKeys(TranslationQuery params) Searches for translation keys according o the given query parameters
Page<UserDetailedVO>	searchUsers(UserQuery query) Searches for users according to the given query parameters
UsersWithBalancesResult	searchUsersWithBalance(UserWithBalanceQuery params) Searches for users including the account balance, according to the given query parameters

Method Detail

createLock

org.cyclos.impl.locks.Lock createLock(org.cyclos.impl.locks.LockType type,
                                    java.lang.Long id,
                                    long timeoutMillis)
                                      throws LockAcquisitionException

Creates a database lock for the given type and entity identifier, waiting the maximum time as the given timeout in millis

Throws:

LockAcquisitionException

getAccountStatus

org.cyclos.impl.banking.NativeAccountStatus getAccountStatus(Account account,
                                                           java.util.Date date)

Returns the native account status at a given date

getJpaQueryTemplates

com.mysema.query.jpa.JPQLTemplates getJpaQueryTemplates()

Returns the templates used for jpa queries

insertAccountsPendingToCharge

long insertAccountsPendingToCharge(AccountFeeLog log)

Inserts the references for the accounts pending to charge the given account fee log

insertMailings

long insertMailings(MailingList mailingList)

Inserts mailings for all users for a given mailing list message

Returns:

the quantity of users that the mailing list is sending

insertTransferInitialStatus

void insertTransferInitialStatus(TransferType transferType,
                               TransferStatus status)

Inserts the relation for current status and a log for each transfer of the given type

insertUserIncomingMessages

void insertUserIncomingMessages(SendMessageDTO sendMessage,
                              MessageOwner messageOwner,
                              User sendingUser,
                              OutgoingMessage outgoing)

Inserts incoming messages for users for a given outgoing message

iterateUserIds

com.mysema.commons.lang.CloseableIterator<java.lang.Long> iterateUserIds(UserQuery query)

Iterates user ids according to the given query parameters

iterateUsers

com.mysema.commons.lang.CloseableIterator<User> iterateUsers(UserQuery query)

Iterates user entities according to the given query parameters

nextAccountIdsToClose

java.util.List<java.lang.Long> nextAccountIdsToClose(int maxCount,
                                                   java.util.Date limit,
                                                   int paymentsThreshold)

Returns up to the maximum count of account ids to close balance, limiting to accounts which have been closed at most at the given date, and having at minimum the given number of payments pending closing

reindexTranslations

void reindexTranslations()

Reindex translation files, allowing searching for keys which are not customized

removeFromContacts

void removeFromContacts(User user)

Removes all rows in the contacts relation where the given user is on either side

searchAds

Page<BasicAdVO> searchAds(BasicAdQuery params)

Searches for advertisement according to the given query

searchRecords

Page<Record> searchRecords(RecordQuery params)

Searches for user records according to the given query parameters

searchTranslationKeys

Page<TranslationKeyVO> searchTranslationKeys(TranslationQuery params)

Searches for translation keys according o the given query parameters

searchUsers

Page<UserDetailedVO> searchUsers(UserQuery query)

Searches for users according to the given query parameters

searchUsersWithBalance

UsersWithBalancesResult searchUsersWithBalance(UserWithBalanceQuery params)

Searches for users including the account balance, according to the given query parameters