net.sourceforge.msscodefactory.v1_11.MSSBamRam.MSSBamRamClearSubDep1Table.java Source code

Java tutorial

Introduction

Here is the source code for net.sourceforge.msscodefactory.v1_11.MSSBamRam.MSSBamRamClearSubDep1Table.java

Source

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

/*
 *   MSS Code Factory 1.11
 *
 *   Copyright (c) 2012-2014 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/>.
 *   
 * ***********************************************************************
 *
 *   $Revision$
 */

package net.sourceforge.msscodefactory.v1_11.MSSBamRam;

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

/*
 *   MSSBamRamClearSubDep1Table in-memory RAM DbIO implementation
 *   for ClearSubDep1.
 */
public class MSSBamRamClearSubDep1Table implements IMSSBamClearSubDep1Table {
    private MSSBamBLRamSchema schema;
    private Map<MSSBamAnyObjPKey, MSSBamClearSubDep1Buff> dictByPKey = new HashMap<MSSBamAnyObjPKey, MSSBamClearSubDep1Buff>();
    private SortedMap<MSSBamClearSubDep1ByContClearTopIdxKey, SortedMap<MSSBamAnyObjPKey, MSSBamClearSubDep1Buff>> dictByContClearTopIdx = new TreeMap<MSSBamClearSubDep1ByContClearTopIdxKey, SortedMap<MSSBamAnyObjPKey, MSSBamClearSubDep1Buff>>();

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

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

        pkey.setClassCode(Buff.getClassCode());

        pkey.setRequiredId(Buff.getRequiredId());

        MSSBamClearSubDep1ByContClearTopIdxKey keyContClearTopIdx = schema.getFactoryClearSubDep1()
                .newContClearTopIdxKey();
        keyContClearTopIdx.setRequiredContClearTopDepId(Buff.getRequiredContClearTopDepId());

        // Validate unique indexes

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

        // Validate foreign keys

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

        {
            boolean allNull = true;
            allNull = false;
            if (!allNull) {
                if (null == schema.getTableClearTopDep().readDerivedByIdIdx(Authorization,
                        Buff.getRequiredContClearTopDepId())) {
                    throw CFLib.getDefaultExceptionFactory().newUnresolvedRelationException(getClass(),
                            "createClearSubDep1", "Container", "ContClearTopDep", "ClearTopDep", null);
                }
            }
        }

        // Proceed with adding the new record

        dictByPKey.put(pkey, Buff);

        SortedMap<MSSBamAnyObjPKey, MSSBamClearSubDep1Buff> subdictContClearTopIdx;
        if (dictByContClearTopIdx.containsKey(keyContClearTopIdx)) {
            subdictContClearTopIdx = dictByContClearTopIdx.get(keyContClearTopIdx);
        } else {
            subdictContClearTopIdx = new TreeMap<MSSBamAnyObjPKey, MSSBamClearSubDep1Buff>();
            dictByContClearTopIdx.put(keyContClearTopIdx, subdictContClearTopIdx);
        }
        subdictContClearTopIdx.put(pkey, Buff);

    }

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

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

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

    public MSSBamClearSubDep1Buff[] 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<MSSBamClearSubDep1Buff> filteredList = new ArrayList<MSSBamClearSubDep1Buff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamClearSubDep1Buff)) {
                    filteredList.add((MSSBamClearSubDep1Buff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamClearSubDep1Buff[0]));
        }
    }

    public MSSBamClearSubDep1Buff[] 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<MSSBamClearSubDep1Buff> filteredList = new ArrayList<MSSBamClearSubDep1Buff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamClearSubDep1Buff)) {
                    filteredList.add((MSSBamClearSubDep1Buff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamClearSubDep1Buff[0]));
        }
    }

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

    public MSSBamClearSubDep1Buff[] 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<MSSBamClearSubDep1Buff> filteredList = new ArrayList<MSSBamClearSubDep1Buff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamClearSubDep1Buff)) {
                    filteredList.add((MSSBamClearSubDep1Buff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamClearSubDep1Buff[0]));
        }
    }

    public MSSBamClearSubDep1Buff 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 MSSBamClearSubDep1Buff) {
            return ((MSSBamClearSubDep1Buff) buff);
        } else {
            return (null);
        }
    }

    public MSSBamClearSubDep1Buff[] readDerivedByTableIdx(MSSBamAuthorization Authorization, long RelationId) {
        final String S_ProcName = "MSSBamRamClearDep.readDerivedByTableIdx() ";
        MSSBamClearDepBuff buffList[] = schema.getTableClearDep().readDerivedByTableIdx(Authorization, RelationId);
        if (buffList == null) {
            return (null);
        } else {
            MSSBamClearDepBuff buff;
            ArrayList<MSSBamClearSubDep1Buff> filteredList = new ArrayList<MSSBamClearSubDep1Buff>();
            for (int idx = 0; idx < buffList.length; idx++) {
                buff = buffList[idx];
                if ((buff != null) && (buff instanceof MSSBamClearSubDep1Buff)) {
                    filteredList.add((MSSBamClearSubDep1Buff) buff);
                }
            }
            return (filteredList.toArray(new MSSBamClearSubDep1Buff[0]));
        }
    }

    public MSSBamClearSubDep1Buff[] readDerivedByContClearTopIdx(MSSBamAuthorization Authorization,
            long ContClearTopDepId) {
        final String S_ProcName = "MSSBamRamClearSubDep1.readDerivedByContClearTopIdx() ";
        MSSBamClearSubDep1ByContClearTopIdxKey key = schema.getFactoryClearSubDep1().newContClearTopIdxKey();
        key.setRequiredContClearTopDepId(ContClearTopDepId);

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

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

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

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

    public MSSBamClearSubDep1Buff lockBuff(MSSBamAuthorization Authorization, MSSBamAnyObjPKey PKey) {
        final String S_ProcName = "MSSBamRamClearSubDep1.readBuff() ";
        MSSBamClearSubDep1Buff buff = readDerived(Authorization, PKey);
        if ((buff != null) && (!buff.getClassCode().equals("CLR1"))) {
            buff = null;
        }
        return (buff);
    }

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

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

    public MSSBamClearSubDep1Buff[] readBuffByTenantIdx(MSSBamAuthorization Authorization, long TenantId) {
        final String S_ProcName = "MSSBamRamAnyObj.readBuffByTenantIdx() ";
        MSSBamAnyObjBuff buff;
        ArrayList<MSSBamClearSubDep1Buff> filteredList = new ArrayList<MSSBamClearSubDep1Buff>();
        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((MSSBamClearSubDep1Buff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamClearSubDep1Buff[0]));
    }

    public MSSBamClearSubDep1Buff[] readBuffByScopeIdx(MSSBamAuthorization Authorization, Long ScopeId) {
        final String S_ProcName = "MSSBamRamAnyObj.readBuffByScopeIdx() ";
        MSSBamAnyObjBuff buff;
        ArrayList<MSSBamClearSubDep1Buff> filteredList = new ArrayList<MSSBamClearSubDep1Buff>();
        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((MSSBamClearSubDep1Buff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamClearSubDep1Buff[0]));
    }

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

    public MSSBamClearSubDep1Buff[] readBuffByAuthorIdx(MSSBamAuthorization Authorization, Long AuthorId) {
        final String S_ProcName = "MSSBamRamAnyObj.readBuffByAuthorIdx() ";
        MSSBamAnyObjBuff buff;
        ArrayList<MSSBamClearSubDep1Buff> filteredList = new ArrayList<MSSBamClearSubDep1Buff>();
        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((MSSBamClearSubDep1Buff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamClearSubDep1Buff[0]));
    }

    public MSSBamClearSubDep1Buff 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 ((MSSBamClearSubDep1Buff) buff);
        } else {
            return (null);
        }
    }

    public MSSBamClearSubDep1Buff[] readBuffByTableIdx(MSSBamAuthorization Authorization, long RelationId) {
        final String S_ProcName = "MSSBamRamClearDep.readBuffByTableIdx() ";
        MSSBamClearDepBuff buff;
        ArrayList<MSSBamClearSubDep1Buff> filteredList = new ArrayList<MSSBamClearSubDep1Buff>();
        MSSBamClearDepBuff[] buffList = readDerivedByTableIdx(Authorization, RelationId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("CLRD")) {
                filteredList.add((MSSBamClearSubDep1Buff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamClearSubDep1Buff[0]));
    }

    public MSSBamClearSubDep1Buff[] readBuffByContClearTopIdx(MSSBamAuthorization Authorization,
            long ContClearTopDepId) {
        final String S_ProcName = "MSSBamRamClearSubDep1.readBuffByContClearTopIdx() ";
        MSSBamClearSubDep1Buff buff;
        ArrayList<MSSBamClearSubDep1Buff> filteredList = new ArrayList<MSSBamClearSubDep1Buff>();
        MSSBamClearSubDep1Buff[] buffList = readDerivedByContClearTopIdx(Authorization, ContClearTopDepId);
        for (int idx = 0; idx < buffList.length; idx++) {
            buff = buffList[idx];
            if ((buff != null) && buff.getClassCode().equals("CLR1")) {
                filteredList.add((MSSBamClearSubDep1Buff) buff);
            }
        }
        return (filteredList.toArray(new MSSBamClearSubDep1Buff[0]));
    }

    public void updateClearSubDep1(MSSBamAuthorization Authorization, MSSBamClearSubDep1Buff Buff) {
        MSSBamAnyObjPKey pkey = schema.getFactoryAnyObj().newPKey();
        pkey.setRequiredId(Buff.getRequiredId());
        MSSBamClearSubDep1Buff existing = dictByPKey.get(pkey);
        if (existing == null) {
            throw CFLib.getDefaultExceptionFactory().newStaleCacheDetectedException(getClass(),
                    "updateClearSubDep1", "Existing record not found", "ClearSubDep1", pkey);
        }
        MSSBamClearSubDep1ByContClearTopIdxKey existingKeyContClearTopIdx = schema.getFactoryClearSubDep1()
                .newContClearTopIdxKey();
        existingKeyContClearTopIdx.setRequiredContClearTopDepId(existing.getRequiredContClearTopDepId());

        MSSBamClearSubDep1ByContClearTopIdxKey newKeyContClearTopIdx = schema.getFactoryClearSubDep1()
                .newContClearTopIdxKey();
        newKeyContClearTopIdx.setRequiredContClearTopDepId(Buff.getRequiredContClearTopDepId());

        // Check unique indexes

        // Validate foreign keys

        {
            boolean allNull = true;

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

        {
            boolean allNull = true;

            if (allNull) {
                if (null == schema.getTableClearTopDep().readDerivedByIdIdx(Authorization,
                        Buff.getRequiredContClearTopDepId())) {
                    throw CFLib.getDefaultExceptionFactory().newUnresolvedRelationException(getClass(),
                            "updateClearSubDep1", "Container", "ContClearTopDep", "ClearTopDep", null);
                }
            }
        }

        // Update is valid

        SortedMap<MSSBamAnyObjPKey, MSSBamClearSubDep1Buff> subdict;

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

        subdict = dictByContClearTopIdx.get(existingKeyContClearTopIdx);
        if (subdict != null) {
            subdict.remove(pkey);
        }
        if (dictByContClearTopIdx.containsKey(newKeyContClearTopIdx)) {
            subdict = dictByContClearTopIdx.get(newKeyContClearTopIdx);
        } else {
            subdict = new TreeMap<MSSBamAnyObjPKey, MSSBamClearSubDep1Buff>();
            dictByContClearTopIdx.put(newKeyContClearTopIdx, subdict);
        }
        subdict.put(pkey, Buff);

    }

    public void deleteClearSubDep1(MSSBamAuthorization Authorization, MSSBamClearSubDep1Buff Buff) {
        final String S_ProcName = "MSSBamRamClearSubDep1Table.deleteClearSubDep1() ";
        MSSBamAnyObjPKey pkey = schema.getFactoryAnyObj().newPKey();

        pkey.setRequiredId(schema.nextAnyObjIdGen());
        MSSBamClearSubDep1Buff existing = dictByPKey.get(pkey);
        if (existing == null) {
            throw CFLib.getDefaultExceptionFactory().newStaleCacheDetectedException(getClass(),
                    "deleteClearSubDep1", "Existing record not found", "ClearSubDep1", pkey);
        }
        if (existing.getRequiredRevision() != Buff.getRequiredRevision()) {
            throw CFLib.getDefaultExceptionFactory().newCollisionDetectedException(getClass(), "deleteClearSubDep1",
                    pkey);
        }
        MSSBamClearSubDep1ByContClearTopIdxKey keyContClearTopIdx = schema.getFactoryClearSubDep1()
                .newContClearTopIdxKey();
        keyContClearTopIdx.setRequiredContClearTopDepId(existing.getRequiredContClearTopDepId());

        // Validate reverse foreign keys

        if (schema.getTableClearSubDep2().readDerivedByContClearDep1Idx(Authorization,
                existing.getRequiredId()).length > 0) {
            throw CFLib.getDefaultExceptionFactory().newDependentsDetectedException(getClass(),
                    "deleteClearSubDep1", "Container", "ContClearSubDep1", "ClearSubDep2", pkey);
        }

        // Delete is valid

        SortedMap<MSSBamAnyObjPKey, MSSBamClearSubDep1Buff> subdict;

        dictByPKey.remove(pkey);

        subdict = dictByContClearTopIdx.get(keyContClearTopIdx);
        subdict.remove(pkey);

    }

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

    public MSSBamCursor openClearSubDep1CursorByContClearTopIdx(MSSBamAuthorization Authorization,
            long ContClearTopDepId) {
        MSSBamCursor cursor;
        MSSBamClearSubDep1ByContClearTopIdxKey key = schema.getFactoryClearSubDep1().newContClearTopIdxKey();
        key.setRequiredContClearTopDepId(ContClearTopDepId);

        if (dictByContClearTopIdx.containsKey(key)) {
            SortedMap<MSSBamAnyObjPKey, MSSBamClearSubDep1Buff> subdictContClearTopIdx = dictByContClearTopIdx
                    .get(key);
            cursor = new MSSBamRamClearSubDep1Cursor(Authorization, schema, subdictContClearTopIdx.values());
        } else {
            cursor = new MSSBamRamClearSubDep1Cursor(Authorization, schema,
                    new ArrayList<MSSBamClearSubDep1Buff>());
        }
        return (cursor);
    }

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

    public MSSBamClearSubDep1Buff nextClearSubDep1Cursor(MSSBamCursor Cursor) {
        MSSBamRamClearSubDep1Cursor cursor = (MSSBamRamClearSubDep1Cursor) Cursor;
        MSSBamClearSubDep1Buff rec = cursor.getCursor().next();
        cursor.setRowIdx(cursor.getRowIdx() + 1);
        return (rec);
    }

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

    public MSSBamClearSubDep1Buff firstClearSubDep1Cursor(MSSBamCursor Cursor) {
        int targetRowIdx = 1;
        MSSBamClearSubDep1Buff rec = null;
        Cursor.reset();
        while (Cursor.getRowIdx() < targetRowIdx) {
            rec = nextClearSubDep1Cursor(Cursor);
        }
        return (rec);
    }

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

    public MSSBamClearSubDep1Buff nthClearSubDep1Cursor(MSSBamCursor Cursor, int Idx) {
        int targetRowIdx = Idx;
        MSSBamClearSubDep1Buff rec = null;
        if (Cursor.getRowIdx() >= targetRowIdx) {
            Cursor.reset();
        }
        while (Cursor.getRowIdx() < targetRowIdx) {
            rec = nextClearSubDep1Cursor(Cursor);
        }
        return (rec);
    }
}