SchemaMap.Tool.SQL.Delete
class SchemaMap.Tool.SQL.Delete extends SchemaMap.Tool.SQL.Base
Method Inventory
Methods
classmethod Map(from As %String, to As %String, row As %String = "", path As %String = "", contained As %Boolean = 0, clause As %String = "", args...) as %Status
Delete data from the mapping table. Can be constrained by providing an optional row ID, path, and/or an additional clause.
If a row ID is provided, this method deletes only that row from the SQL table, and ignores any path or clause input to this method.
If there is no row ID provided, the method consults the path and clause for filters to apply to the query.
The method deletes rows using the path name exactly as provided, as well as entries that are contained within that path.
classmethod Schema(schema As %String, path As %String = "", contained As %Boolean = 0, clause As %String = "", args...) as %Status
Delete data from the schema table. Can be constrained by providing a path and/or an additional clause. order if set to 1 will order based on Path,
otherwise it will be sorted by ID. sqlargs can be used to store variables that are used in clause.