Extend this class to create a regression test when .data files are used to load data into tables. More...

Inheritance diagram for SQLDataRegression:

[legend]

Collaboration diagram for SQLDataRegression:

[legend]

Public Member Functions
_.Library.Status	OnBeforeEachTest ()
	Method to clean up before each Test method is executed.

_.Library.Status	reloadDATA ()
	Method that handles the reloading of data from the <parameter>DATAFILE</parameter> for each Test method in <class>SQLRegression</class>

Public Member Functions inherited from SQLRegression
_.Library.Status	OnAfterEachTest ()
	Method to clean up after each Test method is executed.

_.Library.Status	OnAfterSqlFile (_.Library.String sqlfile)
	Method available to do any work after a Sql File has finished execution.

_.Library.Status	OnBeforeSqlFile (_.Library.String sqlfile)
	Method available to do any work before a Sql File begins execution.

	TestDynamic ()
	Test each line of SQL from <parameter>SQLFILE</parameter> using dynamic SQL. More...

	TestEmbedded ()
	Test each line of SQL from <parameter>SQLFILE</parameter> using embedded SQL.

	TestJDBC ()
	Test each line of SQL from <parameter>SQLFILE</parameter> using a JDBC SQL Gateway connection.

	TestODBC ()
	Test each line of SQL from <parameter>SQLFILE</parameter> using an ODBC SQL Gateway connection. More...

	processDiffFile (_.Library.Stream rslt)
	Method to display incorrect results in a more readable format.

_.Library.Status	verifyResults (_.Library.FileCharacterStream src, _.Library.String testName)
	Compare dynamic results src against existing reference file.

Public Member Functions inherited from TestCase
_.Library.Boolean	AssertEqualsViaMacro (autoquoted, value1, value2, description)
	Returns true if two values are equal. More...

_.Library.Boolean	AssertFailureViaMacro (message)
	Unconditionally log a failure. More...

_.Library.Boolean	AssertFilesSQLUnorderedSameViaMacro (autoquoted, file1, file2, description, ignoreOrderBy, skipPlan, noheader)
	Returns true if two files containing SQL query results contain the same unordered results. More...

_.Library.Boolean	AssertFilesSameViaMacro (autoquoted, file1, file2, description)
	Returns true if two files are identical. More...

_.Library.Boolean	AssertNotEqualsViaMacro (autoquoted, value1, value2, description)
	Returns true if expressions are not equal. More...

_.Library.Boolean	AssertNotTrueViaMacro (autoquoted, value, description)
	Returns true if the expression is not true. More...

_.Library.Boolean	AssertSkippedViaMacro (message)
	An assertion to state that the test has been skipped for the reason described in the assertion's message. More...

_.Library.Boolean	AssertStatusEqualsViaMacro (autoquoted, value1, value2, description)
	Returns true if two statuses are equal. More...

_.Library.Boolean	AssertStatusNotOKViaMacro (autoquoted, status, description)
	Returns true if the status code is not a successful status code. More...

_.Library.Boolean	AssertStatusOKViaMacro (autoquoted, status, description)
	Returns true if the status code is $$$OK. More...

_.Library.Boolean	AssertSuccessViaMacro (message)
	Unconditionally log success. More...

_.Library.Boolean	AssertTrueViaMacro (autoquoted, value, description)
	Returns true if expression is true. More...

	Checkout (file1, file2, forceref)
	Helper method that will check out the one file in Perforce and copy the output to the reference file. More...

	LogMessage (message)
	Enter a message in quotes, such as "Start of test". More...

_.Library.Status	OnAfterAllTests ()
	Run by RunTest once after all test methods in the test class are run. More...

_.Library.Status	OnAfterOneTest (_.Library.String testname)
	Run by RunTest immediately after each test method in the test class is run. More...

_.Library.Status	OnBeforeAllTests ()
	Run by RunTest once before any test methods in the test class are run. More...

_.Library.Status	OnBeforeOneTest (_.Library.String testname)
	Run by RunTest immediately before each test method in the test class is run. More...

Public Member Functions inherited from RegisteredObject
_.Library.Status	OnAddToSaveSet (_.Library.Integer depth, _.Library.Integer insert, _.Library.Integer callcount)
	This callback method is invoked when the current object is added to the SaveSet,. More...

_.Library.Status	OnClose ()
	This callback method is invoked by the <METHOD>Close</METHOD> method to. More...

_.Library.Status	OnConstructClone (_.Library.RegisteredObject object, _.Library.Boolean deep, _.Library.String cloned)
	This callback method is invoked by the <METHOD>ConstructClone</METHOD> method to. More...

_.Library.Status	OnNew ()
	This callback method is invoked by the <METHOD>New</METHOD> method to. More...

_.Library.Status	OnValidateObject ()
	This callback method is invoked by the <METHOD>ValidateObject</METHOD> method to. More...

Static Public Attributes
	CORRELATIONLIST = None
	Extend this class to create a regression test when .data files are used to load data into tables. More...

	DATACLASS = None
	Specifies a class, such as Sample.Person, which should be correlated with the XML tag specified by <parameter>DATATAG</parameter>, such as <person>, in the <parameter>DATAFILE</parameter>. More...

	DATAFILE = None
	File that contains data in XML format, such as Person.data. More...

	DATATAG = None
	Specifies an XML tag in <parameter>DATAFILE</parameter>, such as <person>, which should be correlated to the class specified by <parameter>DATACLASS</parameter>, such as Sample.Person.

Static Public Attributes inherited from SQLRegression
	DISPLAYELAPSEDTIME = None
	Extends TestCase. More...

	DISPLAYSECONDS = None
	<PARAMETER>DISPLAYSECONDS</PARAMETER> enables you to internationalize the spelling of "seconds" in More...

	DISPLAYTESTNAME = None
	<PARAMETER>DISPLAYTESTNAME</PARAMETER> enables you to internationalize the display of the test name, More...

	REFFILE = None
	Specifies a result file for comparison use.

	SHOWPLAN = None
	Set <PARAMETER>SHOWPLAN</PARAMETER>=1 to dump the access plans used by each test in the test script. More...

	SQLFILE = None
	Comma-delimited sql filenames overrides the sql file lookup by specifying which and in which order sql script files are to be tested.

	TESTFILE = None
	Specifies the xml file running the test so it's not reloaded.

	TIMESCALE = None
	The <PARAMETER>TIMESCALE</PARAMETER> parameter enables you to control whether elapsed time information. More...

Static Public Attributes inherited from TestCase
	AutoGiveUsersNSAccess = None
	Extend this class to create new test case classes. More...

	AutoUserNames = None
	String of test users. More...

	AutoUserResources = None
	Optional: specifies resources for each test user in AutoUserNames. More...

	AutoUserRoles = None
	Optional: specifies roles for each test user in AutoUserNames. More...

Static Public Attributes inherited from RegisteredObject
	CAPTION = None
	Optional name used by the Form Wizard for a class when generating forms. More...

	JAVATYPE = None
	The Java type to be used when exported.

	PROPERTYVALIDATION = None
	This parameter controls the default validation behavior for the object. More...

Additional Inherited Members
Public Attributes inherited from TestCase
	AutoPassword
	If UnitTest.Manager creates test users specified by AutoUserNames, it will generate a random-string password. More...

	Debug
	Use the /debug flag with UnitTest.Manager.RunTest to break into debug mode on the first failure. More...

	SkipTest
	The SkipTest property gets set when a test is being skipped. More...

Detailed Description

Extend this class to create a regression test when .data files are used to load data into tables.

Member Data Documentation

◆ CORRELATIONLIST

CORRELATIONLIST = None

static

Extend this class to create a regression test when .data files are used to load data into tables.

List that correlates XML tags in a data file with classes.

Tag/class entries are in the form tag:class, tag1:class1, tag2:class2. Each entry is like setting the <parameter>DATATAG</parameter> and <parameter>DATACLASS</parameter> parameters, but the <parameter>CORRELATIONLIST</parameter> sets several tag/class pairs in one parameter. If <parameter>CORRELATIONLIST</parameter>, <parameter>DATACLASS</parameter>, and <parameter>DATATAG</parameter> are all specified, the <parameter>DATATAG</parameter> and <parameter>DATACLASS</parameter> pair are added to the end of the <parameter>CORRELATIONLIST</parameter>.

◆ DATACLASS

DATACLASS = None

static

Specifies a class, such as Sample.Person, which should be correlated with the XML tag specified by <parameter>DATATAG</parameter>, such as <person>, in the <parameter>DATAFILE</parameter>.

Sample.Person is part of https://github.com/intersystems/Samples-Data. See Downloading Samples.

◆ DATAFILE

DATAFILE = None

static

File that contains data in XML format, such as Person.data.

If no directory name is specified by RunTest, then the current UnitTest directory is used.

Public Member Functions

Static Public Attributes

Additional Inherited Members

Detailed Description

Member Data Documentation

◆ CORRELATIONLIST

◆ DATACLASS

◆ DATAFILE