Mercurial > lada > lada-server
view src/main/java/de/intevation/lada/model/stammdaten/Query.java @ 1255:c0db68c9a87d
enable new-line in sql text of queries
author | Michael Stanko <mstanko@bfs.de> |
---|---|
date | Wed, 04 Jan 2017 15:36:47 +0100 |
parents | 186d602e031a |
children |
line wrap: on
line source
package de.intevation.lada.model.stammdaten; import java.io.Serializable; import java.util.List; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.ManyToOne; import javax.persistence.OneToMany; import javax.persistence.OrderBy; import javax.persistence.Transient; import com.fasterxml.jackson.annotation.JsonIgnore; /** * The persistent class for the query database table. * */ @Entity public class Query implements Serializable { private static final long serialVersionUID = 1L; @Id private Integer id; private String description; private String name; private String sql; @ManyToOne @JoinColumn(name="type", insertable=false, updatable=false) private QueryType type; @Column(name="type") private Integer typeId; @Transient private Boolean favorite; //bi-directional many-to-one association to Filter @OneToMany(fetch=FetchType.EAGER, mappedBy="query") private List<Filter> filters; //bi-directional many-to-one association to Result @OneToMany(fetch=FetchType.EAGER, mappedBy="query") @OrderBy("index") private List<Result> results; public Query() { } public Integer getId() { return this.id; } public void setId(Integer id) { this.id = id; } public String getDescription() { return this.description; } public void setDescription(String description) { this.description = description; } public String getName() { return this.name; } public void setName(String name) { this.name = name; } public String getSql() { // remove \r and \n from sql text return this.sql.replaceAll("(\r\n|\n)", " "); } public void setSql(String sql) { this.sql = sql; } public String getType() { return this.type.getType(); } /** * @return the typeId */ @JsonIgnore public Integer getTypeId() { return typeId; } /** * @param typeId the typeId to set */ @JsonIgnore public void setTypeId(Integer typeId) { this.typeId = typeId; } /** * @return the favorite */ public Boolean getFavorite() { return favorite; } /** * @param favorite the favorite to set */ public void setFavorite(Boolean favorite) { this.favorite = favorite; } public List<Filter> getFilters() { return this.filters; } public void setFilters(List<Filter> filters) { this.filters = filters; } public Filter addFilter(Filter filter) { getFilters().add(filter); filter.setQuery(this); return filter; } public Filter removeFilter(Filter filter) { getFilters().remove(filter); filter.setQuery(null); return filter; } public List<Result> getResults() { return this.results; } public void setResults(List<Result> results) { this.results = results; } public Result addResult(Result result) { getResults().add(result); result.setQuery(this); return result; } public Result removeResult(Result result) { getResults().remove(result); result.setQuery(null); return result; } }