oracle.apps.fnd.appltest.diagfwk
Class TestBaseDiagfwk

java.lang.Object
  oracle.apps.fnd.appllcm.sdk.common.TestBaseLCM
      oracle.apps.fnd.appltest.diagfwk.TestBaseDiagfwk

Direct Known Subclasses:

ManualTestADRTestRunFacadeAPIs, ManualTestASDFWADRProvider, PSRTestReliabilityTest1, QA_JavaAPI_TestSuite, TestBaseJAXB, UTestAbstractDiagTest, UTestADRProvider, UTestAnnotationConverter, UTestAnnotationConverterExceptions, UTestASDFWADRProvider, UTestCLIDevSecurityProvider, UTestCommon, UTestConnectionInfoProvider, UTestCSFCredentialProvider, UTestCSFCredNegativeTestProvider, UTestDiagCmdExtractReport, UTestDiagCmdGetTestRun, UTestDiagCmdLoadTest, UTestDiagCmdRunTests, UTestDiagCmdRunTestsCancel, UTestDiagCmdRunTestsEx, UTestDiagConfigProvider, UTestDiagContextExtnImpl, UTestDiagnosticsTestFramework, UTestDiagPLSQLStepTests, UTestDiagTestExecutorMXBeanImpl, UTestDiagUtil, UTestExecutorMBeanClientImpl, UTestExecutorMBeanDiscovererImpl, UTestFileBasedDAOFactory, UTestHelpVerb, UTestInputParamContextImpl, UTestNLSBundle, UTestNLSBundle_ar, UTestNLSBundle_de, UTestNLSBundle_es, UTestNLSBundle_fr, UTestNLSBundle_it, UTestNLSBundle_ja, UTestNLSBundle_ko, UTestNLSBundle_nl, UTestNLSBundle_pt_BR, UTestNLSBundle_zh_CN, UTestNLSBundle_zh_TW, UTestOAConnectionProvider, UTestOADBBaseDAO, UTestOADBDAOFactory, UTestOADBTagDAOQuery, UTestOADBTagDAOSave, UTestOADBTagValueIdDAOFetchPrereqs, UTestOADBTestDefDAOFetchPrereqs, UTestOADBTestDefDAOInputSet, UTestOADBTestDefDAOQuery, UTestOADBTestDefDAOSave, UTestOADBTestRunDAOQuery, UTestOADBTestRunDAOSave, UTestOADBTestRunDAOSaveTestRun, UTestOADBTestStats, UTestOANLSProviderImpl, UTestODFURLProvider, UTestOraclePLSQLProvider, UTestPLSQLDiagCmdLoadTest, UTestPLSQLDiagCmdRunTest, UTestPLSQLReportProcessor, UTestProfileProvider, UTestPSRDiagTestExecutorMXBeanImpl, UTestRegisterVerb, UTestReportFactory, UTestReportURLProvider, UTestReportVerb, UTestReportVisitor, UTestRunTestVerb, UTestRuntimeMBeanAdminSrvConnProvider, UTestStandAloneConnectionProvider, UTestStatusVerb, UTestStdInUtil, UTestSysPropAdminSrvConnProvider, UTestTagDefFacade, UTestTagDefFacadeRemoveTag, UTestTagDefFacadeRemoveTagValue, UTestTagImpl, UTestTagValueImpl, UTestTestDefFacade, UTestTestDefFacadeRegister, UTestTestDefImpl, UTestTestDefImplLoadXML, UTestTestDefImplRun, UTestTestDefImplRunSingle, UTestTestDefImplSave, UTestTestExecImpl, UTestTestExtnPathProvider, UTestTestInputSetImpl, UTestTestParamImplLovValidator, UTestTestReportExtnImpl, UTestTestReportGetSetTests, UTestTestReportXMLGenTests, UTestTestRunFacade, UTestTestRunImpl, UTestTestStats, UTestTransformTestReportXML, UTestTransformTestReportXMLEx, UTestURLProvider, UTestURLProviderFactory, UTestXSSecurityProvider

public abstract class TestBaseDiagfwk
extends oracle.apps.fnd.appllcm.sdk.common.TestBaseLCM

Base class for all Diagnostics Framework relate unit tests.

Since:

release specific (what release of product did this appear in)

Version:

$Header: atgpf/appltest/applications/Diagnostics/Engine/test/oracle/apps/fnd/appltest/diagfwk/TestBaseDiagfwk.java /main/46 2010/01/06 15:06:03 ilawler Exp $

Author:

ppradhan

Field Summary

static java.lang.String	SYSPROP_ORACLE_ADR_BASE
static java.lang.String	SYSPROP_ORACLE_ADR_HOME ADR related system properties
static java.lang.String	SYSPROP_ORACLE_ADR_INSTANCE_ID
static java.lang.String	SYSPROP_ORACLE_ADR_PRODUCT_ID
static java.lang.String	SYSPROP_TEST_DIR Test directory where all unit test related artifacts are created when running the tests.

Fields inherited from class oracle.apps.fnd.appllcm.sdk.common.TestBaseLCM

mWorkingDir

Constructor Summary

TestBaseDiagfwk()

Method Summary

protected static void	addSummaryMsg(SummaryInfo pObj, java.lang.String pId, int pNumMsg)
static void	assertCount(java.lang.String pSQL, int pExpectedCount) Utility API for checking the result of a count query against a diagnostic table.
protected void	assertCountActiveInputParams(java.lang.String pTestName, int pCount) Asserts that the number of active input parameters for the given test is the expected count
protected void	assertCountActiveOutputParams(java.lang.String pTestName, int pCount) Asserts that the number of active input parameters for the given test is the expected count
protected void	assertCountActivePrereqs(java.lang.String pTestName, int pCount) Asserts that the number of active prerequisites for the given test is the expected count
protected void	assertCountActiveTagValues(java.lang.String pTestName, int pCount) Asserts that the number of active tag values for the given test is the expected count
protected static void	assertEqualsBobj(java.lang.String pMsg, DiagBObj pExpected, DiagBObj pActual)
protected static void	assertEqualsBobj(java.lang.String pMsg, DiagBObjList<? extends DiagBObj> pExpected, DiagBObjList<? extends DiagBObj> pActual)
protected static void	assertEqualsBobj(java.lang.String pMsg, Tag pExpected, Tag pActual)
protected static void	assertEqualsBobj(java.lang.String pMsg, TagValuePrereq pExpected, TagValuePrereq pActual)
protected static void	assertEqualsBobj(java.lang.String pMsg, TagValue pExpected, TagValue pActual)
protected static void	assertEqualsBobj(java.lang.String pMsg, TestDef pExpected, TestDef pActual)
protected static void	assertEqualsBobj(java.lang.String pMsg, TestExec pExpected, TestExec pActual)
protected static void	assertEqualsBobj(java.lang.String pMsg, TestInputSetNV pExpected, TestInputSetNV pActual)
protected static void	assertEqualsBobj(java.lang.String pMsg, TestInputSet pExpected, TestInputSet pActual)
protected static void	assertEqualsBobj(java.lang.String pMsg, TestRun pExpected, TestRun pActual)
protected static void	assertEqualsBobj(java.lang.String pMsg, TestStats pExpected, TestStats pActual)
static void	assertEqualsListSize(java.lang.String pMsg, java.util.List pExpected, java.util.List pTest) Asserts that the list sizes are equal
protected static void	assertFileContains_s(java.lang.String pFile, java.lang.String pContent) An assert API that checks to make sure that the given file contains the given content
protected static void	assertFileContainsUnderWorkDir(java.lang.String pFileName, java.lang.String pContent) Asserts that the given file under the work dir contains the expected specified contents
protected static void	assertInputSetExists(java.lang.String pInputSetName, java.lang.String pTestId, int pExpectedNameValuesCount)
static void	assertListContents(java.lang.String[] pExpected, java.util.List<java.lang.String> pTarget) Asserts that the list contents are as expected and as specifed in the given array
protected static void	assertNestedExecsForRun(java.lang.String pRunId, int pExpectedNestedExecs)
protected static void	assertNotTagValueAssocInTest(java.lang.String pTagValueId, java.lang.String pTestName) Verifies that the given test doesn't contain any associations to the given tag value id (either in test metadata or in diagnostics repository association table).
protected static void	assertRunExists(java.lang.String pRunName) Asserts that a run with the given name exists in the test repository.
protected static void	assertRunNotExists(java.lang.String pRunName) Asserts that a run with the given name does not exist in the test repository.
protected static void	assertRunNotExistsById(java.lang.String pRunId) Asserts that a run with the given ID does not exist in the test repository.
protected static void	assertSingeTestGotCreated(TestDefList t)
protected static void	assertTagExists(java.lang.String pTagName) Verifies that the tag with the given name exists
protected static void	assertTagIdNotExists(java.lang.String pTagId)
protected void	assertTagValueAssocExists(java.lang.String pTagName, java.lang.String pTagValue, java.util.List<java.lang.String> pTestNames)
protected static void	assertTagValueExists(java.lang.String pTagName, java.lang.String pTagValue)
protected static void	assertTagValueIdNotExists(java.lang.String pTagValueId)
protected static void	assertTestDefExists(java.lang.String pTestName) Asserts that definition for the given test name exists in the test repository
protected static void	assertTestDefExists(java.lang.String pTestName, java.lang.String pTestId) Asserts that definition for the given test name and test id exists in the test repository
protected static void	assertTestDefNotExists(java.lang.String pTestName) Asserts that the definition for the given test name does not exist in the test repository
protected void	assertTestExecExists(java.lang.String pExecId) Asserts that the test execution with the given execution id exists.
protected static void	assertTestExecs(java.lang.String pRootExecId, int pTotal) Asserts that for the given root execution id, there are in fact the total expected number of executions in the tree
protected static void	assertTestMetadataDoesNotReferenceTagValueId(java.lang.String pTestName, java.lang.String pTagValueId)
protected static void	assertTestParamExists(java.lang.String pTestName, java.lang.String pParamName, java.lang.String pParamDisplayName, java.lang.String pParamDescription, java.lang.String pIOFlag) Asserts that a test parameter with the given name, display name, description and io flag exists
protected static void	assertTestParamExists(java.lang.String pTestName, TestParam pParam) Asserts that a test parameter with the given name, display name, description and IO flag as the given TestParam instance exists for the given test name
protected static void	assertTestsGotCreated(TestDefList t, int pExpectedNumTests)
protected static boolean	checkTagExists(java.lang.String pTagName) Checks if the definition for the give tag name already exists
protected static void	cleanPSRConnectionPool() clean the connection pool of the provider
protected static void	clearAdrSystemProperties() Clears ADR related system properties
static java.lang.String	createIncident(java.lang.String pMessageId, java.lang.String pAppName) Creates an incident in the default adr base and in the adr home for the given application and returns the incident ID.
static java.lang.String	createIncident(java.lang.String pAdrBase, java.lang.String pMessageId, java.lang.String pAppName) Creates an incident in the given adr base and in the adr home for the given application and returns the incident ID.
protected static void	createInputSet(java.lang.String pTestName, java.lang.String pInputSetName, java.lang.String[][] pInputNameValues, java.lang.String pDefaultFlag) Creates a test input set for the given test name (test name should already exist) and with the given input values.
protected static void	createPSRConnectionPool(int size) initialize the connection pool of the provider
protected static void	delete(java.lang.String pDir, java.lang.String pFileName) Deletes the given filename under the given dir
static void	deleteDir(java.lang.String pDir) Deletes the files under this directory recursively and attempts to delete this directory as well.
protected static void	deleteFileUnderWorkDir_s(java.lang.String pFileName)
protected static void	deleteFNDMessage(java.lang.String pMessageName) Deletes a fnd message by name
protected static void	deleteInputSet(java.lang.String pInputsetName) API for deleting one or more inputsets by name
static void	deleteModuleId(java.lang.String pModuleId) API for deleting a Module ID from the repository.
protected void	deleteModuleIdByModKeys(java.lang.String pModuleKey) API for deleting a Module ID from the repository.
static void	deleteProfileValue(java.lang.String pName, java.lang.String pLevelName)
static void	deleteProfileValueAtSiteLevel(java.lang.String pName)
static void	deleteRun(java.lang.String pRunName) API deletes a test run by run name
static void	deleteTag(java.lang.String pTagName) API for deleting a tag with the given name from the repository.
static void	deleteTagValue(java.lang.String pTagName, java.lang.String pTagValue) API for deleting a tag with the given name from the repository.
protected static void	deleteTaxModules(java.lang.String[][] pTaxModulesArr) Deletes the given array of taxonomy modules
static void	deleteTestDef(java.lang.String pTestName) API for deleting a test with the given name from the repository.
protected static void	deleteTestExec(java.lang.String pExecutionId)
protected static void	doLoginAsSpecificUser(java.lang.String user, java.lang.String pwd)
protected static TestRun	fetchTestRun(java.lang.String pRunName) Fetches a test run by name
protected static java.sql.Connection	getConnection() Returns a JDBC connection to a test repository
protected static java.lang.String	getDefaultADRBase() Attempts to compute a default ADR base directory
static java.lang.String	getFileContents(java.lang.String pFile) Gets the contents of the given file in the form of a String
protected static java.lang.String	getSysGuid() Returns a GUID
static java.lang.String	getTestPassword()
static java.lang.String	getTestPasswordAsArg()
static java.lang.String	getTestUserName()
static java.lang.String	getTestUserNameAsArg()
static java.lang.String	getWorkDir()
static void	grantAllTagPrivs(java.lang.String tagId)
static void	grantAllTagPrivsByName(java.lang.String tagName)
static void	grantAllTestPrivs(java.lang.String testId)
static void	grantAllTestPrivsByName(java.lang.String testName)
static void	grantTestUpdateAllowed(java.lang.String testId)
protected static void	insertFNDMessage(int pAppId, java.lang.String pMessageName, java.lang.String[] pTokenNames, int pMessageNumber, java.lang.String pModuleId) Adds the given tag value hierarchy
protected static void	insertModuleDelHeirarchy(java.lang.String pSrcModId, java.lang.String pTgtModId) Adds module heirarhcy into fnd_appl_taxonomy_heirarchy table with type 'DELIVERY'.
protected static java.lang.String	insertModuleId() Adds auto-generated row to fnd_appl_taxonomy and fnd_appl_taxonomy_tl when no Module Id is supplied, just for testing purposes
static java.lang.String	insertModuleId(java.lang.String pModuleId, int pAlternativeId) Adds a row to fnd_appl_taxonomy and fnd_appl_taxonomy_tl for the given Module ID for testing purposes
protected static java.lang.String	insertModuleId(java.lang.String pModuleId, int pProductLine, java.lang.String pModuleName, java.lang.String pModuleType, java.lang.String pFileSystemType, java.lang.String pModuleKey, int pAlternativeId) Inserts a Module ID into Taxonomy tables
protected static java.lang.String	insertModuleId(java.lang.String pModuleId, int pProductLine, java.lang.String pModuleName, java.lang.String pModuleType, java.lang.String pModuleKey, java.lang.String pProdCode, java.lang.String pFileSystemType, int pAlternativeId) Inserts a Module ID into Taxonomy tables
protected static java.lang.String	insertModuleId(java.lang.String pModuleId, java.lang.String pModuleKey, int pAlternativeId) Adds a row to taxonomy tables with given module id and module key
protected static java.lang.String	insertModuleId(java.lang.String pModuleId, java.lang.String pModuleKey, java.lang.String pProductCode, int pAlternativeId) Adds a row to taxonomy tables with given module id, module key and product code
static java.lang.String	insertTag(java.lang.String pTagName, java.lang.String pModuleId) Adds a row to fnd_diag_tag and fnd_diag_tag_tl for the given tag name for testing purposes
static java.lang.String	insertTag(java.lang.String pTagName, java.lang.String pModuleId, java.lang.String pOwnerUserGuid) Adds a row to fnd_diag_tag and fnd_diag_tag_tl for the given tag name for testing purposes
protected static java.lang.String	insertTagValue(java.lang.String pTagName, java.lang.String pTagValue) Adds a row to fnd_diag_tag_value and fnd_diag_tag_value_tl for the given tag name for testing purposes
static java.lang.String	insertTagValue(java.lang.String pTagValueId, java.lang.String pTagName, java.lang.String pTagValue)
static java.lang.String	insertTagValue(java.lang.String pTagValueId, java.lang.String pTagName, java.lang.String pTagValue, java.lang.String pOwnerUserGuid) Inserts a tag value ID for the given tag name and tag value with a preset tag value id
protected static void	insertTagValueHeirarchy(java.lang.String pParentTagValueId, java.lang.String pChildTagValueId) Adds the given tag value hierarchy
protected static void	insertTagValuePrereq(java.lang.String pSourceTagValueId, java.lang.String pPrereqTagValueId) Inserts a tag value ID for the given tag name and tag value with a preset tag value id
protected static void	insertTagValuePrereq(java.lang.String pSourceTagValueId, java.lang.String pPrereqTagValueId, int pOrder) Adds the given tag value hierarchy
protected static java.lang.String	insertTagValueWithParent(java.lang.String pTagValueId, java.lang.String pTagName, java.lang.String pTagValue, java.lang.String pParentTagValueId) Inserts a tag value ID for the given tag name and tag value with a preset tag value id.
protected static void	loadTaxModuleHeirarchy(java.lang.String[][] pTaxHeirArr, java.lang.String[][] pTaxModulesArr) Loads the given array of taxonomy module heirarchy relationships
protected static void	loadTaxModules(java.lang.String[][] pTaxModulesArr) Loads the given array of taxonomy modules
static void	loadTests(java.lang.String[] pTestMetadataFilePaths) API to load an array of tests.
static void	loadTests(java.lang.String pWorkDir, java.lang.String[][] pTestDefArr) API to load an array of tests.
static void	loginAsAdmin()
static void	loginAsAdvancedUser()
static void	loginAsAnonymous()
static void	loginAsDefault()
static void	loginAsRegularUser()
static void	loginAsViewer()
protected static java.lang.String	lookupModuleIdForKey(java.lang.String pModuleKey, java.lang.String[][] pTaxModuleArr) Looks up the module id for the given module key from the given array of taxonomy modules.
protected static DescriptiveHeader	makeDescriptiveHeader(java.lang.String pId)
protected static ErrorInfo	makeErrorInfo(java.lang.String pErrorId)
protected static FixInfo	makeFixInfo(java.lang.String pId, int pNumMsg)
protected static Header	makeHeader(java.lang.String pId)
protected static Message	makeMessage(java.lang.String pMsgId)
protected static Message	makeMessageLinkExternal(java.lang.String pMsgId)
protected static Message	makeMessageLinkInternal(java.lang.String pMsgId)
protected static MsgList	makeMsgList(int pSize)
protected static NameValue	makeNameValue(java.lang.String pName, java.lang.String pValue)
protected static Section	makeSection(java.lang.String pSectionId)
protected static StepReportExtn	makeStepReportExtn(java.lang.String pId, int pInputs, int pOutputs)
protected static SummaryInfo	makeSummaryInfo(java.lang.String pId, int pNumMsg)
protected static Table	makeTable(java.lang.String pId, int pNumCols, int pNumRows)
protected static TestReportExtn	makeTestReportExtn(java.lang.String pId)
protected void	removeCycleSrcIdPrereqId(java.lang.String pSrcTagValId, java.lang.String pPrereqId) API for deleting a source tag value id - prereq tag value id pair.
protected static void	returnConnection(java.sql.Connection lCon) Returns previously borrowed connection back to the provider
static TestRun	runTest(java.lang.String pTestName, java.lang.String pRunName, boolean pWaitForCompletion, int pMonInterval, java.lang.Object[][] pParams) API to run a single test with the given input parameter values
static TestRun	runTests(java.lang.String[] pTestNames, java.lang.String pRunName) API to run a given list of tests in a single run.
static TestRun	runTests(java.lang.String[] pTestNames, java.lang.String pRunName, boolean pWaitForCompletion, int pMonInterval, java.util.Hashtable<java.lang.String,NameValueList> pParams) API to run a given list of tests in a single run.
static void	saveProfileValue(java.lang.String pName, java.lang.String pValue, java.lang.String pLevelName)
static void	saveProfileValueAtSiteLevel(java.lang.String pName, java.lang.String pValue)
protected static void	setAdrSystemProperties(java.lang.String pAdrBase, java.lang.String pAppName) Sets up ADR related system properties
static void	setTestPassword(java.lang.String pwd)
static void	setTestUserName(java.lang.String user)
void	setUpBaseDiag() Setup test directory prior to running the tests.
static void	setUpBaseDiagClass()
void	tearDownBaseDiag()
static void	tearDownBaseDiagClass()
static java.util.List	toList(java.lang.Object[] arr) An utility API to create an ArrayList from an object array
protected static void	verifyExtractedReportsExist(java.lang.String pMsg, TestExec pExec, java.lang.String pFormat, java.lang.String pDestDir) Verifies that the report for the given execution along with reports for all the nested executions exists.
protected static void	verifyExtractedReportsExist(java.lang.String pMsg, TestExec pExec, java.lang.String pFormat, java.lang.String pDestDir, java.lang.String pSubDir) Verifies that the report for the given execution along with reports for all the nested executions exists.
protected static void	verifyExtractedReportsExist(java.lang.String pMsg, TestRun pRun, java.lang.String pFormat, java.lang.String pDestDir) Verifies that the run report for the given run along with reports for all the nested executions exist
protected static void	verifyExtractedReportsExist(java.lang.String pMsg, TestRun pRun, java.lang.String pFormat, java.lang.String pDestDir, boolean pCheckChildren) Verifies that the run report for the given run along with reports for all the nested executions exist
static void	verifyFileExists(java.lang.String pMsg, java.lang.String pExpectedFilePath) Verifies that the given file path exists and the file is not empty.
protected static void	verifyTestRun(TestRun pRun, int pExpectedTopLevelExecs, int pExpectedNestedExecs, java.lang.String pExpectedStatus) Verifies the given TestRun (result of the run command).
static java.lang.String	writeFile(java.lang.String pContents, java.lang.String pFile) Writes file directly under the working directory as indicated by a system property
static java.lang.String	writeFile(java.lang.String pDir, java.lang.String pContents, java.lang.String pFileName) Writes a file with the given name and contents under the given directory.

Methods inherited from class oracle.apps.fnd.appllcm.sdk.common.TestBaseLCM

assertFileContains, deleteFilesUnderDir, deleteFilesUnderDir, deleteFileUnderDir, deleteFileUnderWorkDir, getWorkingDir, setUpBase, setWorkingDir, tearDownBase, writeFileUnderDir, writeFileUnderWorkDir

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

SYSPROP_TEST_DIR

public static final java.lang.String SYSPROP_TEST_DIR

Test directory where all unit test related artifacts are created when running the tests.

See Also:

Constant Field Values

SYSPROP_ORACLE_ADR_HOME

public static final java.lang.String SYSPROP_ORACLE_ADR_HOME

ADR related system properties

See Also:

Constant Field Values

SYSPROP_ORACLE_ADR_BASE

public static final java.lang.String SYSPROP_ORACLE_ADR_BASE

See Also:

Constant Field Values

SYSPROP_ORACLE_ADR_PRODUCT_ID

public static final java.lang.String SYSPROP_ORACLE_ADR_PRODUCT_ID

See Also:

Constant Field Values

SYSPROP_ORACLE_ADR_INSTANCE_ID

public static final java.lang.String SYSPROP_ORACLE_ADR_INSTANCE_ID

See Also:

Constant Field Values

Constructor Detail

TestBaseDiagfwk

public TestBaseDiagfwk()

Method Detail

setUpBaseDiagClass

public static void setUpBaseDiagClass()
                               throws java.lang.Exception

Throws:

java.lang.Exception

doLoginAsSpecificUser

protected static void doLoginAsSpecificUser(java.lang.String user,
                                            java.lang.String pwd)

loginAsAdmin

public static void loginAsAdmin()

loginAsAdvancedUser

public static void loginAsAdvancedUser()

loginAsRegularUser

public static void loginAsRegularUser()

loginAsViewer

public static void loginAsViewer()

loginAsDefault

public static void loginAsDefault()

loginAsAnonymous

public static void loginAsAnonymous()

setUpBaseDiag

public void setUpBaseDiag()
                   throws java.lang.Exception

Setup test directory prior to running the tests.

Throws:

java.lang.Exception

tearDownBaseDiag

public void tearDownBaseDiag()

tearDownBaseDiagClass

public static void tearDownBaseDiagClass()

grantTestUpdateAllowed

public static void grantTestUpdateAllowed(java.lang.String testId)

grantAllTestPrivs

public static void grantAllTestPrivs(java.lang.String testId)

grantAllTestPrivsByName

public static void grantAllTestPrivsByName(java.lang.String testName)

grantAllTagPrivs

public static void grantAllTagPrivs(java.lang.String tagId)

grantAllTagPrivsByName

public static void grantAllTagPrivsByName(java.lang.String tagName)

setTestUserName

public static void setTestUserName(java.lang.String user)

getTestUserName

public static java.lang.String getTestUserName()

getTestUserNameAsArg

public static java.lang.String getTestUserNameAsArg()

setTestPassword

public static void setTestPassword(java.lang.String pwd)

getTestPassword

public static java.lang.String getTestPassword()

getTestPasswordAsArg

public static java.lang.String getTestPasswordAsArg()

toList

public static java.util.List toList(java.lang.Object[] arr)

An utility API to create an ArrayList from an object array

getWorkDir

public static java.lang.String getWorkDir()

assertFileContainsUnderWorkDir

protected static void assertFileContainsUnderWorkDir(java.lang.String pFileName,
                                                     java.lang.String pContent)

Asserts that the given file under the work dir contains the expected specified contents

Parameters:

pFileName - name of the file

pContent - expected contents of the file

deleteFileUnderWorkDir_s

protected static void deleteFileUnderWorkDir_s(java.lang.String pFileName)

deleteDir

public static void deleteDir(java.lang.String pDir)

Deletes the files under this directory recursively and attempts to delete this directory as well.

Parameters:

pDir - directory to delete.

delete

protected static void delete(java.lang.String pDir,
                             java.lang.String pFileName)

Deletes the given filename under the given dir

getFileContents

public static java.lang.String getFileContents(java.lang.String pFile)

Gets the contents of the given file in the form of a String

assertFileContains_s

protected static void assertFileContains_s(java.lang.String pFile,
                                           java.lang.String pContent)

An assert API that checks to make sure that the given file contains the given content

writeFile

public static java.lang.String writeFile(java.lang.String pDir,
                                         java.lang.String pContents,
                                         java.lang.String pFileName)

Writes a file with the given name and contents under the given directory.

Parameters:

pDir -

pContents -

pFileName -

writeFile

public static java.lang.String writeFile(java.lang.String pContents,
                                         java.lang.String pFile)

Writes file directly under the working directory as indicated by a system property

assertListContents

public static void assertListContents(java.lang.String[] pExpected,
                                      java.util.List<java.lang.String> pTarget)

Asserts that the list contents are as expected and as specifed in the given array

assertEqualsListSize

public static void assertEqualsListSize(java.lang.String pMsg,
                                        java.util.List pExpected,
                                        java.util.List pTest)

Asserts that the list sizes are equal

getConnection

protected static java.sql.Connection getConnection()

Returns a JDBC connection to a test repository

Returns:

a JDBC connection to a test repository

returnConnection

protected static void returnConnection(java.sql.Connection lCon)

Returns previously borrowed connection back to the provider

Parameters:

lCon - Connection to be returned

cleanPSRConnectionPool

protected static void cleanPSRConnectionPool()

clean the connection pool of the provider

createPSRConnectionPool

protected static void createPSRConnectionPool(int size)

initialize the connection pool of the provider

deleteTestDef

public static void deleteTestDef(java.lang.String pTestName)

API for deleting a test with the given name from the repository. This API can mainly be used for cleanup purposes in order to cleanup the tables after running a test.

Parameters:

pTestName - name of the test to delete.

deleteInputSet

protected static void deleteInputSet(java.lang.String pInputsetName)

API for deleting one or more inputsets by name

Parameters:

pInputsetName - name of the input set

deleteTag

public static void deleteTag(java.lang.String pTagName)

API for deleting a tag with the given name from the repository. This API can mainly be used for cleanup purposes in order to cleanup the tables after running a test.

Parameters:

pTagName - name of the tag to delete.

deleteTagValue

public static void deleteTagValue(java.lang.String pTagName,
                                  java.lang.String pTagValue)

API for deleting a tag with the given name from the repository. This API can mainly be used for cleanup purposes in order to cleanup the tables after running a test.

Parameters:

pTagName - name of the tag to delete.

deleteTestExec

protected static void deleteTestExec(java.lang.String pExecutionId)

deleteRun

public static void deleteRun(java.lang.String pRunName)

API deletes a test run by run name

deleteModuleId

public static void deleteModuleId(java.lang.String pModuleId)

API for deleting a Module ID from the repository. This API can mainly be used for cleanup purposes in order to cleanup the tables after running a test.

Parameters:

pModuleId - is the Module ID to delete.

deleteModuleIdByModKeys

protected void deleteModuleIdByModKeys(java.lang.String pModuleKey)

API for deleting a Module ID from the repository. This API can mainly be used for cleanup purposes in order to cleanup the tables after running a test.

Parameters:

pModuleKeys - is the Module ID to delete.

deleteFNDMessage

protected static void deleteFNDMessage(java.lang.String pMessageName)

Deletes a fnd message by name

Parameters:

pMessageName - - Message name

checkTagExists

protected static boolean checkTagExists(java.lang.String pTagName)

Checks if the definition for the give tag name already exists

insertTag

public static java.lang.String insertTag(java.lang.String pTagName,
                                         java.lang.String pModuleId)

Adds a row to fnd_diag_tag and fnd_diag_tag_tl for the given tag name for testing purposes

Parameters:

pTagName - name of the tag

Returns:

the tag ID GUID

insertTag

public static java.lang.String insertTag(java.lang.String pTagName,
                                         java.lang.String pModuleId,
                                         java.lang.String pOwnerUserGuid)

Adds a row to fnd_diag_tag and fnd_diag_tag_tl for the given tag name for testing purposes

Parameters:

pTagName - name of the tag

pModuleId - module id for the module that owns the tag

pOwnerUserGuid - user GUID for the user that creates the tag. If null defaults to "0"

Returns:

the tag ID GUID

insertTagValue

public static java.lang.String insertTagValue(java.lang.String pTagValueId,
                                              java.lang.String pTagName,
                                              java.lang.String pTagValue)

insertTagValue

public static java.lang.String insertTagValue(java.lang.String pTagValueId,
                                              java.lang.String pTagName,
                                              java.lang.String pTagValue,
                                              java.lang.String pOwnerUserGuid)

Inserts a tag value ID for the given tag name and tag value with a preset tag value id

Parameters:

pTagValueId -

pTagName -

pTagValue -

Returns:

insertTagValueWithParent

protected static java.lang.String insertTagValueWithParent(java.lang.String pTagValueId,
                                                           java.lang.String pTagName,
                                                           java.lang.String pTagValue,
                                                           java.lang.String pParentTagValueId)

Inserts a tag value ID for the given tag name and tag value with a preset tag value id.

Parameters:

pTagValueId -

pTagName -

pTagValue -

pParentTagValueId -

Returns:

insertTagValuePrereq

protected static void insertTagValuePrereq(java.lang.String pSourceTagValueId,
                                           java.lang.String pPrereqTagValueId)

Inserts a tag value ID for the given tag name and tag value with a preset tag value id

insertTagValue

protected static java.lang.String insertTagValue(java.lang.String pTagName,
                                                 java.lang.String pTagValue)

Adds a row to fnd_diag_tag_value and fnd_diag_tag_value_tl for the given tag name for testing purposes

Parameters:

pTagName - name of the tag

pTagValue - name of the tag value

Returns:

the tag value ID GUID

insertModuleId

protected static java.lang.String insertModuleId(java.lang.String pModuleId,
                                                 int pProductLine,
                                                 java.lang.String pModuleName,
                                                 java.lang.String pModuleType,
                                                 java.lang.String pFileSystemType,
                                                 java.lang.String pModuleKey,
                                                 int pAlternativeId)

Inserts a Module ID into Taxonomy tables

Parameters:

pModuleId -

pProductLine -

pModuleName -

pModuleType -

pFileSystemType -

Returns:

a Module ID GUID

insertModuleId

protected static java.lang.String insertModuleId(java.lang.String pModuleId,
                                                 int pProductLine,
                                                 java.lang.String pModuleName,
                                                 java.lang.String pModuleType,
                                                 java.lang.String pModuleKey,
                                                 java.lang.String pProdCode,
                                                 java.lang.String pFileSystemType,
                                                 int pAlternativeId)

Inserts a Module ID into Taxonomy tables

Parameters:

pModuleId -

pProductLine -

pModuleName -

pModuleType -

pFileSystemType -

pModuleKey -

pProdCode -

Returns:

a Module ID GUID

insertModuleId

public static java.lang.String insertModuleId(java.lang.String pModuleId,
                                              int pAlternativeId)

Adds a row to fnd_appl_taxonomy and fnd_appl_taxonomy_tl for the given Module ID for testing purposes

Parameters:

pModuleId - Taxonomy Module ID

Returns:

Module ID GUID

insertModuleId

protected static java.lang.String insertModuleId(java.lang.String pModuleId,
                                                 java.lang.String pModuleKey,
                                                 int pAlternativeId)

Adds a row to taxonomy tables with given module id and module key

insertModuleId

protected static java.lang.String insertModuleId(java.lang.String pModuleId,
                                                 java.lang.String pModuleKey,
                                                 java.lang.String pProductCode,
                                                 int pAlternativeId)

Adds a row to taxonomy tables with given module id, module key and product code

insertModuleId

protected static java.lang.String insertModuleId()

Adds auto-generated row to fnd_appl_taxonomy and fnd_appl_taxonomy_tl when no Module Id is supplied, just for testing purposes

Returns:

Module ID GUID

insertModuleDelHeirarchy

protected static void insertModuleDelHeirarchy(java.lang.String pSrcModId,
                                               java.lang.String pTgtModId)

Adds module heirarhcy into fnd_appl_taxonomy_heirarchy table with type 'DELIVERY'.

insertTagValueHeirarchy

protected static void insertTagValueHeirarchy(java.lang.String pParentTagValueId,
                                              java.lang.String pChildTagValueId)

Adds the given tag value hierarchy

insertTagValuePrereq

protected static void insertTagValuePrereq(java.lang.String pSourceTagValueId,
                                           java.lang.String pPrereqTagValueId,
                                           int pOrder)

Adds the given tag value hierarchy

removeCycleSrcIdPrereqId

protected void removeCycleSrcIdPrereqId(java.lang.String pSrcTagValId,
                                        java.lang.String pPrereqId)

API for deleting a source tag value id - prereq tag value id pair. This API can mainly be used for cleanup purposes

getSysGuid

protected static java.lang.String getSysGuid()

Returns a GUID

Returns:

a system guid.

assertTestExecs

protected static void assertTestExecs(java.lang.String pRootExecId,
                                      int pTotal)

Asserts that for the given root execution id, there are in fact the total expected number of executions in the tree

Parameters:

pRootExecId - root execution id

pTotal - total number of executions in the tree

assertTestDefExists

protected static void assertTestDefExists(java.lang.String pTestName)

Asserts that definition for the given test name exists in the test repository

Parameters:

pTestName - name of the test

assertInputSetExists

protected static void assertInputSetExists(java.lang.String pInputSetName,
                                           java.lang.String pTestId,
                                           int pExpectedNameValuesCount)

assertTestDefExists

protected static void assertTestDefExists(java.lang.String pTestName,
                                          java.lang.String pTestId)

Asserts that definition for the given test name and test id exists in the test repository

Parameters:

pTestName - name of the test

pTestId - ID of the test

assertRunExists

protected static void assertRunExists(java.lang.String pRunName)

Asserts that a run with the given name exists in the test repository.

Parameters:

pRunName - name of the run to check

assertRunNotExists

protected static void assertRunNotExists(java.lang.String pRunName)

Asserts that a run with the given name does not exist in the test repository.

Parameters:

pRunName - name of the run to check

assertNotTagValueAssocInTest

protected static void assertNotTagValueAssocInTest(java.lang.String pTagValueId,
                                                   java.lang.String pTestName)

Verifies that the given test doesn't contain any associations to the given tag value id (either in test metadata or in diagnostics repository association table).

assertRunNotExistsById

protected static void assertRunNotExistsById(java.lang.String pRunId)

Asserts that a run with the given ID does not exist in the test repository.

Parameters:

pRunId - ID of the run to check

assertTestDefNotExists

protected static void assertTestDefNotExists(java.lang.String pTestName)

Asserts that the definition for the given test name does not exist in the test repository

Parameters:

pTestName - name of test.

assertTagExists

protected static void assertTagExists(java.lang.String pTagName)

Verifies that the tag with the given name exists

assertTagValueExists

protected static void assertTagValueExists(java.lang.String pTagName,
                                           java.lang.String pTagValue)

assertTagValueIdNotExists

protected static void assertTagValueIdNotExists(java.lang.String pTagValueId)

assertTagIdNotExists

protected static void assertTagIdNotExists(java.lang.String pTagId)

assertTestMetadataDoesNotReferenceTagValueId

protected static void assertTestMetadataDoesNotReferenceTagValueId(java.lang.String pTestName,
                                                                   java.lang.String pTagValueId)

assertTagValueAssocExists

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

assertCountActiveInputParams

protected void assertCountActiveInputParams(java.lang.String pTestName,
                                            int pCount)

Asserts that the number of active input parameters for the given test is the expected count

Parameters:

pTestName - name of the test

pCount - expected count

assertTestParamExists

protected static void assertTestParamExists(java.lang.String pTestName,
                                            TestParam pParam)

Asserts that a test parameter with the given name, display name, description and IO flag as the given TestParam instance exists for the given test name

assertTestParamExists

protected static void assertTestParamExists(java.lang.String pTestName,
                                            java.lang.String pParamName,
                                            java.lang.String pParamDisplayName,
                                            java.lang.String pParamDescription,
                                            java.lang.String pIOFlag)

Asserts that a test parameter with the given name, display name, description and io flag exists

assertCountActiveOutputParams

protected void assertCountActiveOutputParams(java.lang.String pTestName,
                                             int pCount)

Asserts that the number of active input parameters for the given test is the expected count

Parameters:

pTestName - name of the test

pCount - expected count

assertCountActivePrereqs

protected void assertCountActivePrereqs(java.lang.String pTestName,
                                        int pCount)

Asserts that the number of active prerequisites for the given test is the expected count

Parameters:

pTestName - name of the test

pCount - expected count

assertCountActiveTagValues

protected void assertCountActiveTagValues(java.lang.String pTestName,
                                          int pCount)

Asserts that the number of active tag values for the given test is the expected count

Parameters:

pTestName - name of the test

pCount - expected count

assertTestExecExists

protected void assertTestExecExists(java.lang.String pExecId)

Asserts that the test execution with the given execution id exists.

Parameters:

pExecId - execution id

assertNestedExecsForRun

protected static void assertNestedExecsForRun(java.lang.String pRunId,
                                              int pExpectedNestedExecs)

assertCount

public static void assertCount(java.lang.String pSQL,
                               int pExpectedCount)

Utility API for checking the result of a count query against a diagnostic table. This API can be used to validate results of certain unit tests that may insert rows into diagnostics tables.

Parameters:

pSQL - A "Select count(*) ..." type SQL query string

pExpectedCount - expected result from the count query.

assertSingeTestGotCreated

protected static void assertSingeTestGotCreated(TestDefList t)

assertTestsGotCreated

protected static void assertTestsGotCreated(TestDefList t,
                                            int pExpectedNumTests)

loadTests

public static void loadTests(java.lang.String pWorkDir,
                             java.lang.String[][] pTestDefArr)

API to load an array of tests.

loadTests

public static void loadTests(java.lang.String[] pTestMetadataFilePaths)

API to load an array of tests.

runTests

public static TestRun runTests(java.lang.String[] pTestNames,
                               java.lang.String pRunName)

API to run a given list of tests in a single run. Assumes that the tests are already registered.

runTest

public static TestRun runTest(java.lang.String pTestName,
                              java.lang.String pRunName,
                              boolean pWaitForCompletion,
                              int pMonInterval,
                              java.lang.Object[][] pParams)

API to run a single test with the given input parameter values

runTests

public static TestRun runTests(java.lang.String[] pTestNames,
                               java.lang.String pRunName,
                               boolean pWaitForCompletion,
                               int pMonInterval,
                               java.util.Hashtable<java.lang.String,NameValueList> pParams)

API to run a given list of tests in a single run. Assumes that the tests are already registered.

loadTaxModules

protected static void loadTaxModules(java.lang.String[][] pTaxModulesArr)

Loads the given array of taxonomy modules

deleteTaxModules

protected static void deleteTaxModules(java.lang.String[][] pTaxModulesArr)

Deletes the given array of taxonomy modules

loadTaxModuleHeirarchy

protected static void loadTaxModuleHeirarchy(java.lang.String[][] pTaxHeirArr,
                                             java.lang.String[][] pTaxModulesArr)

Loads the given array of taxonomy module heirarchy relationships

lookupModuleIdForKey

protected static java.lang.String lookupModuleIdForKey(java.lang.String pModuleKey,
                                                       java.lang.String[][] pTaxModuleArr)

Looks up the module id for the given module key from the given array of taxonomy modules.

Parameters:

pModuleKey - module key to lookup

Returns:

module id

verifyTestRun

protected static void verifyTestRun(TestRun pRun,
                                    int pExpectedTopLevelExecs,
                                    int pExpectedNestedExecs,
                                    java.lang.String pExpectedStatus)

Verifies the given TestRun (result of the run command). Checks the expected number of executions in the run and also the expected status of the run.

fetchTestRun

protected static TestRun fetchTestRun(java.lang.String pRunName)

Fetches a test run by name

Parameters:

pRunName - name of the test run

Returns:

a populated TestRun object instance for the given run.

verifyFileExists

public static void verifyFileExists(java.lang.String pMsg,
                                    java.lang.String pExpectedFilePath)

Verifies that the given file path exists and the file is not empty.

Parameters:

pMsg - message for the test

pExpectedFilePath - expected file path

verifyExtractedReportsExist

protected static void verifyExtractedReportsExist(java.lang.String pMsg,
                                                  TestRun pRun,
                                                  java.lang.String pFormat,
                                                  java.lang.String pDestDir)

Verifies that the run report for the given run along with reports for all the nested executions exist

Parameters:

pRun - run for which to verify reports are extracted

pFormat - the expected format for the report.

verifyExtractedReportsExist

protected static void verifyExtractedReportsExist(java.lang.String pMsg,
                                                  TestRun pRun,
                                                  java.lang.String pFormat,
                                                  java.lang.String pDestDir,
                                                  boolean pCheckChildren)

Verifies that the run report for the given run along with reports for all the nested executions exist

Parameters:

pRun - run for which to verify reports are extracted

pFormat - the expected format for the report.

verifyExtractedReportsExist

protected static void verifyExtractedReportsExist(java.lang.String pMsg,
                                                  TestExec pExec,
                                                  java.lang.String pFormat,
                                                  java.lang.String pDestDir)

Verifies that the report for the given execution along with reports for all the nested executions exists.

Parameters:

pExec - execution for which to verify reports are extracted

pFormat - the expected format for the report.

verifyExtractedReportsExist

protected static void verifyExtractedReportsExist(java.lang.String pMsg,
                                                  TestExec pExec,
                                                  java.lang.String pFormat,
                                                  java.lang.String pDestDir,
                                                  java.lang.String pSubDir)

Verifies that the report for the given execution along with reports for all the nested executions exists.

Parameters:

pExec - execution for which to verify reports are extracted

pFormat - the expected format for the report.

pSubDir - if not null, uses this as the expected subdirectory. If null, uses the execution's run id as the expected subdirectory for this execution. Otherwise expects the sub directory to be the execution id.

createInputSet

protected static void createInputSet(java.lang.String pTestName,
                                     java.lang.String pInputSetName,
                                     java.lang.String[][] pInputNameValues,
                                     java.lang.String pDefaultFlag)

Creates a test input set for the given test name (test name should already exist) and with the given input values.

Parameters:

pTestName -

pInputSetName -

pInputNameValues -

pDefaultFlag -

insertFNDMessage

protected static void insertFNDMessage(int pAppId,
                                       java.lang.String pMessageName,
                                       java.lang.String[] pTokenNames,
                                       int pMessageNumber,
                                       java.lang.String pModuleId)

Adds the given tag value hierarchy

assertEqualsBobj

protected static void assertEqualsBobj(java.lang.String pMsg,
                                       TestInputSet pExpected,
                                       TestInputSet pActual)

assertEqualsBobj

protected static void assertEqualsBobj(java.lang.String pMsg,
                                       TestInputSetNV pExpected,
                                       TestInputSetNV pActual)

assertEqualsBobj

protected static void assertEqualsBobj(java.lang.String pMsg,
                                       Tag pExpected,
                                       Tag pActual)

assertEqualsBobj

protected static void assertEqualsBobj(java.lang.String pMsg,
                                       TestDef pExpected,
                                       TestDef pActual)

assertEqualsBobj

protected static void assertEqualsBobj(java.lang.String pMsg,
                                       TagValuePrereq pExpected,
                                       TagValuePrereq pActual)

assertEqualsBobj

protected static void assertEqualsBobj(java.lang.String pMsg,
                                       DiagBObjList<? extends DiagBObj> pExpected,
                                       DiagBObjList<? extends DiagBObj> pActual)

assertEqualsBobj

protected static void assertEqualsBobj(java.lang.String pMsg,
                                       DiagBObj pExpected,
                                       DiagBObj pActual)

assertEqualsBobj

protected static void assertEqualsBobj(java.lang.String pMsg,
                                       TagValue pExpected,
                                       TagValue pActual)

assertEqualsBobj

protected static void assertEqualsBobj(java.lang.String pMsg,
                                       TestRun pExpected,
                                       TestRun pActual)

assertEqualsBobj

protected static void assertEqualsBobj(java.lang.String pMsg,
                                       TestStats pExpected,
                                       TestStats pActual)

assertEqualsBobj

protected static void assertEqualsBobj(java.lang.String pMsg,
                                       TestExec pExpected,
                                       TestExec pActual)

makeNameValue

protected static NameValue makeNameValue(java.lang.String pName,
                                         java.lang.String pValue)

makeStepReportExtn

protected static StepReportExtn makeStepReportExtn(java.lang.String pId,
                                                   int pInputs,
                                                   int pOutputs)

makeTestReportExtn

protected static TestReportExtn makeTestReportExtn(java.lang.String pId)

makeMsgList

protected static MsgList makeMsgList(int pSize)

makeErrorInfo

protected static ErrorInfo makeErrorInfo(java.lang.String pErrorId)

makeFixInfo

protected static FixInfo makeFixInfo(java.lang.String pId,
                                     int pNumMsg)

makeHeader

protected static Header makeHeader(java.lang.String pId)

makeMessage

protected static Message makeMessage(java.lang.String pMsgId)

makeMessageLinkInternal

protected static Message makeMessageLinkInternal(java.lang.String pMsgId)

makeMessageLinkExternal

protected static Message makeMessageLinkExternal(java.lang.String pMsgId)

makeSection

protected static Section makeSection(java.lang.String pSectionId)

makeDescriptiveHeader

protected static DescriptiveHeader makeDescriptiveHeader(java.lang.String pId)

makeSummaryInfo

protected static SummaryInfo makeSummaryInfo(java.lang.String pId,
                                             int pNumMsg)

addSummaryMsg

protected static void addSummaryMsg(SummaryInfo pObj,
                                    java.lang.String pId,
                                    int pNumMsg)

makeTable

protected static Table makeTable(java.lang.String pId,
                                 int pNumCols,
                                 int pNumRows)

saveProfileValueAtSiteLevel

public static void saveProfileValueAtSiteLevel(java.lang.String pName,
                                               java.lang.String pValue)

saveProfileValue

public static void saveProfileValue(java.lang.String pName,
                                    java.lang.String pValue,
                                    java.lang.String pLevelName)

deleteProfileValueAtSiteLevel

public static void deleteProfileValueAtSiteLevel(java.lang.String pName)

deleteProfileValue

public static void deleteProfileValue(java.lang.String pName,
                                      java.lang.String pLevelName)

createIncident

public static java.lang.String createIncident(java.lang.String pMessageId,
                                              java.lang.String pAppName)

Creates an incident in the default adr base and in the adr home for the given application and returns the incident ID.

createIncident

public static java.lang.String createIncident(java.lang.String pAdrBase,
                                              java.lang.String pMessageId,
                                              java.lang.String pAppName)

Creates an incident in the given adr base and in the adr home for the given application and returns the incident ID. Attempts to create the incident under ADR home with the given app name e.g. "diag/ofm/fusionapps/"

Parameters:

pAdrBase -

pAdrHome -

pMessageId -

pAppName -

Returns:

incident id

clearAdrSystemProperties

protected static void clearAdrSystemProperties()

Clears ADR related system properties

setAdrSystemProperties

protected static void setAdrSystemProperties(java.lang.String pAdrBase,
                                             java.lang.String pAppName)

Sets up ADR related system properties

getDefaultADRBase

protected static java.lang.String getDefaultADRBase()

Attempts to compute a default ADR base directory

Returns: