/*
 * 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.sql.SQLException;

public class AllMethodParams extends ViewRowFactory implements ViewRow {

    public static int iPARAM_NAME;
    public static int iPARAM_NO;
    public static int iPARAM_MODE;
    public static int iPARAM_TYPE_MOD;
    public static int iPARAM_TYPE_OWNER;
    public static int iPARAM_TYPE_NAME;
    public static int iCHARACTER_SET_NAME;
    public static int iMETHOD_NAME;
    public static int iMETHOD_NO;
    private static boolean m_indexed = false;

    // Attributes
    public String paramName;
    public String paramNo;
    public String paramMode;
    public String paramTypeMod;
    public String paramTypeOwner;
    public String paramTypeName;
    public String characterSetName;
    public String methodName;
    public String methodNo;

    public AllMethodParams(ResultSet rs) throws SQLException {
        super();
        if (!m_indexed) {
            m_indexed = true;
            iPARAM_NAME = rs.findColumn("PARAM_NAME");
            iPARAM_NO = rs.findColumn("PARAM_NO");
            iPARAM_MODE = rs.findColumn("PARAM_MODE");
            iPARAM_TYPE_MOD = rs.findColumn("PARAM_TYPE_MOD");
            iPARAM_TYPE_OWNER = rs.findColumn("PARAM_TYPE_OWNER");
            iPARAM_TYPE_NAME = rs.findColumn("PARAM_TYPE_NAME");
            iCHARACTER_SET_NAME = rs.findColumn("CHARACTER_SET_NAME");
            iMETHOD_NAME = rs.findColumn("METHOD_NAME");
            iMETHOD_NO = rs.findColumn("METHOD_NO");
        }
        paramName = rs.getString(iPARAM_NAME);
        paramNo = rs.getString(iPARAM_NO);
        paramMode = rs.getString(iPARAM_MODE);
        paramTypeMod = rs.getString(iPARAM_TYPE_MOD);
        paramTypeOwner = rs.getString(iPARAM_TYPE_OWNER);
        paramTypeName = rs.getString(iPARAM_TYPE_NAME);
        characterSetName = rs.getString(iCHARACTER_SET_NAME);
        methodName = rs.getString(iMETHOD_NAME);
        methodNo = rs.getString(iMETHOD_NO);
    }

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

    public String toString() {
        return paramName + "," + paramNo + "," + paramMode + "," + paramTypeMod + ","
            + paramTypeOwner + "," + characterSetName + "," + methodName + "," + methodNo;
    }

    public static String[] getProjectList() {
        return new String[]{"PARAM_NAME", "PARAM_NO", "PARAM_MODE", "PARAM_TYPE_MOD",
            "PARAM_TYPE_OWNER", "CHARACTER_SET_NAME", "METHOD_NAME", "METHOD_NO"};
    }
}