net.sourceforge.msscodefactory.v1_10.MSSBamRam.MSSBamRamSchemaId16GenTable.java Source code

Java tutorial

Introduction

Here is the source code for net.sourceforge.msscodefactory.v1_10.MSSBamRam.MSSBamRamSchemaId16GenTable.java

Source

// Description: Java6 in-memory RAM DbIO implementation for SchemaId16Gen.

/*
 *   MSS Code Factory 1.10
 *
 *   Copyright (c) 2012 Mark Sobkow
 *   
 *   This program is available as free software under the GNU GPL v3, or
 *   under a commercial license from Mark Sobkow.  For commercial licensing
 *   details, please contact msobkow@sasktel.net.
 *   
 *   Under the terms of the GPL:
 *   
 *      This program is free software: you can redistribute it and/or modify
 *      it under the terms of the GNU General Public License as published by
 *      the Free Software Foundation, either version 3 of the License, or
 *      (at your option) any later version.
 *     
 *      This program is distributed in the hope that it will be useful,
 *      but WITHOUT ANY WARRANTY; without even the implied warranty of
 *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *      GNU General Public License for more details.
 *     
 *      You should have received a copy of the GNU General Public License
 *      along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *   
 * ***********************************************************************
 *
 *   Code manufactured
 *   by MSS Code Factory version 1.9.3294
 *
 *   $Revision: 26 $
 */

package net.sourceforge.msscodefactory.v1_10.MSSBamRam;

import java.sql.*;
import java.util.*;
import net.sourceforge.msscodefactory.cflib.v1_9.CFLib.*;
import org.apache.commons.codec.binary.Base64;
import net.sourceforge.msscodefactory.v1_10.MSSBam.*;
import net.sourceforge.msscodefactory.v1_10.MSSBamBL.*;
import net.sourceforge.msscodefactory.v1_10.MSSBamBLRam.*;

/*
 *   MSSBamRamSchemaId16GenTable in-memory RAM DbIO implementation
 *   for SchemaId16Gen.
 */
public class MSSBamRamSchemaId16GenTable implements IMSSBamSchemaId16GenTable {
    private MSSBamBLRamSchema schema;
    private Map<MSSBamAnyObjPKey, MSSBamSchemaId16GenBuff> dictByPKey = new HashMap<MSSBamAnyObjPKey, MSSBamSchemaId16GenBuff>();
    private SortedMap<MSSBamSchemaId16GenByContainerIdxKey, SortedMap<MSSBamAnyObjPKey, MSSBamSchemaId16GenBuff>> dictByContainerIdx = new TreeMap<MSSBamSchemaId16GenByContainerIdxKey, SortedMap<MSSBamAnyObjPKey, MSSBamSchemaId16GenBuff>>();

    public MSSBamRamSchemaId16GenTable(MSSBamBLRamSchema argSchema) {
        schema = argSchema;
    }

    public void createSchemaId16Gen(MSSBamAuthorization Authorization, MSSBamSchemaId16GenBuff Buff) {
        MSSBamAnyObjPKey pkey = schema.getFactoryAnyObj().newPKey();

        pkey.setClassCode(Buff.getClassCode());

        pkey.setRequiredId(Buff.getRequiredId());

        MSSBamSchemaId16GenByContainerIdxKey keyContainerIdx = schema.getFactorySchemaId16Gen()
                .newContainerIdxKey();
        keyContainerIdx.setRequiredContainerId(Buff.getRequiredContainerId());

        // Validate unique indexes

        if (dictByPKey.containsKey(pkey)) {
            throw CFLib.getDefaultExceptionFactory().newPrimaryKeyNotNewException(getClass(), "createSchemaId16Gen",
                    pkey);
        }

        // Validate foreign keys

        {
            boolean allNull = true;
            allNull = false;
            if (!allNull) {
                if (null == schema.getTableId16GenDef().readDerivedByIdIdx(Authorization, Buff.getRequiredId())) {
                    throw CFLib.getDefaultExceptionFactory().newUnresolvedRelationException(getClass(),
                            "createSchemaId16Gen", "Superclass", "SuperClass", "Id16GenDef", null);
                }
            }
        }

        {
            boolean allNull = true;
            allNull = false;
            if (!allNull) {
                if (null == schema.getTableSchemaDef().readDerivedByIdIdx(Authorization,
                        Buff.getRequiredContainerId())) {
                    throw CFLib.getDefaultExceptionFactory().newUnresolvedRelationException(getClass(),
                            "createSchemaId16Gen", "Container", "CSchema", "SchemaDef", null);
                }
            }
        }

        // Proceed with adding the new record

        dictByPKey.put(pkey, Buff);

        SortedMap<MSSBamAnyObjPKey, MSSBamSchemaId16GenBuff> subdictContainerIdx;
        if (dictByContainerIdx.containsKey(keyContainerIdx)) {
            subdictContainerIdx = dictByContainerIdx.get(keyContainerIdx);
        } else {
            subdictContainerIdx = new TreeMap<MSSBamAnyObjPKey, MSSBamSchemaId16GenBuff>();
            dictByContainerIdx.put(keyContainerIdx, subdictContainerIdx);
        }
        subdictContainerIdx.put(pkey, Buff);

    }

    public MSSBamSchemaId16GenBuff readDerived(MSSBamAuthorization Authorization, MSSBamAnyObjPKey PKey) {
        final String S_ProcName = "MSSBamRamSchemaId16Gen.readDerived() ";
        MSSBamAnyObjPKey key = schema.getFactoryAnyObj().newPKey();
        key.setRequiredId(PKey.getRequiredId());
        MSSBamSchemaId16GenBuff buff;
        if (dictByPKey.containsKey(key)) {
            buff = dictByPKey.get(key);
        } else {
            buff = null;
        }
        return (buff);
    }

    public MSSBamSchemaId16GenBuff[] readAllDerived(MSSBamAuthorization Authorization) {
        final String S_ProcName = "MSSBamRamSchemaId16Gen.readAllDerived() ";
        MSSBamSchemaId16GenBuff[] retList = new MSSBamSchemaId16GenBuff[dictByPKey.values().size()];
        Iterator<MSSBamSchemaId16GenBuff> iter = dictByPKey.values().iterator();
        int idx = 0;
        while (iter.hasNext()) {
            retList[idx++] = iter.next();
        }
        return (retList);
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByTenantIdx(MSSBamAuthorization Authorization, long TenantId) {
        final String S_ProcName = "MSSBamRamAnyObj.readDerivedByTenantIdx() ";
        MSSBamAnyObjBuff buffList[] = schema.getTableAnyObj().readDerivedByTenantIdx(Authorization, TenantId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamAnyObjBuff buff;
            ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamSchemaId16GenBuff)) {
                    filteredList.add((MSSBamSchemaId16GenBuff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
        }
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByScopeIdx(MSSBamAuthorization Authorization, Long ScopeId) {
        final String S_ProcName = "MSSBamRamAnyObj.readDerivedByScopeIdx() ";
        MSSBamAnyObjBuff buffList[] = schema.getTableAnyObj().readDerivedByScopeIdx(Authorization, ScopeId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamAnyObjBuff buff;
            ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamSchemaId16GenBuff)) {
                    filteredList.add((MSSBamSchemaId16GenBuff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
        }
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByAuthorIdx(MSSBamAuthorization Authorization, Long AuthorId) {
        final String S_ProcName = "MSSBamRamAnyObj.readDerivedByAuthorIdx() ";
        MSSBamAnyObjBuff buffList[] = schema.getTableAnyObj().readDerivedByAuthorIdx(Authorization, AuthorId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamAnyObjBuff buff;
            ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamSchemaId16GenBuff)) {
                    filteredList.add((MSSBamSchemaId16GenBuff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
        }
    }

    public MSSBamSchemaId16GenBuff readDerivedByUNameIdx(MSSBamAuthorization Authorization, Long ScopeId,
            String Name) {
        final String S_ProcName = "MSSBamRamAnyObj.readDerivedByUNameIdx() ";
        MSSBamAnyObjBuff buff = schema.getTableAnyObj().readDerivedByUNameIdx(Authorization, ScopeId, Name);
        if (buff == null) {
            return (null);
        } else if (buff instanceof MSSBamSchemaId16GenBuff) {
            return ((MSSBamSchemaId16GenBuff) buff);
        } else {
            return (null);
        }
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByVContIdx(MSSBamAuthorization Authorization,
            long ValueContainerId) {
        final String S_ProcName = "MSSBamRamValue.readDerivedByVContIdx() ";
        MSSBamValueBuff buffList[] = schema.getTableValue().readDerivedByVContIdx(Authorization, ValueContainerId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamValueBuff buff;
            ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamSchemaId16GenBuff)) {
                    filteredList.add((MSSBamSchemaId16GenBuff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
        }
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByDataScopeIdx(MSSBamAuthorization Authorization,
            Short DataScopeId) {
        final String S_ProcName = "MSSBamRamValue.readDerivedByDataScopeIdx() ";
        MSSBamValueBuff buffList[] = schema.getTableValue().readDerivedByDataScopeIdx(Authorization, DataScopeId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamValueBuff buff;
            ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamSchemaId16GenBuff)) {
                    filteredList.add((MSSBamSchemaId16GenBuff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
        }
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByVAccSecIdx(MSSBamAuthorization Authorization,
            Short ViewAccessSecurityId) {
        final String S_ProcName = "MSSBamRamValue.readDerivedByVAccSecIdx() ";
        MSSBamValueBuff buffList[] = schema.getTableValue().readDerivedByVAccSecIdx(Authorization,
                ViewAccessSecurityId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamValueBuff buff;
            ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamSchemaId16GenBuff)) {
                    filteredList.add((MSSBamSchemaId16GenBuff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
        }
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByVAccFreqIdx(MSSBamAuthorization Authorization,
            Short ViewAccessFrequencyId) {
        final String S_ProcName = "MSSBamRamValue.readDerivedByVAccFreqIdx() ";
        MSSBamValueBuff buffList[] = schema.getTableValue().readDerivedByVAccFreqIdx(Authorization,
                ViewAccessFrequencyId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamValueBuff buff;
            ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamSchemaId16GenBuff)) {
                    filteredList.add((MSSBamSchemaId16GenBuff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
        }
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByEAccSecIdx(MSSBamAuthorization Authorization,
            Short EditAccessSecurityId) {
        final String S_ProcName = "MSSBamRamValue.readDerivedByEAccSecIdx() ";
        MSSBamValueBuff buffList[] = schema.getTableValue().readDerivedByEAccSecIdx(Authorization,
                EditAccessSecurityId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamValueBuff buff;
            ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamSchemaId16GenBuff)) {
                    filteredList.add((MSSBamSchemaId16GenBuff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
        }
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByEAccFreqIdx(MSSBamAuthorization Authorization,
            Short EditAccessFrequencyId) {
        final String S_ProcName = "MSSBamRamValue.readDerivedByEAccFreqIdx() ";
        MSSBamValueBuff buffList[] = schema.getTableValue().readDerivedByEAccFreqIdx(Authorization,
                EditAccessFrequencyId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamValueBuff buff;
            ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamSchemaId16GenBuff)) {
                    filteredList.add((MSSBamSchemaId16GenBuff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
        }
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByPrevIdx(MSSBamAuthorization Authorization, Long PrevId) {
        final String S_ProcName = "MSSBamRamValue.readDerivedByPrevIdx() ";
        MSSBamValueBuff buffList[] = schema.getTableValue().readDerivedByPrevIdx(Authorization, PrevId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamValueBuff buff;
            ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamSchemaId16GenBuff)) {
                    filteredList.add((MSSBamSchemaId16GenBuff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
        }
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByNextIdx(MSSBamAuthorization Authorization, Long NextId) {
        final String S_ProcName = "MSSBamRamValue.readDerivedByNextIdx() ";
        MSSBamValueBuff buffList[] = schema.getTableValue().readDerivedByNextIdx(Authorization, NextId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamValueBuff buff;
            ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamSchemaId16GenBuff)) {
                    filteredList.add((MSSBamSchemaId16GenBuff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
        }
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByContPrevIdx(MSSBamAuthorization Authorization,
            long ValueContainerId, Long PrevId) {
        final String S_ProcName = "MSSBamRamValue.readDerivedByContPrevIdx() ";
        MSSBamValueBuff buffList[] = schema.getTableValue().readDerivedByContPrevIdx(Authorization,
                ValueContainerId, PrevId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamValueBuff buff;
            ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamSchemaId16GenBuff)) {
                    filteredList.add((MSSBamSchemaId16GenBuff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
        }
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByContNextIdx(MSSBamAuthorization Authorization,
            long ValueContainerId, Long NextId) {
        final String S_ProcName = "MSSBamRamValue.readDerivedByContNextIdx() ";
        MSSBamValueBuff buffList[] = schema.getTableValue().readDerivedByContNextIdx(Authorization,
                ValueContainerId, NextId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamValueBuff buff;
            ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamSchemaId16GenBuff)) {
                    filteredList.add((MSSBamSchemaId16GenBuff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
        }
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByDispIdx(MSSBamAuthorization Authorization, Long DispenserId) {
        final String S_ProcName = "MSSBamRamId16GenDef.readDerivedByDispIdx() ";
        MSSBamId16GenDefBuff buffList[] = schema.getTableId16GenDef().readDerivedByDispIdx(Authorization,
                DispenserId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamId16GenDefBuff buff;
            ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamSchemaId16GenBuff)) {
                    filteredList.add((MSSBamSchemaId16GenBuff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
        }
    }

    public MSSBamSchemaId16GenBuff[] readDerivedByContainerIdx(MSSBamAuthorization Authorization,
            long ContainerId) {
        final String S_ProcName = "MSSBamRamSchemaId16Gen.readDerivedByContainerIdx() ";
        MSSBamSchemaId16GenByContainerIdxKey key = schema.getFactorySchemaId16Gen().newContainerIdxKey();
        key.setRequiredContainerId(ContainerId);

        MSSBamSchemaId16GenBuff[] recArray;
        if (dictByContainerIdx.containsKey(key)) {
            SortedMap<MSSBamAnyObjPKey, MSSBamSchemaId16GenBuff> subdictContainerIdx = dictByContainerIdx.get(key);
            recArray = new MSSBamSchemaId16GenBuff[subdictContainerIdx.size()];
            Iterator<MSSBamSchemaId16GenBuff> iter = subdictContainerIdx.values().iterator();
            int idx = 0;
            while (iter.hasNext()) {
                recArray[idx++] = iter.next();
            }
        } else {
            recArray = new MSSBamSchemaId16GenBuff[0];
        }
        return (recArray);
    }

    public MSSBamSchemaId16GenBuff readDerivedByIdIdx(MSSBamAuthorization Authorization, long Id) {
        final String S_ProcName = "MSSBamRamAnyObj.readDerivedByIdIdx() ";
        MSSBamAnyObjPKey key = schema.getFactoryAnyObj().newPKey();
        key.setRequiredId(Id);

        MSSBamSchemaId16GenBuff buff;
        if (dictByPKey.containsKey(key)) {
            buff = dictByPKey.get(key);
        } else {
            buff = null;
        }
        return (buff);
    }

    public MSSBamSchemaId16GenBuff readBuff(MSSBamAuthorization Authorization, MSSBamAnyObjPKey PKey) {
        final String S_ProcName = "MSSBamRamSchemaId16Gen.readBuff() ";
        MSSBamSchemaId16GenBuff buff = readDerived(Authorization, PKey);
        if ((buff != null) && (!buff.getClassCode().equals("SG16"))) {
            buff = null;
        }
        return (buff);
    }

    public MSSBamSchemaId16GenBuff[] readAllBuff(MSSBamAuthorization Authorization) {
        final String S_ProcName = "MSSBamRamSchemaId16Gen.readAllBuff() ";
        MSSBamSchemaId16GenBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamSchemaId16GenBuff[] buffList = readAllDerived(Authorization);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("SG16")) {
                filteredList.add(buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff readBuffByIdIdx(MSSBamAuthorization Authorization, long Id) {
        final String S_ProcName = "MSSBamRamAnyObj.readBuffByIdIdx() ";
        MSSBamAnyObjBuff buff = readDerivedByIdIdx(Authorization, Id);
        if ((buff != null) && buff.getClassCode().equals("ANYO")) {
            return ((MSSBamSchemaId16GenBuff) buff);
        } else {
            return (null);
        }
    }

    public MSSBamSchemaId16GenBuff[] readBuffByTenantIdx(MSSBamAuthorization Authorization, long TenantId) {
        final String S_ProcName = "MSSBamRamAnyObj.readBuffByTenantIdx() ";
        MSSBamAnyObjBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamAnyObjBuff[] buffList = readDerivedByTenantIdx(Authorization, TenantId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("ANYO")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff[] readBuffByScopeIdx(MSSBamAuthorization Authorization, Long ScopeId) {
        final String S_ProcName = "MSSBamRamAnyObj.readBuffByScopeIdx() ";
        MSSBamAnyObjBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamAnyObjBuff[] buffList = readDerivedByScopeIdx(Authorization, ScopeId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("ANYO")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff[] readBuffByAuthorIdx(MSSBamAuthorization Authorization, Long AuthorId) {
        final String S_ProcName = "MSSBamRamAnyObj.readBuffByAuthorIdx() ";
        MSSBamAnyObjBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamAnyObjBuff[] buffList = readDerivedByAuthorIdx(Authorization, AuthorId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("ANYO")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff readBuffByUNameIdx(MSSBamAuthorization Authorization, Long ScopeId,
            String Name) {
        final String S_ProcName = "MSSBamRamAnyObj.readBuffByUNameIdx() ";
        MSSBamAnyObjBuff buff = readDerivedByUNameIdx(Authorization, ScopeId, Name);
        if ((buff != null) && buff.getClassCode().equals("ANYO")) {
            return ((MSSBamSchemaId16GenBuff) buff);
        } else {
            return (null);
        }
    }

    public MSSBamSchemaId16GenBuff[] readBuffByVContIdx(MSSBamAuthorization Authorization, long ValueContainerId) {
        final String S_ProcName = "MSSBamRamValue.readBuffByVContIdx() ";
        MSSBamValueBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamValueBuff[] buffList = readDerivedByVContIdx(Authorization, ValueContainerId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("VAL")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff[] readBuffByDataScopeIdx(MSSBamAuthorization Authorization, Short DataScopeId) {
        final String S_ProcName = "MSSBamRamValue.readBuffByDataScopeIdx() ";
        MSSBamValueBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamValueBuff[] buffList = readDerivedByDataScopeIdx(Authorization, DataScopeId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("VAL")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff[] readBuffByVAccSecIdx(MSSBamAuthorization Authorization,
            Short ViewAccessSecurityId) {
        final String S_ProcName = "MSSBamRamValue.readBuffByVAccSecIdx() ";
        MSSBamValueBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamValueBuff[] buffList = readDerivedByVAccSecIdx(Authorization, ViewAccessSecurityId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("VAL")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff[] readBuffByVAccFreqIdx(MSSBamAuthorization Authorization,
            Short ViewAccessFrequencyId) {
        final String S_ProcName = "MSSBamRamValue.readBuffByVAccFreqIdx() ";
        MSSBamValueBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamValueBuff[] buffList = readDerivedByVAccFreqIdx(Authorization, ViewAccessFrequencyId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("VAL")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff[] readBuffByEAccSecIdx(MSSBamAuthorization Authorization,
            Short EditAccessSecurityId) {
        final String S_ProcName = "MSSBamRamValue.readBuffByEAccSecIdx() ";
        MSSBamValueBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamValueBuff[] buffList = readDerivedByEAccSecIdx(Authorization, EditAccessSecurityId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("VAL")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff[] readBuffByEAccFreqIdx(MSSBamAuthorization Authorization,
            Short EditAccessFrequencyId) {
        final String S_ProcName = "MSSBamRamValue.readBuffByEAccFreqIdx() ";
        MSSBamValueBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamValueBuff[] buffList = readDerivedByEAccFreqIdx(Authorization, EditAccessFrequencyId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("VAL")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff[] readBuffByPrevIdx(MSSBamAuthorization Authorization, Long PrevId) {
        final String S_ProcName = "MSSBamRamValue.readBuffByPrevIdx() ";
        MSSBamValueBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamValueBuff[] buffList = readDerivedByPrevIdx(Authorization, PrevId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("VAL")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff[] readBuffByNextIdx(MSSBamAuthorization Authorization, Long NextId) {
        final String S_ProcName = "MSSBamRamValue.readBuffByNextIdx() ";
        MSSBamValueBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamValueBuff[] buffList = readDerivedByNextIdx(Authorization, NextId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("VAL")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff[] readBuffByContPrevIdx(MSSBamAuthorization Authorization, long ValueContainerId,
            Long PrevId) {
        final String S_ProcName = "MSSBamRamValue.readBuffByContPrevIdx() ";
        MSSBamValueBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamValueBuff[] buffList = readDerivedByContPrevIdx(Authorization, ValueContainerId, PrevId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("VAL")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff[] readBuffByContNextIdx(MSSBamAuthorization Authorization, long ValueContainerId,
            Long NextId) {
        final String S_ProcName = "MSSBamRamValue.readBuffByContNextIdx() ";
        MSSBamValueBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamValueBuff[] buffList = readDerivedByContNextIdx(Authorization, ValueContainerId, NextId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("VAL")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff[] readBuffByDispIdx(MSSBamAuthorization Authorization, Long DispenserId) {
        final String S_ProcName = "MSSBamRamId16GenDef.readBuffByDispIdx() ";
        MSSBamId16GenDefBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamId16GenDefBuff[] buffList = readDerivedByDispIdx(Authorization, DispenserId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("G16")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public MSSBamSchemaId16GenBuff[] readBuffByContainerIdx(MSSBamAuthorization Authorization, long ContainerId) {
        final String S_ProcName = "MSSBamRamSchemaId16Gen.readBuffByContainerIdx() ";
        MSSBamSchemaId16GenBuff buff;
        ArrayList<MSSBamSchemaId16GenBuff> filteredList = new ArrayList<MSSBamSchemaId16GenBuff>();
        MSSBamSchemaId16GenBuff[] buffList = readDerivedByContainerIdx(Authorization, ContainerId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("SG16")) {
                filteredList.add((MSSBamSchemaId16GenBuff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamSchemaId16GenBuff[0]));
    }

    public void updateSchemaId16Gen(MSSBamAuthorization Authorization, MSSBamSchemaId16GenBuff Buff) {
        MSSBamAnyObjPKey pkey = schema.getFactoryAnyObj().newPKey();
        pkey.setRequiredId(Buff.getRequiredId());
        MSSBamSchemaId16GenBuff existing = dictByPKey.get(pkey);
        if (existing == null) {
            throw CFLib.getDefaultExceptionFactory().newStaleCacheDetectedException(getClass(),
                    "updateSchemaId16Gen", "Existing record not found", "SchemaId16Gen", pkey);
        }
        MSSBamSchemaId16GenByContainerIdxKey existingKeyContainerIdx = schema.getFactorySchemaId16Gen()
                .newContainerIdxKey();
        existingKeyContainerIdx.setRequiredContainerId(existing.getRequiredContainerId());

        MSSBamSchemaId16GenByContainerIdxKey newKeyContainerIdx = schema.getFactorySchemaId16Gen()
                .newContainerIdxKey();
        newKeyContainerIdx.setRequiredContainerId(Buff.getRequiredContainerId());

        // Check unique indexes

        // Validate foreign keys

        {
            boolean allNull = true;

            if (allNull) {
                if (null == schema.getTableId16GenDef().readDerivedByIdIdx(Authorization, Buff.getRequiredId())) {
                    throw CFLib.getDefaultExceptionFactory().newUnresolvedRelationException(getClass(),
                            "updateSchemaId16Gen", "Superclass", "SuperClass", "Id16GenDef", null);
                }
            }
        }

        {
            boolean allNull = true;

            if (allNull) {
                if (null == schema.getTableSchemaDef().readDerivedByIdIdx(Authorization,
                        Buff.getRequiredContainerId())) {
                    throw CFLib.getDefaultExceptionFactory().newUnresolvedRelationException(getClass(),
                            "updateSchemaId16Gen", "Container", "CSchema", "SchemaDef", null);
                }
            }
        }

        // Update is valid

        SortedMap<MSSBamAnyObjPKey, MSSBamSchemaId16GenBuff> subdict;

        dictByPKey.remove(pkey);
        dictByPKey.put(pkey, Buff);

        subdict = dictByContainerIdx.get(existingKeyContainerIdx);
        if (subdict != null) {
            subdict.remove(pkey);
        }
        if (dictByContainerIdx.containsKey(newKeyContainerIdx)) {
            subdict = dictByContainerIdx.get(newKeyContainerIdx);
        } else {
            subdict = new TreeMap<MSSBamAnyObjPKey, MSSBamSchemaId16GenBuff>();
            dictByContainerIdx.put(newKeyContainerIdx, subdict);
        }
        subdict.put(pkey, Buff);

    }

    public void deleteSchemaId16Gen(MSSBamAuthorization Authorization, MSSBamSchemaId16GenBuff Buff) {
        final String S_ProcName = "MSSBamRamSchemaId16GenTable.deleteSchemaId16Gen() ";
        MSSBamAnyObjPKey pkey = schema.getFactoryAnyObj().newPKey();

        pkey.setRequiredId(schema.nextAnyObjIdGen());
        MSSBamSchemaId16GenBuff existing = dictByPKey.get(pkey);
        if (existing == null) {
            throw CFLib.getDefaultExceptionFactory().newStaleCacheDetectedException(getClass(),
                    "deleteSchemaId16Gen", "Existing record not found", "SchemaId16Gen", pkey);
        }
        if (existing.getRequiredRevision() != Buff.getRequiredRevision()) {
            throw CFLib.getDefaultExceptionFactory().newCollisionDetectedException(getClass(),
                    "deleteSchemaId16Gen", pkey);
        }
        MSSBamSchemaId16GenByContainerIdxKey keyContainerIdx = schema.getFactorySchemaId16Gen()
                .newContainerIdxKey();
        keyContainerIdx.setRequiredContainerId(existing.getRequiredContainerId());

        // Validate reverse foreign keys

        // Delete is valid

        SortedMap<MSSBamAnyObjPKey, MSSBamSchemaId16GenBuff> subdict;

        dictByPKey.remove(pkey);

        subdict = dictByContainerIdx.get(keyContainerIdx);
        subdict.remove(pkey);

    }

    public MSSBamCursor openSchemaId16GenCursorAll(MSSBamAuthorization Authorization) {
        MSSBamCursor cursor = new MSSBamRamSchemaId16GenCursor(Authorization, schema, dictByPKey.values());
        return (cursor);
    }

    public MSSBamCursor openSchemaId16GenCursorByContainerIdx(MSSBamAuthorization Authorization, long ContainerId) {
        MSSBamCursor cursor;
        MSSBamSchemaId16GenByContainerIdxKey key = schema.getFactorySchemaId16Gen().newContainerIdxKey();
        key.setRequiredContainerId(ContainerId);

        if (dictByContainerIdx.containsKey(key)) {
            SortedMap<MSSBamAnyObjPKey, MSSBamSchemaId16GenBuff> subdictContainerIdx = dictByContainerIdx.get(key);
            cursor = new MSSBamRamSchemaId16GenCursor(Authorization, schema, subdictContainerIdx.values());
        } else {
            cursor = new MSSBamRamSchemaId16GenCursor(Authorization, schema,
                    new ArrayList<MSSBamSchemaId16GenBuff>());
        }
        return (cursor);
    }

    public void closeSchemaId16GenCursor(MSSBamCursor Cursor) {
        // Cursor.DataReader.Close();
    }

    public MSSBamSchemaId16GenBuff nextSchemaId16GenCursor(MSSBamCursor Cursor) {
        MSSBamRamSchemaId16GenCursor cursor = (MSSBamRamSchemaId16GenCursor) Cursor;
        MSSBamSchemaId16GenBuff rec = cursor.getCursor().next();
        cursor.setRowIdx(cursor.getRowIdx() + 1);
        return (rec);
    }

    public MSSBamSchemaId16GenBuff prevSchemaId16GenCursor(MSSBamCursor Cursor) {
        int targetRowIdx = (Cursor.getRowIdx() > 1) ? Cursor.getRowIdx() - 1 : 1;
        MSSBamSchemaId16GenBuff rec = null;
        if (Cursor.getRowIdx() >= targetRowIdx) {
            Cursor.reset();
        }
        while (Cursor.getRowIdx() < targetRowIdx) {
            rec = nextSchemaId16GenCursor(Cursor);
        }
        return (rec);
    }

    public MSSBamSchemaId16GenBuff firstSchemaId16GenCursor(MSSBamCursor Cursor) {
        int targetRowIdx = 1;
        MSSBamSchemaId16GenBuff rec = null;
        Cursor.reset();
        while (Cursor.getRowIdx() < targetRowIdx) {
            rec = nextSchemaId16GenCursor(Cursor);
        }
        return (rec);
    }

    public MSSBamSchemaId16GenBuff lastSchemaId16GenCursor(MSSBamCursor Cursor) {
        throw CFLib.getDefaultExceptionFactory().newNotImplementedYetException(getClass(),
                "lastSchemaId16GenCursor");
    }

    public MSSBamSchemaId16GenBuff nthSchemaId16GenCursor(MSSBamCursor Cursor, int Idx) {
        int targetRowIdx = Idx;
        MSSBamSchemaId16GenBuff rec = null;
        if (Cursor.getRowIdx() >= targetRowIdx) {
            Cursor.reset();
        }
        while (Cursor.getRowIdx() < targetRowIdx) {
            rec = nextSchemaId16GenCursor(Cursor);
        }
        return (rec);
    }
}