content: /*
   * Copyright 2010-2025 Hyland Software, Inc. and its affiliates.
   *
   * 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.
   */
  package org.activiti.standalone.escapeclause;
  
  import static org.assertj.core.api.Assertions.assertThat;
  
  import java.util.HashMap;
  import java.util.Map;
  import org.activiti.engine.runtime.ProcessInstance;
  import org.junit.Test;
  
  public class ProcessInstanceQueryEscapeClauseTest extends AbstractEscapeClauseTestCase {
  
      private String deploymentOneId;
  
      private String deploymentTwoId;
  
      private ProcessInstance processInstance1;
  
      private ProcessInstance processInstance2;
  
      @Override
      protected void setUp() throws Exception {
          deploymentOneId = repositoryService
              .createDeployment()
              .tenantId("One%")
              .addClasspathResource("org/activiti/engine/test/api/oneTaskProcess.bpmn20.xml")
              .deploy()
              .getId();
  
          deploymentTwoId = repositoryService
              .createDeployment()
              .tenantId("Two_")
              .addClasspathResource("org/activiti/engine/test/api/oneTaskProcess.bpmn20.xml")
              .deploy()
              .getId();
  
          Map<String, Object> vars = new HashMap<String, Object>();
          vars.put("var1", "One%");
          processInstance1 = runtimeService.startProcessInstanceByKeyAndTenantId("oneTaskProcess", vars, "One%");
          runtimeService.setProcessInstanceName(processInstance1.getId(), "One%");
  
          vars = new HashMap<String, Object>();
          vars.put("var1", "Two_");
          processInstance2 = runtimeService.startProcessInstanceByKeyAndTenantId("oneTaskProcess", vars, "Two_");
          runtimeService.setProcessInstanceName(processInstance2.getId(), "Two_");
  
          super.setUp();
      }
  
      @Override
      protected void tearDown() throws Exception {
          super.tearDown();
          repositoryService.deleteDeployment(deploymentOneId, true);
          repositoryService.deleteDeployment(deploymentTwoId, true);
      }
  
      public void testQueryByTenantIdLike() {
          // tenantIdLike
          ProcessInstance processInstance = runtimeService
              .createProcessInstanceQuery()
              .processInstanceTenantIdLike("%\\%%")
              .singleResult();
          assertThat(processInstance).isNotNull();
          assertThat(processInstance.getId()).isEqualTo(processInstance1.getId());
  
          processInstance = runtimeService
              .createProcessInstanceQuery()
              .processInstanceTenantIdLike("%\\_%")
              .singleResult();
          assertThat(processInstance).isNotNull();
          assertThat(processInstance.getId()).isEqualTo(processInstance2.getId());
  
          // orQuery
          processInstance = runtimeService
              .createProcessInstanceQuery()
              .or()
              .processInstanceTenantIdLike("%\\%%")
              .processDefinitionId("undefined")
              .singleResult();
          assertThat(processInstance).isNotNull();
          assertThat(processInstance.getId()).isEqualTo(processInstance1.getId());
  
          processInstance = runtimeService
              .createProcessInstanceQuery()
              .or()
              .processInstanceTenantIdLike("%\\_%")
              .processDefinitionId("undefined")
              .singleResult();
          assertThat(processInstance).isNotNull();
          assertThat(processInstance.getId()).isEqualTo(processInstance2.getId());
      }
  
      public void testQueryByProcessInstanceNameLike() {
          // processInstanceNameLike
          assertThat(
              runtimeService.createProcessInstanceQuery().processInstanceNameLike("%\\%%").singleResult()
          ).isNotNull();
          assertThat(
              runtimeService.createProcessInstanceQuery().processInstanceNameLike("%\\%%").singleResult().getId()
          ).isEqualTo(processInstance1.getId());
  
          assertThat(
              runtimeService.createProcessInstanceQuery().processInstanceNameLike("%\\_%").singleResult()
          ).isNotNull();
          assertThat(
              runtimeService.createProcessInstanceQuery().processInstanceNameLike("%\\_%").singleResult().getId()
          ).isEqualTo(processInstance2.getId());
  
          // orQuery
          assertThat(
              runtimeService
                  .createProcessInstanceQuery()
                  .or()
                  .processInstanceNameLike("%\\%%")
                  .processDefinitionId("undefined")
                  .singleResult()
          ).isNotNull();
          assertThat(
              runtimeService
                  .createProcessInstanceQuery()
                  .or()
                  .processInstanceNameLike("%\\%%")
                  .processDefinitionId("undefined")
                  .singleResult()
                  .getId()
          ).isEqualTo(processInstance1.getId());
  
          assertThat(
              runtimeService
                  .createProcessInstanceQuery()
                  .or()
                  .processInstanceNameLike("%\\_%")
                  .processDefinitionId("undefined")
                  .singleResult()
          ).isNotNull();
          assertThat(
              runtimeService
                  .createProcessInstanceQuery()
                  .or()
                  .processInstanceNameLike("%\\_%")
                  .processDefinitionId("undefined")
                  .singleResult()
                  .getId()
          ).isEqualTo(processInstance2.getId());
      }
  
      public void testQueryProcessInstanceNameLikeIgnoreCase() {
          // processInstanceNameLike
          assertThat(
              runtimeService.createProcessInstanceQuery().processInstanceNameLikeIgnoreCase("%\\%%").singleResult()
          ).isNotNull();
          assertThat(
              runtimeService
                  .createProcessInstanceQuery()
                  .processInstanceNameLikeIgnoreCase("%\\%%")
                  .singleResult()
                  .getId()
          ).isEqualTo(processInstance1.getId());
  
          assertThat(
              runtimeService.createProcessInstanceQuery().processInstanceNameLikeIgnoreCase("%\\_%").singleResult()
          ).isNotNull();
          assertThat(
              runtimeService
                  .createProcessInstanceQuery()
                  .processInstanceNameLikeIgnoreCase("%\\_%")
                  .singleResult()
                  .getId()
          ).isEqualTo(processInstance2.getId());
  
          // orQuery
          assertThat(
              runtimeService
                  .createProcessInstanceQuery()
                  .or()
                  .processInstanceNameLikeIgnoreCase("%\\%%")
                  .processDefinitionId("undefined")
                  .singleResult()
          ).isNotNull();
          assertThat(
              runtimeService
                  .createProcessInstanceQuery()
                  .or()
                  .processInstanceNameLikeIgnoreCase("%\\%%")
                  .processDefinitionId("undefined")
                  .singleResult()
                  .getId()
          ).isEqualTo(processInstance1.getId());
  
          assertThat(
              runtimeService
                  .createProcessInstanceQuery()
                  .or()
                  .processInstanceNameLikeIgnoreCase("%\\_%")
                  .processDefinitionId("undefined")
                  .singleResult()
          ).isNotNull();
          assertThat(
              runtimeService
                  .createProcessInstanceQuery()
                  .or()
                  .processInstanceNameLikeIgnoreCase("%\\_%")
                  .processDefinitionId("undefined")
                  .singleResult()
                  .getId()
          ).isEqualTo(processInstance2.getId());
      }
  
      @Test
      public void testQueryLikeByQueryVariableValue() {
          // queryVariableValue
          ProcessInstance processInstance = runtimeService
              .createProcessInstanceQuery()
              .variableValueLike("var1", "%\\%%")
              .singleResult();
          assertThat(processInstance).isNotNull();
          assertThat(processInstance.getId()).isEqualTo(processInstance1.getId());
  
          processInstance = runtimeService.createProcessInstanceQuery().variableValueLike("var1", "%\\_%").singleResult();
          assertThat(processInstance).isNotNull();
          assertThat(processInstance.getId()).isEqualTo(processInstance2.getId());
  
          // orQuery
          processInstance = runtimeService
              .createProcessInstanceQuery()
              .or()
              .variableValueLike("var1", "%\\%%")
              .processDefinitionId("undefined")
              .singleResult();
          assertThat(processInstance).isNotNull();
          assertThat(processInstance.getId()).isEqualTo(processInstance1.getId());
  
          processInstance = runtimeService
              .createProcessInstanceQuery()
              .or()
              .variableValueLike("var1", "%\\_%")
              .processDefinitionId("undefined")
              .singleResult();
          assertThat(processInstance).isNotNull();
          assertThat(processInstance.getId()).isEqualTo(processInstance2.getId());
      }
  
      @Test
      public void testQueryLikeByQueryVariableValueIgnoreCase() {
          // queryVariableValueIgnoreCase
          ProcessInstance processInstance = runtimeService
              .createProcessInstanceQuery()
              .variableValueLikeIgnoreCase("var1", "%\\%%")
              .singleResult();
          assertThat(processInstance).isNotNull();
          assertThat(processInstance.getId()).isEqualTo(processInstance1.getId());
  
          processInstance = runtimeService
              .createProcessInstanceQuery()
              .variableValueLikeIgnoreCase("var1", "%\\_%")
              .singleResult();
          assertThat(processInstance).isNotNull();
          assertThat(processInstance.getId()).isEqualTo(processInstance2.getId());
  
          // orQuery
          processInstance = runtimeService
              .createProcessInstanceQuery()
              .or()
              .variableValueLikeIgnoreCase("var1", "%\\%%")
              .processDefinitionId("undefined")
              .singleResult();
          assertThat(processInstance).isNotNull();
          assertThat(processInstance.getId()).isEqualTo(processInstance1.getId());
  
          processInstance = runtimeService
              .createProcessInstanceQuery()
              .or()
              .variableValueLikeIgnoreCase("var1", "%\\_%")
              .processDefinitionId("undefined")
              .singleResult();
          assertThat(processInstance).isNotNull();
          assertThat(processInstance.getId()).isEqualTo(processInstance2.getId());
      }
  }
  