org.apache.deltaspike.data.api.Query Java Examples

private void initRequiresTransaction(RepositoryMethodMetadata repositoryMethodMetadata)
{
    boolean requiresTransaction = false;
    
    if (ClassUtils.containsMethod(EntityRepositoryHandler.class, repositoryMethodMetadata.getMethod()))
    {
        Method originalMethod = ClassUtils.extractMethod(EntityRepositoryHandler.class,
                repositoryMethodMetadata.getMethod());
        if (originalMethod.isAnnotationPresent(RequiresTransaction.class))
        {
            requiresTransaction = true;
        }
    }

    Query query = repositoryMethodMetadata.getQuery();
    Modifying modifying = repositoryMethodMetadata.getModifying();
    
    if ((query != null && !query.lock().equals(LockModeType.NONE)) || modifying != null)
    {
        requiresTransaction = true;
    }
    
    repositoryMethodMetadata.setRequiresTransaction(requiresTransaction);
}
 

/**
 * Calculate the total of revenues on a list of {@link FinancialPeriod}
 *
 * @return the total value of revenues
 */
@Query("SELECT COALESCE(SUM(pm.paidValue), 0) " +
        "FROM PeriodMovement mv " +
        "INNER JOIN Payment pm ON pm.id = mv.payment.id " +
        "INNER JOIN Apportionment ap on ap.movement = mv.id " +
        "INNER JOIN MovementClass mc on mc.id = ap.movementClass.id " +
        "AND mc.movementClassType = 'REVENUE' " +
        "AND mv.periodMovementState <> 'OPEN'")
BigDecimal calculateTotalRevenues();
 

/**
 * Same as {@link #calculateTotalOpen()} but filtering by {@link FinancialPeriod}
 *
 * @param periods the list of {@link FinancialPeriod} to search for
 * @return the total value of open {@link PeriodMovement}
 */
@Query("SELECT COALESCE(SUM(mv.value), 0) " +
        "FROM PeriodMovement mv " +
        "INNER JOIN FinancialPeriod fp ON fp.id = mv.financialPeriod.id " +
        "AND fp.id IN (?1) " +
        "AND mv.periodMovementState = 'OPEN'")
BigDecimal calculateTotalOpen(List<Long> periods);
 

/**
 * Same as {@link #calculateTotalRevenues()} but filtering by {@link FinancialPeriod}
 *
 * @param periods the list of {@link FinancialPeriod} to search for
 * @return the total value of revenues
 */
@Query("SELECT COALESCE(SUM(pm.paidValue), 0) " +
        "FROM PeriodMovement mv " +
        "INNER JOIN FinancialPeriod fp ON fp.id = mv.financialPeriod.id " +
        "INNER JOIN Payment pm ON pm.id = mv.payment.id " +
        "INNER JOIN Apportionment ap on ap.movement = mv.id " +
        "INNER JOIN MovementClass mc on mc.id = ap.movementClass.id " +
        "AND fp.id IN (?1) " +
        "AND mc.movementClassType = 'REVENUE' " +
        "AND mv.periodMovementState <> 'OPEN'")
BigDecimal calculateTotalRevenues(List<Long> periods);
 

/**
 * Calculate the total of revenues on a list of {@link FinancialPeriod}
 *
 * @return the total value of revenues
 */
@Query("SELECT COALESCE(SUM(pm.paidValue), 0) " +
        "FROM PeriodMovement mv " +
        "INNER JOIN Payment pm ON pm.id = mv.payment.id " +
        "INNER JOIN Apportionment ap on ap.movement = mv.id " +
        "INNER JOIN MovementClass mc on mc.id = ap.movementClass.id " +
        "AND mc.movementClassType = 'REVENUE' " +
        "AND mv.periodMovementState <> 'OPEN'")
BigDecimal calculateTotalRevenues();
 

@Override
public Object execute(CdiQueryInvocationContext context)
{
    Method method = context.getMethod();
    Query query = method.getAnnotation(Query.class);
    javax.persistence.Query jpaQuery = createJpaQuery(query, context);
    return context.executeQuery(jpaQuery);
}
 

/**
 * Calculate the total of expenses on a list of {@link FinancialPeriod}
 *
 * @return the total value of expenses
 */
@Query("SELECT COALESCE(SUM(pm.paidValue), 0) " +
        "FROM PeriodMovement mv " +
        "INNER JOIN Payment pm ON pm.id = mv.payment.id " +
        "INNER JOIN Apportionment ap on ap.movement = mv.id " +
        "INNER JOIN MovementClass mc on mc.id = ap.movementClass.id " +
        "AND pm.paymentMethod <> 'CREDIT_CARD' " +
        "AND mc.movementClassType = 'EXPENSE' " +
        "AND mv.periodMovementState <> 'OPEN'")
BigDecimal calculateTotalExpenses();
 

/**
 * Calculate the total of expenses on a list of {@link FinancialPeriod}
 *
 * @return the total value of expenses
 */
@Query("SELECT COALESCE(SUM(pm.paidValue), 0) " +
        "FROM PeriodMovement mv " +
        "INNER JOIN Payment pm ON pm.id = mv.payment.id " +
        "INNER JOIN Apportionment ap on ap.movement = mv.id " +
        "INNER JOIN MovementClass mc on mc.id = ap.movementClass.id " +
        "AND pm.paymentMethod <> 'CREDIT_CARD' " +
        "AND mc.movementClassType = 'EXPENSE' " +
        "AND mv.periodMovementState <> 'OPEN'")
BigDecimal calculateTotalExpenses();
 

/**
 * Same as {@link #calculateTotalExpenses()} but filtering by {@link FinancialPeriod}
 *
 * @param periods the list of {@link FinancialPeriod} to search for
 * @return the total value of expenses
 */
@Query("SELECT COALESCE(SUM(pm.paidValue), 0) " +
        "FROM PeriodMovement mv " +
        "INNER JOIN FinancialPeriod fp ON fp.id = mv.financialPeriod.id " +
        "INNER JOIN Payment pm ON pm.id = mv.payment.id " +
        "INNER JOIN Apportionment ap on ap.movement = mv.id " +
        "INNER JOIN MovementClass mc on mc.id = ap.movementClass.id " +
        "AND fp.id IN (?1) " +
        "AND pm.paymentMethod <> 'CREDIT_CARD' " +
        "AND mc.movementClassType = 'EXPENSE' " +
        "AND mv.periodMovementState <> 'OPEN'")
BigDecimal calculateTotalExpenses(List<Long> periods);
 

/**
 * Same as {@link #calculateTotalPaidAndReceived()} but filtering by {@link FinancialPeriod}
 *
 * @param periods the list of {@link FinancialPeriod} to search for
 * @return the total value of paid and received {@link PeriodMovement}
 */
@Query("SELECT COALESCE(SUM(pm.paidValue), 0) " +
        "FROM PeriodMovement mv " +
        "INNER JOIN FinancialPeriod fp ON fp.id = mv.financialPeriod.id " +
        "INNER JOIN Payment pm ON pm.id = mv.payment.id " +
        "AND fp.id IN (?1) " +
        "AND pm.paymentMethod <> 'CREDIT_CARD' " +
        "AND mv.periodMovementState <> 'OPEN'")
BigDecimal calculateTotalPaidAndReceived(List<Long> periods);
 

/**
 * Calculate the total of paid or received {@link PeriodMovement} on a list of {@link FinancialPeriod}
 *
 * @return the total value of paid and received {@link PeriodMovement}
 */
@Query("SELECT COALESCE(SUM(pm.paidValue), 0) " +
        "FROM PeriodMovement mv " +
        "INNER JOIN Payment pm ON pm.id = mv.payment.id " +
        "AND pm.paymentMethod <> 'CREDIT_CARD' " +
        "AND mv.periodMovementState <> 'OPEN'")
BigDecimal calculateTotalPaidAndReceived();
 

/**
 * Same as {@link #calculateTotalRevenues()} but filtering by {@link FinancialPeriod}
 *
 * @param periods the list of {@link FinancialPeriod} to search for
 * @return the total value of revenues
 */
@Query("SELECT COALESCE(SUM(pm.paidValue), 0) " +
        "FROM PeriodMovement mv " +
        "INNER JOIN FinancialPeriod fp ON fp.id = mv.financialPeriod.id " +
        "INNER JOIN Payment pm ON pm.id = mv.payment.id " +
        "INNER JOIN Apportionment ap on ap.movement = mv.id " +
        "INNER JOIN MovementClass mc on mc.id = ap.movementClass.id " +
        "AND fp.id IN (?1) " +
        "AND mc.movementClassType = 'REVENUE' " +
        "AND mv.periodMovementState <> 'OPEN'")
BigDecimal calculateTotalRevenues(List<Long> periods);
 

/**
 * Same as {@link #calculateTotalPaidAndReceived()} but filtering by {@link FinancialPeriod}
 *
 * @param periods the list of {@link FinancialPeriod} to search for
 * @return the total value of paid and received {@link PeriodMovement}
 */
@Query("SELECT COALESCE(SUM(pm.paidValue), 0) " +
        "FROM PeriodMovement mv " +
        "INNER JOIN FinancialPeriod fp ON fp.id = mv.financialPeriod.id " +
        "INNER JOIN Payment pm ON pm.id = mv.payment.id " +
        "AND fp.id IN (?1) " +
        "AND pm.paymentMethod <> 'CREDIT_CARD' " +
        "AND mv.periodMovementState <> 'OPEN'")
BigDecimal calculateTotalPaidAndReceived(List<Long> periods);
 

/**
 * Method to count how much {@link Launch} we have for a given {@link FixedMovement} at open {@link FinancialPeriod}
 *
 * @param fixedMovement to search for {@link Launch}
 * @return the total of {@link Launch} found for this {@link FixedMovement}
 */
@Query("SELECT COUNT(*) " +
        "FROM Launch la " +
        "WHERE la.fixedMovement = ?1 " +
        "AND la.financialPeriod.id IN " +
        "   (SELECT fp.id FROM FinancialPeriod fp WHERE fp.closed = false AND fp.expired = false)")
long countByFixedMovementAtCurrentFinancialPeriod(FixedMovement fixedMovement);
 

/**
 * Calculate the total of paid or received {@link PeriodMovement} on a list of {@link FinancialPeriod}
 *
 * @return the total value of paid and received {@link PeriodMovement}
 */
@Query("SELECT COALESCE(SUM(pm.paidValue), 0) " +
        "FROM PeriodMovement mv " +
        "INNER JOIN Payment pm ON pm.id = mv.payment.id " +
        "AND pm.paymentMethod <> 'CREDIT_CARD' " +
        "AND mv.periodMovementState <> 'OPEN'")
BigDecimal calculateTotalPaidAndReceived();
 

@Query(named = Simple.BY_NAME_LIKE, singleResult = OPTIONAL)
public abstract Simple findByNameOptional(String name);
 

@Query(lock = PESSIMISTIC_READ)
Simple findByName(String name);
 

@Query("select s from Simple s where s.name = ?1 order by s.counter desc")
public abstract QueryResult<Simple> findByQueryWithOrderBy(String name);
 

@Query(lock = PESSIMISTIC_READ)
public abstract Simple findByName(String name);
 

@Modifying @Query("delete from Simple")
int deleteAll();
 

@Query("from Member m order by m.name")
public abstract List<Member> findAllOrderedByName();
 

@Query("SELECT s FROM Simple s WHERE s.name = ?1")
List<Simple> findByName2(String name);
 

@Query(named = Simple.BY_NAME_LIKE)
Simple findByNameNoLock(String name);
 

@Query(lock = PESSIMISTIC_READ)
Simple findByName(String name);
 

@Query(named = SimpleStringId.FIND_ALL_ORDER_BY_ID)
public abstract QueryResult<SimpleStringId> findAllOrderByIdPaginate(@FirstResult int start, @MaxResults int pageSize);
 

@Query("select h from House h where h.name = ?1")
@EntityGraph(paths = {"flats.tenants", "garages"})
House fetchByNameWithFlatTenants(String name);
 

@Query("select h from House h where h.name = ?1")
@EntityGraph(paths = {"flats", "garages"})
House fetchByNameWithDynamicGraph(String name);
 

@Query("select h from House h where h.name = ?1")
@EntityGraph("none")
House fetchByNameWithInvalidGraph(String name);
 

@Query("select h from House h where h.name = ?1")
@EntityGraph("withFlats")
House fetchByName(String name);
 

@Query("SELECT d FROM Depositor d WHERE d.name=:name")
List<Depositor> findByName(@QueryParam("name") String name);