Class apptools.core.json

abstract class apptools.core.json

JSON utility

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
		10

Summary

Methods
ExportClassInstances	ExportGlobals	GetJSONObject	GetOneObject
GlobalsNode	ImportClassInstances	ImportGlobals	ImportNodeRestore
Pretty	WriteJSONFromSQL

Methods

• classmethod ExportClassInstances(class, sql="", filename="", ByRef json, exec="", JsonAsString=0) as %Status

Class ------------------------------------------------------------------------------------------------ write ##class(apptools.core.json).ExportClassInstances("%Library.SQLConnection","select * FROM %Library.sys_SQLConnection WHERE (1=1)","/tmp/gateways.json") write ##class(apptools.core.json).ExportClassInstances("Security.Users","select * from Security.Users where Enabled['1'","/tmp/users.json",.js) write ##class(apptools.core.json).Pretty(js)

• classmethod ExportGlobals(gn, filename="", ByRef json, Filtr="", erros, JsonAsString=0) as %Status

todo set Filtr="%gn[""install""&&(@%gn'[""ERROR"")" ; do ##class(apptools.core.json).ExportGlobals("^ZPM.Dev.ModuleD","/tmp/zpm-glob.json",.json, $Get(Filtr)) write ##class(apptools.core.json).Pretty(json)

• classmethod GetJSONObject(oid) as %Status

• classmethod GetOneObject(class, id, ByRef cls, ByRef json, exec="") as %Status

• classmethod GlobalsNode(node As %String = "", val As %String = "", ByRef count, ByRef js, gn) as %Status

Set the global node to json

• classmethod ImportClassInstances(filename="", ByRef json, ByRef change) as %Status

!!!set change("Name")="read" write ##class(apptools.core.json).ImportClassInstances("/tmp/gateways.json",.js,.change) write ##class(apptools.core.json).ImportClassInstances("/tmp/users.json",.js) write ##class(apptools.core.json).Pretty(js) //write $$Do^ZPretty(js) //install pretty-json

• classmethod ImportGlobals(filename="", ByRef json, ByRef change, Filtr="") as %Status

Clobals ------------------------------------------------------------------------------ set change("Name")="read" do ##class(apptools.core.json).ImportGlobals("/tmp/glob.json",.json,.change)

• classmethod ImportNodeRestore(obj, gn, orig, Filtr="", ByRef outvalue) as %Status

• classmethod Pretty(input, fil, nl) as %String

From https://github.com/isc-at/ZPretty Author Robert Cemper write $$Do^ZPretty(js) /// zpm "install pretty-json" write ##class(apptools.core.json).Pretty("{""key"":123,""key2"":321}")

• classmethod WriteJSONFromSQL(sql As %String) as %Status

w ##class(apptools.core.json).WriteJSONFromSQL("select * FROM %Library.sys_SQLConnection WHERE Connection_Name='postgres'")

Class Reference IRIS for UNIX 2024.1.2
Documentation Search