/*
 * Copyright (c) 1998, 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
 */

// Contributors:
//     Oracle - initial API and implementation from Oracle TopLink
package org.eclipse.persistence.testing.models.mapping;

import org.eclipse.persistence.sessions.*;
import org.eclipse.persistence.testing.framework.*;
import org.eclipse.persistence.tools.schemaframework.*;

/**
 * This creates a system for outer joins with multiple tables
 */
public class OuterJoinSystem extends TestSystem {
    public OuterJoinSystem() {
        project = new OuterJoinWithMultipleTablesProject();
    }

    @Override
    public void addDescriptors(DatabaseSession session) {
        if (project == null) {
            project = new OuterJoinWithMultipleTablesProject();
        }
        (session).addDescriptors(project);
    }

    @Override
    public void createTables(DatabaseSession session) {
        SchemaManager schemaManager = new SchemaManager(session);

        //create added tables for outer join with multiple tables testing
        schemaManager.replaceObject(Course.tableDefinition());
        schemaManager.replaceObject(Student.tableDefinition());
        schemaManager.createSequences();

    }

    /**
    * Return a connected session using the default login.
    */
    @Override
    public DatabaseSession login() {
        DatabaseSession session;

        session = project.createDatabaseSession();
        session.login();

        return session;

    }

    @Override
    public void populate(DatabaseSession session) {
        Student instance;
        PopulationManager manager = PopulationManager.getDefaultManager();
        String appendString = session.getLogin().getPlatform().getTableQualifier();
        if (appendString.length() != 0) {
            appendString = appendString + ".";
        }

        //======insert some Student Examples=====//
        instance = Student.example1();
        session.writeObject(instance);
        manager.registerObject(instance, "example1");

        instance = Student.example2();
        session.writeObject(instance);
        manager.registerObject(instance, "example2");

        instance = Student.example3();
        session.writeObject(instance);
        manager.registerObject(instance, "example3");

        instance = Student.example4();
        session.writeObject(instance);
        manager.registerObject(instance, "example4");

        instance = Student.example5();
        session.writeObject(instance);
        manager.registerObject(instance, "example5");

        instance = Student.example6();
        session.writeObject(instance);
        manager.registerObject(instance, "example6");

        instance = Student.example7();
        session.writeObject(instance);
        manager.registerObject(instance, "example7");

        Student instance2 = Student.example15();
        Course instance1 = Course.example15();
        instance = Student.example15();
        session.writeObject(instance);
        manager.registerObject(instance, "example15");

        session.executeNonSelectingCall(new org.eclipse.persistence.queries.SQLCall("UPDATE " + appendString + "STUDENT SET C_ID = NULL WHERE ST_ID = " + instance2.getSt_ID()));

        session.executeNonSelectingCall(new org.eclipse.persistence.queries.SQLCall("DELETE FROM STUDENT2 WHERE COURSE_ID = " + instance1.getCourse_ID()));

        /*    instance = Student.example8();
            session.writeObject(instance);
            manager.registerObject(instance, "example8");


            instance = Student.example9();
            session.writeObject(instance);
            manager.registerObject(instance, "example9");


            instance = Student.example10();
            session.writeObject(instance);
            manager.registerObject(instance, "example10");

            instance = Student.example11();
            session.writeObject(instance);
            manager.registerObject(instance, "example11");


            instance = Student.example12();
            session.writeObject(instance);
            manager.registerObject(instance, "example12");

            instance = Student.example13();
            session.writeObject(instance);
            manager.registerObject(instance, "example13");

            instance = Student.example14();
            session.writeObject(instance);
            manager.registerObject(instance, "example14");

        */
    }
}