Home > Class Reference > ENSLIB namespace > %UnitTest.ESQL
Private  Storage   


The methods in this class are used by the SQLRegression class to execute SQL files using embedded SQL and return results in a stream. They are subject to change, and not intended to be called directly.


Parameters Properties Methods Queries Indices ForeignKeys Triggers


%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
countGlobalRefs crossVerify describe diffData
diffExpectedByStream diffPlan exeRoutine genPlan
genRoutine getColumn getData getFromPlan
getSqlCode getSqlExec ltrim repairName
rewindLine rtrim runESQL stripChar
trim typeNameByType verifyName


• 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 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