Package com.mysema.query.types.expr

Examples of com.mysema.query.types.expr.BooleanExpression

100
101
102
103
104
105
106
107
108
109
  }

  @Override
  public BigDecimal sumResolvedAmountByAccountIdAndYearMonthAndSign(Integer accountId, YearMonth yearMonth, OperationSign sign) {

    BooleanExpression predicate = operation.account.id.eq(accountId).and(buildOperationSignPredicate(sign)).and(operation.status.id.eq(OperationStatus.RESOLVED));
    predicate = addOperationYearMonthExpression(predicate, operation, yearMonth);

    return from(operation).where(predicate).uniqueResult(operation.amount.sum());
  }
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
  }

  @Override
  public Page<Operation> findCardOperationsByAccountIdAndYearMonthAndStatus(Integer accountId, YearMonth yearMonth, OperationStatus status, Pageable pageable) {

    BooleanExpression predicate = operation.type.id.eq(OperationType.CARD).and(operation.account.id.eq(accountId)).and(operation.status.id.eq(status));
    predicate = addOperationYearMonthExpression(predicate, operation, yearMonth);

    JPQLQuery countQuery = from(operation).where(predicate);
    JPQLQuery query = applyPagination(from(operation).where(predicate).orderBy(operation.date.desc()), pageable);
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
  }

  @Override
  public BigDecimal sumCardAmountByAccountIdAndYearMonthAndSignAndStatus(Integer accountId, YearMonth yearMonth, OperationSign sign, OperationStatus status) {

    BooleanExpression predicate = operation.type.id.eq(OperationType.CARD).and(operation.account.id.eq(accountId)).and(buildOperationSignPredicate(sign))
        .and(operation.status.id.eq(status));
    predicate = addOperationYearMonthExpression(predicate, operation, yearMonth);

    return from(operation).where(predicate).uniqueResult(operation.amount.sum());
  }
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
  }

  @Override
  public Page<Operation> findCardOperationsByCardIdAndYearMonthAndStatus(Integer cardId, YearMonth yearMonth, OperationStatus status, Pageable pageable) {

    BooleanExpression predicate = operation.type.id.eq(OperationType.CARD).and(operation.card.id.eq(cardId)).and(operation.status.id.eq(status));
    predicate = addOperationYearMonthExpression(predicate, operation, yearMonth);

    JPQLQuery countQuery = from(operation).where(predicate);
    JPQLQuery query = applyPagination(from(operation).where(predicate).orderBy(operation.date.desc()), pageable);
View Full Code Here
143
144
145
146
147
148
149
150
151
152
153
  }

  @Override
  public BigDecimal sumCardAmountByCardIdAndYearMonthAndSignAndStatus(Integer cardId, YearMonth yearMonth, OperationSign sign, OperationStatus status) {

    BooleanExpression predicate = operation.type.id.eq(OperationType.CARD).and(operation.card.id.eq(cardId)).and(buildOperationSignPredicate(sign))
        .and(operation.status.id.eq(status));
    predicate = addOperationYearMonthExpression(predicate, operation, yearMonth);

    return from(operation).where(predicate).uniqueResult(operation.amount.sum());
  }
View Full Code Here
153
154
155
156
157
158
159
160
161
162
163
  }

  @Override
  public Page<Operation> findTransferByAccountId(Integer accountId, Pageable pageable) {

    BooleanExpression predicate = operation.type.id.eq(OperationType.TRANSFER).and(operation.account.id.eq(accountId));

    JPQLQuery countQuery = from(operation).where(predicate);
    JPQLQuery query = applyPagination(from(operation).where(predicate).orderBy(operation.date.desc()), pageable);

    return buildPage(countQuery, query, pageable);
View Full Code Here
63
64
65
66
67
68
69
70
        assertTrue(query().where(user.emailAddress.eq("bobby@example.com")).notExists());
    }

    @Test
    public void Count() {
        BooleanExpression filter = user.emailAddress.eq("bob@example.com");
        assertEquals(1, query().where(filter).count());
    }
View Full Code Here
69
70
71
72
73
74
75
76
77
78
        assertEquals(1, query().where(filter).count());
    }

    @Test
    public void UniqueResult() {
        BooleanExpression filter = user.emailAddress.eq("bob@example.com");
        User u = query().where(filter).uniqueResult();
        assertNotNull(u);
        assertEquals("bob@example.com", u.getEmailAddress());
    }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
        assertEquals("bob@example.com", u.getEmailAddress());
    }

    @Test
    public void List() {
        BooleanExpression filter = user.emailAddress.eq("bob@example.com");
        List<User> list = query().where(filter).list();
        assertEquals(1, list.size());
        User u = query().where(filter).uniqueResult();
        assertEquals(u, list.get(0));
    }
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
        assertNotNull(query().where(user.middleName.eq("X")).singleResult());
    }

    @Test
    public void Ordering() {
        BooleanExpression filter = user.middleName.eq("X");
        // asc
        List<String> asc = getFirstNames(query().where(filter).orderBy(
                user.firstName.asc()).list());
        assertEquals(Arrays.asList("Anton", "Barbara", "John", "Robert"), asc);
View Full Code Here
TOP

Related Classes of com.mysema.query.types.expr.BooleanExpression

  • $.BaseService
  • com.excilys.ebi.bank.dao.impl.OperationDaoImpl
  • com.mysema.query.domain.AnyUsageTest
  • com.mysema.query.domain.ExpressionTest
  • com.mysema.query.hibernate.search.SearchQueryTest
  • com.mysema.query.jdo.JDOSQLQueryTest
  • com.mysema.query.JPABase
  • com.mysema.query.LuceneSerializerTest
  • com.mysema.query.PrecedenceTest
  • com.mysema.query.sql.RelationalPathBase
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.