Skip to main content

%CSP.UI.Portal.SQL.Utils

abstract class %CSP.UI.Portal.SQL.Utils extends %Library.RegisteredObject

Utilities used by Management Portal SQL.

Method Inventory

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
classmethod DrawTabs(totalResultsets, pOutputValues As %Integer = 0, pQueryID As %Integer = -1)
Control method to draw tab group. This is only used on the SQL Home page for Execute Query tab.
classmethod GetConfigSQLProperties(ByRef Properties As %String) as %Status
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

FeedbackOpens in a new tab