001// --------------------------------------------------------------------------------
002// Copyright 2002-2026 Echo Three, LLC
003//
004// Licensed under the Apache License, Version 2.0 (the "License");
005// you may not use this file except in compliance with the License.
006// You may obtain a copy of the License at
007//
008//     http://www.apache.org/licenses/LICENSE-2.0
009//
010// Unless required by applicable law or agreed to in writing, software
011// distributed under the License is distributed on an "AS IS" BASIS,
012// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
013// See the License for the specific language governing permissions and
014// limitations under the License.
015// --------------------------------------------------------------------------------
016
017package com.echothree.model.control.core.server.database;
018
019import static com.echothree.model.jooq.server.tables.core.EntityCollectionAttributes.EntityCollectionAttributes;
020import com.echothree.model.data.core.server.entity.EntityAttribute;
021import com.echothree.util.server.persistence.Session;
022import java.util.List;
023
024public class EntityInstancePKsByCollectionEntityAttributeQuery
025        extends BaseEntityInstancePKQuery<EntityInstancePKResult> {
026
027    @Override
028    public List<EntityInstancePKResult> execute(final EntityAttribute entityAttribute) {
029        var query = getDslContext()
030                .selectDistinct(EntityCollectionAttributes.ENTITY_INSTANCE.as("EntityInstancePK"))
031                .from(EntityCollectionAttributes)
032                .where(EntityCollectionAttributes.ENTITY_ATTRIBUTE.eq(entityAttribute.getPrimaryKey()),
033                        EntityCollectionAttributes.THRU_TIME.eq(Session.MAX_TIME));
034
035        return super.execute(query);
036    }
037    
038}