// --------------------------------------------------------------------------------
// Copyright 2002-2025 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
// --------------------------------------------------------------------------------

/**
 * ItemDetailFactory.java
 */

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

import com.echothree.model.data.item.common.pk.ItemPK;
import com.echothree.model.data.item.common.pk.ItemTypePK;
import com.echothree.model.data.item.common.pk.ItemUseTypePK;
import com.echothree.model.data.item.common.pk.ItemCategoryPK;
import com.echothree.model.data.accounting.common.pk.ItemAccountingCategoryPK;
import com.echothree.model.data.vendor.common.pk.ItemPurchasingCategoryPK;
import com.echothree.model.data.party.common.pk.PartyPK;
import com.echothree.model.data.item.common.pk.ItemDeliveryTypePK;
import com.echothree.model.data.item.common.pk.ItemInventoryTypePK;
import com.echothree.model.data.sequence.common.pk.SequencePK;
import com.echothree.model.data.uom.common.pk.UnitOfMeasureKindPK;
import com.echothree.model.data.item.common.pk.ItemPriceTypePK;
import com.echothree.model.data.cancellationpolicy.common.pk.CancellationPolicyPK;
import com.echothree.model.data.returnpolicy.common.pk.ReturnPolicyPK;
import com.echothree.model.data.style.common.pk.StylePathPK;

import com.echothree.model.data.item.server.entity.Item;
import com.echothree.model.data.item.server.entity.ItemType;
import com.echothree.model.data.item.server.entity.ItemUseType;
import com.echothree.model.data.item.server.entity.ItemCategory;
import com.echothree.model.data.accounting.server.entity.ItemAccountingCategory;
import com.echothree.model.data.vendor.server.entity.ItemPurchasingCategory;
import com.echothree.model.data.party.server.entity.Party;
import com.echothree.model.data.item.server.entity.ItemDeliveryType;
import com.echothree.model.data.item.server.entity.ItemInventoryType;
import com.echothree.model.data.sequence.server.entity.Sequence;
import com.echothree.model.data.uom.server.entity.UnitOfMeasureKind;
import com.echothree.model.data.item.server.entity.ItemPriceType;
import com.echothree.model.data.cancellationpolicy.server.entity.CancellationPolicy;
import com.echothree.model.data.returnpolicy.server.entity.ReturnPolicy;
import com.echothree.model.data.style.server.entity.StylePath;

import com.echothree.model.data.item.common.ItemDetailConstants;
import com.echothree.model.data.item.common.pk.ItemDetailPK;
import com.echothree.model.data.item.server.value.ItemDetailValue;
import com.echothree.model.data.item.server.entity.ItemDetail;
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 com.echothree.util.server.persistence.ThreadSession;
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 org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

@ApplicationScoped
public class ItemDetailFactory
        implements BaseFactory<ItemDetailPK, ItemDetail> {
    
    //final private static Log log = LogFactory.getLog(ItemDetailFactory.class);
    
    final private static String SQL_SELECT_READ_ONLY = "SELECT itmdt_itemdetailid, itmdt_itm_itemid, itmdt_itemname, itmdt_ityp_itemtypeid, itmdt_iutyp_itemusetypeid, itmdt_ic_itemcategoryid, itmdt_iactgc_itemaccountingcategoryid, itmdt_iprchc_itempurchasingcategoryid, itmdt_companypartyid, itmdt_idlvrtyp_itemdeliverytypeid, itmdt_iinvtyp_iteminventorytypeid, itmdt_inventoryserialized, itmdt_serialnumbersequenceid, itmdt_shippingchargeexempt, itmdt_shippingstarttime, itmdt_shippingendtime, itmdt_salesorderstarttime, itmdt_salesorderendtime, itmdt_purchaseorderstarttime, itmdt_purchaseorderendtime, itmdt_allowclubdiscounts, itmdt_allowcoupondiscounts, itmdt_allowassociatepayments, itmdt_uomk_unitofmeasurekindid, itmdt_ipt_itempricetypeid, itmdt_cnclplcy_cancellationpolicyid, itmdt_rtnplcy_returnpolicyid, itmdt_stylpth_stylepathid, itmdt_fromtime, itmdt_thrutime FROM itemdetails WHERE itmdt_itemdetailid = ?";
    final private static String SQL_SELECT_READ_WRITE = "SELECT itmdt_itemdetailid, itmdt_itm_itemid, itmdt_itemname, itmdt_ityp_itemtypeid, itmdt_iutyp_itemusetypeid, itmdt_ic_itemcategoryid, itmdt_iactgc_itemaccountingcategoryid, itmdt_iprchc_itempurchasingcategoryid, itmdt_companypartyid, itmdt_idlvrtyp_itemdeliverytypeid, itmdt_iinvtyp_iteminventorytypeid, itmdt_inventoryserialized, itmdt_serialnumbersequenceid, itmdt_shippingchargeexempt, itmdt_shippingstarttime, itmdt_shippingendtime, itmdt_salesorderstarttime, itmdt_salesorderendtime, itmdt_purchaseorderstarttime, itmdt_purchaseorderendtime, itmdt_allowclubdiscounts, itmdt_allowcoupondiscounts, itmdt_allowassociatepayments, itmdt_uomk_unitofmeasurekindid, itmdt_ipt_itempricetypeid, itmdt_cnclplcy_cancellationpolicyid, itmdt_rtnplcy_returnpolicyid, itmdt_stylpth_stylepathid, itmdt_fromtime, itmdt_thrutime FROM itemdetails WHERE itmdt_itemdetailid = ? FOR UPDATE";
    final private static String SQL_INSERT = "INSERT INTO itemdetails (itmdt_itemdetailid, itmdt_itm_itemid, itmdt_itemname, itmdt_ityp_itemtypeid, itmdt_iutyp_itemusetypeid, itmdt_ic_itemcategoryid, itmdt_iactgc_itemaccountingcategoryid, itmdt_iprchc_itempurchasingcategoryid, itmdt_companypartyid, itmdt_idlvrtyp_itemdeliverytypeid, itmdt_iinvtyp_iteminventorytypeid, itmdt_inventoryserialized, itmdt_serialnumbersequenceid, itmdt_shippingchargeexempt, itmdt_shippingstarttime, itmdt_shippingendtime, itmdt_salesorderstarttime, itmdt_salesorderendtime, itmdt_purchaseorderstarttime, itmdt_purchaseorderendtime, itmdt_allowclubdiscounts, itmdt_allowcoupondiscounts, itmdt_allowassociatepayments, itmdt_uomk_unitofmeasurekindid, itmdt_ipt_itempricetypeid, itmdt_cnclplcy_cancellationpolicyid, itmdt_rtnplcy_returnpolicyid, itmdt_stylpth_stylepathid, itmdt_fromtime, itmdt_thrutime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
    final private static String SQL_UPDATE = "UPDATE itemdetails SET itmdt_itm_itemid = ?, itmdt_itemname = ?, itmdt_ityp_itemtypeid = ?, itmdt_iutyp_itemusetypeid = ?, itmdt_ic_itemcategoryid = ?, itmdt_iactgc_itemaccountingcategoryid = ?, itmdt_iprchc_itempurchasingcategoryid = ?, itmdt_companypartyid = ?, itmdt_idlvrtyp_itemdeliverytypeid = ?, itmdt_iinvtyp_iteminventorytypeid = ?, itmdt_inventoryserialized = ?, itmdt_serialnumbersequenceid = ?, itmdt_shippingchargeexempt = ?, itmdt_shippingstarttime = ?, itmdt_shippingendtime = ?, itmdt_salesorderstarttime = ?, itmdt_salesorderendtime = ?, itmdt_purchaseorderstarttime = ?, itmdt_purchaseorderendtime = ?, itmdt_allowclubdiscounts = ?, itmdt_allowcoupondiscounts = ?, itmdt_allowassociatepayments = ?, itmdt_uomk_unitofmeasurekindid = ?, itmdt_ipt_itempricetypeid = ?, itmdt_cnclplcy_cancellationpolicyid = ?, itmdt_rtnplcy_returnpolicyid = ?, itmdt_stylpth_stylepathid = ?, itmdt_fromtime = ?, itmdt_thrutime = ? WHERE itmdt_itemdetailid = ?";
    final private static String SQL_DELETE = "DELETE FROM itemdetails WHERE itmdt_itemdetailid = ?";
    final private static String SQL_VALID = "SELECT COUNT(*) FROM itemdetails WHERE itmdt_itemdetailid = ?";
    
    final private static String PK_COLUMN = "itmdt_itemdetailid";
    final private static String ALL_COLUMNS = "itmdt_itemdetailid, itmdt_itm_itemid, itmdt_itemname, itmdt_ityp_itemtypeid, itmdt_iutyp_itemusetypeid, itmdt_ic_itemcategoryid, itmdt_iactgc_itemaccountingcategoryid, itmdt_iprchc_itempurchasingcategoryid, itmdt_companypartyid, itmdt_idlvrtyp_itemdeliverytypeid, itmdt_iinvtyp_iteminventorytypeid, itmdt_inventoryserialized, itmdt_serialnumbersequenceid, itmdt_shippingchargeexempt, itmdt_shippingstarttime, itmdt_shippingendtime, itmdt_salesorderstarttime, itmdt_salesorderendtime, itmdt_purchaseorderstarttime, itmdt_purchaseorderendtime, itmdt_allowclubdiscounts, itmdt_allowcoupondiscounts, itmdt_allowassociatepayments, itmdt_uomk_unitofmeasurekindid, itmdt_ipt_itempricetypeid, itmdt_cnclplcy_cancellationpolicyid, itmdt_rtnplcy_returnpolicyid, itmdt_stylpth_stylepathid, itmdt_fromtime, itmdt_thrutime";
    final public static String TABLE_NAME = "itemdetails";
    
    final public static String ITMDT_ITEMDETAILID = "itmdt_itemdetailid";
    final public static String ITMDT_ITM_ITEMID = "itmdt_itm_itemid";
    final public static String ITMDT_ITEMNAME = "itmdt_itemname";
    final public static String ITMDT_ITYP_ITEMTYPEID = "itmdt_ityp_itemtypeid";
    final public static String ITMDT_IUTYP_ITEMUSETYPEID = "itmdt_iutyp_itemusetypeid";
    final public static String ITMDT_IC_ITEMCATEGORYID = "itmdt_ic_itemcategoryid";
    final public static String ITMDT_IACTGC_ITEMACCOUNTINGCATEGORYID = "itmdt_iactgc_itemaccountingcategoryid";
    final public static String ITMDT_IPRCHC_ITEMPURCHASINGCATEGORYID = "itmdt_iprchc_itempurchasingcategoryid";
    final public static String ITMDT_COMPANYPARTYID = "itmdt_companypartyid";
    final public static String ITMDT_IDLVRTYP_ITEMDELIVERYTYPEID = "itmdt_idlvrtyp_itemdeliverytypeid";
    final public static String ITMDT_IINVTYP_ITEMINVENTORYTYPEID = "itmdt_iinvtyp_iteminventorytypeid";
    final public static String ITMDT_INVENTORYSERIALIZED = "itmdt_inventoryserialized";
    final public static String ITMDT_SERIALNUMBERSEQUENCEID = "itmdt_serialnumbersequenceid";
    final public static String ITMDT_SHIPPINGCHARGEEXEMPT = "itmdt_shippingchargeexempt";
    final public static String ITMDT_SHIPPINGSTARTTIME = "itmdt_shippingstarttime";
    final public static String ITMDT_SHIPPINGENDTIME = "itmdt_shippingendtime";
    final public static String ITMDT_SALESORDERSTARTTIME = "itmdt_salesorderstarttime";
    final public static String ITMDT_SALESORDERENDTIME = "itmdt_salesorderendtime";
    final public static String ITMDT_PURCHASEORDERSTARTTIME = "itmdt_purchaseorderstarttime";
    final public static String ITMDT_PURCHASEORDERENDTIME = "itmdt_purchaseorderendtime";
    final public static String ITMDT_ALLOWCLUBDISCOUNTS = "itmdt_allowclubdiscounts";
    final public static String ITMDT_ALLOWCOUPONDISCOUNTS = "itmdt_allowcoupondiscounts";
    final public static String ITMDT_ALLOWASSOCIATEPAYMENTS = "itmdt_allowassociatepayments";
    final public static String ITMDT_UOMK_UNITOFMEASUREKINDID = "itmdt_uomk_unitofmeasurekindid";
    final public static String ITMDT_IPT_ITEMPRICETYPEID = "itmdt_ipt_itempricetypeid";
    final public static String ITMDT_CNCLPLCY_CANCELLATIONPOLICYID = "itmdt_cnclplcy_cancellationpolicyid";
    final public static String ITMDT_RTNPLCY_RETURNPOLICYID = "itmdt_rtnplcy_returnpolicyid";
    final public static String ITMDT_STYLPTH_STYLEPATHID = "itmdt_stylpth_stylepathid";
    final public static String ITMDT_FROMTIME = "itmdt_fromtime";
    final public static String ITMDT_THRUTIME = "itmdt_thrutime";
    
    final private static EntityIdGenerator entityIdGenerator = new EntityIdGenerator(ItemDetailConstants.COMPONENT_VENDOR_NAME, ItemDetailConstants.ENTITY_TYPE_NAME);
    
    /** Creates a new instance of ItemDetailFactory */
    protected ItemDetailFactory() {
        super();
    }
    
    public static ItemDetailFactory getInstance() {
        return CDI.current().select(ItemDetailFactory.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 ItemDetailConstants.COMPONENT_VENDOR_NAME;
    }
    
    @Override
    public String getEntityTypeName() {
        return ItemDetailConstants.ENTITY_TYPE_NAME;
    }
    
    public PreparedStatement prepareStatement(String query) {
        return ThreadSession.currentSession().prepareStatement(ItemDetailFactory.class, query);
    }
    
    public ItemDetailPK getNextPK() {
        return new ItemDetailPK(entityIdGenerator.getNextEntityId());
    }
    
    public Set<ItemDetailPK> getPKsFromResultSetAsSet(ResultSet rs)
            throws PersistenceDatabaseException {
        Set<ItemDetailPK> _result = new HashSet<>();
        
        try {
            while(rs.next()) {
                _result.add(getPKFromResultSet(rs));
            }
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        return _result;
    }
    
    public java.util.List<ItemDetailPK> getPKsFromResultSetAsList(ResultSet rs)
            throws PersistenceDatabaseException {
        java.util.List<ItemDetailPK> _result = new ArrayList<>();
        
        try {
            while(rs.next()) {
                _result.add(getPKFromResultSet(rs));
            }
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        return _result;
    }
    
    public ItemDetailPK getPKFromResultSet(ResultSet rs)
            throws PersistenceDatabaseException {
        ItemDetailPK _result;
        
        try {
            long itmdt_itemdetailid = rs.getLong(ITMDT_ITEMDETAILID);
            Long _entityId = rs.wasNull() ? null : itmdt_itemdetailid;
            
            _result = new ItemDetailPK(_entityId);
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        return _result;
    }
    
    public java.util.List<ItemDetailValue> getValuesFromPKs(Session session, Collection<ItemDetailPK> pks)
            throws PersistenceDatabaseException {
        java.util.List<ItemDetailValue> _values = new ArrayList<>(pks.size());
        
        for(ItemDetailPK _pk: pks) {
            _values.add(getValueFromPK(session, _pk));
        }
        
        return _values;
    }
    
    public ItemDetailValue getValueFromPK(Session session, ItemDetailPK pk)
            throws PersistenceDatabaseException {
        ItemDetailValue _value;
        
        // See if we already have the entity in the session cache
        ItemDetail _entity = (ItemDetail)session.getEntity(pk);
        if(_entity == null)
            _value = getEntityFromPK(session, EntityPermission.READ_ONLY, pk).getItemDetailValue();
        else
            _value = _entity.getItemDetailValue();
        
        return _value;
    }
    
    public java.util.List<ItemDetailValue> getValuesFromResultSet(Session session, ResultSet rs)
            throws PersistenceDatabaseException {
        java.util.List<ItemDetailValue> _result = new ArrayList<>();
        
        try {
            while(rs.next()) {
                _result.add(getValueFromResultSet(session, rs));
            }
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        return _result;
    }
    
    public ItemDetailValue getValueFromResultSet(Session session, ResultSet rs)
            throws PersistenceDatabaseException {
        ItemDetailValue _value;
        
        try {
            Long itmdt_itemdetailid = rs.getLong(ITMDT_ITEMDETAILID);
            ItemDetailPK _pk = new ItemDetailPK(itmdt_itemdetailid);
            
            // See if we already have the entity in the session cache
            ItemDetail _entity = (ItemDetail)session.getEntity(_pk);
            
            if(_entity == null) {
                Long itmdt_itm_itemid = rs.getLong(ITMDT_ITM_ITEMID);
                if(rs.wasNull())
                    itmdt_itm_itemid = null;
                
                String itmdt_itemname = rs.getString(ITMDT_ITEMNAME);
                if(rs.wasNull())
                    itmdt_itemname = null;
                
                Long itmdt_ityp_itemtypeid = rs.getLong(ITMDT_ITYP_ITEMTYPEID);
                if(rs.wasNull())
                    itmdt_ityp_itemtypeid = null;
                
                Long itmdt_iutyp_itemusetypeid = rs.getLong(ITMDT_IUTYP_ITEMUSETYPEID);
                if(rs.wasNull())
                    itmdt_iutyp_itemusetypeid = null;
                
                Long itmdt_ic_itemcategoryid = rs.getLong(ITMDT_IC_ITEMCATEGORYID);
                if(rs.wasNull())
                    itmdt_ic_itemcategoryid = null;
                
                Long itmdt_iactgc_itemaccountingcategoryid = rs.getLong(ITMDT_IACTGC_ITEMACCOUNTINGCATEGORYID);
                if(rs.wasNull())
                    itmdt_iactgc_itemaccountingcategoryid = null;
                
                Long itmdt_iprchc_itempurchasingcategoryid = rs.getLong(ITMDT_IPRCHC_ITEMPURCHASINGCATEGORYID);
                if(rs.wasNull())
                    itmdt_iprchc_itempurchasingcategoryid = null;
                
                Long itmdt_companypartyid = rs.getLong(ITMDT_COMPANYPARTYID);
                if(rs.wasNull())
                    itmdt_companypartyid = null;
                
                Long itmdt_idlvrtyp_itemdeliverytypeid = rs.getLong(ITMDT_IDLVRTYP_ITEMDELIVERYTYPEID);
                if(rs.wasNull())
                    itmdt_idlvrtyp_itemdeliverytypeid = null;
                
                Long itmdt_iinvtyp_iteminventorytypeid = rs.getLong(ITMDT_IINVTYP_ITEMINVENTORYTYPEID);
                if(rs.wasNull())
                    itmdt_iinvtyp_iteminventorytypeid = null;
                
                Boolean itmdt_inventoryserialized = rs.getInt(ITMDT_INVENTORYSERIALIZED) == 1;
                if(rs.wasNull())
                    itmdt_inventoryserialized = null;
                
                Long itmdt_serialnumbersequenceid = rs.getLong(ITMDT_SERIALNUMBERSEQUENCEID);
                if(rs.wasNull())
                    itmdt_serialnumbersequenceid = null;
                
                Boolean itmdt_shippingchargeexempt = rs.getInt(ITMDT_SHIPPINGCHARGEEXEMPT) == 1;
                if(rs.wasNull())
                    itmdt_shippingchargeexempt = null;
                
                Long itmdt_shippingstarttime = rs.getLong(ITMDT_SHIPPINGSTARTTIME);
                if(rs.wasNull())
                    itmdt_shippingstarttime = null;
                
                Long itmdt_shippingendtime = rs.getLong(ITMDT_SHIPPINGENDTIME);
                if(rs.wasNull())
                    itmdt_shippingendtime = null;
                
                Long itmdt_salesorderstarttime = rs.getLong(ITMDT_SALESORDERSTARTTIME);
                if(rs.wasNull())
                    itmdt_salesorderstarttime = null;
                
                Long itmdt_salesorderendtime = rs.getLong(ITMDT_SALESORDERENDTIME);
                if(rs.wasNull())
                    itmdt_salesorderendtime = null;
                
                Long itmdt_purchaseorderstarttime = rs.getLong(ITMDT_PURCHASEORDERSTARTTIME);
                if(rs.wasNull())
                    itmdt_purchaseorderstarttime = null;
                
                Long itmdt_purchaseorderendtime = rs.getLong(ITMDT_PURCHASEORDERENDTIME);
                if(rs.wasNull())
                    itmdt_purchaseorderendtime = null;
                
                Boolean itmdt_allowclubdiscounts = rs.getInt(ITMDT_ALLOWCLUBDISCOUNTS) == 1;
                if(rs.wasNull())
                    itmdt_allowclubdiscounts = null;
                
                Boolean itmdt_allowcoupondiscounts = rs.getInt(ITMDT_ALLOWCOUPONDISCOUNTS) == 1;
                if(rs.wasNull())
                    itmdt_allowcoupondiscounts = null;
                
                Boolean itmdt_allowassociatepayments = rs.getInt(ITMDT_ALLOWASSOCIATEPAYMENTS) == 1;
                if(rs.wasNull())
                    itmdt_allowassociatepayments = null;
                
                Long itmdt_uomk_unitofmeasurekindid = rs.getLong(ITMDT_UOMK_UNITOFMEASUREKINDID);
                if(rs.wasNull())
                    itmdt_uomk_unitofmeasurekindid = null;
                
                Long itmdt_ipt_itempricetypeid = rs.getLong(ITMDT_IPT_ITEMPRICETYPEID);
                if(rs.wasNull())
                    itmdt_ipt_itempricetypeid = null;
                
                Long itmdt_cnclplcy_cancellationpolicyid = rs.getLong(ITMDT_CNCLPLCY_CANCELLATIONPOLICYID);
                if(rs.wasNull())
                    itmdt_cnclplcy_cancellationpolicyid = null;
                
                Long itmdt_rtnplcy_returnpolicyid = rs.getLong(ITMDT_RTNPLCY_RETURNPOLICYID);
                if(rs.wasNull())
                    itmdt_rtnplcy_returnpolicyid = null;
                
                Long itmdt_stylpth_stylepathid = rs.getLong(ITMDT_STYLPTH_STYLEPATHID);
                if(rs.wasNull())
                    itmdt_stylpth_stylepathid = null;
                
                Long itmdt_fromtime = rs.getLong(ITMDT_FROMTIME);
                if(rs.wasNull())
                    itmdt_fromtime = null;
                
                Long itmdt_thrutime = rs.getLong(ITMDT_THRUTIME);
                if(rs.wasNull())
                    itmdt_thrutime = null;
                
                _value = new ItemDetailValue(_pk, new ItemPK(itmdt_itm_itemid), itmdt_itemname, new ItemTypePK(itmdt_ityp_itemtypeid), new ItemUseTypePK(itmdt_iutyp_itemusetypeid), new ItemCategoryPK(itmdt_ic_itemcategoryid), new ItemAccountingCategoryPK(itmdt_iactgc_itemaccountingcategoryid), new ItemPurchasingCategoryPK(itmdt_iprchc_itempurchasingcategoryid), new PartyPK(itmdt_companypartyid), new ItemDeliveryTypePK(itmdt_idlvrtyp_itemdeliverytypeid), new ItemInventoryTypePK(itmdt_iinvtyp_iteminventorytypeid), itmdt_inventoryserialized, new SequencePK(itmdt_serialnumbersequenceid), itmdt_shippingchargeexempt, itmdt_shippingstarttime, itmdt_shippingendtime, itmdt_salesorderstarttime, itmdt_salesorderendtime, itmdt_purchaseorderstarttime, itmdt_purchaseorderendtime, itmdt_allowclubdiscounts, itmdt_allowcoupondiscounts, itmdt_allowassociatepayments, new UnitOfMeasureKindPK(itmdt_uomk_unitofmeasurekindid), new ItemPriceTypePK(itmdt_ipt_itempricetypeid), new CancellationPolicyPK(itmdt_cnclplcy_cancellationpolicyid), new ReturnPolicyPK(itmdt_rtnplcy_returnpolicyid), new StylePathPK(itmdt_stylpth_stylepathid), itmdt_fromtime, itmdt_thrutime);
            } else
                _value = _entity.getItemDetailValue();
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        return _value;
    }
    
    public java.util.List<ItemDetail> getEntitiesFromPKs(EntityPermission entityPermission, Collection<ItemDetailPK> pks)
            throws PersistenceDatabaseException {
        return getEntitiesFromPKs(ThreadSession.currentSession(), entityPermission, pks);
    }
    
    public java.util.List<ItemDetail> getEntitiesFromPKs(Session session, EntityPermission entityPermission, Collection<ItemDetailPK> pks)
            throws PersistenceDatabaseException {
        java.util.List<ItemDetail> _entities = new ArrayList<>(pks.size());
        
        for(ItemDetailPK _pk: pks) {
            _entities.add(getEntityFromPK(session, entityPermission, _pk));
        }
        
        return _entities;
    }
    
    public ItemDetail getEntityFromValue(EntityPermission entityPermission, ItemDetailValue value) {
        return getEntityFromPK(ThreadSession.currentSession(), entityPermission, value.getPrimaryKey());
    }
    
    public ItemDetail getEntityFromValue(Session session, EntityPermission entityPermission, ItemDetailValue value) {
        return getEntityFromPK(session, entityPermission, value.getPrimaryKey());
    }
    
    public ItemDetail getEntityFromPK(EntityPermission entityPermission, ItemDetailPK pk)
            throws PersistenceDatabaseException {
        return getEntityFromPK(ThreadSession.currentSession(), entityPermission, pk);
    }
    
    public ItemDetail getEntityFromCache(Session session, ItemDetailPK pk) {
        ItemDetailValue _value = (ItemDetailValue)session.getValueCache().get(pk);
    
        return _value == null ? null : new ItemDetail(_value, EntityPermission.READ_ONLY);
    }
    
    public ItemDetail getEntityFromPK(Session session, EntityPermission entityPermission, ItemDetailPK pk)
            throws PersistenceDatabaseException {
        ItemDetail _entity;
        
        // See if we already have the entity in the session cache
        _entity = (ItemDetail)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(session, 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(session, 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<ItemDetailPK> getPKsFromQueryAsSet(PreparedStatement ps, final Object... params)
            throws PersistenceDatabaseException {
        Set<ItemDetailPK> _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<ItemDetailPK> getPKsFromQueryAsList(PreparedStatement ps, final Object... params)
            throws PersistenceDatabaseException {
        java.util.List<ItemDetailPK> _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 ItemDetailPK getPKFromQuery(PreparedStatement ps, final Object... params)
            throws PersistenceDatabaseException {
        ItemDetailPK _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<ItemDetail> getEntitiesFromQuery(Session session, EntityPermission entityPermission, Map<EntityPermission, String>queryMap, final Object... params)
            throws PersistenceDatabaseException {
        PreparedStatement ps = session.prepareStatement(ItemDetailFactory.class, queryMap.get(entityPermission));
        
        return getEntitiesFromQuery(session, entityPermission, ps, params);
    }
    
    public java.util.List<ItemDetail> getEntitiesFromQuery(EntityPermission entityPermission, Map<EntityPermission, String>queryMap, final Object... params)
            throws PersistenceDatabaseException {
        Session session = ThreadSession.currentSession();
        PreparedStatement ps = session.prepareStatement(ItemDetailFactory.class, queryMap.get(entityPermission));
        
        return getEntitiesFromQuery(session, entityPermission, ps, params);
    }
    
    public java.util.List<ItemDetail> getEntitiesFromQuery(Session session, EntityPermission entityPermission, Map<EntityPermission, String>queryMap)
            throws PersistenceDatabaseException {
        PreparedStatement ps = session.prepareStatement(ItemDetailFactory.class, queryMap.get(entityPermission));
        
        return getEntitiesFromQuery(session, entityPermission, ps);
    }
    
    public java.util.List<ItemDetail> getEntitiesFromQuery(EntityPermission entityPermission, Map<EntityPermission, String>queryMap)
            throws PersistenceDatabaseException {
        Session session = ThreadSession.currentSession();
        PreparedStatement ps = session.prepareStatement(ItemDetailFactory.class, queryMap.get(entityPermission));
        
        return getEntitiesFromQuery(session, entityPermission, ps);
    }
    
    public java.util.List<ItemDetail> getEntitiesFromQuery(EntityPermission entityPermission, PreparedStatement ps)
            throws PersistenceDatabaseException {
        return getEntitiesFromQuery(ThreadSession.currentSession(), entityPermission, ps);
    }
    
    public java.util.List<ItemDetail> getEntitiesFromQuery(EntityPermission entityPermission, PreparedStatement ps, final Object... params)
            throws PersistenceDatabaseException {
        return getEntitiesFromQuery(ThreadSession.currentSession(), entityPermission, ps, params);
    }
    
    public java.util.List<ItemDetail> getEntitiesFromQuery(Session session, EntityPermission entityPermission, PreparedStatement ps, final Object... params)
            throws PersistenceDatabaseException {
        java.util.List<ItemDetail> _entities;
        ResultSet _rs = null;
        
        try {
            if(params.length != 0) {
                Session.setQueryParams(ps, params);
            }
            
            _rs = ps.executeQuery();
            _entities = getEntitiesFromResultSet(session, 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 ItemDetail getEntityFromQuery(Session session, EntityPermission entityPermission, Map<EntityPermission, String>queryMap, final Object... params)
            throws PersistenceDatabaseException {
        PreparedStatement ps = session.prepareStatement(ItemDetailFactory.class, queryMap.get(entityPermission));
        
        return getEntityFromQuery(session, entityPermission, ps, params);
    }
    
    public ItemDetail getEntityFromQuery(EntityPermission entityPermission, Map<EntityPermission, String>queryMap, final Object... params)
            throws PersistenceDatabaseException {
        Session session = ThreadSession.currentSession();
        PreparedStatement ps = session.prepareStatement(ItemDetailFactory.class, queryMap.get(entityPermission));
        
        return getEntityFromQuery(session, entityPermission, ps, params);
    }
    
    public ItemDetail getEntityFromQuery(Session session, EntityPermission entityPermission, Map<EntityPermission, String>queryMap)
            throws PersistenceDatabaseException {
        PreparedStatement ps = session.prepareStatement(ItemDetailFactory.class, queryMap.get(entityPermission));
        
        return getEntityFromQuery(session, entityPermission, ps);
    }
    
    public ItemDetail getEntityFromQuery(EntityPermission entityPermission, Map<EntityPermission, String>queryMap)
            throws PersistenceDatabaseException {
        Session session = ThreadSession.currentSession();
        PreparedStatement ps = session.prepareStatement(ItemDetailFactory.class, queryMap.get(entityPermission));
        
        return getEntityFromQuery(session, entityPermission, ps);
    }
    
    public ItemDetail getEntityFromQuery(EntityPermission entityPermission, PreparedStatement ps)
            throws PersistenceDatabaseException {
        return getEntityFromQuery(ThreadSession.currentSession(), entityPermission, ps);
    }
    
    public ItemDetail getEntityFromQuery(EntityPermission entityPermission, PreparedStatement ps, final Object... params)
            throws PersistenceDatabaseException {
        return getEntityFromQuery(ThreadSession.currentSession(), entityPermission, ps, params);
    }
    
    public ItemDetail getEntityFromQuery(Session session, EntityPermission entityPermission, PreparedStatement ps, final Object... params)
            throws PersistenceDatabaseException {
        ItemDetail _entity = null;
        ResultSet _rs = null;
        
        try {
            if(params.length != 0) {
                Session.setQueryParams(ps, params);
            }
            
            _rs = ps.executeQuery();
            if(_rs.next()) {
                _entity = getEntityFromResultSet(session, 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<ItemDetail> getEntitiesFromResultSet(EntityPermission entityPermission, ResultSet rs)
            throws PersistenceDatabaseException {
        return getEntitiesFromResultSet(ThreadSession.currentSession(), entityPermission, rs);
    }
    
    public java.util.List<ItemDetail> getEntitiesFromResultSet(Session session, EntityPermission entityPermission, ResultSet rs)
            throws PersistenceDatabaseException {
        java.util.List<ItemDetail> _result = new ArrayList<>();
        
        try {
            while(rs.next()) {
                _result.add(getEntityFromResultSet(session, entityPermission, rs));
            }
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        return _result;
    }
    
    public ItemDetail getEntityFromResultSet(EntityPermission entityPermission, ResultSet rs)
            throws PersistenceDatabaseException {
        return getEntityFromResultSet(ThreadSession.currentSession(), entityPermission, rs);
    }
    
    public ItemDetail getEntityFromResultSet(Session session, EntityPermission entityPermission, ResultSet rs)
            throws PersistenceDatabaseException {
        ItemDetail _entity;
        
        try {
            Long itmdt_itemdetailid = rs.getLong(ITMDT_ITEMDETAILID);
            ItemDetailPK _pk = new ItemDetailPK(itmdt_itemdetailid);
            
            // See if we already have the entity in the session cache
            _entity = (ItemDetail)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(session, _pk);
            }
            
            if(_entity == null) {
                Long itmdt_itm_itemid = rs.getLong(ITMDT_ITM_ITEMID);
                if(rs.wasNull())
                    itmdt_itm_itemid = null;
                
                String itmdt_itemname = rs.getString(ITMDT_ITEMNAME);
                if(rs.wasNull())
                    itmdt_itemname = null;
                
                Long itmdt_ityp_itemtypeid = rs.getLong(ITMDT_ITYP_ITEMTYPEID);
                if(rs.wasNull())
                    itmdt_ityp_itemtypeid = null;
                
                Long itmdt_iutyp_itemusetypeid = rs.getLong(ITMDT_IUTYP_ITEMUSETYPEID);
                if(rs.wasNull())
                    itmdt_iutyp_itemusetypeid = null;
                
                Long itmdt_ic_itemcategoryid = rs.getLong(ITMDT_IC_ITEMCATEGORYID);
                if(rs.wasNull())
                    itmdt_ic_itemcategoryid = null;
                
                Long itmdt_iactgc_itemaccountingcategoryid = rs.getLong(ITMDT_IACTGC_ITEMACCOUNTINGCATEGORYID);
                if(rs.wasNull())
                    itmdt_iactgc_itemaccountingcategoryid = null;
                
                Long itmdt_iprchc_itempurchasingcategoryid = rs.getLong(ITMDT_IPRCHC_ITEMPURCHASINGCATEGORYID);
                if(rs.wasNull())
                    itmdt_iprchc_itempurchasingcategoryid = null;
                
                Long itmdt_companypartyid = rs.getLong(ITMDT_COMPANYPARTYID);
                if(rs.wasNull())
                    itmdt_companypartyid = null;
                
                Long itmdt_idlvrtyp_itemdeliverytypeid = rs.getLong(ITMDT_IDLVRTYP_ITEMDELIVERYTYPEID);
                if(rs.wasNull())
                    itmdt_idlvrtyp_itemdeliverytypeid = null;
                
                Long itmdt_iinvtyp_iteminventorytypeid = rs.getLong(ITMDT_IINVTYP_ITEMINVENTORYTYPEID);
                if(rs.wasNull())
                    itmdt_iinvtyp_iteminventorytypeid = null;
                
                Boolean itmdt_inventoryserialized = rs.getInt(ITMDT_INVENTORYSERIALIZED) == 1;
                if(rs.wasNull())
                    itmdt_inventoryserialized = null;
                
                Long itmdt_serialnumbersequenceid = rs.getLong(ITMDT_SERIALNUMBERSEQUENCEID);
                if(rs.wasNull())
                    itmdt_serialnumbersequenceid = null;
                
                Boolean itmdt_shippingchargeexempt = rs.getInt(ITMDT_SHIPPINGCHARGEEXEMPT) == 1;
                if(rs.wasNull())
                    itmdt_shippingchargeexempt = null;
                
                Long itmdt_shippingstarttime = rs.getLong(ITMDT_SHIPPINGSTARTTIME);
                if(rs.wasNull())
                    itmdt_shippingstarttime = null;
                
                Long itmdt_shippingendtime = rs.getLong(ITMDT_SHIPPINGENDTIME);
                if(rs.wasNull())
                    itmdt_shippingendtime = null;
                
                Long itmdt_salesorderstarttime = rs.getLong(ITMDT_SALESORDERSTARTTIME);
                if(rs.wasNull())
                    itmdt_salesorderstarttime = null;
                
                Long itmdt_salesorderendtime = rs.getLong(ITMDT_SALESORDERENDTIME);
                if(rs.wasNull())
                    itmdt_salesorderendtime = null;
                
                Long itmdt_purchaseorderstarttime = rs.getLong(ITMDT_PURCHASEORDERSTARTTIME);
                if(rs.wasNull())
                    itmdt_purchaseorderstarttime = null;
                
                Long itmdt_purchaseorderendtime = rs.getLong(ITMDT_PURCHASEORDERENDTIME);
                if(rs.wasNull())
                    itmdt_purchaseorderendtime = null;
                
                Boolean itmdt_allowclubdiscounts = rs.getInt(ITMDT_ALLOWCLUBDISCOUNTS) == 1;
                if(rs.wasNull())
                    itmdt_allowclubdiscounts = null;
                
                Boolean itmdt_allowcoupondiscounts = rs.getInt(ITMDT_ALLOWCOUPONDISCOUNTS) == 1;
                if(rs.wasNull())
                    itmdt_allowcoupondiscounts = null;
                
                Boolean itmdt_allowassociatepayments = rs.getInt(ITMDT_ALLOWASSOCIATEPAYMENTS) == 1;
                if(rs.wasNull())
                    itmdt_allowassociatepayments = null;
                
                Long itmdt_uomk_unitofmeasurekindid = rs.getLong(ITMDT_UOMK_UNITOFMEASUREKINDID);
                if(rs.wasNull())
                    itmdt_uomk_unitofmeasurekindid = null;
                
                Long itmdt_ipt_itempricetypeid = rs.getLong(ITMDT_IPT_ITEMPRICETYPEID);
                if(rs.wasNull())
                    itmdt_ipt_itempricetypeid = null;
                
                Long itmdt_cnclplcy_cancellationpolicyid = rs.getLong(ITMDT_CNCLPLCY_CANCELLATIONPOLICYID);
                if(rs.wasNull())
                    itmdt_cnclplcy_cancellationpolicyid = null;
                
                Long itmdt_rtnplcy_returnpolicyid = rs.getLong(ITMDT_RTNPLCY_RETURNPOLICYID);
                if(rs.wasNull())
                    itmdt_rtnplcy_returnpolicyid = null;
                
                Long itmdt_stylpth_stylepathid = rs.getLong(ITMDT_STYLPTH_STYLEPATHID);
                if(rs.wasNull())
                    itmdt_stylpth_stylepathid = null;
                
                Long itmdt_fromtime = rs.getLong(ITMDT_FROMTIME);
                if(rs.wasNull())
                    itmdt_fromtime = null;
                
                Long itmdt_thrutime = rs.getLong(ITMDT_THRUTIME);
                if(rs.wasNull())
                    itmdt_thrutime = null;
                
                ItemDetailValue _value = new ItemDetailValue(_pk, itmdt_itm_itemid == null? null: new ItemPK(itmdt_itm_itemid), itmdt_itemname, itmdt_ityp_itemtypeid == null? null: new ItemTypePK(itmdt_ityp_itemtypeid), itmdt_iutyp_itemusetypeid == null? null: new ItemUseTypePK(itmdt_iutyp_itemusetypeid), itmdt_ic_itemcategoryid == null? null: new ItemCategoryPK(itmdt_ic_itemcategoryid), itmdt_iactgc_itemaccountingcategoryid == null? null: new ItemAccountingCategoryPK(itmdt_iactgc_itemaccountingcategoryid), itmdt_iprchc_itempurchasingcategoryid == null? null: new ItemPurchasingCategoryPK(itmdt_iprchc_itempurchasingcategoryid), itmdt_companypartyid == null? null: new PartyPK(itmdt_companypartyid), itmdt_idlvrtyp_itemdeliverytypeid == null? null: new ItemDeliveryTypePK(itmdt_idlvrtyp_itemdeliverytypeid), itmdt_iinvtyp_iteminventorytypeid == null? null: new ItemInventoryTypePK(itmdt_iinvtyp_iteminventorytypeid), itmdt_inventoryserialized, itmdt_serialnumbersequenceid == null? null: new SequencePK(itmdt_serialnumbersequenceid), itmdt_shippingchargeexempt, itmdt_shippingstarttime, itmdt_shippingendtime, itmdt_salesorderstarttime, itmdt_salesorderendtime, itmdt_purchaseorderstarttime, itmdt_purchaseorderendtime, itmdt_allowclubdiscounts, itmdt_allowcoupondiscounts, itmdt_allowassociatepayments, itmdt_uomk_unitofmeasurekindid == null? null: new UnitOfMeasureKindPK(itmdt_uomk_unitofmeasurekindid), itmdt_ipt_itempricetypeid == null? null: new ItemPriceTypePK(itmdt_ipt_itempricetypeid), itmdt_cnclplcy_cancellationpolicyid == null? null: new CancellationPolicyPK(itmdt_cnclplcy_cancellationpolicyid), itmdt_rtnplcy_returnpolicyid == null? null: new ReturnPolicyPK(itmdt_rtnplcy_returnpolicyid), itmdt_stylpth_stylepathid == null? null: new StylePathPK(itmdt_stylpth_stylepathid), itmdt_fromtime, itmdt_thrutime);
                _entity = new ItemDetail(_value, entityPermission);
            }
            
            if(!foundInSessionCache) {
                if(entityPermission.equals(EntityPermission.READ_ONLY)) {
                    session.putReadOnlyEntity(_pk, _entity);
                    session.getValueCache().put(_entity.getItemDetailValue());
                } else {
                    session.putReadWriteEntity(_pk, _entity);
                }
            }
        } catch (SQLException se) {
            throw new PersistenceDatabaseException(se);
        }
        
        return _entity;
    }
    
    public ItemDetail create(Session session, Item item, String itemName, ItemType itemType, ItemUseType itemUseType, ItemCategory itemCategory, ItemAccountingCategory itemAccountingCategory, ItemPurchasingCategory itemPurchasingCategory, Party companyParty, ItemDeliveryType itemDeliveryType, ItemInventoryType itemInventoryType, Boolean inventorySerialized, Sequence serialNumberSequence, Boolean shippingChargeExempt, Long shippingStartTime, Long shippingEndTime, Long salesOrderStartTime, Long salesOrderEndTime, Long purchaseOrderStartTime, Long purchaseOrderEndTime, Boolean allowClubDiscounts, Boolean allowCouponDiscounts, Boolean allowAssociatePayments, UnitOfMeasureKind unitOfMeasureKind, ItemPriceType itemPriceType, CancellationPolicy cancellationPolicy, ReturnPolicy returnPolicy, StylePath stylePath, Long fromTime, Long thruTime)
            throws PersistenceDatabaseException, PersistenceNotNullException {
        return create(session, item == null ? null : item.getPrimaryKey(), itemName, itemType == null ? null : itemType.getPrimaryKey(), itemUseType == null ? null : itemUseType.getPrimaryKey(), itemCategory == null ? null : itemCategory.getPrimaryKey(), itemAccountingCategory == null ? null : itemAccountingCategory.getPrimaryKey(), itemPurchasingCategory == null ? null : itemPurchasingCategory.getPrimaryKey(), companyParty == null ? null : companyParty.getPrimaryKey(), itemDeliveryType == null ? null : itemDeliveryType.getPrimaryKey(), itemInventoryType == null ? null : itemInventoryType.getPrimaryKey(), inventorySerialized, serialNumberSequence == null ? null : serialNumberSequence.getPrimaryKey(), shippingChargeExempt, shippingStartTime, shippingEndTime, salesOrderStartTime, salesOrderEndTime, purchaseOrderStartTime, purchaseOrderEndTime, allowClubDiscounts, allowCouponDiscounts, allowAssociatePayments, unitOfMeasureKind == null ? null : unitOfMeasureKind.getPrimaryKey(), itemPriceType == null ? null : itemPriceType.getPrimaryKey(), cancellationPolicy == null ? null : cancellationPolicy.getPrimaryKey(), returnPolicy == null ? null : returnPolicy.getPrimaryKey(), stylePath == null ? null : stylePath.getPrimaryKey(), fromTime, thruTime);
    }
    
    public ItemDetail create(Item item, String itemName, ItemType itemType, ItemUseType itemUseType, ItemCategory itemCategory, ItemAccountingCategory itemAccountingCategory, ItemPurchasingCategory itemPurchasingCategory, Party companyParty, ItemDeliveryType itemDeliveryType, ItemInventoryType itemInventoryType, Boolean inventorySerialized, Sequence serialNumberSequence, Boolean shippingChargeExempt, Long shippingStartTime, Long shippingEndTime, Long salesOrderStartTime, Long salesOrderEndTime, Long purchaseOrderStartTime, Long purchaseOrderEndTime, Boolean allowClubDiscounts, Boolean allowCouponDiscounts, Boolean allowAssociatePayments, UnitOfMeasureKind unitOfMeasureKind, ItemPriceType itemPriceType, CancellationPolicy cancellationPolicy, ReturnPolicy returnPolicy, StylePath stylePath, Long fromTime, Long thruTime)
            throws PersistenceDatabaseException, PersistenceNotNullException {
        return create(ThreadSession.currentSession(), item == null ? null : item.getPrimaryKey(), itemName, itemType == null ? null : itemType.getPrimaryKey(), itemUseType == null ? null : itemUseType.getPrimaryKey(), itemCategory == null ? null : itemCategory.getPrimaryKey(), itemAccountingCategory == null ? null : itemAccountingCategory.getPrimaryKey(), itemPurchasingCategory == null ? null : itemPurchasingCategory.getPrimaryKey(), companyParty == null ? null : companyParty.getPrimaryKey(), itemDeliveryType == null ? null : itemDeliveryType.getPrimaryKey(), itemInventoryType == null ? null : itemInventoryType.getPrimaryKey(), inventorySerialized, serialNumberSequence == null ? null : serialNumberSequence.getPrimaryKey(), shippingChargeExempt, shippingStartTime, shippingEndTime, salesOrderStartTime, salesOrderEndTime, purchaseOrderStartTime, purchaseOrderEndTime, allowClubDiscounts, allowCouponDiscounts, allowAssociatePayments, unitOfMeasureKind == null ? null : unitOfMeasureKind.getPrimaryKey(), itemPriceType == null ? null : itemPriceType.getPrimaryKey(), cancellationPolicy == null ? null : cancellationPolicy.getPrimaryKey(), returnPolicy == null ? null : returnPolicy.getPrimaryKey(), stylePath == null ? null : stylePath.getPrimaryKey(), fromTime, thruTime);
    }
    
    private void bindForCreate(PreparedStatement _ps, ItemDetailValue _value)
            throws SQLException {
        _ps.setLong(1, _value.getEntityId());
        
        ItemPK itmdt_itm_itemid = _value.getItemPK();
        if(itmdt_itm_itemid == null)
            _ps.setNull(2, Types.BIGINT);
        else
            _ps.setLong(2, itmdt_itm_itemid.getEntityId());
            
        String itmdt_itemname = _value.getItemName();
        if(itmdt_itemname == null)
            _ps.setNull(3, Types.VARCHAR);
        else
            _ps.setString(3, itmdt_itemname);
            
        ItemTypePK itmdt_ityp_itemtypeid = _value.getItemTypePK();
        if(itmdt_ityp_itemtypeid == null)
            _ps.setNull(4, Types.BIGINT);
        else
            _ps.setLong(4, itmdt_ityp_itemtypeid.getEntityId());
            
        ItemUseTypePK itmdt_iutyp_itemusetypeid = _value.getItemUseTypePK();
        if(itmdt_iutyp_itemusetypeid == null)
            _ps.setNull(5, Types.BIGINT);
        else
            _ps.setLong(5, itmdt_iutyp_itemusetypeid.getEntityId());
            
        ItemCategoryPK itmdt_ic_itemcategoryid = _value.getItemCategoryPK();
        if(itmdt_ic_itemcategoryid == null)
            _ps.setNull(6, Types.BIGINT);
        else
            _ps.setLong(6, itmdt_ic_itemcategoryid.getEntityId());
            
        ItemAccountingCategoryPK itmdt_iactgc_itemaccountingcategoryid = _value.getItemAccountingCategoryPK();
        if(itmdt_iactgc_itemaccountingcategoryid == null)
            _ps.setNull(7, Types.BIGINT);
        else
            _ps.setLong(7, itmdt_iactgc_itemaccountingcategoryid.getEntityId());
            
        ItemPurchasingCategoryPK itmdt_iprchc_itempurchasingcategoryid = _value.getItemPurchasingCategoryPK();
        if(itmdt_iprchc_itempurchasingcategoryid == null)
            _ps.setNull(8, Types.BIGINT);
        else
            _ps.setLong(8, itmdt_iprchc_itempurchasingcategoryid.getEntityId());
            
        PartyPK itmdt_companypartyid = _value.getCompanyPartyPK();
        if(itmdt_companypartyid == null)
            _ps.setNull(9, Types.BIGINT);
        else
            _ps.setLong(9, itmdt_companypartyid.getEntityId());
            
        ItemDeliveryTypePK itmdt_idlvrtyp_itemdeliverytypeid = _value.getItemDeliveryTypePK();
        if(itmdt_idlvrtyp_itemdeliverytypeid == null)
            _ps.setNull(10, Types.BIGINT);
        else
            _ps.setLong(10, itmdt_idlvrtyp_itemdeliverytypeid.getEntityId());
            
        ItemInventoryTypePK itmdt_iinvtyp_iteminventorytypeid = _value.getItemInventoryTypePK();
        if(itmdt_iinvtyp_iteminventorytypeid == null)
            _ps.setNull(11, Types.BIGINT);
        else
            _ps.setLong(11, itmdt_iinvtyp_iteminventorytypeid.getEntityId());
            
        Boolean itmdt_inventoryserialized = _value.getInventorySerialized();
        if(itmdt_inventoryserialized == null)
            _ps.setNull(12, Types.BIT);
        else
            _ps.setInt(12, itmdt_inventoryserialized? 1: 0);
            
        SequencePK itmdt_serialnumbersequenceid = _value.getSerialNumberSequencePK();
        if(itmdt_serialnumbersequenceid == null)
            _ps.setNull(13, Types.BIGINT);
        else
            _ps.setLong(13, itmdt_serialnumbersequenceid.getEntityId());
            
        Boolean itmdt_shippingchargeexempt = _value.getShippingChargeExempt();
        if(itmdt_shippingchargeexempt == null)
            _ps.setNull(14, Types.BIT);
        else
            _ps.setInt(14, itmdt_shippingchargeexempt? 1: 0);
            
        Long itmdt_shippingstarttime = _value.getShippingStartTime();
        if(itmdt_shippingstarttime == null)
            _ps.setNull(15, Types.BIGINT);
        else
            _ps.setLong(15, itmdt_shippingstarttime);
            
        Long itmdt_shippingendtime = _value.getShippingEndTime();
        if(itmdt_shippingendtime == null)
            _ps.setNull(16, Types.BIGINT);
        else
            _ps.setLong(16, itmdt_shippingendtime);
            
        Long itmdt_salesorderstarttime = _value.getSalesOrderStartTime();
        if(itmdt_salesorderstarttime == null)
            _ps.setNull(17, Types.BIGINT);
        else
            _ps.setLong(17, itmdt_salesorderstarttime);
            
        Long itmdt_salesorderendtime = _value.getSalesOrderEndTime();
        if(itmdt_salesorderendtime == null)
            _ps.setNull(18, Types.BIGINT);
        else
            _ps.setLong(18, itmdt_salesorderendtime);
            
        Long itmdt_purchaseorderstarttime = _value.getPurchaseOrderStartTime();
        if(itmdt_purchaseorderstarttime == null)
            _ps.setNull(19, Types.BIGINT);
        else
            _ps.setLong(19, itmdt_purchaseorderstarttime);
            
        Long itmdt_purchaseorderendtime = _value.getPurchaseOrderEndTime();
        if(itmdt_purchaseorderendtime == null)
            _ps.setNull(20, Types.BIGINT);
        else
            _ps.setLong(20, itmdt_purchaseorderendtime);
            
        Boolean itmdt_allowclubdiscounts = _value.getAllowClubDiscounts();
        if(itmdt_allowclubdiscounts == null)
            _ps.setNull(21, Types.BIT);
        else
            _ps.setInt(21, itmdt_allowclubdiscounts? 1: 0);
            
        Boolean itmdt_allowcoupondiscounts = _value.getAllowCouponDiscounts();
        if(itmdt_allowcoupondiscounts == null)
            _ps.setNull(22, Types.BIT);
        else
            _ps.setInt(22, itmdt_allowcoupondiscounts? 1: 0);
            
        Boolean itmdt_allowassociatepayments = _value.getAllowAssociatePayments();
        if(itmdt_allowassociatepayments == null)
            _ps.setNull(23, Types.BIT);
        else
            _ps.setInt(23, itmdt_allowassociatepayments? 1: 0);
            
        UnitOfMeasureKindPK itmdt_uomk_unitofmeasurekindid = _value.getUnitOfMeasureKindPK();
        if(itmdt_uomk_unitofmeasurekindid == null)
            _ps.setNull(24, Types.BIGINT);
        else
            _ps.setLong(24, itmdt_uomk_unitofmeasurekindid.getEntityId());
            
        ItemPriceTypePK itmdt_ipt_itempricetypeid = _value.getItemPriceTypePK();
        if(itmdt_ipt_itempricetypeid == null)
            _ps.setNull(25, Types.BIGINT);
        else
            _ps.setLong(25, itmdt_ipt_itempricetypeid.getEntityId());
            
        CancellationPolicyPK itmdt_cnclplcy_cancellationpolicyid = _value.getCancellationPolicyPK();
        if(itmdt_cnclplcy_cancellationpolicyid == null)
            _ps.setNull(26, Types.BIGINT);
        else
            _ps.setLong(26, itmdt_cnclplcy_cancellationpolicyid.getEntityId());
            
        ReturnPolicyPK itmdt_rtnplcy_returnpolicyid = _value.getReturnPolicyPK();
        if(itmdt_rtnplcy_returnpolicyid == null)
            _ps.setNull(27, Types.BIGINT);
        else
            _ps.setLong(27, itmdt_rtnplcy_returnpolicyid.getEntityId());
            
        StylePathPK itmdt_stylpth_stylepathid = _value.getStylePathPK();
        if(itmdt_stylpth_stylepathid == null)
            _ps.setNull(28, Types.BIGINT);
        else
            _ps.setLong(28, itmdt_stylpth_stylepathid.getEntityId());
            
        Long itmdt_fromtime = _value.getFromTime();
        if(itmdt_fromtime == null)
            _ps.setNull(29, Types.BIGINT);
        else
            _ps.setLong(29, itmdt_fromtime);
            
        Long itmdt_thrutime = _value.getThruTime();
        if(itmdt_thrutime == null)
            _ps.setNull(30, Types.BIGINT);
        else
            _ps.setLong(30, itmdt_thrutime);
            
    }
    
    public ItemDetail create(Session session, ItemPK itemPK, String itemName, ItemTypePK itemTypePK, ItemUseTypePK itemUseTypePK, ItemCategoryPK itemCategoryPK, ItemAccountingCategoryPK itemAccountingCategoryPK, ItemPurchasingCategoryPK itemPurchasingCategoryPK, PartyPK companyPartyPK, ItemDeliveryTypePK itemDeliveryTypePK, ItemInventoryTypePK itemInventoryTypePK, Boolean inventorySerialized, SequencePK serialNumberSequencePK, Boolean shippingChargeExempt, Long shippingStartTime, Long shippingEndTime, Long salesOrderStartTime, Long salesOrderEndTime, Long purchaseOrderStartTime, Long purchaseOrderEndTime, Boolean allowClubDiscounts, Boolean allowCouponDiscounts, Boolean allowAssociatePayments, UnitOfMeasureKindPK unitOfMeasureKindPK, ItemPriceTypePK itemPriceTypePK, CancellationPolicyPK cancellationPolicyPK, ReturnPolicyPK returnPolicyPK, StylePathPK stylePathPK, Long fromTime, Long thruTime)
            throws PersistenceDatabaseException, PersistenceNotNullException {
        ItemDetailPK _pk = getNextPK();
        ItemDetailValue _value = new ItemDetailValue(_pk, itemPK, itemName, itemTypePK, itemUseTypePK, itemCategoryPK, itemAccountingCategoryPK, itemPurchasingCategoryPK, companyPartyPK, itemDeliveryTypePK, itemInventoryTypePK, inventorySerialized, serialNumberSequencePK, shippingChargeExempt, shippingStartTime, shippingEndTime, salesOrderStartTime, salesOrderEndTime, purchaseOrderStartTime, purchaseOrderEndTime, allowClubDiscounts, allowCouponDiscounts, allowAssociatePayments, unitOfMeasureKindPK, itemPriceTypePK, cancellationPolicyPK, returnPolicyPK, stylePathPK, 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);
        }
        
        ItemDetail _entity = new ItemDetail(_value, EntityPermission.READ_ONLY);
        session.putReadOnlyEntity(_pk, _entity);
        
        return _entity;
    }
    
    public ItemDetail create(ItemPK itemPK, String itemName, ItemTypePK itemTypePK, ItemUseTypePK itemUseTypePK, ItemCategoryPK itemCategoryPK, ItemAccountingCategoryPK itemAccountingCategoryPK, ItemPurchasingCategoryPK itemPurchasingCategoryPK, PartyPK companyPartyPK, ItemDeliveryTypePK itemDeliveryTypePK, ItemInventoryTypePK itemInventoryTypePK, Boolean inventorySerialized, SequencePK serialNumberSequencePK, Boolean shippingChargeExempt, Long shippingStartTime, Long shippingEndTime, Long salesOrderStartTime, Long salesOrderEndTime, Long purchaseOrderStartTime, Long purchaseOrderEndTime, Boolean allowClubDiscounts, Boolean allowCouponDiscounts, Boolean allowAssociatePayments, UnitOfMeasureKindPK unitOfMeasureKindPK, ItemPriceTypePK itemPriceTypePK, CancellationPolicyPK cancellationPolicyPK, ReturnPolicyPK returnPolicyPK, StylePathPK stylePathPK, Long fromTime, Long thruTime)
            throws PersistenceDatabaseException, PersistenceNotNullException {
        return create(ThreadSession.currentSession(), itemPK, itemName, itemTypePK, itemUseTypePK, itemCategoryPK, itemAccountingCategoryPK, itemPurchasingCategoryPK, companyPartyPK, itemDeliveryTypePK, itemInventoryTypePK, inventorySerialized, serialNumberSequencePK, shippingChargeExempt, shippingStartTime, shippingEndTime, salesOrderStartTime, salesOrderEndTime, purchaseOrderStartTime, purchaseOrderEndTime, allowClubDiscounts, allowCouponDiscounts, allowAssociatePayments, unitOfMeasureKindPK, itemPriceTypePK, cancellationPolicyPK, returnPolicyPK, stylePathPK, fromTime, thruTime);
    }
    
    public void create(Session session, Collection<ItemDetailValue> _values)
            throws PersistenceDatabaseException, PersistenceNotNullException {
        int _size = _values.size();
        
        if(_size > 0) {
            PreparedStatement _ps = session.prepareStatement(SQL_INSERT);
            List<ItemDetailValue> _cacheValues = new ArrayList<>(_size);
            
            try {
                for(ItemDetailValue _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) -> {
                ItemDetail _cacheEntity = new ItemDetail(_cacheValue, EntityPermission.READ_ONLY);
                
                session.putReadOnlyEntity(_cacheValue.getPrimaryKey(), _cacheEntity);
            });
        }
    }
    
    public void create(Collection<ItemDetailValue> _values)
            throws PersistenceDatabaseException, PersistenceNotNullException {
        create(ThreadSession.currentSession(), _values);
    }
    
    private boolean bindForStore(PreparedStatement _ps, ItemDetailValue _value)
            throws SQLException {
        boolean _hasBeenModified = _value.hasBeenModified();
        
        if(_hasBeenModified) {
            ItemPK itmdt_itm_itemid = _value.getItemPK();
            if(itmdt_itm_itemid == null)
                _ps.setNull(1, Types.BIGINT);
            else
                _ps.setLong(1, itmdt_itm_itemid.getEntityId());
            
            String itmdt_itemname = _value.getItemName();
            if(itmdt_itemname == null)
                _ps.setNull(2, Types.VARCHAR);
            else
                _ps.setString(2, itmdt_itemname);
            
            ItemTypePK itmdt_ityp_itemtypeid = _value.getItemTypePK();
            if(itmdt_ityp_itemtypeid == null)
                _ps.setNull(3, Types.BIGINT);
            else
                _ps.setLong(3, itmdt_ityp_itemtypeid.getEntityId());
            
            ItemUseTypePK itmdt_iutyp_itemusetypeid = _value.getItemUseTypePK();
            if(itmdt_iutyp_itemusetypeid == null)
                _ps.setNull(4, Types.BIGINT);
            else
                _ps.setLong(4, itmdt_iutyp_itemusetypeid.getEntityId());
            
            ItemCategoryPK itmdt_ic_itemcategoryid = _value.getItemCategoryPK();
            if(itmdt_ic_itemcategoryid == null)
                _ps.setNull(5, Types.BIGINT);
            else
                _ps.setLong(5, itmdt_ic_itemcategoryid.getEntityId());
            
            ItemAccountingCategoryPK itmdt_iactgc_itemaccountingcategoryid = _value.getItemAccountingCategoryPK();
            if(itmdt_iactgc_itemaccountingcategoryid == null)
                _ps.setNull(6, Types.BIGINT);
            else
                _ps.setLong(6, itmdt_iactgc_itemaccountingcategoryid.getEntityId());
            
            ItemPurchasingCategoryPK itmdt_iprchc_itempurchasingcategoryid = _value.getItemPurchasingCategoryPK();
            if(itmdt_iprchc_itempurchasingcategoryid == null)
                _ps.setNull(7, Types.BIGINT);
            else
                _ps.setLong(7, itmdt_iprchc_itempurchasingcategoryid.getEntityId());
            
            PartyPK itmdt_companypartyid = _value.getCompanyPartyPK();
            if(itmdt_companypartyid == null)
                _ps.setNull(8, Types.BIGINT);
            else
                _ps.setLong(8, itmdt_companypartyid.getEntityId());
            
            ItemDeliveryTypePK itmdt_idlvrtyp_itemdeliverytypeid = _value.getItemDeliveryTypePK();
            if(itmdt_idlvrtyp_itemdeliverytypeid == null)
                _ps.setNull(9, Types.BIGINT);
            else
                _ps.setLong(9, itmdt_idlvrtyp_itemdeliverytypeid.getEntityId());
            
            ItemInventoryTypePK itmdt_iinvtyp_iteminventorytypeid = _value.getItemInventoryTypePK();
            if(itmdt_iinvtyp_iteminventorytypeid == null)
                _ps.setNull(10, Types.BIGINT);
            else
                _ps.setLong(10, itmdt_iinvtyp_iteminventorytypeid.getEntityId());
            
            Boolean itmdt_inventoryserialized = _value.getInventorySerialized();
            if(itmdt_inventoryserialized == null)
                _ps.setNull(11, Types.BIT);
            else
                _ps.setInt(11, itmdt_inventoryserialized? 1: 0);
            
            SequencePK itmdt_serialnumbersequenceid = _value.getSerialNumberSequencePK();
            if(itmdt_serialnumbersequenceid == null)
                _ps.setNull(12, Types.BIGINT);
            else
                _ps.setLong(12, itmdt_serialnumbersequenceid.getEntityId());
            
            Boolean itmdt_shippingchargeexempt = _value.getShippingChargeExempt();
            if(itmdt_shippingchargeexempt == null)
                _ps.setNull(13, Types.BIT);
            else
                _ps.setInt(13, itmdt_shippingchargeexempt? 1: 0);
            
            Long itmdt_shippingstarttime = _value.getShippingStartTime();
            if(itmdt_shippingstarttime == null)
                _ps.setNull(14, Types.BIGINT);
            else
                _ps.setLong(14, itmdt_shippingstarttime);
            
            Long itmdt_shippingendtime = _value.getShippingEndTime();
            if(itmdt_shippingendtime == null)
                _ps.setNull(15, Types.BIGINT);
            else
                _ps.setLong(15, itmdt_shippingendtime);
            
            Long itmdt_salesorderstarttime = _value.getSalesOrderStartTime();
            if(itmdt_salesorderstarttime == null)
                _ps.setNull(16, Types.BIGINT);
            else
                _ps.setLong(16, itmdt_salesorderstarttime);
            
            Long itmdt_salesorderendtime = _value.getSalesOrderEndTime();
            if(itmdt_salesorderendtime == null)
                _ps.setNull(17, Types.BIGINT);
            else
                _ps.setLong(17, itmdt_salesorderendtime);
            
            Long itmdt_purchaseorderstarttime = _value.getPurchaseOrderStartTime();
            if(itmdt_purchaseorderstarttime == null)
                _ps.setNull(18, Types.BIGINT);
            else
                _ps.setLong(18, itmdt_purchaseorderstarttime);
            
            Long itmdt_purchaseorderendtime = _value.getPurchaseOrderEndTime();
            if(itmdt_purchaseorderendtime == null)
                _ps.setNull(19, Types.BIGINT);
            else
                _ps.setLong(19, itmdt_purchaseorderendtime);
            
            Boolean itmdt_allowclubdiscounts = _value.getAllowClubDiscounts();
            if(itmdt_allowclubdiscounts == null)
                _ps.setNull(20, Types.BIT);
            else
                _ps.setInt(20, itmdt_allowclubdiscounts? 1: 0);
            
            Boolean itmdt_allowcoupondiscounts = _value.getAllowCouponDiscounts();
            if(itmdt_allowcoupondiscounts == null)
                _ps.setNull(21, Types.BIT);
            else
                _ps.setInt(21, itmdt_allowcoupondiscounts? 1: 0);
            
            Boolean itmdt_allowassociatepayments = _value.getAllowAssociatePayments();
            if(itmdt_allowassociatepayments == null)
                _ps.setNull(22, Types.BIT);
            else
                _ps.setInt(22, itmdt_allowassociatepayments? 1: 0);
            
            UnitOfMeasureKindPK itmdt_uomk_unitofmeasurekindid = _value.getUnitOfMeasureKindPK();
            if(itmdt_uomk_unitofmeasurekindid == null)
                _ps.setNull(23, Types.BIGINT);
            else
                _ps.setLong(23, itmdt_uomk_unitofmeasurekindid.getEntityId());
            
            ItemPriceTypePK itmdt_ipt_itempricetypeid = _value.getItemPriceTypePK();
            if(itmdt_ipt_itempricetypeid == null)
                _ps.setNull(24, Types.BIGINT);
            else
                _ps.setLong(24, itmdt_ipt_itempricetypeid.getEntityId());
            
            CancellationPolicyPK itmdt_cnclplcy_cancellationpolicyid = _value.getCancellationPolicyPK();
            if(itmdt_cnclplcy_cancellationpolicyid == null)
                _ps.setNull(25, Types.BIGINT);
            else
                _ps.setLong(25, itmdt_cnclplcy_cancellationpolicyid.getEntityId());
            
            ReturnPolicyPK itmdt_rtnplcy_returnpolicyid = _value.getReturnPolicyPK();
            if(itmdt_rtnplcy_returnpolicyid == null)
                _ps.setNull(26, Types.BIGINT);
            else
                _ps.setLong(26, itmdt_rtnplcy_returnpolicyid.getEntityId());
            
            StylePathPK itmdt_stylpth_stylepathid = _value.getStylePathPK();
            if(itmdt_stylpth_stylepathid == null)
                _ps.setNull(27, Types.BIGINT);
            else
                _ps.setLong(27, itmdt_stylpth_stylepathid.getEntityId());
            
            Long itmdt_fromtime = _value.getFromTime();
            if(itmdt_fromtime == null)
                _ps.setNull(28, Types.BIGINT);
            else
                _ps.setLong(28, itmdt_fromtime);
            
            Long itmdt_thrutime = _value.getThruTime();
            if(itmdt_thrutime == null)
                _ps.setNull(29, Types.BIGINT);
            else
                _ps.setLong(29, itmdt_thrutime);
            
            _ps.setLong(30, _value.getPrimaryKey().getEntityId());
            
            _value.clearHasBeenModified();
        }
        
        return _hasBeenModified;
    }
    
    @Override
    public void store(Session session, ItemDetail entity)
            throws PersistenceDatabaseException {
        PreparedStatement _ps = session.prepareStatement(SQL_UPDATE);
        
        try {
            ItemDetailValue _value = entity.getItemDetailValue();
            
            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(Session session, Collection<ItemDetail> entities)
            throws PersistenceDatabaseException {
        if(entities.size() > 0) {
            PreparedStatement _ps = session.prepareStatement(SQL_UPDATE);
            int _modifiedEntities = 0;
            
            try {
                for(ItemDetail entity : entities) {
                    if(bindForStore(_ps, entity.getItemDetailValue())) {
                        _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.getItemDetailValue());
                    });
                }
            } catch (SQLException se) {
                throw new PersistenceDatabaseException(se);
            }
        }
    }
    
    @Override
    public void store(Collection<ItemDetail> entities)
            throws PersistenceDatabaseException {
        store(ThreadSession.currentSession(), entities);
    }
    
    @Override
    public void remove(Session session, ItemDetail entity)
            throws PersistenceDatabaseException {
        remove(session, entity.getPrimaryKey());
    }
    
    @Override
    public void remove(Session session, ItemDetailPK 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(Session session, Collection<ItemDetailPK> pks)
            throws PersistenceDatabaseException {
        if(pks.size() > 0) {
            PreparedStatement _ps = session.prepareStatement(SQL_DELETE);
            int _modifiedEntities = 0;
            
            try {
                for(ItemDetailPK 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 void remove(Collection<ItemDetailPK> pks)
            throws PersistenceDatabaseException {
        remove(ThreadSession.currentSession(), pks);
    }
    
    @Override
    public boolean validPK(Session session, ItemDetailPK 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;
    }
    
}