/*
 * Copyright (c) 2018, 2021 Oracle and/or its affiliates. All rights reserved.
 * Copyright (c) 2018, 2019 IBM Corporation. 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
 */

// Contributors:
//     02/14/2018-2.7 Will Dazey
//       - 529602: Added support for CLOBs in DELETE statements for Oracle
package org.eclipse.persistence.jpa.test.lob;

import java.util.Set;
import java.util.Arrays;
import java.util.Collections;
import java.util.HashSet;

import jakarta.persistence.EntityManager;
import jakarta.persistence.EntityManagerFactory;

import org.eclipse.persistence.internal.databaseaccess.Platform;
import org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl;
import org.eclipse.persistence.jpa.test.framework.DDLGen;
import org.eclipse.persistence.jpa.test.framework.Emf;
import org.eclipse.persistence.jpa.test.framework.EmfRunner;
import org.eclipse.persistence.jpa.test.lob.model.CollectedEntity;
import org.eclipse.persistence.jpa.test.lob.model.ParentEntity;
import org.junit.Assert;
import org.junit.Test;
import org.junit.runner.RunWith;

@RunWith(EmfRunner.class)
public class TestLobMerge {

    @Emf(createTables = DDLGen.DROP_CREATE, classes = { CollectedEntity.class, ParentEntity.class })
    private EntityManagerFactory emf;

    /**
     * Merging ElementCollections on Oracle fails when EclipseLink generates 
     * a DELETE SQL statement with a WHERE clause containing a CLOB.
     *
     */
    @Test
    public void testLobMerge() throws Exception {
        //Test for Oracle only
        Platform pl = emf.unwrap(EntityManagerFactoryImpl.class).getDatabaseSession().getDatasourcePlatform();
        if(!pl.isOracle()) {
            Assert.assertTrue("Platform \""+ pl +"\". Test will run on Oracle only", true);
            return;
        }

        EntityManager em = emf.createEntityManager();
        try {
            final Set<CollectedEntity> col1 = new HashSet<CollectedEntity>(
                    Arrays.asList(new CollectedEntity("label1", "content1"),
                            new CollectedEntity("label2", "content2"),
                            new CollectedEntity("label3", "content3")));

            final ParentEntity pdo = new ParentEntity(9, Collections.unmodifiableSet(col1));
            em.getTransaction().begin();
            em.persist(pdo);
            em.getTransaction().commit();

            final Set<CollectedEntity> col2 = new HashSet<CollectedEntity>(
                    Arrays.asList(new CollectedEntity("label1", "content1"),
                            new CollectedEntity("label2", "content2")));
            final ParentEntity newEntity = new ParentEntity(pdo.getId(), col2);

            em.getTransaction().begin();
            em.merge(newEntity);
            //Failure would occur on merge, if it passed merge, test passed
            em.getTransaction().commit();
        } finally {
            if (em.getTransaction().isActive()) {
                em.getTransaction().rollback();
            }
            if(em.isOpen()) {
                em.close();
            }
        }
    }
}