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() {
        return this.sql;
    }

    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;
    }
}