我是使用MongoDB scala驱动程序。我在从MongoDB获取记录方面遇到了问题。
以下是我的MongoDB初始化:
发现查询:
我希望你能将这个文档映射到我的Case类中。
Case类类似于:
如果我想从文档中获取JSON字符串,可以按照以下步骤操作:
然后我将获得以下JSON字符串:
我可以将JSON字符串解析为样例类,但是...看看
如何将文档映射到样例类?
private val client: MongoClient = MongoClient()
private val database: MongoDatabase = client.getDatabase(“rulemgntdb”)
val WorkOrdercollection: MongoCollection[Document] = database.getCollection("workOrder")
发现查询:
MongoFactory.WorkOrdercollection.find().collect().subscribe(
(results: Seq[Document]) =>
println(s”Found: #${results}“)
)
结果会像这样打印:
Found: #List(Document((_id,BsonString{value=‘5af153f49547a205f9798129’}), (workOrderId,BsonString{value=‘9a9e1ce8-c576-4a15-a1ff-4af780b14b7f’}), (thingId,BsonString{value=‘Mumbai_Robot_3’}), (alertId,BsonString{value=‘Alert_1’}), (description,BsonString{value=‘Robot is not in good condition’}), (lastViewedDate,BsonDateTime{value=1525781377952}), (suggestedMaintenanceDate,BsonDateTime{value=1525781377952}), (startDate,BsonDateTime{value=1525781377952})))
我希望你能将这个文档映射到我的Case类中。
Case类类似于:
case class WorkOrder (
var id : String = (new ObjectId()).toString(),
var workOrderId: String,
var thingId : String,
var alertId : String,
var description : String,
val lastViewedDate : Date,
val suggestedMaintenanceDate : Date,
val startDate : Date
)
如果我想从文档中获取JSON字符串,可以按照以下步骤操作:
MongoFactory.WorkOrdercollection.find(query).subscribe(
(user: Document) => println(user.toJson()), // onNext
(error: Throwable) => println(s"Query failed: ${error.getMessage}"), // onError
() => println("Done") // onComplete
)
然后我将获得以下JSON字符串:
{ “_id” : “5af153f49547a205f9798129", “workOrderId” : “9a9e1ce8-c576-4a15-a1ff-4af780b14b7f”, “thingId” : “Mumbai_Robot_3", “alertId” : “Alert_1", “description” : “Robot is not in good condition”, “lastViewedDate” : { “$date” : 1525781377952 }, “suggestedMaintenanceDate” : { “$date” : 1525781377952 }, “startDate” : { “$date” : 1525781377952 } }
我可以将JSON字符串解析为样例类,但是...看看
"startDate": {"$date": 1525781377952}
,我无法将MongoDB日期解析为Scala日期。如何将文档映射到样例类?