oracle.apps.fnd.appltest.diagfwk.engine.provider.dao
Interface TestDefDAO

All Superinterfaces:

BaseDAO

All Known Implementing Classes:

OADBTestDefDAO

public interface TestDefDAO
extends BaseDAO

Models a Data Access Object for retrieving Test Definition related information.

Nested Class Summary

Nested classes/interfaces inherited from interface oracle.apps.fnd.appltest.diagfwk.engine.provider.dao.BaseDAO

BaseDAO.DBSessionInfo

Method Summary

boolean	delete(TestDef pObj) Removes the given test definition object from the test repository.
java.util.List<java.lang.String>	fetchAllPrereqs(java.lang.String testName)
java.util.List<java.lang.String>	fetchAllPrereqs(java.lang.String pTestId, java.util.List<java.lang.String> pTagValueIdList)
java.util.List<java.lang.String>	fetchAllPrereqs(java.lang.String pTestId, java.lang.String pTagValueId, java.util.List<java.lang.String> pTagValueIdList)
TestPrereqList	fetchAllTestPrereqs(java.lang.String pTagValueId, java.util.List<java.lang.String> pIncludedTestIds)
java.lang.String	getInputsetId(java.lang.String pInputsetName, java.lang.String pTestId) Returns the GUID for the inpuset with the given name and the given test ID.
java.lang.String	getTestId(java.lang.String testName) Returns the test ID for the given test name.
java.lang.String[]	getTestIds(java.lang.String[] testNames) Returns the respective test IDs for all the given test names.
TestPrereqList	queryActivePrereqTests(java.lang.String pSourceTestName) Fetches the list of active immediate prerequisite tests for the given test
TagValueList	queryActiveTagValues(java.lang.String pTestName) Fetches the list of active diagnostic tag values associated with the given test name
TestDef[]	queryAllTests()
java.lang.String	queryFusionAppsVersion() query the Fusion Apps Version string
TestInputSetNVList	queryInputSetNVList(java.lang.String pInputsetId) Queries the list of test input name values for the given input set ID
TestInputSetList	queryInputSets(java.lang.String pTestName) Queries the list of test input sets registered in the test repository for the given test.
TestInputSetList	queryInputSetsByTestId(java.lang.String pTestId) Queries the list of test input sets registered in the test repository for the given test ID
TestInputSetList	queryInputSetsByTestId(java.lang.String pTestId, java.lang.String pDefaultFlag) Queries the list of test input sets registered in the test repository for the given test ID and with the given default flag
TestDefList	queryTestAttributesForTestNames(java.lang.String[] pTestNames) Queries some select test level attributes for the given test names.
TestDef	queryTestDefById(java.lang.String id)
TestDef	queryTestDefByName(java.lang.String name)
TestDef	queryTestDefSummaryById(java.lang.String pId) Fetches the summary information only for the given test id
TestDef	queryTestDefSummaryByName(java.lang.String pTestName) Fetches the summary information only for the given test name
java.lang.String[]	queryTestDisplayNames(java.lang.String[] pTestNames) Queries the test display names for the given test names.
TestParamList	queryTestParameters(java.lang.String pTestId, boolean isInput) Fetches the input/output parameter related information from fnd_diag_test_param for the test given test ID and param IO type
void	removeTagAssociationFromTests(java.lang.String pTagName, java.lang.String pTagValue, java.util.List<java.lang.String> pTestNames) Deletes the assocation to the given tag name and value from the given tests.
void	save(TestDef pObj) Saves the given test definition object to the test repository.
void	save(TestDef pObj, java.util.List<TagValue> pAutoSaveTagValues) Saves the given test definition object to the test repository.
void	save(TestInputSet pObj) Saves the given test input set to the test repository.
void	saveTagValueAssoc(TagValue pTagValue, java.util.List<java.lang.String> pTestNames) Associates the given list of tests with the given tag name and value pair

Methods inherited from interface oracle.apps.fnd.appltest.diagfwk.engine.provider.dao.BaseDAO

createSysGuid, getDBSessionInfo, queryNlsParameters, querySysDate, querySysDate

Method Detail

queryTestDefById

TestDef queryTestDefById(java.lang.String id)

Parameters:

id -

Returns:

TestDef object

queryTestDefByName

TestDef queryTestDefByName(java.lang.String name)

Parameters:

name -

Returns:

TestDef object

queryTestDisplayNames

java.lang.String[] queryTestDisplayNames(java.lang.String[] pTestNames)

Queries the test display names for the given test names.

Parameters:

pTestNames - input test names for which to fetch the corresponding display names

Returns:

Array of display names corresponding to the given test names

queryTestAttributesForTestNames

TestDefList queryTestAttributesForTestNames(java.lang.String[] pTestNames)

Queries some select test level attributes for the given test names. These attributes include test id, test name, test display name, prereq status count, inputs status. Currently does not include metadata.

Parameters:

pTestNames - names of the test to query

Returns:

the list of TestDef objects with the queried attributes populated for the given test names.

queryAllTests

TestDef[] queryAllTests()

queryTestDefSummaryByName

TestDef queryTestDefSummaryByName(java.lang.String pTestName)

Fetches the summary information only for the given test name

Parameters:

pTestName - name of the test

Returns:

an instance of TestDef with only the summary information populated.

queryTestDefSummaryById

TestDef queryTestDefSummaryById(java.lang.String pId)

Fetches the summary information only for the given test id

Parameters:

pId - id of the test

Returns:

an instance of TestDef with only the summary information populated.

queryTestParameters

TestParamList queryTestParameters(java.lang.String pTestId,
                                  boolean isInput)

Fetches the input/output parameter related information from fnd_diag_test_param for the test given test ID and param IO type

Parameters:

pTestId - - ID for the test

isInput - - the parameter type, true for input, false for output

Returns:

the list of parameters for the given test and the given param type

queryActivePrereqTests

TestPrereqList queryActivePrereqTests(java.lang.String pSourceTestName)

Fetches the list of active immediate prerequisite tests for the given test

Parameters:

pSourceTestName - name of the test for which to fetch prerequisites.

Returns:

the list of immediate prerequisite tests for the given test name.

queryActiveTagValues

TagValueList queryActiveTagValues(java.lang.String pTestName)

Fetches the list of active diagnostic tag values associated with the given test name

Parameters:

pTestName - name of the test for which to fetch the tag values

Returns:

list of active diagnostic tag values.

getTestId

java.lang.String getTestId(java.lang.String testName)

Returns the test ID for the given test name. Returns null if a test with the given name is not found in the test repository.

Parameters:

testName - name of the test

Returns:

the ID for the test with the given name

getInputsetId

java.lang.String getInputsetId(java.lang.String pInputsetName,
                               java.lang.String pTestId)

Returns the GUID for the inpuset with the given name and the given test ID.

Parameters:

pInputsetName - name of the input set

pTestId - test id for the input set

Returns:

inputset ID.

getTestIds

java.lang.String[] getTestIds(java.lang.String[] testNames)

Returns the respective test IDs for all the given test names. If a test name is not found, then the corresponding index in the returned array is null.

Parameters:

testNames - the list of test names

Returns:

a list of test IDs for the given test names

fetchAllPrereqs

java.util.List<java.lang.String> fetchAllPrereqs(java.lang.String testName)
                                                 throws DiagPrereqCycleException

Parameters:

testName - test name

Returns:

List of Strings with complete set of prerequiste testNames, after resolving dependencies.

Throws:

DiagPrereqCycleException - shows cycle found during dependency resolution process.

fetchAllPrereqs

java.util.List<java.lang.String> fetchAllPrereqs(java.lang.String pTestId,
                                                 java.util.List<java.lang.String> pTagValueIdList)
                                                 throws DiagPrereqCycleException

Parameters:

pTestId - test id

pTagValueIdList - - When value is null, API will not add TagValue prereq list. When value is not null, API will append TagValue prereqs list, discovered while resolving test id dependencies.

Returns:

List of prerequisite testId's, after resolving dependencies.

Throws:

DiagPrereqCycleException - shows cycle found during dependency resolution process.

fetchAllPrereqs

java.util.List<java.lang.String> fetchAllPrereqs(java.lang.String pTestId,
                                                 java.lang.String pTagValueId,
                                                 java.util.List<java.lang.String> pTagValueIdList)
                                                 throws DiagPrereqCycleException

Parameters:

pTestId - a test id

pTagValueId - a tag value id

pTagValueIdList - - When value is null, API will not add TagValue prereq list. When value is not null, API will append TagValue prereqs list, discovered while resolving test id dependencies

Returns:

List of prerequisite testId's, after resolving dependencies.

Throws:

DiagPrereqCycleException

fetchAllTestPrereqs

TestPrereqList fetchAllTestPrereqs(java.lang.String pTagValueId,
                                   java.util.List<java.lang.String> pIncludedTestIds)
                                   throws DiagPrereqCycleException

Parameters:

pTagValueId - - Tag Value Id

pIncludedTestIds - - fetch all included (and/or child) test ids (order is not important). When value is null, API will not fetch included test ids. When value is not null, API will append included test ids, discovered while resolving tag value id dependencies (both prereqs and includes) for the passed parameter "pTagValueId". However, resultset excludes test ids directly assigned to the parameter itself.

Returns:

- TestPrereqList with run order information - after processing all dependencies

Throws:

DiagPrereqCycleException - shows cycle found during dependency resolution process.

delete

boolean delete(TestDef pObj)
               throws java.sql.SQLException

Removes the given test definition object from the test repository. associated test data is deleted params, inputsets. Tag values and prereqs are unlinked

Parameters:

pObj - test definition object to save

Throws:

java.sql.SQLException

save

void save(TestDef pObj,
          java.util.List<TagValue> pAutoSaveTagValues)

Saves the given test definition object to the test repository. If the test already exists, the test definition is updated. Otherwise a new entry is created in the repository.

Parameters:

pObj - test definition object to save

pAutoSaveTagValues - list of tag values to save automatically unresolved tag values

save

void save(TestDef pObj)

Saves the given test definition object to the test repository. If the test already exists, the test definition is updated. Otherwise a new entry is created in the repository.

Parameters:

pObj - test definition object to save

saveTagValueAssoc

void saveTagValueAssoc(TagValue pTagValue,
                       java.util.List<java.lang.String> pTestNames)

Associates the given list of tests with the given tag name and value pair

Parameters:

pTagValue - tag value to associate

pTestNames - names of the tests to associate with the tag name and value

save

void save(TestInputSet pObj)

Saves the given test input set to the test repository. If an inputset with the given name for the particular test ID, already exists, the input set definition is updated. Otherwise a new input set is created.

Parameters:

pObj - test input set to save.

removeTagAssociationFromTests

void removeTagAssociationFromTests(java.lang.String pTagName,
                                   java.lang.String pTagValue,
                                   java.util.List<java.lang.String> pTestNames)

Deletes the assocation to the given tag name and value from the given tests. This involves:

• Removing any association in the given test definition metadata
• Removing entries from the fnd_diag_tag_value_test_assoc table

Parameters:

pTagName - name of the tag

pTagValue - value of the tag

pTestNames - list of test names from which to remove association to the given tag name value

queryInputSets

TestInputSetList queryInputSets(java.lang.String pTestName)

Queries the list of test input sets registered in the test repository for the given test.

Parameters:

pTestName - name of the test

Returns:

the list of input sets in the repsotory for the given test name.

queryInputSetsByTestId

TestInputSetList queryInputSetsByTestId(java.lang.String pTestId)

Queries the list of test input sets registered in the test repository for the given test ID

Parameters:

pTestId - ID of the test

Returns:

the list of input sets in the repsotory for the given test name.

queryInputSetsByTestId

TestInputSetList queryInputSetsByTestId(java.lang.String pTestId,
                                        java.lang.String pDefaultFlag)

Queries the list of test input sets registered in the test repository for the given test ID and with the given default flag

Parameters:

pTestId - test ID

pDefaultFlag - default flag

Returns:

the list of input sets in the repository with the given test name and default flag.

queryInputSetNVList

TestInputSetNVList queryInputSetNVList(java.lang.String pInputsetId)

Queries the list of test input name values for the given input set ID

Parameters:

pInputsetId - input set ID

Returns:

the list of name values for the given input set

queryFusionAppsVersion

java.lang.String queryFusionAppsVersion()

query the Fusion Apps Version string

Returns: