我要把照护所收集的数据发送到消防站。firebase中的日期(ex.updateDate)是浮动的。
云修复:
{"updatedAt":"2021-07-11 06:28:22.420435 UTC","revisions":[{"knowledgeVector":
{"processes":[{"clock":"34","id":"3353F0B6-8B59-4B86-B4AD-A74EE76DCD93","__key__":
{"namespace":"","app":"","path":""}}],"__key__":
{"namespace":"","app":"","path":""}},"entities":[{"type":"task","object":
{"instructions":"Tap the button below anytime you experience nausea.","schemaVersion":
{"majorVersion":"2","patchNumber":"4","minorVersion":"0","__key__":
{"namespace":"","app":"","path":""}},"timezone":{"identifier":"Asia/Tokyo","__key__":
{"namespace":"","app":"","path":""}},"updatedDate":646268927.410913,"title":"Track your
nausea!!","uuid":"1942E91C-F0C3-410D-9D06-F5F6B3859D0E","schedule":{"elements":
[{"start":"645980400","duration":{"isAllDay":true,"__key__":
{"namespace":"","app":"","path":""}},"interval":
{"weekOfYear":"0","year":"0","second":"0","minute":"0","hour":"0","month":"0","day":"1","
__key__":{"namespace":"","app":"","path":""}},"text":"Anytime throughout the
day","__key__":{"namespace":"","app":"","path":""}}],"__key__":
{"namespace":"","app":"","path":""}},"createdDate":646268927.410907,"id":"nausea","impact
sAdherence":false,"effectiveDate":
{"integer":"645980400","provided":"integer"},"phoneNumbers":[],"messagingNumbers":
[],"emailAddresses":[],"values":[],"__key__":
{"namespace":"","app":"","path":""}},"__key__":{"namespace":"","app":"","path":""}},
{"type":"task","object":{"instructions":"Peform Pelvic Gymnastics 5times for 10 Seconds
Each Time.","schemaVersion":
{"majorVersion":"2","patchNumber":"4","minorVersion":"0","__key__":
{"namespace":"","app":"","path":""}},"timezone":{"identifier":"Asia/Tokyo","__key__":
{"namespace":"","app":"","path":""}},"updatedDate":646268927.42012,"title":在使用以下代码输出到日志的照管工具包数据中,日期是时间戳。
Log (在向Firebase发送和接收病人事件时交换的称为修订的变量的内容):
[CareKitStore.OCKRevisionRecord(entities:
[CareKitStore.OCKEntity.task(CareKitStore.OCKTask(carePlanUUID: nil, id: "nausea", title:
Optional("Track your incontinence!!"), instructions: Optional("Tap the button below
anytime you experience nausea."), impactsAdherence: false, schedule:
CareKitStore.OCKSchedule(elements: [CareKitStore.OCKScheduleElement(text: Optional("Anytime throughout the day"), duration: CareKitStore.OCKScheduleElement.Duration.allDay, start: 2021-08-12 15:00:00 +0000, end: nil, interval: year: 0 month: 0 day: 1 hour: 0 minute: 0 second: 0 weekOfYear: 0 isLeapMonth: false , targetValues: [])]), groupIdentifier: nil, tags: nil, effectiveDate: 2021-08-12 15:00:00 +0000, deletedDate: nil, uuid: Optional(E6D112BD-0E9F-430F-BF9C-4CE5D69BAC54), nextVersionUUID: nil, previousVersionUUID: nil, createdDate: Optional(2021-08-15 23:28:52 +0000), updatedDate: Optional(2021-08-15 23:28:52 +0000), schemaVersion: Optional(2.0.4), remoteID: nil, source: nil, userInfo: nil, asset: nil, notes: Optional([]), timezone: Asia/Tokyo (current))), 我用下面的代码获得了修订的内容。
extension CKCareKitRemoteSyncWithFirestore {
fileprivate func putRevisionInFirestore(deviceRevision: OCKRevisionRecord, _ overwriteRemote: Bool, _ completion: @escaping (Error?) -> Void) {
do {
let data = try JSONEncoder().encode(deviceRevision)
let json = try CKSendHelper.jsonDataAsDict(data) ?? [String:Any]()
CKSendHelper.appendCareKitArrayInFirestore(json: json, collection: collection, withIdentifier: identifier, overwriteRemote: overwriteRemote) { (success, error) in
print("[putRevisionInFirestore] success \(success), error \(error?.localizedDescription ?? "")")
completion(error)
}
} catch {
print("[putRevisionInFirestore] " + error.localizedDescription)
completion(error)
}
}
fileprivate func getRevisionsFromFirestore(completion: @escaping (_ revisions: [OCKRevisionRecord]) -> Void) {
CKSendHelper.getFromFirestore(collection: collection, identifier: identifier, onCompletion: { (document, error) in
guard let document = document,
let payload = document.data()?["revisions"] else {
completion([OCKRevisionRecord]())
return
}
do {
let jsonData = try JSONSerialization.data(withJSONObject: payload, options: [])
let revisions = try JSONDecoder().decode([OCKRevisionRecord].self, from: jsonData)
completion(revisions)
print(revisions)
} catch {
print("[getRevisionsFromFirestore] ERROR " + error.localizedDescription)
completion([OCKRevisionRecord]())
}
})
}
fileprivate func createPullMergeRevisionRecord(_ revisions: [OCKRevisionRecord], _ knowledgeVector: OCKRevisionRecord.KnowledgeVector) -> OCKRevisionRecord {
let newEntities = revisions.filter({ $0.knowledgeVector >= knowledgeVector }).flatMap({ $0.entities })
var allKnowledge = OCKRevisionRecord.KnowledgeVector()
for rev in revisions.map({ $0.knowledgeVector }) {
allKnowledge.merge(with: rev)
}
let newRecord = OCKRevisionRecord(entities: newEntities, knowledgeVector: allKnowledge)
return newRecord
}
fileprivate func createPushMergeRevisionRecord(_ revisions: [OCKRevisionRecord], _ knowledgeVector: OCKRevisionRecord.KnowledgeVector) -> OCKRevisionRecord {
let newEntities = revisions.filter({ knowledgeVector >= $0.knowledgeVector }).flatMap({ $0.entities })
var allKnowledge = knowledgeVector
for rev in revisions.map({ $0.knowledgeVector }) {
allKnowledge.merge(with: rev)
}
let newRecord = OCKRevisionRecord(entities: newEntities, knowledgeVector: allKnowledge)
return newRecord
}
}我尝试用下面的查询(BigQuery)将这个浮动日期数据转换为时间戳,但这是不正确的。还有其他好的解决办法吗?提前谢谢。
SELECT FORMAT_TIMESTAMP("%Y-%m-%d %H:%M:%S", TIMESTAMP_SECONDS(CAST(updatedDate as INT64)), "Asia/Tokyo") as formatted FROM `@@@` 发布于 2021-09-26 09:05:36
Gourav B,谢谢你的回应我解决了。
按照您的建议,在上面代码的"putRevisionInFirestore“函数中,我在日志中输出了原始数据"deviceRevision”和" json“,它们将"deviceRevision”转换为json。
因此,前者的日期数据是正确的时间戳,后者是浮动的。
因此,我猜想json的编码部分出现了问题,并在putRevisionInFirestore中指定了如下所示的编码策略,并且防火墙上的日期数据已经从浮动更改为正确的时间戳。
谢谢你的帮助!
fileprivate func putRevisionInFirestore(deviceRevision: OCKRevisionRecord, _ overwriteRemote: Bool, _ completion: @escaping (Error?) -> Void) {
do {let encoder = JSONEncoder()
encoder.dateEncodingStrategy = .iso8601
let data = try encoder.encode(deviceRevision)
let json = try CKSendHelper.jsonDataAsDict(data) ?? [String:Any]()
CKSendHelper.appendCareKitArrayInFirestore(json: json, collection: collection, withIdentifier: identifier, overwriteRemote: overwriteRemote) { (success, error) in
print("[putRevisionInFirestore] success \(success), error \(error?.localizedDescription ?? "")")
print("[putRevisionInFirestore_deviceRevision]",deviceRevision)
print("[putRevisionInFirestore_json]",json)
completion(error)
}
} catch {
print("[putRevisionInFirestore] " + error.localizedDescription)
completion(error)
}
}https://stackoverflow.com/questions/69313221
复制相似问题