001/*- 002 * #%L 003 * HAPI FHIR JPA Server 004 * %% 005 * Copyright (C) 2014 - 2023 Smile CDR, Inc. 006 * %% 007 * Licensed under the Apache License, Version 2.0 (the "License"); 008 * you may not use this file except in compliance with the License. 009 * You may obtain a copy of the License at 010 * 011 * http://www.apache.org/licenses/LICENSE-2.0 012 * 013 * Unless required by applicable law or agreed to in writing, software 014 * distributed under the License is distributed on an "AS IS" BASIS, 015 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 016 * See the License for the specific language governing permissions and 017 * limitations under the License. 018 * #L% 019 */ 020package ca.uhn.fhir.jpa.search.builder.predicate; 021 022import ca.uhn.fhir.jpa.search.builder.sql.SearchQueryBuilder; 023import ca.uhn.fhir.jpa.util.QueryParameterUtils; 024import com.healthmarketscience.sqlbuilder.BinaryCondition; 025import com.healthmarketscience.sqlbuilder.Condition; 026import com.healthmarketscience.sqlbuilder.NotCondition; 027import com.healthmarketscience.sqlbuilder.UnaryCondition; 028import com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn; 029 030import java.util.Set; 031 032public class ResourceTablePredicateBuilder extends BaseJoiningPredicateBuilder { 033 private final DbColumn myColumnResId; 034 private final DbColumn myColumnResDeletedAt; 035 private final DbColumn myColumnResType; 036 private final DbColumn myColumnLastUpdated; 037 private final DbColumn myColumnLanguage; 038 039 /** 040 * Constructor 041 */ 042 public ResourceTablePredicateBuilder(SearchQueryBuilder theSearchSqlBuilder) { 043 super(theSearchSqlBuilder, theSearchSqlBuilder.addTable("HFJ_RESOURCE")); 044 myColumnResId = getTable().addColumn("RES_ID"); 045 myColumnResType = getTable().addColumn("RES_TYPE"); 046 myColumnResDeletedAt = getTable().addColumn("RES_DELETED_AT"); 047 myColumnLastUpdated = getTable().addColumn("RES_UPDATED"); 048 myColumnLanguage = getTable().addColumn("RES_LANGUAGE"); 049 } 050 051 @Override 052 public DbColumn getResourceIdColumn() { 053 return myColumnResId; 054 } 055 056 public Condition createResourceTypeAndNonDeletedPredicates() { 057 BinaryCondition typePredicate = null; 058 if (getResourceType() != null) { 059 typePredicate = BinaryCondition.equalTo(myColumnResType, generatePlaceholder(getResourceType())); 060 } 061 return QueryParameterUtils.toAndPredicate(typePredicate, UnaryCondition.isNull(myColumnResDeletedAt)); 062 } 063 064 public DbColumn getLastUpdatedColumn() { 065 return myColumnLastUpdated; 066 } 067 068 public Condition createLanguagePredicate(Set<String> theValues, boolean theNegated) { 069 Condition condition = 070 QueryParameterUtils.toEqualToOrInPredicate(myColumnLanguage, generatePlaceholders(theValues)); 071 if (theNegated) { 072 condition = new NotCondition(condition); 073 } 074 return condition; 075 } 076 077 public DbColumn getColumnLastUpdated() { 078 return myColumnLastUpdated; 079 } 080}