/*
 * Copyright (c) 1998, 2020 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:
//     Mike Norman - from Proof-of-concept, become production code
package dbws.testing.shadowddlgeneration.oldjpub;

//javase imports
import java.sql.ResultSet;
import java.util.ArrayList;

// Includes all the columns in ALL_ARGUMENTS and USER_AUGUMENTS

public class UserArguments extends ViewRowFactory implements ViewRow {
    // Attributes
    public String PACKAGE_NAME;
    public String OBJECT_NAME; // DO _NOT_ REFACTOR THIS!
    public String OVERLOAD; // DO _NOT_ REFACTOR THIS!
    public String ARGUMENT_NAME; // DO _NOT_ REFACTOR THIS!
    public int POSITION; // DO _NOT_ REFACTOR THIS!
    public int sequence;
    public int DATA_LEVEL; // DO _NOT_ REFACTOR THIS!
    public String DATA_TYPE;
    public String IN_OUT;
    public int DATA_LENGTH;
    public int DATA_PRECISION;
    public int DATA_SCALE;
    public String CHARACTER_SET_NAME;
    public String TYPE_OWNER;
    public String TYPE_NAME;
    public String TYPE_SUBNAME;
    public String PLS_TYPE;
    public int OBJECT_ID;

    public static int iPACKAGE_NAME;
    public static int iOBJECT_NAME;
    public static int iOVERLOAD;
    public static int iARGUMENT_NAME;
    public static int iPOSITION;
    public static int iSEQUENCE;
    public static int iDATA_LEVEL;
    public static int iDATA_TYPE;
    public static int iIN_OUT;
    public static int iDATA_LENGTH;
    public static int iDATA_PRECISION;
    public static int iDATA_SCALE;
    public static int iCHARACTER_SET_NAME;
    public static int iTYPE_OWNER;
    public static int iTYPE_NAME;
    public static int iTYPE_SUBNAME;
    public static int iPLS_TYPE;
    public static int iOBJECT_ID;
    private static boolean m_indexed = false;

    protected UserArguments() {
        super();
    }

    public UserArguments(ResultSet rs) throws java.sql.SQLException {
        super();
        if (!m_indexed) {
            m_indexed = true;
            iPACKAGE_NAME = rs.findColumn("PACKAGE_NAME");
            iOBJECT_NAME = rs.findColumn("OBJECT_NAME");
            iOVERLOAD = rs.findColumn("OVERLOAD");
            iARGUMENT_NAME = rs.findColumn("ARGUMENT_NAME");
            iPOSITION = rs.findColumn("POSITION");
            iSEQUENCE = rs.findColumn("SEQUENCE");
            iDATA_TYPE = rs.findColumn("DATA_TYPE");
            iIN_OUT = rs.findColumn("IN_OUT");
            iDATA_LENGTH = rs.findColumn("DATA_LENGTH");
            iDATA_PRECISION = rs.findColumn("DATA_PRECISION");
            iDATA_SCALE = rs.findColumn("DATA_SCALE");
            iCHARACTER_SET_NAME = rs.findColumn("CHARACTER_SET_NAME");
            iTYPE_OWNER = rs.findColumn("TYPE_OWNER");
            iTYPE_NAME = rs.findColumn("TYPE_NAME");
            iTYPE_SUBNAME = rs.findColumn("TYPE_SUBNAME");
            iPLS_TYPE = rs.findColumn("PLS_TYPE");
            iDATA_LEVEL = rs.findColumn("DATA_LEVEL");
            iOBJECT_ID = rs.findColumn("OBJECT_ID");
        }
        PACKAGE_NAME = rs.getString(iPACKAGE_NAME);
        OBJECT_NAME = rs.getString(iOBJECT_NAME);
        OVERLOAD = rs.getString(iOVERLOAD);
        ARGUMENT_NAME = rs.getString(iARGUMENT_NAME);
        POSITION = rs.getInt(iPOSITION);
        sequence = rs.getInt(iSEQUENCE);
        DATA_TYPE = rs.getString(iDATA_TYPE);
        IN_OUT = rs.getString(iIN_OUT);
        DATA_LENGTH = rs.getInt(iDATA_LENGTH);
        DATA_PRECISION = rs.getInt(iDATA_PRECISION);
        DATA_SCALE = rs.getInt(iDATA_SCALE);
        CHARACTER_SET_NAME = rs.getString(iCHARACTER_SET_NAME);
        TYPE_OWNER = rs.getString(iTYPE_OWNER);
        TYPE_NAME = rs.getString(iTYPE_NAME);
        TYPE_SUBNAME = rs.getString(iTYPE_SUBNAME);
        PLS_TYPE = rs.getString(iPLS_TYPE);
        DATA_LEVEL = rs.getInt(iDATA_LEVEL);
        OBJECT_ID = rs.getInt(iOBJECT_ID);
    }

    @Override
    public boolean isUserArguments() {
        return true;
    }

    public String toString() {
        return OBJECT_NAME + "," + PACKAGE_NAME + "," + OVERLOAD + "," + ARGUMENT_NAME + ","
            + POSITION + "," + sequence + "," + DATA_LEVEL + "," + DATA_TYPE + "," + IN_OUT + ","
            + DATA_LENGTH + "," + DATA_PRECISION + "," + DATA_SCALE + "," + CHARACTER_SET_NAME
            + "," + TYPE_OWNER + "," + TYPE_NAME + "," + TYPE_SUBNAME + "," + OBJECT_ID;
    }

    public static void orderByPosition(ArrayList<ViewRow> rows) {
        for (int i = 0; i < rows.size() - 1; i++) {
            UserArguments rowi = (UserArguments)rows.get(i);
            int minIdx = i;
            int minPos = rowi.POSITION;
            for (int j = i; j < rows.size(); j++) {
                UserArguments rowj = (UserArguments)rows.get(j);
                if (minPos > rowj.POSITION) {
                    minIdx = j;
                    minPos = rowj.POSITION;
                }
            }
            if (i != minIdx) {
                ViewRow tmp = rows.get(i);
                rows.set(i, rows.get(minIdx));
                rows.set(minIdx, tmp);
            }
        }
    }

    public static void orderBySequence(ArrayList<ViewRow> rows) {
        for (int i = 0; i < rows.size() - 1; i++) {
            UserArguments rowi = (UserArguments)rows.get(i);
            int minIdx = i;
            int minPos = rowi.sequence;
            for (int j = i; j < rows.size(); j++) {
                UserArguments rowj = (UserArguments)rows.get(j);
                if (minPos > rowj.sequence) {
                    minIdx = j;
                    minPos = rowj.sequence;
                }
            }
            if (i != minIdx) {
                ViewRow tmp = rows.get(i);
                rows.set(i, rows.get(minIdx));
                rows.set(minIdx, tmp);
            }
        }
    }

    public static String[] getProjectList() {
        return new String[]{"PACKAGE_NAME", "TYPE_NAME", "TYPE_SUBNAME", "OBJECT_NAME", "OVERLOAD",
            "ARGUMENT_NAME", "IN_OUT", "DATA_TYPE", "PLS_TYPE", "DATA_LEVEL", "SEQUENCE",
            "POSITION", "TYPE_OWNER", "DATA_LENGTH", "DATA_PRECISION", "DATA_SCALE",
            "CHARACTER_SET_NAME", "OBJECT_ID"};
    }
}