/*
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 */
package org.apache.openjpa.jdbc.procedure.entity;

import javax.persistence.Entity;
import javax.persistence.EntityResult;
import javax.persistence.Id;
import javax.persistence.NamedStoredProcedureQueries;
import javax.persistence.NamedStoredProcedureQuery;
import javax.persistence.SqlResultSetMapping;
import javax.persistence.SqlResultSetMappings;
import javax.persistence.StoredProcedureParameter;

import static javax.persistence.ParameterMode.INOUT;
import static javax.persistence.ParameterMode.OUT;

@Entity
@NamedStoredProcedureQueries({
        @NamedStoredProcedureQuery(
                name = "EntityWithStoredProcedure.simple",
                procedureName = "TESTSIMPLE"
        ),
        @NamedStoredProcedureQuery(
                name = "EntityWithStoredProcedure.inParams",
                procedureName = "TESTINS",
                parameters = {
                        @StoredProcedureParameter(name = "SOME_NUMBER", type = Integer.class),
                        @StoredProcedureParameter(name = "SOME_STRING", type = String.class)
                }
        ),
        @NamedStoredProcedureQuery(
                name = "EntityWithStoredProcedure.x2",
                procedureName = "XTWO",
                parameters = {
                        @StoredProcedureParameter(name = "SOME_NUMBER", type = Integer.class),
                        @StoredProcedureParameter(name = "RESULT", type = Integer.class, mode = OUT)
                }
        ),
        @NamedStoredProcedureQuery(
                name = "EntityWithStoredProcedure.inout",
                procedureName = "XINOUT",
                parameters = {
                        @StoredProcedureParameter(name = "P", type = Integer.class, mode = INOUT)
                }
        ),
        @NamedStoredProcedureQuery(
                name = "EntityWithStoredProcedure.mapping",
                procedureName = "MAPPING",
                resultSetMappings = {"mapping1", "mapping2"}
        )
})
@SqlResultSetMappings({
        @SqlResultSetMapping(
                name = "mapping1",
                entities = @EntityResult(entityClass = EntityWithStoredProcedure.class)
        ),
        @SqlResultSetMapping(
                name = "mapping2",
                entities = @EntityResult(entityClass = EntityWithStoredProcedure.Mapping2.class)
        )
})
public class EntityWithStoredProcedure {
    @Id
    private long id;
    private String name;

    public EntityWithStoredProcedure() {
        // no-op
    }

    public EntityWithStoredProcedure(final long id, final String name) {
        this.id = id;
        this.name = name;
    }

    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

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

    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;
        EntityWithStoredProcedure that = (EntityWithStoredProcedure) o;
        return id == that.id && name.equals(that.name);
    }

    @Override
    public int hashCode() {
        int result = (int) (id ^ (id >>> 32));
        result = 31 * result + name.hashCode();
        return result;
    }

    @Entity
    public static class Mapping2 {
        @Id
        private long id;
        private String name;

        public long getId() {
            return id;
        }

        public void setId(long id) {
            this.id = id;
        }

        public String getName() {
            return name;
        }

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