/*
 * Copyright (c) 2018, 2021 Oracle and/or its affiliates. All rights reserved.
 *
 * This program and the accompanying materials are made available under the
 * terms of the Eclipse Public License v. 2.0 which is available at
 * http://www.eclipse.org/legal/epl-2.0,
 * or the Eclipse Distribution License v. 1.0 which is available at
 * http://www.eclipse.org/org/documents/edl-v10.php.
 *
 * SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause
 */

package jpql.query;

import java.sql.Date;
import jakarta.persistence.Entity;
import jakarta.persistence.Id;
import jakarta.persistence.NamedQueries;
import jakarta.persistence.NamedQuery;
import jakarta.persistence.OneToOne;

@Entity
@NamedQueries
({
    @NamedQuery(name="product.abs",      query="SELECT ABS(p.quantity) FROM Product p"),
    @NamedQuery(name="product.date",     query="SELECT DISTINCT p From Product p where p.shelfLife.soldDate NOT BETWEEN :date1 AND :newdate"),
    @NamedQuery(name="product.int1",     query="Select Distinct Object(p) from Product p where (p.quantity > (500 + :int1)) AND (p.partNumber IS NULL)"),
    @NamedQuery(name="product.max",      query="SELECT MAX(p.quantity) FROM Product p"),
    @NamedQuery(name="product.min",      query="SELECT MIN(p.quantity) FROM Product p"),
    @NamedQuery(name="product.null",     query="UPDATE Product AS p SET p.partNumber = NULL"),
    @NamedQuery(name="product.quantity", query="SELECT AVG(p.quantity) FROM Product p"),
    @NamedQuery(name="product.treat",    query="SELECT TREAT(TREAT(p.project LargeProject).parent AS LargeProject).endDate FROM Product p"),
    @NamedQuery(name="product.update1",  query="UPDATE Product SET shelfLife.soldDate = CURRENT_DATE WHERE shelfLife IS NOT NULL AND shelfLife.soldDate <> CURRENT_DATE"),
    @NamedQuery(name="product.update2",  query="UPDATE Product SET partNumber = CASE enumType WHEN com.titan.domain.EnumType.FIRST_NAME THEN '1' WHEN com.titan.domain.EnumType.LAST_NAME THEN '2' ELSE '3' END"),
    @NamedQuery(name="product.update3",  query="UPDATE Product SET partNumber = CASE TYPE(project) WHEN LargeProject THEN '2' WHEN SmallProject THEN '3' ELSE '4' END")
})
@SuppressWarnings("unused")
public class Product extends AbstractProduct {

    private static final long serialVersionUID = -4279004200805515912L;

    @Id
    private int id;
    @OneToOne
    private Project project;
    private int quantity;
    private Date releaseDate;
    private ShelfLife shelfLife;
    private EnumType enumType;
}