embeddedselect.query

Pegasus is an open-source implementationof the DMTF CIM and WBEM standards. It is designed to be por

#==============================================================
# Testcases for applyProjection with embedded objects.
#
# NOTE: ONLY use this file for applyProjection testcases.
#==============================================================

#==============================================================
# Properties at the FROM class level
#==============================================================

# Simple properties
SELECT EmbObjBase FROM CQL_EmbeddedSubClass
SELECT EmbObjSub FROM CQL_EmbeddedSubClass

# Good scoping class
SELECT CQL_EmbeddedSubClass::EmbObjBase FROM CQL_EmbeddedSubClass
SELECT CQL_EmbeddedBase::EmbObjSub FROM CQL_EmbeddedSubClass

# Bad scoping class
# Result: the instance of the FROM class will be emptied 
SELECT CQL_NonExistent::EmbObjBase FROM CQL_EmbeddedSubClass

# One good scoping class, one bad scoping class
# Result: only EmbObjSub is projected   
SELECT CQL_NonExistent::EmbObjBase, CQL_EmbeddedBase::EmbObjSub FROM CQL_EmbeddedSubClass

# Combine bad scoping class, and one simple property
# Result: only EmbObjBase is projected   
SELECT CQL_NonExistent::EmbObjBase, EmbObjBase FROM CQL_EmbeddedSubClass

# Combine good scoping class, and one simple property
SELECT EmbObjSub, CQL_EmbeddedSubClass::EmbObjBase FROM CQL_EmbeddedSubClass

#==============================================================
# Wildcard at FROM class level, and properties at the FROM level.
#
# The result of all of these is to project every property
# in the tree below the FROM class.
#==============================================================  

# Just a wildcard
SELECT * FROM CQL_EmbeddedSubClass

# With simple properties
SELECT *, EmbObjSub FROM CQL_EmbeddedSubClass

# With good scoping class
SELECT CQL_EmbeddedBase::EmbObjSub, * FROM CQL_EmbeddedSubClass

# With bad scoping class
SELECT *, CQL_NonExistent::EmbObjBase FROM CQL_EmbeddedSubClass

# With one good scoping class, one bad scoping class
SELECT CQL_NonExistent::EmbObjBase, *, CQL_EmbeddedBase::EmbObjSub FROM CQL_EmbeddedSubClass

# With one bad scoping class, and one simple property
SELECT CQL_NonExistent::EmbObjBase, EmbObjBase, * FROM CQL_EmbeddedSubClass

# With one good scoping class, and one simple property
SELECT *, EmbObjSub, CQL_EmbeddedSubClass::EmbObjBase FROM CQL_EmbeddedSubClass

#==============================================================
# Properties at the second level
#==============================================================

# Simple properties
SELECT EmbObjBase.CQL_EmbeddedTestElement::CS FROM CQL_EmbeddedSubClass
SELECT EmbObjBase.CQL_EmbeddedTestElement::TEArray FROM CQL_EmbeddedSubClass
SELECT EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT FROM CQL_EmbeddedSubClass
SELECT EmbObjBase.CQL_EmbeddedTestElement::SomeClass FROM CQL_EmbeddedSubClass

# Bad scoping classes
# Result: instance of the FROM class is emptied
SELECT EmbObjSub.CQL_NonExistent::TPT, EmbObjSub.CQL_NonExistent::CS FROM CQL_EmbeddedSubClass

# One good scoping class, one bad scoping class
# Result: ignore the bad scope, project CS
SELECT EmbObjSub.CQL_NonExistent::TPT, EmbObjSub.CQL_EmbeddedTestPropertyTypes::CS FROM CQL_EmbeddedSubClass

# Combine bad scoping classes, and the embedded object itself
# Result: ignore the bad scopes, project EmbObjSub
SELECT EmbObjSub.CQL_NonExistent::CS, EmbObjSub.CQL_NonExistent::TPT, EmbObjSub FROM CQL_EmbeddedSubClass

# Combine one good scoping class, one bad scoping class, and the embedded object itself
# Result: ignore the bad scope, project EmbObjSub
SELECT EmbObjSub.CQL_NonExistent::TPT, EmbObjSub, EmbObjSub.CQL_EmbeddedTestPropertyTypes::CS FROM CQL_EmbeddedSubClass

#==============================================================
# Wildcard at the second level, and properties at the second level.
#
# The result of all of these is to project every property
# in the tree below the second level
#==============================================================  

# Good scoping classes
# Result: project every property in the tree below EmbObjSub 
SELECT EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT, EmbObjSub.CQL_EmbeddedTestElement::TE, EmbObjSub.CQL_EmbeddedTestPropertyTypes::CS, EmbObjSub.* FROM CQL_EmbeddedSubClass

# Bad scoping classes
# Result: project every property in the tree below EmbObjSub 
SELECT EmbObjSub.*, EmbObjSub.CQL_NonExistent::TPT, EmbObjSub.CQL_NonExistent::CS FROM CQL_EmbeddedSubClass

# One good scoping class, one bad scoping class
# Result: project every property in the tree below EmbObjSub 
SELECT EmbObjSub.CQL_NonExistent::TPT, EmbObjSub.*, EmbObjSub.CQL_EmbeddedTestPropertyTypes::CS FROM CQL_EmbeddedSubClass

# Combine bad scoping classes, and the embedded object itself
# Result: project every property in the tree below EmbObjSub 
SELECT EmbObjSub.CQL_NonExistent::CS, EmbObjSub.*, EmbObjSub.CQL_NonExistent::TPT, EmbObjSub FROM CQL_EmbeddedSubClass

# Combine one good scoping class, one bad scoping class, and the embedded object itself
# Result: project every property in the tree below EmbObjSub 
SELECT EmbObjSub.CQL_NonExistent::TPT, EmbObjSub, EmbObjSub.CQL_EmbeddedTestPropertyTypes::CS, EmbObjSub.* FROM CQL_EmbeddedSubClass

#==============================================================
# Properties at the third level
#==============================================================

# Simple properties
SELECT EmbObjBase.CQL_EmbeddedTestElement::TE.CQL_TestElement::InstanceId FROM CQL_EmbeddedSubClass
SELECT EmbObjBase.CQL_EmbeddedTestElement::CS.CIM_ComputerSystem::EnabledState FROM CQL_EmbeddedSubClass
SELECT EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyUint32Array FROM CQL_EmbeddedSubClass

# Bad scoping classes
# Result: instance of the FROM class is emptied
SELECT EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_NonExistent::propertyString, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_NonExistent::propertyUint8 FROM CQL_EmbeddedSubClass

# One good scoping class, one bad scoping class
# Result: project propertyString
SELECT EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyString, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_NonExistent::propertyUint8 FROM CQL_EmbeddedSubClass

# Combine bad scoping class, and the embedded object itself
# Result: TPT is projected
SELECT EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_NonExistent::propertyUint8 FROM CQL_EmbeddedSubClass

# Combine one good scoping class, one bad scoping class, and the embedded object itself
# Result: TPT is projected
SELECT EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyString, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_NonExistent::propertyUint8, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT FROM CQL_EmbeddedSubClass

#==============================================================
# Wildcard at the third level, and properties at the third level.
#
# The result of all of these is to project every property
# in the tree below the third level
#==============================================================  

# Good scoping class
SELECT EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyString, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyUint8, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.* FROM CQL_EmbeddedSubClass

# Bad scoping classes
SELECT EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.*, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_NonExistent::propertyString, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_NonExistent::propertyUint8 FROM CQL_EmbeddedSubClass

# One good scoping class, one bad scoping class
SELECT EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyString, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_NonExistent::propertyUint8, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.* FROM CQL_EmbeddedSubClass

# Combine bad scoping class, and the embedded object itself
SELECT EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.*, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_NonExistent::propertyUint8 FROM CQL_EmbeddedSubClass

# Combine one good scoping class, one bad scoping class, and the embedded object itself
SELECT EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyString, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.*, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_NonExistent::propertyUint8, EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT FROM CQL_EmbeddedSubClass


#===================================================================
#
# Mixed Level Testing
#
# Test projection of whole embedded objects, with child properties
# also projected.
#
# If a chained identifier ends at an embedded object, then the
# whole embedded object is projected, ie. whatever properties 
# are on that embedded object remain after the projection, regardless
# of the type of the embedded object.
#
# This set of testcases test that all the properties on the embedded
# object are preserved, even if other chained identifiers call
# out child properties on the embedded object.
#
# Note that wildcard is treated as if each child embedded object
# property on the wildcarded object is projected as a whole.
#
# Example:
#  
# Class fc has two embedded object properties, eo1 and eo2. 
# eo1 is of type scopeclass, and has two properties, p1 and p2
#
# SELECT fc.*, fc.eo1.scopeclass::p1 FROM fc
# is equivalent to
# SELECT fc.eo1, fc.eo2, fc.eo1.scopeclass::p1 FROM fc
#
# e01 and e02 need to projected as-is, ie. p2 is preserved on eo1. 
#===================================================================

# No whole embedded objects or wildcards.  Just pick two leaves to set a baseline
# Projected Properties:
# EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyString => projected
# EmbObjBase.CQL_EmbeddedTestElement::CS.CQL_NonExistent::EnabledState  => ignored
#
# Result: project propertyString
#
SELECT EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyString, EmbObjBase.CQL_EmbeddedTestElement::CS.CQL_NonExistent::EnabledState FROM CQL_EmbeddedSubClass

# No whole embedded objects or wildcards.  Just pick two leaves to set a baseline
# Projected Properties:
# EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_NonExistent::propertyString => ignored
# EmbObjBase.CQL_EmbeddedTestElement::CS.CQL_NonExistent::EnabledState  => ignored
#
# Result: project nothing, instance of FROM class is emptied
#
SELECT EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_NonExistent::propertyString, EmbObjBase.CQL_EmbeddedTestElement::CS.CQL_NonExistent::EnabledState FROM CQL_EmbeddedSubClass

# Wildcard the FROM class, and pick two leaves, one with good scope, one with bad scope.
# Projected Properties:
# *
# EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyString => projected
# EmbObjBase.CQL_EmbeddedTestElement::CS.CQL_NonExistent::EnabledState => ignored  
#
# Result: project all properties in the embedded tree below CQL_EmbeddedSubClass