/*******************************************************************************
 * Copyright (c) 2010 Oracle. All rights reserved.
 * This program and the accompanying materials are made available under the 
 * terms of the Eclipse Public License v1.0 and Eclipse Distribution License v. 1.0 
 * which accompanies this distribution. 
 * The Eclipse Public License is available at http://www.eclipse.org/legal/epl-v10.html
 * and the Eclipse Distribution License is available at 
 * http://www.eclipse.org/org/documents/edl-v10.php.
 *
 * Contributors:
 *     10/15/2010-2.2 Guy Pelletier 
 *       - 322008: Improve usability of additional criteria applied to queries at the session/EM
 ******************************************************************************/  
package org.eclipse.persistence.testing.models.jpa.advanced.additionalcriteria;

import java.util.ArrayList;
import java.util.List;

import javax.persistence.Basic;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.NamedNativeQuery;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

import org.eclipse.persistence.annotations.AdditionalCriteria;

import static javax.persistence.CascadeType.PERSIST;

@Entity
@Table(name="JPA_AC_SCHOOL")
@AdditionalCriteria("this.name LIKE 'Ottawa%'")
// A named native query will not append the additional criteria.
@NamedNativeQuery(
    name="findAllSQLSchools", 
    query="select * from JPA_AC_SCHOOL",
    resultClass=org.eclipse.persistence.testing.models.jpa.advanced.additionalcriteria.School.class
)
@NamedQuery(
    name="findJPQLSchools", 
    query="SELECT s from School s"
)
public class School {
    @Id
    @GeneratedValue(generator="AC_SCHOOL_SEQ")
    @SequenceGenerator(name="AC_SCHOOL_SEQ", allocationSize=25)
    public Integer id;
    
    @Basic
    public String name;
    
    @OneToMany(mappedBy="school", cascade=PERSIST)
    public List<Student> students;

    public School() {
        students = new ArrayList<Student>();
    }
    
    public void addStudent(Student student) {
        students.add(student);
        student.setSchool(this);
    }
    
    public Integer getId() {
        return id;
    }
    
    public String getName() {
        return name;
    }
    
    public List<Student> getStudents() {
        return students;
    }

    public void setId(Integer id) {
        this.id = id;
    }
    
    public void setName(String name) {
        this.name = name;
    }

    public void setStudents(List<Student> students) {
        this.students = students;
    }
}