Class %UnitTest.DSQL

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

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

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
		2

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	genPlan	getColumn
getData	getFromPlan	getSqlCode	getSqlExec
ltrim	processDRSToStream	rewindLine	rtrim
runDSQL	stripChar	trim	typeNameByType

Subclasses
%UnitTest.SQLRegression

Methods

• classmethod processDRSToStream(ByRef rs As %ResultSet, ByRef output As %Stream) as %Status

Process each result set to a stream

• classmethod runDSQL(sqlfilename As %String, verbose As %Boolean = 0, genplan As %Boolean = 0) as %FileCharacterStream

Execute sql from sql file against Cache Dynamic SQL and return results in a stream If verbose is true, write verbose information to terminal If genplan is true, generate information and write it in stream for appropriate sql statements SQL statements are delimited by "####"


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