// --------------------------------------------------------------------------------
// Copyright 2002-2026 Echo Three, LLC
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//     http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
// --------------------------------------------------------------------------------
// Generated File -- DO NOT EDIT BY HAND
// --------------------------------------------------------------------------------

/**
 * PaymentMethodCreditCardFactory.java
 */

package com.echothree.model.data.payment.server.factory;

import com.echothree.model.data.payment.common.pk.PaymentMethodPK;

import com.echothree.model.data.payment.server.entity.PaymentMethod;

import com.echothree.model.data.payment.common.PaymentMethodCreditCardConstants;
import com.echothree.model.data.payment.common.pk.PaymentMethodCreditCardPK;
import com.echothree.model.data.payment.server.value.PaymentMethodCreditCardValue;
import com.echothree.model.data.payment.server.entity.PaymentMethodCreditCard;
import com.echothree.util.common.exception.PersistenceDatabaseException;
import com.echothree.util.common.exception.PersistenceDatabaseUpdateException;
import com.echothree.util.common.exception.PersistenceNotNullException;
import com.echothree.util.server.persistence.BaseFactory;
import com.echothree.util.server.persistence.EntityIdGenerator;
import com.echothree.util.server.persistence.EntityPermission;
import com.echothree.util.server.persistence.PersistenceDebugFlags;
import com.echothree.util.server.persistence.Session;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import java.io.ByteArrayInputStream;
import java.io.StringReader;
import java.util.ArrayList;
import java.util.Collection;
import java.util.HashSet;
import java.util.List;
import java.util.Map;
import java.util.Set;
import javax.enterprise.context.ApplicationScoped;
import javax.enterprise.inject.spi.CDI;
import javax.inject.Inject;
import org.jooq.ResultQuery;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

@ApplicationScoped
public class PaymentMethodCreditCardFactory
        implements BaseFactory<PaymentMethodCreditCardPK, PaymentMethodCreditCard> {
    
    @Inject
    Session session;
    
    //private static final Logger log = LoggerFactory.getLogger(PaymentMethodCreditCardFactory.class);
    
    final private static String SQL_SELECT_READ_ONLY = "SELECT pmcc_paymentmethodcreditcardid, pmcc_pm_paymentmethodid, pmcc_requestnameoncard, pmcc_requirenameoncard, pmcc_checkcardnumber, pmcc_requestexpirationdate, pmcc_requireexpirationdate, pmcc_checkexpirationdate, pmcc_requestsecuritycode, pmcc_requiresecuritycode, pmcc_cardnumbervalidationpattern, pmcc_securitycodevalidationpattern, pmcc_retaincreditcard, pmcc_retainsecuritycode, pmcc_requestbilling, pmcc_requirebilling, pmcc_requestissuer, pmcc_requireissuer, pmcc_fromtime, pmcc_thrutime FROM paymentmethodcreditcards WHERE pmcc_paymentmethodcreditcardid = ?";
    final private static String SQL_SELECT_READ_WRITE = "SELECT pmcc_paymentmethodcreditcardid, pmcc_pm_paymentmethodid, pmcc_requestnameoncard, pmcc_requirenameoncard, pmcc_checkcardnumber, pmcc_requestexpirationdate, pmcc_requireexpirationdate, pmcc_checkexpirationdate, pmcc_requestsecuritycode, pmcc_requiresecuritycode, pmcc_cardnumbervalidationpattern, pmcc_securitycodevalidationpattern, pmcc_retaincreditcard, pmcc_retainsecuritycode, pmcc_requestbilling, pmcc_requirebilling, pmcc_requestissuer, pmcc_requireissuer, pmcc_fromtime, pmcc_thrutime FROM paymentmethodcreditcards WHERE pmcc_paymentmethodcreditcardid = ? FOR UPDATE";
    final private static String SQL_INSERT = "INSERT INTO paymentmethodcreditcards (pmcc_paymentmethodcreditcardid, pmcc_pm_paymentmethodid, pmcc_requestnameoncard, pmcc_requirenameoncard, pmcc_checkcardnumber, pmcc_requestexpirationdate, pmcc_requireexpirationdate, pmcc_checkexpirationdate, pmcc_requestsecuritycode, pmcc_requiresecuritycode, pmcc_cardnumbervalidationpattern, pmcc_securitycodevalidationpattern, pmcc_retaincreditcard, pmcc_retainsecuritycode, pmcc_requestbilling, pmcc_requirebilling, pmcc_requestissuer, pmcc_requireissuer, pmcc_fromtime, pmcc_thrutime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
    final private static String SQL_UPDATE = "UPDATE paymentmethodcreditcards SET pmcc_pm_paymentmethodid = ?, pmcc_requestnameoncard = ?, pmcc_requirenameoncard = ?, pmcc_checkcardnumber = ?, pmcc_requestexpirationdate = ?, pmcc_requireexpirationdate = ?, pmcc_checkexpirationdate = ?, pmcc_requestsecuritycode = ?, pmcc_requiresecuritycode = ?, pmcc_cardnumbervalidationpattern = ?, pmcc_securitycodevalidationpattern = ?, pmcc_retaincreditcard = ?, pmcc_retainsecuritycode = ?, pmcc_requestbilling = ?, pmcc_requirebilling = ?, pmcc_requestissuer = ?, pmcc_requireissuer = ?, pmcc_fromtime = ?, pmcc_thrutime = ? WHERE pmcc_paymentmethodcreditcardid = ?";
    final private static String SQL_DELETE = "DELETE FROM paymentmethodcreditcards WHERE pmcc_paymentmethodcreditcardid = ?";
    final private static String SQL_VALID = "SELECT COUNT(*) FROM paymentmethodcreditcards WHERE pmcc_paymentmethodcreditcardid = ?";
    
    final private static String PK_COLUMN = "pmcc_paymentmethodcreditcardid";
    final private static String ALL_COLUMNS = "pmcc_paymentmethodcreditcardid, pmcc_pm_paymentmethodid, pmcc_requestnameoncard, pmcc_requirenameoncard, pmcc_checkcardnumber, pmcc_requestexpirationdate, pmcc_requireexpirationdate, pmcc_checkexpirationdate, pmcc_requestsecuritycode, pmcc_requiresecuritycode, pmcc_cardnumbervalidationpattern, pmcc_securitycodevalidationpattern, pmcc_retaincreditcard, pmcc_retainsecuritycode, pmcc_requestbilling, pmcc_requirebilling, pmcc_requestissuer, pmcc_requireissuer, pmcc_fromtime, pmcc_thrutime";
    final public static String TABLE_NAME = "paymentmethodcreditcards";
    
    final public static String PMCC_PAYMENTMETHODCREDITCARDID = "pmcc_paymentmethodcreditcardid";
    final public static String PMCC_PM_PAYMENTMETHODID = "pmcc_pm_paymentmethodid";
    final public static String PMCC_REQUESTNAMEONCARD = "pmcc_requestnameoncard";
    final public static String PMCC_REQUIRENAMEONCARD = "pmcc_requirenameoncard";
    final public static String PMCC_CHECKCARDNUMBER = "pmcc_checkcardnumber";
    final public static String PMCC_REQUESTEXPIRATIONDATE = "pmcc_requestexpirationdate";
    final public static String PMCC_REQUIREEXPIRATIONDATE = "pmcc_requireexpirationdate";
    final public static String PMCC_CHECKEXPIRATIONDATE = "pmcc_checkexpirationdate";
    final public static String PMCC_REQUESTSECURITYCODE = "pmcc_requestsecuritycode";
    final public static String PMCC_REQUIRESECURITYCODE = "pmcc_requiresecuritycode";
    final public static String PMCC_CARDNUMBERVALIDATIONPATTERN = "pmcc_cardnumbervalidationpattern";
    final public static String PMCC_SECURITYCODEVALIDATIONPATTERN = "pmcc_securitycodevalidationpattern";
    final public static String PMCC_RETAINCREDITCARD = "pmcc_retaincreditcard";
    final public static String PMCC_RETAINSECURITYCODE = "pmcc_retainsecuritycode";
    final public static String PMCC_REQUESTBILLING = "pmcc_requestbilling";
    final public static String PMCC_REQUIREBILLING = "pmcc_requirebilling";
    final public static String PMCC_REQUESTISSUER = "pmcc_requestissuer";
    final public static String PMCC_REQUIREISSUER = "pmcc_requireissuer";
    final public static String PMCC_FROMTIME = "pmcc_fromtime";
    final public static String PMCC_THRUTIME = "pmcc_thrutime";
    
    final private static EntityIdGenerator entityIdGenerator = new EntityIdGenerator(PaymentMethodCreditCardConstants.COMPONENT_VENDOR_NAME, PaymentMethodCreditCardConstants.ENTITY_TYPE_NAME);
    
    /** Creates a new instance of PaymentMethodCreditCardFactory */
    protected PaymentMethodCreditCardFactory() {
        super();
    }
    
    public static PaymentMethodCreditCardFactory getInstance() {
        return CDI.current().select(PaymentMethodCreditCardFactory.class).get();
    }
    
    @Override
    public String getPKColumn() {
        return PK_COLUMN;
    }
    
    @Override
    public String getAllColumns() {
        return ALL_COLUMNS;
    }
    
    @Override
    public String getTableName() {
        return TABLE_NAME;
    }
    
    @Override
    public String getComponentVendorName() {
        return PaymentMethodCreditCardConstants.COMPONENT_VENDOR_NAME;
    }
    
    @Override
    public String getEntityTypeName() {
        return PaymentMethodCreditCardConstants.ENTITY_TYPE_NAME;
    }
    
    public PreparedStatement prepareStatement(String query) {
        return session.prepareStatement(PaymentMethodCreditCardFactory.class, query);
    }
    
    public PaymentMethodCreditCardPK getNextPK() {
        return new PaymentMethodCreditCardPK(entityIdGenerator.getNextEntityId());
    }
    
    public Set<PaymentMethodCreditCardPK> getPKsFromResultSetAsSet(ResultSet rs)
            throws PersistenceDatabaseException {
        Set<PaymentMethodCreditCardPK> _result = new HashSet<>();
        
        try {
            while(rs.next()) {
                _result.add(getPKFromResultSet(rs));
            }
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        return _result;
    }
    
    public java.util.List<PaymentMethodCreditCardPK> getPKsFromResultSetAsList(ResultSet rs)
            throws PersistenceDatabaseException {
        java.util.List<PaymentMethodCreditCardPK> _result = new ArrayList<>();
        
        try {
            while(rs.next()) {
                _result.add(getPKFromResultSet(rs));
            }
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        return _result;
    }
    
    public PaymentMethodCreditCardPK getPKFromResultSet(ResultSet rs)
            throws PersistenceDatabaseException {
        PaymentMethodCreditCardPK _result;
        
        try {
            long pmcc_paymentmethodcreditcardid = rs.getLong(PMCC_PAYMENTMETHODCREDITCARDID);
            Long _entityId = rs.wasNull() ? null : pmcc_paymentmethodcreditcardid;
            
            _result = new PaymentMethodCreditCardPK(_entityId);
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        return _result;
    }
    
    public java.util.List<PaymentMethodCreditCardValue> getValuesFromPKs(Collection<PaymentMethodCreditCardPK> pks)
            throws PersistenceDatabaseException {
        java.util.List<PaymentMethodCreditCardValue> _values = new ArrayList<>(pks.size());
        
        for(PaymentMethodCreditCardPK _pk: pks) {
            _values.add(getValueFromPK(_pk));
        }
        
        return _values;
    }
    
    public PaymentMethodCreditCardValue getValueFromPK(PaymentMethodCreditCardPK pk)
            throws PersistenceDatabaseException {
        PaymentMethodCreditCardValue _value;
        
        // See if we already have the entity in the session cache
        PaymentMethodCreditCard _entity = (PaymentMethodCreditCard)session.getEntity(pk);
        if(_entity == null)
            _value = getEntityFromPK(EntityPermission.READ_ONLY, pk).getPaymentMethodCreditCardValue();
        else
            _value = _entity.getPaymentMethodCreditCardValue();
        
        return _value;
    }
    
    public java.util.List<PaymentMethodCreditCardValue> getValuesFromResultSet(ResultSet rs)
            throws PersistenceDatabaseException {
        java.util.List<PaymentMethodCreditCardValue> _result = new ArrayList<>();
        
        try {
            while(rs.next()) {
                _result.add(getValueFromResultSet(rs));
            }
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        return _result;
    }
    
    public PaymentMethodCreditCardValue getValueFromResultSet(ResultSet rs)
            throws PersistenceDatabaseException {
        PaymentMethodCreditCardValue _value;
        
        try {
            Long pmcc_paymentmethodcreditcardid = rs.getLong(PMCC_PAYMENTMETHODCREDITCARDID);
            PaymentMethodCreditCardPK _pk = new PaymentMethodCreditCardPK(pmcc_paymentmethodcreditcardid);
            
            // See if we already have the entity in the session cache
            PaymentMethodCreditCard _entity = (PaymentMethodCreditCard)session.getEntity(_pk);
            
            if(_entity == null) {
                Long pmcc_pm_paymentmethodid = rs.getLong(PMCC_PM_PAYMENTMETHODID);
                if(rs.wasNull())
                    pmcc_pm_paymentmethodid = null;
                
                Boolean pmcc_requestnameoncard = rs.getInt(PMCC_REQUESTNAMEONCARD) == 1;
                if(rs.wasNull())
                    pmcc_requestnameoncard = null;
                
                Boolean pmcc_requirenameoncard = rs.getInt(PMCC_REQUIRENAMEONCARD) == 1;
                if(rs.wasNull())
                    pmcc_requirenameoncard = null;
                
                Boolean pmcc_checkcardnumber = rs.getInt(PMCC_CHECKCARDNUMBER) == 1;
                if(rs.wasNull())
                    pmcc_checkcardnumber = null;
                
                Boolean pmcc_requestexpirationdate = rs.getInt(PMCC_REQUESTEXPIRATIONDATE) == 1;
                if(rs.wasNull())
                    pmcc_requestexpirationdate = null;
                
                Boolean pmcc_requireexpirationdate = rs.getInt(PMCC_REQUIREEXPIRATIONDATE) == 1;
                if(rs.wasNull())
                    pmcc_requireexpirationdate = null;
                
                Boolean pmcc_checkexpirationdate = rs.getInt(PMCC_CHECKEXPIRATIONDATE) == 1;
                if(rs.wasNull())
                    pmcc_checkexpirationdate = null;
                
                Boolean pmcc_requestsecuritycode = rs.getInt(PMCC_REQUESTSECURITYCODE) == 1;
                if(rs.wasNull())
                    pmcc_requestsecuritycode = null;
                
                Boolean pmcc_requiresecuritycode = rs.getInt(PMCC_REQUIRESECURITYCODE) == 1;
                if(rs.wasNull())
                    pmcc_requiresecuritycode = null;
                
                String pmcc_cardnumbervalidationpattern = rs.getString(PMCC_CARDNUMBERVALIDATIONPATTERN);
                if(rs.wasNull())
                    pmcc_cardnumbervalidationpattern = null;
                
                String pmcc_securitycodevalidationpattern = rs.getString(PMCC_SECURITYCODEVALIDATIONPATTERN);
                if(rs.wasNull())
                    pmcc_securitycodevalidationpattern = null;
                
                Boolean pmcc_retaincreditcard = rs.getInt(PMCC_RETAINCREDITCARD) == 1;
                if(rs.wasNull())
                    pmcc_retaincreditcard = null;
                
                Boolean pmcc_retainsecuritycode = rs.getInt(PMCC_RETAINSECURITYCODE) == 1;
                if(rs.wasNull())
                    pmcc_retainsecuritycode = null;
                
                Boolean pmcc_requestbilling = rs.getInt(PMCC_REQUESTBILLING) == 1;
                if(rs.wasNull())
                    pmcc_requestbilling = null;
                
                Boolean pmcc_requirebilling = rs.getInt(PMCC_REQUIREBILLING) == 1;
                if(rs.wasNull())
                    pmcc_requirebilling = null;
                
                Boolean pmcc_requestissuer = rs.getInt(PMCC_REQUESTISSUER) == 1;
                if(rs.wasNull())
                    pmcc_requestissuer = null;
                
                Boolean pmcc_requireissuer = rs.getInt(PMCC_REQUIREISSUER) == 1;
                if(rs.wasNull())
                    pmcc_requireissuer = null;
                
                Long pmcc_fromtime = rs.getLong(PMCC_FROMTIME);
                if(rs.wasNull())
                    pmcc_fromtime = null;
                
                Long pmcc_thrutime = rs.getLong(PMCC_THRUTIME);
                if(rs.wasNull())
                    pmcc_thrutime = null;
                
                _value = new PaymentMethodCreditCardValue(_pk, new PaymentMethodPK(pmcc_pm_paymentmethodid), pmcc_requestnameoncard, pmcc_requirenameoncard, pmcc_checkcardnumber, pmcc_requestexpirationdate, pmcc_requireexpirationdate, pmcc_checkexpirationdate, pmcc_requestsecuritycode, pmcc_requiresecuritycode, pmcc_cardnumbervalidationpattern, pmcc_securitycodevalidationpattern, pmcc_retaincreditcard, pmcc_retainsecuritycode, pmcc_requestbilling, pmcc_requirebilling, pmcc_requestissuer, pmcc_requireissuer, pmcc_fromtime, pmcc_thrutime);
            } else
                _value = _entity.getPaymentMethodCreditCardValue();
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        return _value;
    }
    
    public java.util.List<PaymentMethodCreditCard> getEntitiesFromPKs(EntityPermission entityPermission, Collection<PaymentMethodCreditCardPK> pks)
            throws PersistenceDatabaseException {
        java.util.List<PaymentMethodCreditCard> _entities = new ArrayList<>(pks.size());
        
        for(PaymentMethodCreditCardPK _pk: pks) {
            _entities.add(getEntityFromPK(entityPermission, _pk));
        }
        
        return _entities;
    }
    
    public PaymentMethodCreditCard getEntityFromValue(EntityPermission entityPermission, PaymentMethodCreditCardValue value) {
        return getEntityFromPK(entityPermission, value.getPrimaryKey());
    }
    
    public PaymentMethodCreditCard getEntityFromCache(PaymentMethodCreditCardPK pk) {
        PaymentMethodCreditCardValue _value = (PaymentMethodCreditCardValue)session.getValueCache().get(pk);
    
        return _value == null ? null : new PaymentMethodCreditCard(_value, EntityPermission.READ_ONLY);
    }
    
    public PaymentMethodCreditCard getEntityFromPK(EntityPermission entityPermission, PaymentMethodCreditCardPK pk)
            throws PersistenceDatabaseException {
        PaymentMethodCreditCard _entity;
        
        // See if we already have the entity in the session cache
        _entity = (PaymentMethodCreditCard)session.getEntity(pk);
        if(_entity != null) {
            // If the requested permission is READ_WRITE, and the cached permission is
            // READ_ONLY, then pretend that the cached object wasn't found, and create
            // a new entity that is READ_WRITE.
            if(entityPermission.equals(EntityPermission.READ_WRITE)) {
                if(_entity.getEntityPermission().equals(EntityPermission.READ_ONLY))
                    _entity = null;
            }
        }
        
        if(_entity == null && entityPermission.equals(EntityPermission.READ_ONLY)) {
            _entity = getEntityFromCache(pk);
        }
        
        if(_entity == null) {
            PreparedStatement _ps = session.prepareStatement(entityPermission.equals(EntityPermission.READ_ONLY)? SQL_SELECT_READ_ONLY: SQL_SELECT_READ_WRITE);
            long _entityId = pk.getEntityId();
            ResultSet _rs = null;
            
            try {
                _ps.setLong(1, _entityId);
                _rs = _ps.executeQuery();
                if(_rs.next()) {
                    _entity = getEntityFromResultSet(entityPermission, _rs);
                }
            } catch (SQLException se) {
                throw new PersistenceDatabaseException(se);
            } finally {
                if(_rs != null) {
                    try {
                        _rs.close();
                    } catch (SQLException se) {
                        // do nothing
                    }
                }
            }
        }
        
        return _entity;
    }
    
    public Set<PaymentMethodCreditCardPK> getPKsFromQueryAsSet(PreparedStatement ps, final Object... params)
            throws PersistenceDatabaseException {
        Set<PaymentMethodCreditCardPK> _pks;
        ResultSet _rs = null;
        
        try {
            if(params.length != 0) {
                Session.setQueryParams(ps, params);
            }
            
            _rs = ps.executeQuery();
            _pks = getPKsFromResultSetAsSet(_rs);
            _rs.close();
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        } finally {
            if(_rs != null) {
                try {
                    _rs.close();
                } catch (SQLException se) {
                    // do nothing
                }
            }
        }
        
        return _pks;
    }
    
    public java.util.List<PaymentMethodCreditCardPK> getPKsFromQueryAsList(PreparedStatement ps, final Object... params)
            throws PersistenceDatabaseException {
        java.util.List<PaymentMethodCreditCardPK> _pks;
        ResultSet _rs = null;
        
        try {
            if(params.length != 0) {
                Session.setQueryParams(ps, params);
            }
            
            _rs = ps.executeQuery();
            _pks = getPKsFromResultSetAsList(_rs);
            _rs.close();
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        } finally {
            if(_rs != null) {
                try {
                    _rs.close();
                } catch (SQLException se) {
                    // do nothing
                }
            }
        }
        
        return _pks;
    }
    
    public PaymentMethodCreditCardPK getPKFromQuery(PreparedStatement ps, final Object... params)
            throws PersistenceDatabaseException {
        PaymentMethodCreditCardPK _pk = null;
        ResultSet _rs = null;
        
        try {
            if(params.length != 0) {
                Session.setQueryParams(ps, params);
            }
            
            _rs = ps.executeQuery();
            if(_rs.next()) {
                _pk = getPKFromResultSet(_rs);
            }
            _rs.close();
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        } finally {
            if(_rs != null) {
                try {
                    _rs.close();
                } catch (SQLException se) {
                    // do nothing
                }
            }
        }
        
        return _pk;
    }
    
    public java.util.List<PaymentMethodCreditCard> getEntitiesFromQuery(EntityPermission entityPermission, Map<EntityPermission, String>queryMap, final Object... params)
            throws PersistenceDatabaseException {
        PreparedStatement ps = session.prepareStatement(PaymentMethodCreditCardFactory.class, queryMap.get(entityPermission));
        
        return getEntitiesFromQuery(entityPermission, ps, params);
    }
    
    public java.util.List<PaymentMethodCreditCard> getEntitiesFromQuery(EntityPermission entityPermission, Map<EntityPermission, String>queryMap)
            throws PersistenceDatabaseException {
        PreparedStatement ps = session.prepareStatement(PaymentMethodCreditCardFactory.class, queryMap.get(entityPermission));
        
        return getEntitiesFromQuery(entityPermission, ps);
    }
    
    public java.util.List<PaymentMethodCreditCard> getEntitiesFromQuery(EntityPermission entityPermission, ResultQuery<?> query)
            throws PersistenceDatabaseException {
        PreparedStatement ps = session.prepareStatement(PaymentMethodCreditCardFactory.class, query.getSQL());
        
        return getEntitiesFromQuery(entityPermission, ps, query.getBindValues().toArray());
    }
    
    public java.util.List<PaymentMethodCreditCard> getEntitiesFromQuery(EntityPermission entityPermission, PreparedStatement ps, final Object... params)
            throws PersistenceDatabaseException {
        java.util.List<PaymentMethodCreditCard> _entities;
        ResultSet _rs = null;
        
        try {
            if(params.length != 0) {
                Session.setQueryParams(ps, params);
            }
            
            _rs = ps.executeQuery();
            _entities = getEntitiesFromResultSet(entityPermission, _rs);
            _rs.close();
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        } finally {
            if(_rs != null) {
                try {
                    _rs.close();
                } catch (SQLException se) {
                    // do nothing
                }
            }
        }
        
        return _entities;
    }
    
    public PaymentMethodCreditCard getEntityFromQuery(EntityPermission entityPermission, Map<EntityPermission, String>queryMap, final Object... params)
            throws PersistenceDatabaseException {
        PreparedStatement ps = session.prepareStatement(PaymentMethodCreditCardFactory.class, queryMap.get(entityPermission));
        
        return getEntityFromQuery(entityPermission, ps, params);
    }
    
    public PaymentMethodCreditCard getEntityFromQuery(EntityPermission entityPermission, Map<EntityPermission, String>queryMap)
            throws PersistenceDatabaseException {
        PreparedStatement ps = session.prepareStatement(PaymentMethodCreditCardFactory.class, queryMap.get(entityPermission));
        
        return getEntityFromQuery(entityPermission, ps);
    }
    
    public PaymentMethodCreditCard getEntityFromQuery(EntityPermission entityPermission, ResultQuery<?> query)
            throws PersistenceDatabaseException {
        PreparedStatement ps = session.prepareStatement(PaymentMethodCreditCardFactory.class, query.getSQL());
        
        return getEntityFromQuery(entityPermission, ps, query.getBindValues().toArray());
    }
    
    public PaymentMethodCreditCard getEntityFromQuery(EntityPermission entityPermission, PreparedStatement ps, final Object... params)
            throws PersistenceDatabaseException {
        PaymentMethodCreditCard _entity = null;
        ResultSet _rs = null;
        
        try {
            if(params.length != 0) {
                Session.setQueryParams(ps, params);
            }
            
            _rs = ps.executeQuery();
            if(_rs.next()) {
                _entity = getEntityFromResultSet(entityPermission, _rs);
            }
            _rs.close();
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        } finally {
            if(_rs != null) {
                try {
                    _rs.close();
                } catch (SQLException se) {
                    // do nothing
                }
            }
        }
        
        return _entity;
    }
    
    public java.util.List<PaymentMethodCreditCard> getEntitiesFromResultSet(EntityPermission entityPermission, ResultSet rs)
            throws PersistenceDatabaseException {
        java.util.List<PaymentMethodCreditCard> _result = new ArrayList<>();
        
        try {
            while(rs.next()) {
                _result.add(getEntityFromResultSet(entityPermission, rs));
            }
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        return _result;
    }
    
    public PaymentMethodCreditCard getEntityFromResultSet(EntityPermission entityPermission, ResultSet rs)
            throws PersistenceDatabaseException {
        PaymentMethodCreditCard _entity;
        
        try {
            Long pmcc_paymentmethodcreditcardid = rs.getLong(PMCC_PAYMENTMETHODCREDITCARDID);
            PaymentMethodCreditCardPK _pk = new PaymentMethodCreditCardPK(pmcc_paymentmethodcreditcardid);
            
            // See if we already have the entity in the session cache
            _entity = (PaymentMethodCreditCard)session.getEntity(_pk);
            if(_entity != null) {
                // If the requested permission is READ_WRITE, and the cached permission is
                // READ_ONLY, then pretend that the cached object wasn't found, and create
                // a new entity that is READ_WRITE.
                if(entityPermission.equals(EntityPermission.READ_WRITE)) {
                    if(_entity.getEntityPermission().equals(EntityPermission.READ_ONLY))
                        _entity = null;
                }
            }
            boolean foundInSessionCache = _entity != null;
            
            if(_entity == null && entityPermission.equals(EntityPermission.READ_ONLY)) {
                _entity = getEntityFromCache(_pk);
            }
            
            if(_entity == null) {
                Long pmcc_pm_paymentmethodid = rs.getLong(PMCC_PM_PAYMENTMETHODID);
                if(rs.wasNull())
                    pmcc_pm_paymentmethodid = null;
                
                Boolean pmcc_requestnameoncard = rs.getInt(PMCC_REQUESTNAMEONCARD) == 1;
                if(rs.wasNull())
                    pmcc_requestnameoncard = null;
                
                Boolean pmcc_requirenameoncard = rs.getInt(PMCC_REQUIRENAMEONCARD) == 1;
                if(rs.wasNull())
                    pmcc_requirenameoncard = null;
                
                Boolean pmcc_checkcardnumber = rs.getInt(PMCC_CHECKCARDNUMBER) == 1;
                if(rs.wasNull())
                    pmcc_checkcardnumber = null;
                
                Boolean pmcc_requestexpirationdate = rs.getInt(PMCC_REQUESTEXPIRATIONDATE) == 1;
                if(rs.wasNull())
                    pmcc_requestexpirationdate = null;
                
                Boolean pmcc_requireexpirationdate = rs.getInt(PMCC_REQUIREEXPIRATIONDATE) == 1;
                if(rs.wasNull())
                    pmcc_requireexpirationdate = null;
                
                Boolean pmcc_checkexpirationdate = rs.getInt(PMCC_CHECKEXPIRATIONDATE) == 1;
                if(rs.wasNull())
                    pmcc_checkexpirationdate = null;
                
                Boolean pmcc_requestsecuritycode = rs.getInt(PMCC_REQUESTSECURITYCODE) == 1;
                if(rs.wasNull())
                    pmcc_requestsecuritycode = null;
                
                Boolean pmcc_requiresecuritycode = rs.getInt(PMCC_REQUIRESECURITYCODE) == 1;
                if(rs.wasNull())
                    pmcc_requiresecuritycode = null;
                
                String pmcc_cardnumbervalidationpattern = rs.getString(PMCC_CARDNUMBERVALIDATIONPATTERN);
                if(rs.wasNull())
                    pmcc_cardnumbervalidationpattern = null;
                
                String pmcc_securitycodevalidationpattern = rs.getString(PMCC_SECURITYCODEVALIDATIONPATTERN);
                if(rs.wasNull())
                    pmcc_securitycodevalidationpattern = null;
                
                Boolean pmcc_retaincreditcard = rs.getInt(PMCC_RETAINCREDITCARD) == 1;
                if(rs.wasNull())
                    pmcc_retaincreditcard = null;
                
                Boolean pmcc_retainsecuritycode = rs.getInt(PMCC_RETAINSECURITYCODE) == 1;
                if(rs.wasNull())
                    pmcc_retainsecuritycode = null;
                
                Boolean pmcc_requestbilling = rs.getInt(PMCC_REQUESTBILLING) == 1;
                if(rs.wasNull())
                    pmcc_requestbilling = null;
                
                Boolean pmcc_requirebilling = rs.getInt(PMCC_REQUIREBILLING) == 1;
                if(rs.wasNull())
                    pmcc_requirebilling = null;
                
                Boolean pmcc_requestissuer = rs.getInt(PMCC_REQUESTISSUER) == 1;
                if(rs.wasNull())
                    pmcc_requestissuer = null;
                
                Boolean pmcc_requireissuer = rs.getInt(PMCC_REQUIREISSUER) == 1;
                if(rs.wasNull())
                    pmcc_requireissuer = null;
                
                Long pmcc_fromtime = rs.getLong(PMCC_FROMTIME);
                if(rs.wasNull())
                    pmcc_fromtime = null;
                
                Long pmcc_thrutime = rs.getLong(PMCC_THRUTIME);
                if(rs.wasNull())
                    pmcc_thrutime = null;
                
                PaymentMethodCreditCardValue _value = new PaymentMethodCreditCardValue(_pk, pmcc_pm_paymentmethodid == null? null: new PaymentMethodPK(pmcc_pm_paymentmethodid), pmcc_requestnameoncard, pmcc_requirenameoncard, pmcc_checkcardnumber, pmcc_requestexpirationdate, pmcc_requireexpirationdate, pmcc_checkexpirationdate, pmcc_requestsecuritycode, pmcc_requiresecuritycode, pmcc_cardnumbervalidationpattern, pmcc_securitycodevalidationpattern, pmcc_retaincreditcard, pmcc_retainsecuritycode, pmcc_requestbilling, pmcc_requirebilling, pmcc_requestissuer, pmcc_requireissuer, pmcc_fromtime, pmcc_thrutime);
                _entity = new PaymentMethodCreditCard(_value, entityPermission);
            }
            
            if(!foundInSessionCache) {
                if(entityPermission.equals(EntityPermission.READ_ONLY)) {
                    session.putReadOnlyEntity(_pk, _entity);
                    session.getValueCache().put(_entity.getPaymentMethodCreditCardValue());
                } else {
                    session.putReadWriteEntity(_pk, _entity);
                }
            }
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        return _entity;
    }
    
    public PaymentMethodCreditCard create(PaymentMethod paymentMethod, Boolean requestNameOnCard, Boolean requireNameOnCard, Boolean checkCardNumber, Boolean requestExpirationDate, Boolean requireExpirationDate, Boolean checkExpirationDate, Boolean requestSecurityCode, Boolean requireSecurityCode, String cardNumberValidationPattern, String securityCodeValidationPattern, Boolean retainCreditCard, Boolean retainSecurityCode, Boolean requestBilling, Boolean requireBilling, Boolean requestIssuer, Boolean requireIssuer, Long fromTime, Long thruTime)
            throws PersistenceDatabaseException, PersistenceNotNullException {
        return create(paymentMethod == null ? null : paymentMethod.getPrimaryKey(), requestNameOnCard, requireNameOnCard, checkCardNumber, requestExpirationDate, requireExpirationDate, checkExpirationDate, requestSecurityCode, requireSecurityCode, cardNumberValidationPattern, securityCodeValidationPattern, retainCreditCard, retainSecurityCode, requestBilling, requireBilling, requestIssuer, requireIssuer, fromTime, thruTime);
    }
    
    private void bindForCreate(PreparedStatement _ps, PaymentMethodCreditCardValue _value)
            throws SQLException {
        _ps.setLong(1, _value.getEntityId());
        
        PaymentMethodPK pmcc_pm_paymentmethodid = _value.getPaymentMethodPK();
        if(pmcc_pm_paymentmethodid == null)
            _ps.setNull(2, Types.BIGINT);
        else
            _ps.setLong(2, pmcc_pm_paymentmethodid.getEntityId());
            
        Boolean pmcc_requestnameoncard = _value.getRequestNameOnCard();
        if(pmcc_requestnameoncard == null)
            _ps.setNull(3, Types.BIT);
        else
            _ps.setInt(3, pmcc_requestnameoncard? 1: 0);
            
        Boolean pmcc_requirenameoncard = _value.getRequireNameOnCard();
        if(pmcc_requirenameoncard == null)
            _ps.setNull(4, Types.BIT);
        else
            _ps.setInt(4, pmcc_requirenameoncard? 1: 0);
            
        Boolean pmcc_checkcardnumber = _value.getCheckCardNumber();
        if(pmcc_checkcardnumber == null)
            _ps.setNull(5, Types.BIT);
        else
            _ps.setInt(5, pmcc_checkcardnumber? 1: 0);
            
        Boolean pmcc_requestexpirationdate = _value.getRequestExpirationDate();
        if(pmcc_requestexpirationdate == null)
            _ps.setNull(6, Types.BIT);
        else
            _ps.setInt(6, pmcc_requestexpirationdate? 1: 0);
            
        Boolean pmcc_requireexpirationdate = _value.getRequireExpirationDate();
        if(pmcc_requireexpirationdate == null)
            _ps.setNull(7, Types.BIT);
        else
            _ps.setInt(7, pmcc_requireexpirationdate? 1: 0);
            
        Boolean pmcc_checkexpirationdate = _value.getCheckExpirationDate();
        if(pmcc_checkexpirationdate == null)
            _ps.setNull(8, Types.BIT);
        else
            _ps.setInt(8, pmcc_checkexpirationdate? 1: 0);
            
        Boolean pmcc_requestsecuritycode = _value.getRequestSecurityCode();
        if(pmcc_requestsecuritycode == null)
            _ps.setNull(9, Types.BIT);
        else
            _ps.setInt(9, pmcc_requestsecuritycode? 1: 0);
            
        Boolean pmcc_requiresecuritycode = _value.getRequireSecurityCode();
        if(pmcc_requiresecuritycode == null)
            _ps.setNull(10, Types.BIT);
        else
            _ps.setInt(10, pmcc_requiresecuritycode? 1: 0);
            
        String pmcc_cardnumbervalidationpattern = _value.getCardNumberValidationPattern();
        if(pmcc_cardnumbervalidationpattern == null)
            _ps.setNull(11, Types.VARCHAR);
        else
            _ps.setString(11, pmcc_cardnumbervalidationpattern);
            
        String pmcc_securitycodevalidationpattern = _value.getSecurityCodeValidationPattern();
        if(pmcc_securitycodevalidationpattern == null)
            _ps.setNull(12, Types.VARCHAR);
        else
            _ps.setString(12, pmcc_securitycodevalidationpattern);
            
        Boolean pmcc_retaincreditcard = _value.getRetainCreditCard();
        if(pmcc_retaincreditcard == null)
            _ps.setNull(13, Types.BIT);
        else
            _ps.setInt(13, pmcc_retaincreditcard? 1: 0);
            
        Boolean pmcc_retainsecuritycode = _value.getRetainSecurityCode();
        if(pmcc_retainsecuritycode == null)
            _ps.setNull(14, Types.BIT);
        else
            _ps.setInt(14, pmcc_retainsecuritycode? 1: 0);
            
        Boolean pmcc_requestbilling = _value.getRequestBilling();
        if(pmcc_requestbilling == null)
            _ps.setNull(15, Types.BIT);
        else
            _ps.setInt(15, pmcc_requestbilling? 1: 0);
            
        Boolean pmcc_requirebilling = _value.getRequireBilling();
        if(pmcc_requirebilling == null)
            _ps.setNull(16, Types.BIT);
        else
            _ps.setInt(16, pmcc_requirebilling? 1: 0);
            
        Boolean pmcc_requestissuer = _value.getRequestIssuer();
        if(pmcc_requestissuer == null)
            _ps.setNull(17, Types.BIT);
        else
            _ps.setInt(17, pmcc_requestissuer? 1: 0);
            
        Boolean pmcc_requireissuer = _value.getRequireIssuer();
        if(pmcc_requireissuer == null)
            _ps.setNull(18, Types.BIT);
        else
            _ps.setInt(18, pmcc_requireissuer? 1: 0);
            
        Long pmcc_fromtime = _value.getFromTime();
        if(pmcc_fromtime == null)
            _ps.setNull(19, Types.BIGINT);
        else
            _ps.setLong(19, pmcc_fromtime);
            
        Long pmcc_thrutime = _value.getThruTime();
        if(pmcc_thrutime == null)
            _ps.setNull(20, Types.BIGINT);
        else
            _ps.setLong(20, pmcc_thrutime);
            
    }
    
    public PaymentMethodCreditCard create(PaymentMethodPK paymentMethodPK, Boolean requestNameOnCard, Boolean requireNameOnCard, Boolean checkCardNumber, Boolean requestExpirationDate, Boolean requireExpirationDate, Boolean checkExpirationDate, Boolean requestSecurityCode, Boolean requireSecurityCode, String cardNumberValidationPattern, String securityCodeValidationPattern, Boolean retainCreditCard, Boolean retainSecurityCode, Boolean requestBilling, Boolean requireBilling, Boolean requestIssuer, Boolean requireIssuer, Long fromTime, Long thruTime)
            throws PersistenceDatabaseException, PersistenceNotNullException {
        PaymentMethodCreditCardPK _pk = getNextPK();
        PaymentMethodCreditCardValue _value = new PaymentMethodCreditCardValue(_pk, paymentMethodPK, requestNameOnCard, requireNameOnCard, checkCardNumber, requestExpirationDate, requireExpirationDate, checkExpirationDate, requestSecurityCode, requireSecurityCode, cardNumberValidationPattern, securityCodeValidationPattern, retainCreditCard, retainSecurityCode, requestBilling, requireBilling, requestIssuer, requireIssuer, fromTime, thruTime);
        
        PreparedStatement _ps = session.prepareStatement(SQL_INSERT);
        
        try {
            bindForCreate(_ps, _value);
            
            if(PersistenceDebugFlags.CheckEntityInsertRowCount) {
                int _count = _ps.executeUpdate();
                
                if(_count != 1) {
                    throw new PersistenceDatabaseUpdateException("insert failed, _count = " + _count);
                }
            } else {
                 _ps.executeUpdate();
            }
            
            session.getValueCache().put(_value);
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        PaymentMethodCreditCard _entity = new PaymentMethodCreditCard(_value, EntityPermission.READ_ONLY);
        session.putReadOnlyEntity(_pk, _entity);
        
        return _entity;
    }
    
    public void create(Collection<PaymentMethodCreditCardValue> _values)
            throws PersistenceDatabaseException, PersistenceNotNullException {
        int _size = _values.size();
        
        if(_size > 0) {
            PreparedStatement _ps = session.prepareStatement(SQL_INSERT);
            List<PaymentMethodCreditCardValue> _cacheValues = new ArrayList<>(_size);
            
            try {
                for(PaymentMethodCreditCardValue _value : _values) {
                    _value.setEntityId(entityIdGenerator.getNextEntityId());
                    bindForCreate(_ps, _value);
                    
                    _ps.addBatch();
                    
                    _cacheValues.add(_value);
                }
                
                if(PersistenceDebugFlags.CheckEntityInsertRowCount) {
                    int[] _counts = _ps.executeBatch();
                    
                    for(int _countOffset = 0 ; _countOffset < _size ; _countOffset++) {
                        if(_counts[_countOffset] != 1 && _counts[_countOffset] != PreparedStatement.SUCCESS_NO_INFO) {
                            throw new PersistenceDatabaseUpdateException("batch insert failed, _counts[" + _countOffset + "] = " + _counts[_countOffset]);
                        }
                    }
                } else {
                     _ps.executeBatch();
                }
                
                _ps.clearBatch();
            } catch (SQLException se) {
                throw new PersistenceDatabaseException(se);
            }
            
            _cacheValues.forEach((_cacheValue) -> {
                PaymentMethodCreditCard _cacheEntity = new PaymentMethodCreditCard(_cacheValue, EntityPermission.READ_ONLY);
                
                session.putReadOnlyEntity(_cacheValue.getPrimaryKey(), _cacheEntity);
            });
        }
    }
    
    private boolean bindForStore(PreparedStatement _ps, PaymentMethodCreditCardValue _value)
            throws SQLException {
        boolean _hasBeenModified = _value.hasBeenModified();
        
        if(_hasBeenModified) {
            PaymentMethodPK pmcc_pm_paymentmethodid = _value.getPaymentMethodPK();
            if(pmcc_pm_paymentmethodid == null)
                _ps.setNull(1, Types.BIGINT);
            else
                _ps.setLong(1, pmcc_pm_paymentmethodid.getEntityId());
            
            Boolean pmcc_requestnameoncard = _value.getRequestNameOnCard();
            if(pmcc_requestnameoncard == null)
                _ps.setNull(2, Types.BIT);
            else
                _ps.setInt(2, pmcc_requestnameoncard? 1: 0);
            
            Boolean pmcc_requirenameoncard = _value.getRequireNameOnCard();
            if(pmcc_requirenameoncard == null)
                _ps.setNull(3, Types.BIT);
            else
                _ps.setInt(3, pmcc_requirenameoncard? 1: 0);
            
            Boolean pmcc_checkcardnumber = _value.getCheckCardNumber();
            if(pmcc_checkcardnumber == null)
                _ps.setNull(4, Types.BIT);
            else
                _ps.setInt(4, pmcc_checkcardnumber? 1: 0);
            
            Boolean pmcc_requestexpirationdate = _value.getRequestExpirationDate();
            if(pmcc_requestexpirationdate == null)
                _ps.setNull(5, Types.BIT);
            else
                _ps.setInt(5, pmcc_requestexpirationdate? 1: 0);
            
            Boolean pmcc_requireexpirationdate = _value.getRequireExpirationDate();
            if(pmcc_requireexpirationdate == null)
                _ps.setNull(6, Types.BIT);
            else
                _ps.setInt(6, pmcc_requireexpirationdate? 1: 0);
            
            Boolean pmcc_checkexpirationdate = _value.getCheckExpirationDate();
            if(pmcc_checkexpirationdate == null)
                _ps.setNull(7, Types.BIT);
            else
                _ps.setInt(7, pmcc_checkexpirationdate? 1: 0);
            
            Boolean pmcc_requestsecuritycode = _value.getRequestSecurityCode();
            if(pmcc_requestsecuritycode == null)
                _ps.setNull(8, Types.BIT);
            else
                _ps.setInt(8, pmcc_requestsecuritycode? 1: 0);
            
            Boolean pmcc_requiresecuritycode = _value.getRequireSecurityCode();
            if(pmcc_requiresecuritycode == null)
                _ps.setNull(9, Types.BIT);
            else
                _ps.setInt(9, pmcc_requiresecuritycode? 1: 0);
            
            String pmcc_cardnumbervalidationpattern = _value.getCardNumberValidationPattern();
            if(pmcc_cardnumbervalidationpattern == null)
                _ps.setNull(10, Types.VARCHAR);
            else
                _ps.setString(10, pmcc_cardnumbervalidationpattern);
            
            String pmcc_securitycodevalidationpattern = _value.getSecurityCodeValidationPattern();
            if(pmcc_securitycodevalidationpattern == null)
                _ps.setNull(11, Types.VARCHAR);
            else
                _ps.setString(11, pmcc_securitycodevalidationpattern);
            
            Boolean pmcc_retaincreditcard = _value.getRetainCreditCard();
            if(pmcc_retaincreditcard == null)
                _ps.setNull(12, Types.BIT);
            else
                _ps.setInt(12, pmcc_retaincreditcard? 1: 0);
            
            Boolean pmcc_retainsecuritycode = _value.getRetainSecurityCode();
            if(pmcc_retainsecuritycode == null)
                _ps.setNull(13, Types.BIT);
            else
                _ps.setInt(13, pmcc_retainsecuritycode? 1: 0);
            
            Boolean pmcc_requestbilling = _value.getRequestBilling();
            if(pmcc_requestbilling == null)
                _ps.setNull(14, Types.BIT);
            else
                _ps.setInt(14, pmcc_requestbilling? 1: 0);
            
            Boolean pmcc_requirebilling = _value.getRequireBilling();
            if(pmcc_requirebilling == null)
                _ps.setNull(15, Types.BIT);
            else
                _ps.setInt(15, pmcc_requirebilling? 1: 0);
            
            Boolean pmcc_requestissuer = _value.getRequestIssuer();
            if(pmcc_requestissuer == null)
                _ps.setNull(16, Types.BIT);
            else
                _ps.setInt(16, pmcc_requestissuer? 1: 0);
            
            Boolean pmcc_requireissuer = _value.getRequireIssuer();
            if(pmcc_requireissuer == null)
                _ps.setNull(17, Types.BIT);
            else
                _ps.setInt(17, pmcc_requireissuer? 1: 0);
            
            Long pmcc_fromtime = _value.getFromTime();
            if(pmcc_fromtime == null)
                _ps.setNull(18, Types.BIGINT);
            else
                _ps.setLong(18, pmcc_fromtime);
            
            Long pmcc_thrutime = _value.getThruTime();
            if(pmcc_thrutime == null)
                _ps.setNull(19, Types.BIGINT);
            else
                _ps.setLong(19, pmcc_thrutime);
            
            _ps.setLong(20, _value.getPrimaryKey().getEntityId());
            
            _value.clearHasBeenModified();
        }
        
        return _hasBeenModified;
    }
    
    @Override
    public void store(PaymentMethodCreditCard entity)
            throws PersistenceDatabaseException {
        PreparedStatement _ps = session.prepareStatement(SQL_UPDATE);
        
        try {
            PaymentMethodCreditCardValue _value = entity.getPaymentMethodCreditCardValue();
            
            if(bindForStore(_ps, _value)) {
                if(PersistenceDebugFlags.CheckEntityUpdateRowCount) {
                    int _count = _ps.executeUpdate();
                    
                    if(_count != 1) {
                        throw new PersistenceDatabaseUpdateException("update failed, _count = " + _count);
                    }
                } else {
                     _ps.executeUpdate();
                }
                
                session.getValueCache().put(_value);
            }
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
    }
    
    @Override
    public void store(Collection<PaymentMethodCreditCard> entities)
            throws PersistenceDatabaseException {
        if(entities.size() > 0) {
            PreparedStatement _ps = session.prepareStatement(SQL_UPDATE);
            int _modifiedEntities = 0;
            
            try {
                for(PaymentMethodCreditCard entity : entities) {
                    if(bindForStore(_ps, entity.getPaymentMethodCreditCardValue())) {
                        _ps.addBatch();
                        _modifiedEntities++;
                    }
                }
                
                if(_modifiedEntities != 0) {
                    if(PersistenceDebugFlags.CheckEntityUpdateRowCount) {
                        int[] _counts = _ps.executeBatch();
                        
                        for(int _countOffset = 0 ; _countOffset < _modifiedEntities  ; _countOffset++) {
                            if(_counts[_countOffset] != 1 && _counts[_countOffset] != PreparedStatement.SUCCESS_NO_INFO) {
                                throw new PersistenceDatabaseUpdateException("batch update failed, _counts[" + _countOffset + "] = " + _counts[_countOffset]);
                            }
                        }
                    } else {
                         _ps.executeBatch();
                    }
                    
                    _ps.clearBatch();
                    
                    entities.forEach((entity) -> {
                        session.getValueCache().put(entity.getPaymentMethodCreditCardValue());
                    });
                }
            } catch (SQLException se) {
                throw new PersistenceDatabaseException(se);
            }
        }
    }
    
    @Override
    public void remove(PaymentMethodCreditCard entity)
            throws PersistenceDatabaseException {
        remove(entity.getPrimaryKey());
    }
    
    @Override
    public void remove(PaymentMethodCreditCardPK pk)
            throws PersistenceDatabaseException {
        PreparedStatement _ps = session.prepareStatement(SQL_DELETE);
        long _entityId = pk.getEntityId();
        
        try {
            _ps.setLong(1, _entityId);
            
            if(PersistenceDebugFlags.CheckEntityDeleteRowCount) {
                int _count = _ps.executeUpdate();
                
                if(_count != 1) {
                    throw new PersistenceDatabaseUpdateException("remove failed, _count = " + _count);
                }
            } else {
                 _ps.executeUpdate();
            }
            
            session.getValueCache().remove(pk);
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        session.removed(pk, false);
    }
    
    @Override
    public void remove(Collection<PaymentMethodCreditCardPK> pks)
            throws PersistenceDatabaseException {
        if(pks.size() > 0) {
            PreparedStatement _ps = session.prepareStatement(SQL_DELETE);
            int _modifiedEntities = 0;
            
            try {
                for(PaymentMethodCreditCardPK pk : pks) {
                    long _entityId = pk.getEntityId();
                    
                    _ps.setLong(1, _entityId);
                    
                    _ps.addBatch();
                    _modifiedEntities++;
                }
                
                if(_modifiedEntities != 0) {
                    if(PersistenceDebugFlags.CheckEntityDeleteRowCount) {
                        int[] _counts = _ps.executeBatch();
                        
                        for(int _countOffset = 0 ; _countOffset < _modifiedEntities  ; _countOffset++) {
                            if(_counts[_countOffset] != 1 && _counts[_countOffset] != PreparedStatement.SUCCESS_NO_INFO) {
                                throw new PersistenceDatabaseUpdateException("batch remove failed, _counts[" + _countOffset + "] = " + _counts[_countOffset]);
                            }
                        }
                    } else {
                        _ps.executeBatch();
                    }
                    
                    _ps.clearBatch();
                    
                    pks.forEach((pk) -> {
                        session.getValueCache().remove(pk);
                    });
                }
            } catch (SQLException se) {
                throw new PersistenceDatabaseException(se);
            }
            
            pks.forEach((pk) -> {
                session.removed(pk, true);
            });
        }
    }
    
    @Override
    public boolean validPK(PaymentMethodCreditCardPK pk)
            throws PersistenceDatabaseException {
        boolean valid = false;
        PreparedStatement _ps = session.prepareStatement(SQL_VALID);
        ResultSet _rs = null;
        
        try {
            _ps.setLong(1, pk.getEntityId());
            
            _rs = _ps.executeQuery();
            if(_rs.next()) {
                long _count = _rs.getLong(1);
                if(_rs.wasNull())
                    _count = 0;
                
                if(_count == 1)
                    valid = true;
            }
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        } finally {
            if(_rs != null) {
                try {
                    _rs.close();
                } catch (SQLException se) {
                    // do nothing
                }
            }
        }
        
        return valid;
    }
    
}