public virtual void testNativeCountQuery() { startProcessInstanceAndEvaluateDecision(); string tablePrefix = processEngineConfiguration.DatabaseTablePrefix; NativeHistoricDecisionInstanceQuery nativeQuery = historyService.createNativeHistoricDecisionInstanceQuery().sql("SELECT count(*) FROM " + tablePrefix + "ACT_HI_DECINST"); assertThat(nativeQuery.count(), @is(1L)); }
public virtual void testNativeQueryPaging() { startProcessInstanceAndEvaluateDecision(); startProcessInstanceAndEvaluateDecision(); string tablePrefix = processEngineConfiguration.DatabaseTablePrefix; NativeHistoricDecisionInstanceQuery nativeQuery = historyService.createNativeHistoricDecisionInstanceQuery().sql("SELECT * FROM " + tablePrefix + "ACT_HI_DECINST"); assertThat(nativeQuery.listPage(0, 2).size(), @is(2)); assertThat(nativeQuery.listPage(1, 1).size(), @is(1)); }
public virtual void testNativeQuery() { startProcessInstanceAndEvaluateDecision(); string tablePrefix = processEngineConfiguration.DatabaseTablePrefix; NativeHistoricDecisionInstanceQuery nativeQuery = historyService.createNativeHistoricDecisionInstanceQuery().sql("SELECT * FROM " + tablePrefix + "ACT_HI_DECINST"); assertThat(nativeQuery.list().size(), @is(1)); NativeHistoricDecisionInstanceQuery nativeQueryWithParameter = historyService.createNativeHistoricDecisionInstanceQuery().sql("SELECT * FROM " + tablePrefix + "ACT_HI_DECINST H WHERE H.DEC_DEF_KEY_ = #{decisionDefinitionKey}"); assertThat(nativeQueryWithParameter.parameter("decisionDefinitionKey", DECISION_DEFINITION_KEY).list().size(), @is(1)); assertThat(nativeQueryWithParameter.parameter("decisionDefinitionKey", "other decision").list().size(), @is(0)); }