| /* |
| * 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 AllTypes extends ViewRowFactory implements ViewRow { |
| |
| public static int iTYPE_NAME; |
| public static int iOWNER; |
| public static int iTYPECODE; |
| public static int iTYPE_OID; |
| public static int iSUPERTYPE_NAME; |
| public static int iSUPERTYPE_OWNER; |
| public static int iFINAL; |
| public static int iINSTANTIABLE; |
| public static int iINCOMPLETE; |
| public static int iPREDEFINED; |
| private static boolean m_indexed = false; |
| |
| // Attributes |
| public String typeName; |
| public String owner; |
| public String typeCode; |
| public byte[] typeOid; |
| public String supertypeName; |
| public String supertypeOwner; |
| public String finalProp; |
| public String instantiable; |
| public String incomplete; |
| public String predefined; |
| |
| public AllTypes(ResultSet rs) throws SQLException { |
| super(); |
| if (!m_indexed) { |
| m_indexed = true; |
| iTYPE_NAME = rs.findColumn("TYPE_NAME"); |
| iOWNER = rs.findColumn("OWNER"); |
| iTYPECODE = rs.findColumn("TYPECODE"); |
| iTYPE_OID = rs.findColumn("TYPE_OID"); |
| iSUPERTYPE_NAME = rs.findColumn("SUPERTYPE_NAME"); |
| iSUPERTYPE_OWNER = rs.findColumn("SUPERTYPE_OWNER"); |
| iFINAL = rs.findColumn("FINAL"); |
| iINSTANTIABLE = rs.findColumn("INSTANTIABLE"); |
| iINCOMPLETE = rs.findColumn("INCOMPLETE"); |
| iPREDEFINED = rs.findColumn("PREDEFINED"); |
| } |
| typeName = rs.getString(iTYPE_NAME); |
| owner = rs.getString(iOWNER); |
| typeCode = rs.getString(iTYPECODE); |
| typeOid = rs.getBytes(iTYPE_OID); |
| supertypeName = rs.getString(iSUPERTYPE_NAME); |
| supertypeOwner = rs.getString(iSUPERTYPE_OWNER); |
| try { |
| finalProp = rs.getString(iFINAL); |
| instantiable = rs.getString(iINSTANTIABLE); |
| incomplete = rs.getString(iINCOMPLETE); |
| } |
| catch (java.sql.SQLException se) { |
| finalProp = "YES"; |
| instantiable = "YES"; |
| incomplete = "YES"; |
| } |
| predefined = rs.getString(iPREDEFINED); |
| } |
| |
| @Override |
| public boolean isAllTypes() { |
| return true; |
| } |
| |
| public String toString() { |
| return owner + "," + typeName + "," + typeCode + "," + new String(typeOid) + "," |
| + supertypeName + "," + supertypeOwner + "," + finalProp + "," + instantiable + "," |
| + incomplete + "," + predefined; |
| } |
| |
| public static String[] getProjectList() { |
| return new String[]{"OWNER", "TYPE_NAME", "TYPECODE", "TYPE_OID", "SUPERTYPE_NAME", |
| "SUPERTYPE_OWENER", "FINAL", "INSTANTIABLE", "INCOMPLETE", "PREDEFINED"}; |
| } |
| } |