/*
 * 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 AllCollTypes extends ViewRowFactory implements ViewRow {

    public static int iCOLL_TYPE;
    public static int iELEM_TYPE_NAME;
    public static int iELEM_TYPE_OWNER;
    public static int iELEM_TYPE_MOD;
    public static int iLENGTH;
    public static int iPRECISION;
    public static int iSCALE;
    public static int iCHARACTER_SET_NAME;
    private static boolean m_indexed = false;

    // Attributes
    public String collType;
    public String elemTypeName;
    public String elemTypeOwner;
    public String elemTypeMod;
    public int elemLength;
    public int elemPrecision;
    public int elemScale;
    public String characterSetName;

    public AllCollTypes(ResultSet rs) throws SQLException {
        super();
        if (!m_indexed) {
            m_indexed = true;
            iCOLL_TYPE = rs.findColumn("COLL_TYPE");
            iELEM_TYPE_NAME = rs.findColumn("ELEM_TYPE_NAME");
            iELEM_TYPE_OWNER = rs.findColumn("ELEM_TYPE_OWNER");
            iELEM_TYPE_MOD = rs.findColumn("ELEM_TYPE_MOD");
            iLENGTH = rs.findColumn("LENGTH");
            iPRECISION = rs.findColumn("PRECISION");
            iSCALE = rs.findColumn("SCALE");
            iCHARACTER_SET_NAME = rs.findColumn("CHARACTER_SET_NAME");
        }
        collType = rs.getString(iCOLL_TYPE);
        elemTypeName = rs.getString(iELEM_TYPE_NAME);
        elemTypeOwner = rs.getString(iELEM_TYPE_OWNER);
        elemTypeMod = rs.getString(iELEM_TYPE_MOD);
        elemLength = rs.getInt(iLENGTH);
        elemPrecision = rs.getInt(iPRECISION);
        elemScale = rs.getInt(iSCALE);
        characterSetName = rs.getString(iCHARACTER_SET_NAME);
    }

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

    public String toString() {
        return collType + "," + elemTypeName + "," + elemTypeOwner + "," + elemTypeMod + ","
            + characterSetName + "," + elemLength + "," + elemPrecision + "," + elemScale;
    }

    public static String[] getProjectList() {
        return new String[]{"COLL_TYPE", "ELEM_TYPE_NAME", "ELEM_TYPE_OWNER", "ELEM_TYPE_MOD",
            "CHARACTER_SET_NAME", "LENGTH", "PRECISION", "SCALE"};
    }
}