SchemaMap.Tool.SQL.Base

class SchemaMap.Tool.SQL.Base

Method Inventory

• AddClause()
• AddOrder()
• AddSet()
• AddTable()
• AddWhere()
• CombineArgs()
• CompleteQuery()
• Execute()

Methods

classmethod AddClause(Output sql, clause As %String) as %Status

classmethod AddOrder(Output sql, schema As %String, pathColumn As %String) as %Status

classmethod AddSet(Output sql, setColumn As %String, setValue As %String) as %Status

classmethod AddTable(Output sql As %String, from As %String, to As %String = "") as %Status

classmethod AddWhere(Output sql As %String, Output sqlargs, schema As %String, pathColumn As %String, path As %String, contained As %Boolean, clause As %String) as %Status

classmethod CombineArgs(Output args, Output whereArgs, setValue As %String = "") as %Status

Puts the contents of whereArgs before args, and returns the contents in args.

classmethod CompleteQuery(Output sql As %String, Output args, from As %String, to As %String = "", pathColumn As %String, path As %String, contained As %Boolean, clause As %String, order As %Boolean = 0, setColumn As %String = "", setValue As %String = "") as %Status

classmethod Execute(sql As %String, Output result As %SQL.StatementResult, sqlargs...)