本文属于机器翻译版本。若本译文内容与英语原文存在差异,则一律以英文原文为准。
$util.rds 中的亚马逊 RDS 助手
$util.rds
包含通过删除结果输出中的无关数据来格式化 Amazon RDS 操作的辅助方法
$util.rds.toJsonString(String serializedSQLResult): String
-
String
通过将字符串化的原始Amazon Relational Database Service (Amazon RDS) 数据 API 操作结果格式转换为更简洁的字符串来返回 a。返回的字符串是结果集的 SQL 记录的序列化列表。每条记录均表示为一个键-值对集合。键是对应的列名称。如果输入中的相应语句是导致变异的 SQL 查询(例如 INSERT、UPDATE、DELETE),则返回一个空列表。例如,该查询
select * from Books limit 2
提供了 Amazon RDS 数据操作的原始结果:{ "sqlStatementResults": [ { "numberOfRecordsUpdated": 0, "records": [ [ { "stringValue": "Mark Twain" }, { "stringValue": "Adventures of Huckleberry Finn" }, { "stringValue": "978-1948132817" } ], [ { "stringValue": "Jack London" }, { "stringValue": "The Call of the Wild" }, { "stringValue": "978-1948132275" } ] ], "columnMetadata": [ { "isSigned": false, "isCurrency": false, "label": "author", "precision": 200, "typeName": "VARCHAR", "scale": 0, "isAutoIncrement": false, "isCaseSensitive": false, "schemaName": "", "tableName": "Books", "type": 12, "nullable": 0, "arrayBaseColumnType": 0, "name": "author" }, { "isSigned": false, "isCurrency": false, "label": "title", "precision": 200, "typeName": "VARCHAR", "scale": 0, "isAutoIncrement": false, "isCaseSensitive": false, "schemaName": "", "tableName": "Books", "type": 12, "nullable": 0, "arrayBaseColumnType": 0, "name": "title" }, { "isSigned": false, "isCurrency": false, "label": "ISBN-13", "precision": 15, "typeName": "VARCHAR", "scale": 0, "isAutoIncrement": false, "isCaseSensitive": false, "schemaName": "", "tableName": "Books", "type": 12, "nullable": 0, "arrayBaseColumnType": 0, "name": "ISBN-13" } ] } ] }
那
util.rds.toJsonString
是:[ { "author": "Mark Twain", "title": "Adventures of Huckleberry Finn", "ISBN-13": "978-1948132817" }, { "author": "Jack London", "title": "The Call of the Wild", "ISBN-13": "978-1948132275" }, ]
$util.rds.toJsonObject(String serializedSQLResult): Object
-
这与 JSON 相同
util.rds.toJsonString
,但结果是 JSONObject
。