lada/lada-server: src/main/java/de/intevation/lada/util/data/QueryBuilder.java annotate

annotate src/main/java/de/intevation/lada/util/data/QueryBuilder.java @ 1263:e36e42cbd1d8

Handle 'null' values in criteria queries.

author	Raimund Renkert <raimund.renkert@intevation.de>
date	Fri, 27 Jan 2017 15:11:50 +0100
parents	86ef81592f67
children

rev	line source
438 f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	1 /* Copyright (C) 2013 by Bundesamt fuer Strahlenschutz
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	2 * Software engineering by Intevation GmbH
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	3 *
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	4 * This file is Free Software under the GNU GPL (v>=3)
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	5 * and comes with ABSOLUTELY NO WARRANTY! Check out
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	6 * the documentation coming with IMIS-Labordaten-Application for details.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	7 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	8 package de.intevation.lada.util.data;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	9
788 7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	10 import java.util.ArrayList;
438 f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	11 import java.util.List;
788 7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	12 import java.util.Map;
438 f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	13
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	14 import javax.persistence.EntityManager;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	15 import javax.persistence.criteria.CriteriaBuilder;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	16 import javax.persistence.criteria.CriteriaQuery;
623 da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	17 import javax.persistence.criteria.Expression;
788 7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	18 import javax.persistence.criteria.Order;
438 f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	19 import javax.persistence.criteria.Path;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	20 import javax.persistence.criteria.Predicate;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	21 import javax.persistence.criteria.Root;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	22
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	23 /**
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	24 * @author <a href="mailto:rrenkert@intevation.de">Raimund Renkert</a>
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	25 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	26 public class QueryBuilder<T> {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	27
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	28 private EntityManager manager;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	29 private CriteriaBuilder builder;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	30 private CriteriaQuery<T> query;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	31 private Root<T> root;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	32 private Class<T> clazz;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	33 private Predicate filter;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	34
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	35 /**
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	36 * Create a new QueryBuilder for the specified class.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	37 *
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	38 * @param manager
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	39 * @param clazz
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	40 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	41 public QueryBuilder(EntityManager manager, Class<T> clazz) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	42 this.manager = manager;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	43 this.clazz = clazz;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	44 this.builder = this.manager.getCriteriaBuilder();
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	45 this.query = this.builder.createQuery(this.clazz);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	46 this.root = this.query.from(this.clazz);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	47 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	48
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	49 /**
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	50 * Get the criteria query build with this class.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	51 *
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	52 * @return The query.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	53 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	54 public CriteriaQuery<T> getQuery() {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	55 if (this.filter == null) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	56 this.query.where();
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	57 return this.query;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	58 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	59 this.query.where(this.filter);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	60 return this.query;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	61 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	62
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	63 /**
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	64 * Logical AND operation.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	65 *
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	66 * @param id The database column name.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	67 * @param value The filter value
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	68 * @return The builder itself.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	69 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	70 public QueryBuilder<T> and(String id, Object value) {
1263 e36e42cbd1d8 Handle 'null' values in criteria queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 1244 diff changeset	71 Predicate p;
e36e42cbd1d8 Handle 'null' values in criteria queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 1244 diff changeset	72 if (value == null) {
e36e42cbd1d8 Handle 'null' values in criteria queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 1244 diff changeset	73 p = this.builder.isNull(this.root.get(id));
e36e42cbd1d8 Handle 'null' values in criteria queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 1244 diff changeset	74 }
e36e42cbd1d8 Handle 'null' values in criteria queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 1244 diff changeset	75 else {
e36e42cbd1d8 Handle 'null' values in criteria queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 1244 diff changeset	76 p = this.builder.equal(this.root.get(id), value);
e36e42cbd1d8 Handle 'null' values in criteria queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 1244 diff changeset	77 }
438 f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	78 if (this.filter != null) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	79 this.filter = this.builder.and(this.filter, p);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	80 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	81 else {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	82 this.filter = this.builder.and(p);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	83 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	84 return this;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	85 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	86
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	87 /**
1244 86ef81592f67 Implement negation of query filter closer to underlying API. Tom Gottfried <tom@intevation.de> parents: 878 diff changeset	88 * Negate filter.
674 d61f5ded953d Added AND NOT to query builder. Raimund Renkert <raimund.renkert@intevation.de> parents: 623 diff changeset	89 *
d61f5ded953d Added AND NOT to query builder. Raimund Renkert <raimund.renkert@intevation.de> parents: 623 diff changeset	90 */
1244 86ef81592f67 Implement negation of query filter closer to underlying API. Tom Gottfried <tom@intevation.de> parents: 878 diff changeset	91 public QueryBuilder<T> not() {
86ef81592f67 Implement negation of query filter closer to underlying API. Tom Gottfried <tom@intevation.de> parents: 878 diff changeset	92 if (this.filter == null) {
86ef81592f67 Implement negation of query filter closer to underlying API. Tom Gottfried <tom@intevation.de> parents: 878 diff changeset	93 return this;
674 d61f5ded953d Added AND NOT to query builder. Raimund Renkert <raimund.renkert@intevation.de> parents: 623 diff changeset	94 }
1244 86ef81592f67 Implement negation of query filter closer to underlying API. Tom Gottfried <tom@intevation.de> parents: 878 diff changeset	95 this.filter = this.filter.not();
674 d61f5ded953d Added AND NOT to query builder. Raimund Renkert <raimund.renkert@intevation.de> parents: 623 diff changeset	96 return this;
d61f5ded953d Added AND NOT to query builder. Raimund Renkert <raimund.renkert@intevation.de> parents: 623 diff changeset	97 }
d61f5ded953d Added AND NOT to query builder. Raimund Renkert <raimund.renkert@intevation.de> parents: 623 diff changeset	98
d61f5ded953d Added AND NOT to query builder. Raimund Renkert <raimund.renkert@intevation.de> parents: 623 diff changeset	99 /**
438 f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	100 * Logical AND with like operation.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	101 *
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	102 * @param id The database column name.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	103 * @param value The filter value
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	104 * @return The builder itself.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	105 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	106 public QueryBuilder<T> andLike(String id, String value) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	107 Path<String> path = this.root.get(id);
708 e50c7f2f864d fixed lower case search field Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de> parents: 693 diff changeset	108 Predicate p = this.builder.like(this.builder.lower(path), value.toLowerCase());
438 f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	109 if (this.filter != null) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	110 this.filter = this.builder.and(this.filter, p);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	111 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	112 else {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	113 this.filter = this.builder.and(p);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	114 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	115 return this;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	116 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	117
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	118 /**
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	119 * Logical OR operation.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	120 *
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	121 * @param id The database column name
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	122 * @param value The filter value.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	123 * @return The builder itself.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	124 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	125 public QueryBuilder<T> or(String id, Object value) {
1263 e36e42cbd1d8 Handle 'null' values in criteria queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 1244 diff changeset	126 Predicate p;
e36e42cbd1d8 Handle 'null' values in criteria queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 1244 diff changeset	127 if (value == null) {
e36e42cbd1d8 Handle 'null' values in criteria queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 1244 diff changeset	128 p = this.builder.isNull(this.root.get(id));
e36e42cbd1d8 Handle 'null' values in criteria queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 1244 diff changeset	129 }
e36e42cbd1d8 Handle 'null' values in criteria queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 1244 diff changeset	130 else {
e36e42cbd1d8 Handle 'null' values in criteria queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 1244 diff changeset	131 p = this.builder.equal(this.root.get(id), value);
e36e42cbd1d8 Handle 'null' values in criteria queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 1244 diff changeset	132 }
438 f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	133 if (this.filter != null) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	134 this.filter = this.builder.or(this.filter, p);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	135 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	136 else {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	137 this.filter = this.builder.or(p);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	138 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	139 return this;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	140 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	141
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	142 /**
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	143 * Logical OR with like operation.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	144 *
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	145 * @param column The database column name.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	146 * @param value The filter value
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	147 * @return The builder itself.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	148 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	149 public QueryBuilder<T> orLike(String id, String value) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	150 Path<String> path = this.root.get(id);
708 e50c7f2f864d fixed lower case search field Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de> parents: 693 diff changeset	151 Predicate p = this.builder.like(this.builder.lower(path), value.toLowerCase());
438 f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	152 if (this.filter != null) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	153 this.filter = this.builder.or(this.filter, p);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	154 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	155 else {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	156 this.filter = this.builder.or(p);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	157 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	158 return this;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	159 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	160
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	161 /**
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	162 * Logical AND operation.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	163 * All elements in <i>values</i> will be concatenated with AND operator.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	164 *
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	165 * @param id The database column name.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	166 * @param values List of values.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	167 * @return The builder itself.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	168 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	169 public QueryBuilder<T> and(String id, List<String> values) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	170 for(String v: values) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	171 this.and(id, v);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	172 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	173 return this;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	174 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	175
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	176 /**
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	177 * Logical OR operation.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	178 * All elements in <i>values</i> will be concatenated with OR operator.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	179 *
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	180 * @param id The database column name.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	181 * @param values List of values.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	182 * @return The builder itself.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	183 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	184 public QueryBuilder<T> or(String id, List<String> values) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	185 for (String v: values) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	186 this.or(id, v);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	187 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	188 return this;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	189 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	190
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	191 /**
693 ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	192 * Logical OR operation.
ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	193 * All elements in <i>values</i> will be concatenated with OR operator.
ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	194 *
ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	195 * @param id The database column name.
ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	196 * @param values List of values.
ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	197 * @return The builder itself.
ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	198 */
ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	199 public QueryBuilder<T> orIntList(String id, List<Integer> values) {
ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	200 for (Integer v: values) {
ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	201 this.or(id, v);
ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	202 }
ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	203 return this;
ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	204 }
ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	205
ca536cd50120 Added logical or for integer lists. Raimund Renkert <raimund.renkert@intevation.de> parents: 674 diff changeset	206 /**
438 f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	207 * Logical AND operation.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	208 * The actually defined query will be concatenated with the query defined
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	209 * in the builder <i>b</i>.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	210 *
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	211 * @param b A builder.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	212 * @return The builder itself.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	213 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	214 public QueryBuilder<T> and(QueryBuilder<T> b) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	215 if (b == null \|\| b.filter == null) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	216 return this;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	217 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	218 if (this.filter != null) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	219 this.filter = this.builder.and(this.filter, b.filter);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	220 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	221 else {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	222 this.filter = this.builder.and(b.filter);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	223 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	224 return this;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	225 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	226
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	227 /**
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	228 * Logical OR operation.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	229 * The actually defined query will be concatenated with the query defined
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	230 * in the builder <i>b</i>.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	231 *
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	232 * @param b A builder.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	233 * @return The builder itself.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	234 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	235 public QueryBuilder<T> or(QueryBuilder<T> b) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	236 if (b == null \|\| b.filter == null) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	237 return this;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	238 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	239 if (this.filter != null) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	240 this.filter = this.builder.or(this.filter, b.filter);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	241 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	242 else {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	243 this.filter = this.builder.or(b.filter);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	244 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	245 return this;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	246 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	247
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	248 /**
623 da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	249 * IN operation combined as logical OR.
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	250 * Test whether result of 'key' is in a list of values.
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	251 *
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	252 * @param key The database column.
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	253 * @param values The list of values.
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	254 *
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	255 * @return The current Querybuilder.
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	256 */
878 9cf4b2ac3e2a Allow filtering of columns of any type with IN(). Tom Gottfried <tom@intevation.de> parents: 788 diff changeset	257 public <M> QueryBuilder<T> orIn(String key, List<M> values) {
9cf4b2ac3e2a Allow filtering of columns of any type with IN(). Tom Gottfried <tom@intevation.de> parents: 788 diff changeset	258 Expression<M> exp = this.root.get(key);
623 da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	259 Predicate p = exp.in(values);
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	260 if (this.filter == null) {
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	261 this.filter = this.builder.or(p);
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	262 }
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	263 else {
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	264 this.filter = this.builder.or(this.filter, p);
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	265 }
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	266 return this;
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	267 }
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	268
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	269 /**
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	270 * IN operation combined as logical AND.
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	271 * Test whether result of 'key' is in a list of values.
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	272 *
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	273 * @param key The database column.
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	274 * @param values The list of values.
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	275 *
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	276 * @return The current Querybuilder.
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	277 */
878 9cf4b2ac3e2a Allow filtering of columns of any type with IN(). Tom Gottfried <tom@intevation.de> parents: 788 diff changeset	278 public <M> QueryBuilder<T> andIn(String key, List<M> values) {
9cf4b2ac3e2a Allow filtering of columns of any type with IN(). Tom Gottfried <tom@intevation.de> parents: 788 diff changeset	279 Expression<M> exp = this.root.get(key);
623 da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	280 Predicate p = exp.in(values);
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	281 if (this.filter == null) {
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	282 this.filter = this.builder.and(p);
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	283 }
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	284 else {
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	285 this.filter = this.builder.and(this.filter, p);
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	286 }
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	287 return this;
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	288 }
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	289
da56b05604ae Added methods for sql 'IN' queries. Raimund Renkert <raimund.renkert@intevation.de> parents: 585 diff changeset	290 /**
438 f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	291 * Use 'distinct' in the query.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	292 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	293 public void distinct() {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	294 this.query.distinct(true);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	295 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	296
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	297 /**
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	298 * Order result by the specified column name
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	299 *
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	300 * @param id The column name.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	301 * @param asc Ascending(true), Descending(false).
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	302 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	303 public void orderBy(String id, boolean asc) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	304 if (asc) {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	305 this.query.orderBy(this.builder.asc(this.root.get(id)));
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	306 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	307 else {
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	308 this.query.orderBy(this.builder.desc(this.root.get(id)));
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	309 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	310 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	311
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	312 /**
788 7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	313 * Order result by the specified column name
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	314 *
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	315 * @param ids Map of column names and boolean for asc/desc.
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	316 */
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	317 public void orderBy(Map<String, Boolean> ids) {
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	318 List<Order> order = new ArrayList<Order>();
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	319 for (String id : ids.keySet()) {
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	320 if (ids.get(id)) {
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	321 order.add(this.builder.asc(this.root.get(id)));
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	322 }
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	323 else {
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	324 order.add(this.builder.desc(this.root.get(id)));
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	325 }
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	326 }
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	327 this.query.orderBy(order);
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	328 }
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	329
7133f6114920 Added 'order by' for multiple columns. Raimund Renkert <raimund.renkert@intevation.de> parents: 708 diff changeset	330 /**
438 f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	331 * Get an empty instance of this builder to create subfilters.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	332 *
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	333 * @return An empty instance of this builder.
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	334 */
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	335 public QueryBuilder<T> getEmptyBuilder(){
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	336 QueryBuilder<T> copy = new QueryBuilder<T>(manager, clazz);
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	337 copy.builder = this.builder;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	338 copy.root = this.root;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	339 return copy;
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	340 }
f0ad10e0e1b1 Moved Repositories, etc. into data package. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	341 }

Mercurial > lada > lada-server

annotate src/main/java/de/intevation/lada/util/data/QueryBuilder.java @ 1263:e36e42cbd1d8