native json in the cache' objectscript 2016.*
TRANSCRIPT
Native JSON вCaché ObjectScript
Тимур Сафин
Синтаксис JSON
0“string”
truefalsenull
“key” : “value”{}[]
Это – JSON
{"firstName":"John", "lastName":"Doe"}
Это – JSON
"employees“ : [{"firstName” : "John", "lastName“ : "Doe"},{"firstName“ : "Anna", "lastName“ : "Smith"},{"firstName“ : "Peter", "lastName“ : "Jones"}
]
Это – не совсем JSON
SELECT '[1, 2, "foo", null]'::json;
SELECT '{"bar": "baz", "balance": 7.77, "active": false}'::json;
SELECT '{"foo": [true, "bar"], "tags": {"a": 1, "b": null}}'::json;
%Object и %Array
USER>set object = ##class(%Object).$new()
USER>set object.name = "Stefan Wittmann"
USER>set object.lastSeriesSeen = "Daredevil"
USER>set object.likes = "Galaxy"
%Object и %Array
USER>set array = ##class(%Array).$new()
USER>do array.$push(1)
USER>do array.$push("This is a string")
USER>do array.$push(object)
Сериализация в JSON
USER>do object.$toJSON()
{"name":"Stefan Wittmann","lastSeriesSeen":"Daredevil","likes":"Galaxy"}
USER>do array.$toJSON()
[1,"This is a string.",{"name":"Stefan Wittmann","lastSeriesSeen":"Daredevil","likes":"Galaxy"}]
Разбор JSONUSER>set someJSONstring = "{""firstname"":""Stefan"",""lastname"":""Wittmann""}"
USER>set consumedJSON = ##class(%AbstractObject).$fromJSON(someJSONstring)
USER>write consumedJSON.$size()2USER>write consumedJSON.$toJSON(){"firstname":"Stefan","lastname":"Wittmann"}
Итераторы на %Object
USER>set iter = object.$getIterator()
USER>while iter.$getNext(.key,.value) { write "key "_key_" : "_value,! }key name : Stefan Wittmannkey lastSeriesSeen : Daredevilkey likes : Galaxy
Итераторы на %Array
USER>set iter = array.$getIterator()
USER>while iter.$getNext(.key,.value) {write "key "_key_" : "_value,! }
key 0 : 1key 1 : This is a string.key 2 : 2@%Library.Object
Присваивание элемента в %Array
USER>do array.$set(10,"This is a string in a sparse array")
USER>write array.$toJSON()[1,"This is a string.",{"name":"Stefan Wittmann","lastSeriesSeen":"Daredevil","likes":"Galaxy"},null,null,null,null,null,null,null,"This is a string in a sparse array"]
Итератор по разреженному массиву
USER>set iter = array.$getIterator()
USER>while iter.$getNext(.key,.value) {write "key "_key_" : "_value,! }
key 0 : 1key 1 : This is a string.key 2 : 2@%Library.Objectkey 10 : This is a string in a sparse array
Native JSON Syntax
USER>set object = {"name":"Stefan Wittmann","lastMovieSeen":"The Martian","likes":"Writing Blogs"}
USER>write object.$toJSON(){"name":"Stefan Wittmann","lastMovieSeen":"The Martian","likes":"Writing Blogs"}USER>set array = [1,2,3,[4,5,6],true,false,null]
USER>write array.$toJSON()[1,2,3,[4,5,6],true,false,null]
Native JSON Syntax
USER>set object = {}
USER>set array = []
Native JSON Syntax
USER>set name = "Stefan"
USER>set subObject = {"nationality":"German","favoriteColors":["yellow","blue"]}
USER>set object = {"name":name,"details":subObject,"lastUpdate":$ZD($H,3)}
USER>write object.$toJSON(){"name":"Stefan","details":{"nationality":"German","favoriteColors":["yellow","blue"]}," lastUpdate ":"2016-01-31"}
Native JSON SyntaxUSER>set array = [1,2,3,[4,5,6],true,false,null]
USER>set iter = array.$getIterator()
USER>while iter.$getNext(.key,.value) { write "key "_key_":"_value,! } key 0:1key 1:2key 2:3key 3:5@%Library.Arraykey 4:1key 5:0key 6:
Native JSON Syntax
USER>set array = [1,2,3,[4,5,6],true,false,null]…USER>w array.$getTypeOf(5)booleanUSER>w array.$getTypeOf(6)null
Native JSON Syntax
USER>set array = [1,2,3,[4,5,6],true,false,null]…USER>do array.$set(7,1)
USER>write array.$toJSON()[1,2,3,[4,5,6],true,false,null,1]USER>do array.$set(7,1,"boolean")
USER>write array.$toJSON()[1,2,3,[4,5,6],true,false,null,true]
Системные методы
$new$set$push$pop$size
$compose
$compose
SAMPLES>set object = array.$compose("%Object")
SAMPLES>write ["zero","one","two"].$compose("%Object").$toJSON(){"0":"zero","1":"one","2":"two"}
$compose
SAMPLES>set person = ##class(Sample.Person).%OpenId(10)
SAMPLES>set object = person.$compose("%Object")
SAMPLES>write object.$toJSON(){"$CLASSNAME":"Sample.Person","$REFERENCE":"10","Age":46,"DOB":47058,"FavoriteColors":[],"Home":{"City":"Washington","State":"HI","Street":"4358 Franklin Place","Zip":59519},"Name":"Quincy,Neil Z.","Office":{"City":"Bensonhurst","State":"WI","Street":"8620 Clinton Drive","Zip":75074},"SSN":"966-11-9404"}
Result SetsSAMPLES>set result = $system.SQL.Execute("call sample.sp_sample_by_name('N')").%NextResult()
SAMPLES>write result.$toJSON(){"content":[{"DOB":"63986","ID":"189","Name":"Nathanson,Natasha T.","SSN":"439-13-7455"},{"DOB":"58420","ID":"85","Name":"Nelson,Charlotte Y.","SSN":"664-42-8486"},{"DOB":"34965","ID":"150","Name":"Noodleman,Charles Y.","SSN":"156-64-3875"},{"DOB":"39300","ID":"134","Name":"North,Ted J.","SSN":"308-14-4306"}],"metadata":{"columnCount":4,"columns":[{"ODBCType":4,"clientType":"","colName":"ID","isAliased":1,"isAutoIncrement":1,"isCaseSensitive":1,"isCurrency":0,"isExpression":0,"isHidden":0,"isIdentity":1,"isKeyColumn":1,"isNullable":0,"isReadOnly":1,"isRowId":1,"isRowVersion":0,"isUnique":1,"label":"ID","precision":10,"qualifier":"","scale":0,"schemaName":"Sample","tableName":"Person"},{"ODBCType":12,"clientType":"","colName":"Name","isAliased":1,"isAutoIncrement":0,"isCaseSensitive":0,"isCurrency":0,"isExpression":0,"isHidden":0,"isIdentity":0,"isKeyColumn":0,"isNullable":0,"isReadOnly":0,"isRowId":0,"isRowVersion":0,"isUnique":0,"label":"Name","precision":50,"qualifier":"","scale":0…
И это мы еще не рассказали про JSON расширения в SQL…
JSON & SQLLATEST:USER>set response = ##class(%Net.Http).getJSON("http://localhost:57772/api/document/v1/SAMPLES/continents",{"Username":"_SYSTEM","Password":"SYS"})
LATEST:USER>do response.$toJSON(){"collection":"continents","size":8,"content":[{"documentID":1,"documentVersion":1,"content":{"code":"NA","name":"North America"}},{"documentID":2,"documentVersion":2,"content":{"code":"SA","name":"South America"}},{"documentID":3,"documentVersion":3,"content":{"code":"AF","name":"Africa"}},{"documentID":4,"documentVersion":4,"content":{"code":"AS","name":"Asia"}},{"documentID":5,"documentVersion":5,"content":{"code":"EU","name":"Europe"}},{"documentID":6,"documentVersion":6,"content":{"code":"OC","name":"Oceana"}},{"documentID":7,"documentVersion":7,"content":{"code":"AN","name":"Antarctica"}},{"documentID":9,"documentVersion":8,"content":{}}]}
JSON & SQL
select code, name from JSON_TABLE(%Net.getJSON('http://localhost/api/document/v1/SAMPLES/continents','{"Username":"_SYSTEM","Password":"SYS","Port":57772}'),'$.content' columns (document varchar(2000) path '$',code varchar(2) path '$.content.code',name varchar(50) path '$.content.name')) order by name
Производительность
Производительность разбора JSON
(Each company has an average of 20
employees and 20 customers each with several
addresses)
Caché 2015.1
zenProxyObject
Caché 2016.*
Native JSON
NodeJS
0.12.2
v8: 3.28.73
Load 1000 companies JSON file
(10.8MB)
28000ms 94ms 97ms
Find how many employees called
"Robert“ (126 employees)
55ms 55ms 2ms
Load 10,000 companies JSON file
(108MB)
386700ms 904ms 892ms
Find how many employees called
"Robert" (1346 employees)
554.5ms 567ms 13ms