%CSP.UI.Portal.SQL.Utils
abstract class %CSP.UI.Portal.SQL.Utils extends %Library.RegisteredObject
Utilities used by Management Portal SQL.Method Inventory
- DrawMessages()
- DrawOutputColumns()
- DrawResult()
- DrawResultSet()
- DrawTabBox()
- DrawTabs()
- GetConfigSQLProperties()
- GetError()
- GetQueryParameters()
- GetViewInfo2()
- LoadSchemas()
- LoadTables()
- ReverseSchema()
- SQLExecuteQuery()
- SaveConfigSQLProperties()
Parameters
parameter DOMAIN = %Utility;
Methods
classmethod DrawMessages(pPtr As %Integer = 1, pDrawTab As %Boolean, ByRef pMessages As %String(MAXLEN=""), pQueryID As %Integer = -1)
Messages passed in should already been HTML escaped.
classmethod DrawOutputColumns(pPtr As %Integer = 0, pResult As %SQL.StatementResult, pDrawTab As %Boolean, ByRef pMessages As %String(MAXLEN=""), pQueryID As %Integer = -1)
classmethod DrawResult(pResult As %SQL.StatementResult, pDrawTab As %Boolean = 0, pShowRowNum As %Boolean, ByRef AccStat, pMaxRows As %Integer = 1000, pQueryID As %Integer = -1)
***** The following methods are used to draw query results. Multiple resultsets and call statements are handled. *****
***** The caller should have already obtained a SQL statement result using SQLExecuteQuery in this class. *****
***** See method DrawHTML in %CSP.UI.Portal.SQL.Home and %CSP.UI.Portal.SQL.PrintQuery *****
DrawResult will draw all of the result information returned in the statement result object.
classmethod DrawResultSet(pPtr As %Integer, pResult As %SQL.StatementResult, pDrawTab As %Boolean, pShowRowNum As %Boolean, ByRef pMessages As %String(MAXLEN=""), ByRef AccStat, pMaxRows As %Integer = 1000, pQueryID As %Integer = -1)
Draw html for one resultset.
classmethod DrawTabBox(tabClass As %String, tabCaption As %String, tabIndex As %Integer, totalTabs As %Integer, pQueryID As %Integer = -1)
Draws each tab in tab group button
Control method to draw tab group. This is only used on the SQL Home page for Execute Query tab.
Method for UI to get SQL Configuration Settings. Return Properties array.
classmethod GetError(pResult As %SQL.StatementResult, ByRef pMessages As %String(MAXLEN=""))
GetError will return the HTML for an invalid SQLCODE.
classmethod GetQueryParameters(pText As %String(MAXLEN=""), pRuntimeMode As %Integer = 2, pDialect As %String = "Cache", pObjectSelectMode As %Boolean = 0, ByRef tPromptCount As %Integer) as %String
Method to return number of parameters that user needs to provide for input in order to execute the query.
Return number of Parameters within query text. 0 means none.
classmethod GetViewInfo2(Schema As %String, ViewName As %String, Output Owner As %String, Output ReadOnly As %Boolean, Output CheckOption As %String) as %Status
Given schema name and view name, return view info
classmethod LoadSchemas(pWizard, pDSN, pTableType, pSchemaFilter) as %String
***** End of Group Methods for DrawResult *****
List schemas based on cache gateway connection - you must have a DSN (configuration name) passed in.
This method is Jobbed from the wizard page.
classmethod LoadTables(pWizard, pDSN, pSchema, pTableType, pFilter) as %String
classmethod ReverseSchema(schema) as %String
classmethod SQLExecuteQuery(pText As %String(MAXLEN=""), ByRef pClassName As %String, pRuntimeMode As %Integer = 2, pDialect As %String = "Cache", pObjectSelectMode As %Boolean = 0, %caller As %String = "", ByRef tDiskRead, ByRef StatementType As %Integer = 0, ByRef AccStat, ByRef pSessionData, pQueryID As %Integer, ByRef pRuntimeClassName As %String) as %SQL.StatementResult
Method to return SQL statement object and class name. Called by multiple SQL UI pages.
When %caller is passed in as "SMP" then the system will prevent the DDL API from checking the DDLAllowed flag for the class (used by modifying view)
classmethod SaveConfigSQLProperties(proxy As %ZEN.proxyObject) as %ZEN.proxyObject
Method for UI to save SQL configuration settings. ZEN proxy object is passed in with user selected values.
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %ClassIsLatestVersion()
- %ClassName()
- %ConstructClone()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Extends()
- %GetParameter()
- %IsA()
- %IsModified()
- %New()
- %NormalizeObject()
- %ObjectModified()
- %OriginalNamespace()
- %PackageName()
- %RemoveFromSaveSet()
- %SerializeObject()
- %SetModified()
- %ValidateObject()