public static Query createEditQueryById(Long id) {
QInstanceSpecification query = QInstanceSpecification.newQuery();
query
.select(query.wildcard())
.select(query.clazz().wildcard())
.select(query.clazz().classifier().wildcard())
.select(query.instanceCategorization().wildcard())
.select(query.instanceCategorization().categorization().wildcard())
.select(query.instanceCategorization().categorization().category().wildcard())
.select(query.slot().wildcard())
.select(query.slot().definingFeature().wildcard())
.select(query.slot().value().wildcard())
.select(query.slot().value().instanceValue().wildcard())
.select(
query.slot().value().instanceValue().instance().seqId()) // links to another instance
.select(query.slot().value().literalString().wildcard())
.select(query.slot().value().literalClob().wildcard())
.select(query.slot().value().literalShort().wildcard())
.select(query.slot().value().literalInteger().wildcard())
.select(query.slot().value().literalLong().wildcard())
.select(query.slot().value().literalFloat().wildcard())
.select(query.slot().value().literalDouble().wildcard())
.select(query.slot().value().literalDate().wildcard())
.select(query.slot().value().literalBoolean().wildcard());
query.where(query.seqId().eq(id));
return query;
}
public static Query createExportQuery() {
QInstanceSpecification query = QInstanceSpecification.newQuery();
query
.select(query.wildcard())
.select(query.clazz().wildcard())
.select(query.packageableType().wildcard())
.select(query.packageableType()._package().wildcard())
.select(query.instanceCategorization().wildcard())
.select(query.instanceCategorization().categorization().wildcard())
.select(query.instanceCategorization().categorization().category().wildcard());
return query;
}
public static Query createDeleteQueryById(Long id) {
QInstanceSpecification query = QInstanceSpecification.newQuery();
query
.select(query.seqId())
.select(query.instanceCategorization().seqId())
.select(query.instanceCategorization().categorization().seqId())
// delete slots that point to us
.select(query.instanceValue().seqId())
.select(query.instanceValue().valueSpecification().seqId())
.select(query.instanceValue().valueSpecification().slot().seqId())
// delete our slots
.select(query.slot().seqId())
.select(query.slot().value().seqId())
.select(query.slot().value().instanceValue().seqId())
.select(query.slot().value().literalString().seqId())
.select(query.slot().value().literalClob().seqId())
.select(query.slot().value().literalShort().seqId())
.select(query.slot().value().literalInteger().seqId())
.select(query.slot().value().literalLong().seqId())
.select(query.slot().value().literalFloat().seqId())
.select(query.slot().value().literalDouble().seqId())
.select(query.slot().value().literalDate().seqId())
.select(query.slot().value().literalBoolean().seqId());
query.where(query.seqId().eq(id));
return query;
}
private static Query createQueueSelect(QInstanceSpecification query) {
query
.select(query.wildcard())
.select(query.clazz().wildcard())
.select(query.clazz().classifier().wildcard())
.select(query.instanceCategorization().wildcard())
.select(query.instanceCategorization().categorization().wildcard())
.select(query.instanceCategorization().categorization().category().name())
.select(query.instanceCategorization().categorization().category().parent().name())
.select(query.slot().wildcard())
.select(query.slot().definingFeature().wildcard())
.select(query.slot().definingFeature().name())
.select(query.slot().value().wildcard())
.select(query.slot().value().literalString().value())
.select(query.slot().value().literalClob().value())
.select(query.slot().value().literalShort().value())
.select(query.slot().value().literalInteger().value())
.select(query.slot().value().literalLong().value())
.select(query.slot().value().literalFloat().value())
.select(query.slot().value().literalDouble().value())
.select(query.slot().value().literalDate().value())
.select(query.slot().value().literalBoolean().value())
// all this to resolve the instance value to some readable string
.select(query.slot().value().instanceValue().seqId())
.select(
query.slot().value().instanceValue().instance().seqId()) // links to another instance
.select(query.slot().value().instanceValue().instance().clazz().seqId())
.select(query.slot().value().instanceValue().instance().clazz().classifier().name())
.select(query.slot().value().instanceValue().instance().clazz().classifier().seqId())
.select(query.slot().value().instanceValue().instance().slot().wildcard())
.select(query.slot().value().instanceValue().instance().slot().definingFeature().seqId())
.select(query.slot().value().instanceValue().instance().slot().definingFeature().name())
.select(query.slot().value().instanceValue().instance().slot().value().wildcard())
.select(
query.slot().value().instanceValue().instance().slot().value().literalString().value())
.select(
query.slot().value().instanceValue().instance().slot().value().literalClob().value())
.select(
query.slot().value().instanceValue().instance().slot().value().literalShort().value())
.select(
query.slot().value().instanceValue().instance().slot().value().literalInteger().value())
.select(
query.slot().value().instanceValue().instance().slot().value().literalLong().value())
.select(
query.slot().value().instanceValue().instance().slot().value().literalFloat().value())
.select(
query.slot().value().instanceValue().instance().slot().value().literalDouble().value())
.select(
query.slot().value().instanceValue().instance().slot().value().literalDate().value())
.select(
query
.slot()
.value()
.instanceValue()
.instance()
.slot()
.value()
.literalBoolean()
.value());
return query;
}