Search in sources :

Example 1 with QObject

use of com.evolveum.midpoint.repo.sqale.qmodel.object.QObject in project midpoint by Evolveum.

the class SqaleRepositoryService method executeOverwriteObject.

/**
 * Overwrite is more like update than add.
 */
private <T extends ObjectType> String executeOverwriteObject(@NotNull PrismObject<T> newObject) throws SchemaException, RepositoryException, ObjectAlreadyExistsException {
    String oid = newObject.getOid();
    UUID oidUuid = checkOid(oid);
    long opHandle = registerOperationStart(OP_ADD_OBJECT_OVERWRITE, newObject);
    try (JdbcSession jdbcSession = sqlRepoContext.newJdbcSession().startTransaction()) {
        try {
            // noinspection ConstantConditions
            RootUpdateContext<T, QObject<MObject>, MObject> updateContext = prepareUpdateContext(jdbcSession, newObject.getCompileTimeClass(), oidUuid);
            PrismObject<T> prismObject = updateContext.getPrismObject();
            // no precondition check for overwrite
            invokeConflictWatchers(w -> w.beforeModifyObject(prismObject));
            newObject.setUserData(RepositoryService.KEY_ORIGINAL_OBJECT, prismObject.clone());
            ObjectDelta<T> delta = prismObject.diff(newObject, EquivalenceStrategy.LITERAL);
            Collection<? extends ItemDelta<?, ?>> modifications = delta.getModifications();
            logger.trace("overwriteAddObjectAttempt: originalOid={}, modifications={}", oid, modifications);
            Collection<? extends ItemDelta<?, ?>> executedModifications = updateContext.execute(modifications, false);
            replaceObject(updateContext, updateContext.getPrismObject());
            if (!executedModifications.isEmpty()) {
                invokeConflictWatchers((w) -> w.afterModifyObject(oid));
            }
            logger.trace("OBJECT after:\n{}", prismObject.debugDumpLazily());
        } catch (ObjectNotFoundException e) {
            // so it is just plain addObject after all
            new AddObjectContext<>(sqlRepoContext, newObject).execute(jdbcSession);
            invokeConflictWatchers((w) -> w.afterAddObject(oid, newObject));
        }
        jdbcSession.commit();
        return oid;
    } catch (RuntimeException e) {
        SqaleUtils.handlePostgresException(e);
        throw e;
    } finally {
        registerOperationFinish(opHandle);
    }
}
Also used : Connection(java.sql.Connection) com.evolveum.midpoint.prism.query(com.evolveum.midpoint.prism.query) com.evolveum.midpoint.repo.sqlbase(com.evolveum.midpoint.repo.sqlbase) QOrgClosure(com.evolveum.midpoint.repo.sqale.qmodel.org.QOrgClosure) Autowired(org.springframework.beans.factory.annotation.Autowired) QueryTableMapping(com.evolveum.midpoint.repo.sqlbase.mapping.QueryTableMapping) com.evolveum.midpoint.util.exception(com.evolveum.midpoint.util.exception) InternalsConfig(com.evolveum.midpoint.schema.internals.InternalsConfig) OperationResultStatus(com.evolveum.midpoint.schema.result.OperationResultStatus) S_MatchingRuleEntry(com.evolveum.midpoint.prism.query.builder.S_MatchingRuleEntry) com.evolveum.midpoint.repo.api(com.evolveum.midpoint.repo.api) com.evolveum.midpoint.prism(com.evolveum.midpoint.prism) ObjectQueryUtil(com.evolveum.midpoint.schema.util.ObjectQueryUtil) XmlTypeConverter(com.evolveum.midpoint.prism.xml.XmlTypeConverter) S_ConditionEntry(com.evolveum.midpoint.prism.query.builder.S_ConditionEntry) ObjectDelta(com.evolveum.midpoint.prism.delta.ObjectDelta) RootUpdateContext(com.evolveum.midpoint.repo.sqale.update.RootUpdateContext) Collectors(java.util.stream.Collectors) StandardCharsets(java.nio.charset.StandardCharsets) Objects(java.util.Objects) Nullable(org.jetbrains.annotations.Nullable) Expressions(com.querydsl.core.types.dsl.Expressions) MObject(com.evolveum.midpoint.repo.sqale.qmodel.object.MObject) PropertyDelta(com.evolveum.midpoint.prism.delta.PropertyDelta) QName(javax.xml.namespace.QName) NotNull(org.jetbrains.annotations.NotNull) FocusTypeUtil(com.evolveum.midpoint.schema.util.FocusTypeUtil) Tuple(com.querydsl.core.Tuple) FlexibleRelationalPathBase(com.evolveum.midpoint.repo.sqlbase.querydsl.FlexibleRelationalPathBase) com.evolveum.midpoint.schema(com.evolveum.midpoint.schema) java.util(java.util) com.evolveum.midpoint.xml.ns._public.common.common_3(com.evolveum.midpoint.xml.ns._public.common.common_3) ObjectFilterExpressionEvaluator(com.evolveum.midpoint.repo.api.query.ObjectFilterExpressionEvaluator) AddObjectContext(com.evolveum.midpoint.repo.sqale.update.AddObjectContext) CryptoUtil(com.evolveum.midpoint.common.crypto.CryptoUtil) SchemaConstants(com.evolveum.midpoint.schema.constants.SchemaConstants) OperationResult(com.evolveum.midpoint.schema.result.OperationResult) ItemDeltaCollectionsUtil(com.evolveum.midpoint.prism.delta.ItemDeltaCollectionsUtil) Trace(com.evolveum.midpoint.util.logging.Trace) ObjectUtils.defaultIfNull(org.apache.commons.lang3.ObjectUtils.defaultIfNull) Path(com.querydsl.core.types.Path) PrettyPrinter(com.evolveum.midpoint.util.PrettyPrinter) QOrgMapping(com.evolveum.midpoint.repo.sqale.qmodel.org.QOrgMapping) ItemDelta(com.evolveum.midpoint.prism.delta.ItemDelta) QObjectReferenceMapping(com.evolveum.midpoint.repo.sqale.qmodel.ref.QObjectReferenceMapping) Strings(com.google.common.base.Strings) SQLException(java.sql.SQLException) EquivalenceStrategy(com.evolveum.midpoint.prism.equivalence.EquivalenceStrategy) ObjectTypeUtil(com.evolveum.midpoint.schema.util.ObjectTypeUtil) MObjectType(com.evolveum.midpoint.repo.sqale.qmodel.object.MObjectType) SQLQuery(com.querydsl.sql.SQLQuery) QObjectReference(com.evolveum.midpoint.repo.sqale.qmodel.ref.QObjectReference) PolyString(com.evolveum.midpoint.prism.polystring.PolyString) SqaleTableMapping(com.evolveum.midpoint.repo.sqale.mapping.SqaleTableMapping) QObject(com.evolveum.midpoint.repo.sqale.qmodel.object.QObject) ObjectArrays(com.google.common.collect.ObjectArrays) InternalMonitor(com.evolveum.midpoint.schema.internals.InternalMonitor) QOrg(com.evolveum.midpoint.repo.sqale.qmodel.org.QOrg) SqlPerformanceMonitorImpl(com.evolveum.midpoint.repo.sqlbase.perfmon.SqlPerformanceMonitorImpl) ItemPath(com.evolveum.midpoint.prism.path.ItemPath) Consumer(java.util.function.Consumer) Validate(org.apache.commons.lang3.Validate) Driver(java.sql.Driver) SearchFilterType(com.evolveum.prism.xml.ns._public.query_3.SearchFilterType) DriverManager(java.sql.DriverManager) AddObjectContext(com.evolveum.midpoint.repo.sqale.update.AddObjectContext) MObject(com.evolveum.midpoint.repo.sqale.qmodel.object.MObject) PolyString(com.evolveum.midpoint.prism.polystring.PolyString) QObject(com.evolveum.midpoint.repo.sqale.qmodel.object.QObject)

Example 2 with QObject

use of com.evolveum.midpoint.repo.sqale.qmodel.object.QObject in project midpoint by Evolveum.

the class SqaleRepositoryService method prepareUpdateContext.

/**
 * Read object for update and returns update context that contains it with specific get options.
 */
private <S extends ObjectType, Q extends QObject<R>, R extends MObject> RootUpdateContext<S, Q, R> prepareUpdateContext(@NotNull JdbcSession jdbcSession, @NotNull Class<S> schemaType, @NotNull UUID oid, Collection<SelectorOptions<GetOperationOptions>> getOptions, RepoModifyOptions options) throws SchemaException, ObjectNotFoundException {
    SqaleTableMapping<S, QObject<R>, R> rootMapping = sqlRepoContext.getMappingBySchemaType(schemaType);
    QObject<R> entityPath = rootMapping.defaultAlias();
    Path<?>[] selectExpressions = ObjectArrays.concat(rootMapping.selectExpressions(entityPath, getOptions), entityPath.containerIdSeq);
    Tuple result = jdbcSession.newQuery().select(selectExpressions).from(entityPath).where(entityPath.oid.eq(oid)).forUpdate().fetchOne();
    if (result == null || result.get(entityPath.fullObject) == null) {
        throw new ObjectNotFoundException(schemaType, oid.toString());
    }
    S object = rootMapping.toSchemaObject(result, entityPath, getOptions, jdbcSession, RepoModifyOptions.isForceReindex(options));
    R rootRow = rootMapping.newRowObject();
    rootRow.oid = oid;
    rootRow.containerIdSeq = result.get(entityPath.containerIdSeq);
    // This column is generated, some sub-entities need it, but we can't push it to DB.
    rootRow.objectType = MObjectType.fromSchemaType(object.getClass());
    return new RootUpdateContext<>(sqlRepoContext, jdbcSession, object, rootRow);
}
Also used : Path(com.querydsl.core.types.Path) ItemPath(com.evolveum.midpoint.prism.path.ItemPath) RootUpdateContext(com.evolveum.midpoint.repo.sqale.update.RootUpdateContext) QObject(com.evolveum.midpoint.repo.sqale.qmodel.object.QObject) Tuple(com.querydsl.core.Tuple)

Example 3 with QObject

use of com.evolveum.midpoint.repo.sqale.qmodel.object.QObject in project midpoint by Evolveum.

the class SqaleRepositoryService method readByOid.

/**
 * Read object using provided {@link JdbcSession} as a part of already running transaction.
 */
private <S extends ObjectType> S readByOid(@NotNull JdbcSession jdbcSession, @NotNull Class<S> schemaType, @NotNull UUID oid, Collection<SelectorOptions<GetOperationOptions>> options) throws SchemaException, ObjectNotFoundException {
    SqaleTableMapping<S, QObject<MObject>, MObject> rootMapping = sqlRepoContext.getMappingBySchemaType(schemaType);
    QObject<MObject> root = rootMapping.defaultAlias();
    Tuple result = jdbcSession.newQuery().from(root).select(rootMapping.selectExpressions(root, options)).where(root.oid.eq(oid)).fetchOne();
    if (result == null || result.get(root.fullObject) == null) {
        throw new ObjectNotFoundException(schemaType, oid.toString());
    }
    return rootMapping.toSchemaObject(result, root, options, jdbcSession, false);
}
Also used : MObject(com.evolveum.midpoint.repo.sqale.qmodel.object.MObject) QObject(com.evolveum.midpoint.repo.sqale.qmodel.object.QObject) Tuple(com.querydsl.core.Tuple)

Example 4 with QObject

use of com.evolveum.midpoint.repo.sqale.qmodel.object.QObject in project midpoint by Evolveum.

the class SqaleRepositoryService method executeGetVersion.

private <T extends ObjectType> String executeGetVersion(Class<T> type, UUID oid) throws ObjectNotFoundException {
    long opHandle = registerOperationStart(OP_GET_VERSION, type);
    try (JdbcSession jdbcSession = sqlRepoContext.newJdbcSession().startReadOnlyTransaction()) {
        SqaleTableMapping<T, QObject<MObject>, MObject> rootMapping = sqlRepoContext.getMappingBySchemaType(type);
        QObject<MObject> root = rootMapping.defaultAlias();
        Integer version = jdbcSession.newQuery().select(root.version).from(root).where(root.oid.eq(oid)).fetchOne();
        if (version == null) {
            throw new ObjectNotFoundException(type, oid.toString());
        }
        String versionString = version.toString();
        invokeConflictWatchers((w) -> w.afterGetVersion(oid.toString(), versionString));
        return versionString;
    } finally {
        registerOperationFinish(opHandle);
    }
}
Also used : MObject(com.evolveum.midpoint.repo.sqale.qmodel.object.MObject) PolyString(com.evolveum.midpoint.prism.polystring.PolyString) QObject(com.evolveum.midpoint.repo.sqale.qmodel.object.QObject)

Example 5 with QObject

use of com.evolveum.midpoint.repo.sqale.qmodel.object.QObject in project midpoint by Evolveum.

the class OrgFilterProcessor method process.

@Override
public Predicate process(OrgFilter filter) throws QueryException {
    // necessary for lazy refresh of org closure
    context.markContainsOrgFilter();
    FlexibleRelationalPathBase<?> path = context.root();
    if (!(path instanceof QObject)) {
        throw new QueryException("Org filter can only be used for objects," + " not for path " + path + " of type " + path.getClass());
    }
    QObject<?> objectPath = (QObject<?>) path;
    if (filter.isRoot()) {
        QObjectReference<MObject> ref = getNewRefAlias();
        return subQuery(ref).where(ref.ownerOid.eq(objectPath.oid)).notExists();
    }
    if (filter.getOrgRef() == null) {
        throw new QueryException("No organization reference defined in the search query.");
    }
    String oidParam = filter.getOrgRef().getOid();
    if (oidParam == null) {
        throw new QueryException("No oid specified in organization reference " + filter.getOrgRef().debugDump());
    }
    QName relation = filter.getOrgRef().getRelation();
    // null means ANY (not "default") here, so we only search/normalize non-nulls
    Integer relationId = relation != null ? context.repositoryContext().searchCachedRelationId(relation) : null;
    if (filter.getScope() == OrgFilter.Scope.ONE_LEVEL) {
        QObjectReference<MObject> ref = getNewRefAlias();
        SQLQuery<?> subQuery = subQuery(ref).where(ref.ownerOid.eq(objectPath.oid).and(ref.targetOid.eq(UUID.fromString(oidParam))));
        if (relationId != null) {
            subQuery.where(ref.relationId.eq(relationId));
        }
        return subQuery.exists();
    } else if (filter.getScope() == OrgFilter.Scope.SUBTREE) {
        QObjectReference<MObject> ref = getNewRefAlias();
        QOrgClosure oc = getNewClosureAlias();
        SQLQuery<?> subQuery = subQuery(ref).join(oc).on(oc.descendantOid.eq(ref.targetOid)).where(ref.ownerOid.eq(objectPath.oid).and(oc.ancestorOid.eq(UUID.fromString(oidParam))));
        if (relationId != null) {
            subQuery.where(ref.relationId.eq(relationId));
        }
        return subQuery.exists();
    } else if (filter.getScope() == OrgFilter.Scope.ANCESTORS) {
        QOrgClosure oc = getNewClosureAlias();
        return subQuery(oc).where(oc.ancestorOid.eq(objectPath.oid).and(oc.descendantOid.eq(UUID.fromString(oidParam))).and(oc.ancestorOid.ne(oc.descendantOid))).exists();
    } else {
        throw new QueryException("Unknown scope if org filter: " + filter);
    }
}
Also used : QName(javax.xml.namespace.QName) MObject(com.evolveum.midpoint.repo.sqale.qmodel.object.MObject) SQLQuery(com.querydsl.sql.SQLQuery) QObject(com.evolveum.midpoint.repo.sqale.qmodel.object.QObject) QOrgClosure(com.evolveum.midpoint.repo.sqale.qmodel.org.QOrgClosure) QueryException(com.evolveum.midpoint.repo.sqlbase.QueryException) QObjectReference(com.evolveum.midpoint.repo.sqale.qmodel.ref.QObjectReference)

Aggregations

QObject (com.evolveum.midpoint.repo.sqale.qmodel.object.QObject)5 MObject (com.evolveum.midpoint.repo.sqale.qmodel.object.MObject)4 ItemPath (com.evolveum.midpoint.prism.path.ItemPath)2 PolyString (com.evolveum.midpoint.prism.polystring.PolyString)2 QOrgClosure (com.evolveum.midpoint.repo.sqale.qmodel.org.QOrgClosure)2 QObjectReference (com.evolveum.midpoint.repo.sqale.qmodel.ref.QObjectReference)2 RootUpdateContext (com.evolveum.midpoint.repo.sqale.update.RootUpdateContext)2 Tuple (com.querydsl.core.Tuple)2 CryptoUtil (com.evolveum.midpoint.common.crypto.CryptoUtil)1 com.evolveum.midpoint.prism (com.evolveum.midpoint.prism)1 ItemDelta (com.evolveum.midpoint.prism.delta.ItemDelta)1 ItemDeltaCollectionsUtil (com.evolveum.midpoint.prism.delta.ItemDeltaCollectionsUtil)1 ObjectDelta (com.evolveum.midpoint.prism.delta.ObjectDelta)1 PropertyDelta (com.evolveum.midpoint.prism.delta.PropertyDelta)1 EquivalenceStrategy (com.evolveum.midpoint.prism.equivalence.EquivalenceStrategy)1 com.evolveum.midpoint.prism.query (com.evolveum.midpoint.prism.query)1 S_ConditionEntry (com.evolveum.midpoint.prism.query.builder.S_ConditionEntry)1 S_MatchingRuleEntry (com.evolveum.midpoint.prism.query.builder.S_MatchingRuleEntry)1 XmlTypeConverter (com.evolveum.midpoint.prism.xml.XmlTypeConverter)1 com.evolveum.midpoint.repo.api (com.evolveum.midpoint.repo.api)1