Class %UnitTest.ESQL

class %UnitTest.ESQL extends %RegisteredObject, %UnitTest.Utility

Extends Utility. Methods to execute sql files against Cache Embedded SQL and return results in a stream.

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
		5

Summary

Methods
%%OIDGet	%AddToSaveSet	%ClassIsLatestVersion	%ClassName
%ConstructClone	%DispatchClassMethod	%DispatchGetModified	%DispatchGetProperty
%DispatchMethod	%DispatchSetModified	%DispatchSetMultidimProperty	%DispatchSetProperty
%Extends	%GetParameter	%IsA	%IsModified
%New	%NormalizeObject	%ObjectModified	%OriginalNamespace
%PackageName	%RemoveFromSaveSet	%SerializeObject	%SetModified
%ValidateObject	FindClass	Occurs	convertSQL
countCachedQuery	crossVerify	describe	diffData
diffExpectedByStream	diffPlan	exeRoutine	genPlan
genRoutine	getColumn	getData	getFromPlan
getSqlCode	getSqlExec	ltrim	repairName
rewindLine	rtrim	runESQL	stripChar
trim	typeNameByType	verifyName

Subclasses
%UnitTest.SQLRegression

Methods

• classmethod exeRoutine(mac As %String, tag As %String = "", ByRef output As %Stream) as %Status

Execute MAC file containing embedded SQL and write output

• classmethod genRoutine(ByRef routine As %Routine, tag As %String, code As %Stream) as %Status

Generate MAC and embed each SQL statement and compile MAC A mac must be created for each sql statement

• classmethod repairName(name As %String) as %String

If name is not a legal MAC name, repair the name by removing offending characters

• classmethod runESQL(sqlfilename As %String, verbose As %Boolean = 0, ByRef macs As %ListOfDataTypes = "") as %Stream

Execute sql from sql file against Cache Dynamic SQL and return results in a stream If verbose is true, write verbose information to terminal Insert each generated MAC name into macs SQL statements are delimited by "####"

• classmethod verifyName(name As %String) as %Boolean

Method to verify name as a legal MAC name


[BASEXML] > [%UnitTest] > [ESQL]		Private Storage