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));
}
