|
Oracle Fusion Middleware extensions for Logging and Diagnostic 11g Release 1 (11.1.1.6) E22565-06 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object oracle.apps.fnd.appltest.diagfwk.engine.provider.dao.db.OADBBaseDAO oracle.apps.fnd.appltest.diagfwk.engine.provider.dao.db.OADBTestDefDAO
public class OADBTestDefDAO
Provides Data Access API implementations for Oracle Applications Database.
Nested Class Summary | |
---|---|
protected static class |
OADBTestDefDAO.DepType
|
protected class |
OADBTestDefDAO.PrereqProcessingInfo
|
Nested classes/interfaces inherited from interface oracle.apps.fnd.appltest.diagfwk.engine.provider.dao.BaseDAO |
---|
BaseDAO.DBSessionInfo |
Field Summary | |
---|---|
static java.lang.String |
SQL_QUERY_DIAG_TEST_DELETE_ALLOWED_FOR_TESTNAME
|
static java.lang.String |
SQL_QUERY_DIAG_TEST_PARAM_VL_FOR_TESTID
|
Fields inherited from class oracle.apps.fnd.appltest.diagfwk.engine.provider.dao.db.OADBBaseDAO |
---|
langCode |
Constructor Summary | |
---|---|
OADBTestDefDAO()
|
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 pTestName)
|
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.sql.Connection pCon,
java.lang.String pTestName)
|
java.lang.String |
getTestId(java.lang.String pTestName)
Returns the test ID for the given test name. |
java.lang.String[] |
getTestIds(java.lang.String[] pTestNames)
Returns the respective test IDs for all the given test names. |
protected void |
mergePrereqProcInfoList(java.util.ArrayList<OADBTestDefDAO.PrereqProcessingInfo> pPrereqInfoList,
TestPrereqList pTestIdsFromTagVal,
java.lang.String pid,
int pOrder,
OADBTestDefDAO.DepType pDepType,
boolean pSetProcessedFlag,
OADBTestDefDAO.PrereqProcessingInfo pLastPrereq)
|
protected void |
mergePrereqsArrayList(java.util.ArrayList<OADBTestDefDAO.PrereqProcessingInfo> pPrereqInfoList,
java.util.ArrayList<OADBTestDefDAO.PrereqProcessingInfo> pPrereqInfoListSec,
java.lang.String pid,
int pOrder,
OADBTestDefDAO.PrereqProcessingInfo pLastPrereq)
|
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 application version |
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 pId)
|
TestDef |
queryTestDefByName(java.lang.String pName)
|
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 pId,
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. |
protected void |
removeTagFromTests(java.sql.Connection pCon,
java.lang.String pTagValueId,
java.util.List<java.lang.String> pTests,
boolean pOnlyAssoc,
boolean pIsListOfTestIDs)
|
protected void |
removeTagFromTests(java.sql.Connection pCon,
java.lang.String pTagName,
java.lang.String pTagValue,
java.util.List<java.lang.String> pTestNames,
boolean pOnlyAssoc)
|
protected void |
removeTagFromTests(java.sql.Connection pCon,
java.lang.String pTagName,
java.lang.String pTagValue,
java.util.List<java.lang.String> pTests,
boolean pOnlyAssoc,
boolean pIsListOfTestIDs)
|
protected void |
save(java.sql.Connection pCon,
TestDef pObj)
|
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 class oracle.apps.fnd.appltest.diagfwk.engine.provider.dao.db.OADBBaseDAO |
---|
close, close, close, createSysGuid, getCLOB, getConnection, getDBSessionInfo, getJdbcBatchSize, getLangCode, getSysDate, getSysDate, getSysGuid, populateWhoColumns, prepareWhoColumns, queryNlsParameters, querySysDate, querySysDate, returnConnection, rollBack, setFetchSize, setSavepoint, setWhoColumnsForInsert, setWhoColumnsForUpdate |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface oracle.apps.fnd.appltest.diagfwk.engine.provider.dao.BaseDAO |
---|
createSysGuid, getDBSessionInfo, queryNlsParameters, querySysDate, querySysDate |
Field Detail |
---|
public static final java.lang.String SQL_QUERY_DIAG_TEST_DELETE_ALLOWED_FOR_TESTNAME
public static final java.lang.String SQL_QUERY_DIAG_TEST_PARAM_VL_FOR_TESTID
Constructor Detail |
---|
public OADBTestDefDAO()
Method Detail |
---|
public java.lang.String queryFusionAppsVersion()
queryFusionAppsVersion
in interface TestDefDAO
public void save(TestInputSet pObj)
TestDefDAO
save
in interface TestDefDAO
pObj
- test input set to save.public TestInputSetList queryInputSets(java.lang.String pTestName)
TestDefDAO
queryInputSets
in interface TestDefDAO
pTestName
- name of the test
public TestInputSetList queryInputSetsByTestId(java.lang.String pTestId)
TestDefDAO
queryInputSetsByTestId
in interface TestDefDAO
pTestId
- ID of the test
public TestInputSetList queryInputSetsByTestId(java.lang.String pTestId, java.lang.String pDefaultFlag)
TestDefDAO
queryInputSetsByTestId
in interface TestDefDAO
pTestId
- test IDpDefaultFlag
- default flag
public TestInputSetNVList queryInputSetNVList(java.lang.String pInputsetId)
TestDefDAO
queryInputSetNVList
in interface TestDefDAO
pInputsetId
- input set ID
public void saveTagValueAssoc(TagValue pTagValue, java.util.List<java.lang.String> pTestNames)
TestDefDAO
saveTagValueAssoc
in interface TestDefDAO
pTagValue
- tag value to associatepTestNames
- names of the tests to associate with the
tag name and valuepublic boolean delete(TestDef pObj) throws java.sql.SQLException
TestDefDAO
delete
in interface TestDefDAO
pObj
- test definition object to save
java.sql.SQLException
public void save(TestDef pObj)
TestDefDAO
save
in interface TestDefDAO
pObj
- test definition object to savepublic void save(TestDef pObj, java.util.List<TagValue> pAutoSaveTagValues)
TestDefDAO
save
in interface TestDefDAO
pObj
- test definition object to savepAutoSaveTagValues
- list of tag values to save automatically
unresolved tag valuespublic void removeTagAssociationFromTests(java.lang.String pTagName, java.lang.String pTagValue, java.util.List<java.lang.String> pTestNames)
TestDefDAO
removeTagAssociationFromTests
in interface TestDefDAO
pTagName
- name of the tagpTagValue
- value of the tagpTestNames
- list of test names from which to remove association to
the given tag name valueprotected void removeTagFromTests(java.sql.Connection pCon, java.lang.String pTagName, java.lang.String pTagValue, java.util.List<java.lang.String> pTestNames, boolean pOnlyAssoc) throws java.sql.SQLException
java.sql.SQLException
protected void removeTagFromTests(java.sql.Connection pCon, java.lang.String pTagName, java.lang.String pTagValue, java.util.List<java.lang.String> pTests, boolean pOnlyAssoc, boolean pIsListOfTestIDs) throws java.sql.SQLException
java.sql.SQLException
protected void removeTagFromTests(java.sql.Connection pCon, java.lang.String pTagValueId, java.util.List<java.lang.String> pTests, boolean pOnlyAssoc, boolean pIsListOfTestIDs) throws java.sql.SQLException
java.sql.SQLException
protected void save(java.sql.Connection pCon, TestDef pObj) throws java.sql.SQLException
java.sql.SQLException
public TestDef[] queryAllTests()
queryAllTests
in interface TestDefDAO
public TestDef queryTestDefSummaryByName(java.lang.String pTestName)
TestDefDAO
queryTestDefSummaryByName
in interface TestDefDAO
pTestName
- name of the test
public TestDef queryTestDefSummaryById(java.lang.String pId)
TestDefDAO
queryTestDefSummaryById
in interface TestDefDAO
pId
- id of the test
public TestDef queryTestDefById(java.lang.String pId)
queryTestDefById
in interface TestDefDAO
pId
- - i.e. Test ID
public TestParamList queryTestParameters(java.lang.String pId, boolean isInput)
TestDefDAO
queryTestParameters
in interface TestDefDAO
pId
- - ID for the testisInput
- - the parameter type, true for input, false for output
public TagValueList queryActiveTagValues(java.lang.String pTestName)
TestDefDAO
queryActiveTagValues
in interface TestDefDAO
pTestName
- name of the test for which to fetch the
tag values
public TestPrereqList queryActivePrereqTests(java.lang.String pSourceTestName)
TestDefDAO
queryActivePrereqTests
in interface TestDefDAO
pSourceTestName
- name of the test for which to fetch
prerequisites.
public TestDef queryTestDefByName(java.lang.String pName)
queryTestDefByName
in interface TestDefDAO
pName
- - i.e. Test name
public java.lang.String[] queryTestDisplayNames(java.lang.String[] pTestNames)
TestDefDAO
queryTestDisplayNames
in interface TestDefDAO
pTestNames
- input test names for which to fetch
the corresponding display names
public TestDefList queryTestAttributesForTestNames(java.lang.String[] pTestNames)
TestDefDAO
queryTestAttributesForTestNames
in interface TestDefDAO
pTestNames
- names of the test to query
public java.lang.String getInputsetId(java.lang.String pInputsetName, java.lang.String pTestId)
TestDefDAO
getInputsetId
in interface TestDefDAO
pInputsetName
- name of the input setpTestId
- test id for the input set
public java.lang.String getTestId(java.lang.String pTestName)
TestDefDAO
getTestId
in interface TestDefDAO
pTestName
- name of the test
public java.lang.String getTestId(java.sql.Connection pCon, java.lang.String pTestName)
public java.lang.String[] getTestIds(java.lang.String[] pTestNames)
TestDefDAO
getTestIds
in interface TestDefDAO
pTestNames
- the list of test names
public java.util.List<java.lang.String> fetchAllPrereqs(java.lang.String pTestName) throws DiagPrereqCycleException
fetchAllPrereqs
in interface TestDefDAO
pTestName
- Test Name - a String value
DiagPrereqCycleException
- shows cycle found during dependency resolution process.public java.util.List<java.lang.String> fetchAllPrereqs(java.lang.String pTestId, java.util.List<java.lang.String> pTagValueIdList) throws DiagPrereqCycleException
fetchAllPrereqs
in interface TestDefDAO
pTestId
- test idpTagValueIdList
- - 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.
DiagPrereqCycleException
- shows cycle found during dependency resolution process.protected void mergePrereqProcInfoList(java.util.ArrayList<OADBTestDefDAO.PrereqProcessingInfo> pPrereqInfoList, TestPrereqList pTestIdsFromTagVal, java.lang.String pid, int pOrder, OADBTestDefDAO.DepType pDepType, boolean pSetProcessedFlag, OADBTestDefDAO.PrereqProcessingInfo pLastPrereq)
protected void mergePrereqsArrayList(java.util.ArrayList<OADBTestDefDAO.PrereqProcessingInfo> pPrereqInfoList, java.util.ArrayList<OADBTestDefDAO.PrereqProcessingInfo> pPrereqInfoListSec, java.lang.String pid, int pOrder, OADBTestDefDAO.PrereqProcessingInfo pLastPrereq)
public java.util.List<java.lang.String> fetchAllPrereqs(java.lang.String pTestId, java.lang.String pTagValueId, java.util.List<java.lang.String> pTagValueIdList) throws DiagPrereqCycleException
fetchAllPrereqs
in interface TestDefDAO
pTestId
- a test idpTagValueId
- a tag value idpTagValueIdList
- - 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
DiagPrereqCycleException
public TestPrereqList fetchAllTestPrereqs(java.lang.String pTagValueId, java.util.List<java.lang.String> pIncludedTestIds) throws DiagPrereqCycleException
fetchAllTestPrereqs
in interface TestDefDAO
pTagValueId
- - Tag Value IdpIncludedTestIds
- - 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.
DiagPrereqCycleException
- shows cycle found during dependency resolution process.
|
Oracle Fusion Middleware extensions for Logging and Diagnostic 11g Release 1 (11.1.1.6) E22565-06 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |