public virtual AuthorizationEntity findAuthorization(int type, string userId, string groupId, Resource resource, string resourceId)
{
IDictionary <string, object> @params = new Dictionary <string, object>();
@params["type"] = type;
@params["userId"] = userId;
@params["groupId"] = groupId;
@params["resourceId"] = resourceId;
if (resource != null)
{
@params["resourceType"] = resource.resourceType();
}
return((AuthorizationEntity)DbEntityManager.selectOne("selectAuthorizationByParameters", @params));
}
/// <returns> the latest version of the decision requirements definition with the given key and tenant id </returns>
public virtual DecisionRequirementsDefinitionEntity findLatestDecisionRequirementsDefinitionByKeyAndTenantId(string decisionRequirementsDefinitionKey, string tenantId)
{
IDictionary <string, string> parameters = new Dictionary <string, string>();
parameters["decisionRequirementsDefinitionKey"] = decisionRequirementsDefinitionKey;
parameters["tenantId"] = tenantId;
if (string.ReferenceEquals(tenantId, null))
{
return((DecisionRequirementsDefinitionEntity)DbEntityManager.selectOne("selectLatestDecisionRequirementsDefinitionByKeyWithoutTenantId", parameters));
}
else
{
return((DecisionRequirementsDefinitionEntity)DbEntityManager.selectOne("selectLatestDecisionRequirementsDefinitionByKeyAndTenantId", parameters));
}
}
private DatabasePurgeReport purgeDatabase(CommandContext commandContext)
{
DbEntityManager dbEntityManager = commandContext.DbEntityManager;
// For MySQL and MariaDB we have to disable foreign key check,
// to delete the table data as bulk operation (execution, incident etc.)
// The flag will be reset by the DBEntityManager after flush.
dbEntityManager.IgnoreForeignKeysForNextFlush = true;
IList <string> tablesNames = dbEntityManager.TableNamesPresentInDatabase;
string databaseTablePrefix = commandContext.ProcessEngineConfiguration.DatabaseTablePrefix.Trim();
// for each table
DatabasePurgeReport databasePurgeReport = new DatabasePurgeReport();
foreach (string tableName in tablesNames)
{
string tableNameWithoutPrefix = tableName.Replace(databaseTablePrefix, EMPTY_STRING);
if (!TABLENAMES_EXCLUDED_FROM_DB_CLEAN_CHECK.Contains(tableNameWithoutPrefix))
{
// Check if table contains data
IDictionary <string, string> param = new Dictionary <string, string>();
param[TABLE_NAME] = tableName;
long?count = (long?)dbEntityManager.selectOne(SELECT_TABLE_COUNT, param);
if (count > 0)
{
databasePurgeReport.addPurgeInformation(tableName, count);
// Get corresponding entity classes for the table, which contains data
IList <Type> entities = commandContext.TableDataManager.getEntities(tableName);
if (entities.Count == 0)
{
//JAVA TO C# CONVERTER WARNING: The .NET Type.FullName property will not always yield results identical to the Java Class.getName method:
throw new ProcessEngineException("No mapped implementation of " + typeof(DbEntity).FullName + " was found for: " + tableName);
}
// Delete the table data as bulk operation with the first entity
Type entity = entities[0];
DbBulkOperation deleteBulkOp = new DbBulkOperation(DbOperationType.DELETE_BULK, entity, DELETE_TABLE_DATA, param);
dbEntityManager.DbOperationManager.addOperation(deleteBulkOp);
}
}
}
return(databasePurgeReport);
}
public virtual long?executeSelectSum(MetricsQueryImpl query)
{
long?result = (long?)DbEntityManager.selectOne(SELECT_METER_SUM, query);
result = result != null ? result : 0;
if (shouldAddCurrentUnloggedCount(query))
{
// add current unlogged count
Meter meter = Context.ProcessEngineConfiguration.MetricsRegistry.getMeterByName(query.Name);
if (meter != null)
{
result += meter.get();
}
}
return(result);
}
public virtual long findUserCountByQueryCriteria(DbUserQueryImpl query)
{
configureQuery(query, Resources.USER);
return((long?)DbEntityManager.selectOne("selectUserCountByQueryCriteria", query).Value);
}
public virtual long findTenantCountByQueryCriteria(DbTenantQueryImpl query)
{
configureQuery(query, Resources.TENANT);
return((long?)DbEntityManager.selectOne("selectTenantCountByQueryCriteria", query).Value);
}
public virtual long findBatchCountByQueryCriteria(HistoricBatchQueryImpl historicBatchQuery)
{
configureQuery(historicBatchQuery);
return((long?)DbEntityManager.selectOne("selectHistoricBatchCountByQueryCriteria", historicBatchQuery).Value);
}
public virtual long findEventSubscriptionCountByQueryCriteria(EventSubscriptionQueryImpl eventSubscriptionQueryImpl)
{
configureQuery(eventSubscriptionQueryImpl);
return((long?)DbEntityManager.selectOne("selectEventSubscriptionCountByQueryCriteria",eventSubscriptionQueryImpl).Value);
}
public virtual long findHistoricJobLogsCountByQueryCriteria(HistoricJobLogQueryImpl query)
{
configureQuery(query);
return((long?)DbEntityManager.selectOne("selectHistoricJobLogCountByQueryCriteria", query).Value);
}
public virtual long findJobCountByQueryCriteria(JobQueryImpl jobQuery)
{
configureQuery(jobQuery);
return((long?)DbEntityManager.selectOne("selectJobCountByQueryCriteria", jobQuery).Value);
}
public virtual HistoricBatchEntity findHistoricBatchByJobId(string jobId)
{
return((HistoricBatchEntity)DbEntityManager.selectOne("selectHistoricBatchByJobId", jobId));
}
public virtual long findOperationLogEntryCountByQueryCriteria(UserOperationLogQueryImpl query)
{
AuthorizationManager.configureUserOperationLogQuery(query);
return((long?)DbEntityManager.selectOne("selectUserOperationLogEntryCountByQueryCriteria", query).Value);
}
public virtual long?selectAuthorizationCountByQueryCriteria(AuthorizationQueryImpl authorizationQuery)
{
configureQuery(authorizationQuery, AUTHORIZATION);
return((long?)DbEntityManager.selectOne("selectAuthorizationCountByQueryCriteria", authorizationQuery));
}
public virtual long findTaskCountByQueryCriteria(TaskQueryImpl taskQuery)
{
configureQuery(taskQuery);
return((long?)DbEntityManager.selectOne("selectTaskCountByQueryCriteria", taskQuery).Value);
}
public virtual TaskEntity findTaskByCaseExecutionId(string caseExecutionId)
{
return((TaskEntity)DbEntityManager.selectOne("selectTaskByCaseExecutionId", caseExecutionId));
}
public virtual long findExternalTaskCountByQueryCriteria(ExternalTaskQueryImpl externalTaskQuery)
{
configureQuery(externalTaskQuery);
return((long?)DbEntityManager.selectOne("selectExternalTaskCountByQueryCriteria", externalTaskQuery).Value);
}
public virtual long findUserCountByNativeQuery(IDictionary <string, object> parameterMap)
{
return((long?)DbEntityManager.selectOne("selectUserCountByNativeQuery", parameterMap).Value);
}
public virtual long findFilterCountByQueryCriteria(FilterQueryImpl filterQuery)
{
configureQuery(filterQuery, FILTER);
return((long?)DbEntityManager.selectOne("selectFilterCountByQueryCriteria", filterQuery).Value);
}
public virtual long findIncidentCountByQueryCriteria(IncidentQueryImpl incidentQuery)
{
configureQuery(incidentQuery);
return((long?)DbEntityManager.selectOne("selectIncidentCountByQueryCriteria", incidentQuery).Value);
}
public virtual long findCaseSentryPartCountByQueryCriteria(CaseSentryPartQueryImpl caseSentryPartQuery)
{
return((long?)DbEntityManager.selectOne("selectCaseSentryPartsCountByQueryCriteria", caseSentryPartQuery).Value);
}
public virtual JobEntity findJobById(string jobId)
{
return((JobEntity)DbEntityManager.selectOne("selectJob", jobId));
}
public virtual long findHistoricVariableInstanceCountByQueryCriteria(HistoricVariableInstanceQueryImpl historicProcessVariableQuery)
{
configureQuery(historicProcessVariableQuery);
return((long?)DbEntityManager.selectOne("selectHistoricVariableInstanceCountByQueryCriteria", historicProcessVariableQuery).Value);
}
// select /////////////////////////////////////////////////////////////////
public virtual HistoricJobLogEventEntity findHistoricJobLogById(string historicJobLogId)
{
return((HistoricJobLogEventEntity)DbEntityManager.selectOne("selectHistoricJobLog", historicJobLogId));
}
public virtual long findHistoricVariableInstanceCountByNativeQuery(IDictionary <string, object> parameterMap)
{
return((long?)DbEntityManager.selectOne("selectHistoricVariableInstanceCountByNativeQuery", parameterMap).Value);
}
public virtual long findHistoricCaseActivityInstanceCountByQueryCriteria(HistoricCaseActivityInstanceQueryImpl historicCaseActivityInstanceQuery)
{
configureHistoricCaseActivityInstanceQuery(historicCaseActivityInstanceQuery);
return((long?)DbEntityManager.selectOne("selectHistoricCaseActivityInstanceCountByQueryCriteria", historicCaseActivityInstanceQuery).Value);
}
public virtual EventSubscriptionEntity findEventSubscriptionById(string id)
{
return((EventSubscriptionEntity)DbEntityManager.selectOne("selectEventSubscription",id));
}
public virtual HistoricVariableInstanceEntity findHistoricVariableInstanceByVariableInstanceId(string variableInstanceId)
{
return((HistoricVariableInstanceEntity)DbEntityManager.selectOne("selectHistoricVariableInstanceByVariableInstanceId", variableInstanceId));
}
public virtual long findProcessDefinitionCountByQueryCriteria(ProcessDefinitionQueryImpl processDefinitionQuery)
{
configureProcessDefinitionQuery(processDefinitionQuery);
return((long?)DbEntityManager.selectOne("selectProcessDefinitionCountByQueryCriteria", processDefinitionQuery).Value);
}
public virtual long findDecisionDefinitionCountByQueryCriteria(DecisionDefinitionQueryImpl decisionDefinitionQuery)
{
configureDecisionDefinitionQuery(decisionDefinitionQuery);
return((long?)DbEntityManager.selectOne("selectDecisionDefinitionCountByQueryCriteria", decisionDefinitionQuery).Value);
}
public virtual long findGroupCountByQueryCriteria(DbGroupQueryImpl query)
{
configureQuery(query, Resources.GROUP);
return((long?)DbEntityManager.selectOne("selectGroupCountByQueryCriteria", query).Value);
}
