我尝试使用以下代码通过 ObjectId 获取 mongodb 记录,但不断获取未找到 by err.Error()
以下是我的 mongo 集合示例
{ "_id" : ObjectId("5a2a75f777e864d018131a59"), "callDate" : "22/12/2017", "time" : "16.25", "callType" : "a", "position" : "aaa", "description" : "aaaaaa", "qty" : 2, "estimatedDuration" : 2.3, "estimatedOvertime" : 3.44, "rate" : 4, "laborExtension" : 3 }
{ "_id" : ObjectId("5a2a75f877e864d018131a5b"), "callDate" : "22/12/2017", "time" : "16.25", "callType" : "a", "position" : "aaa", "description" : "aaaaaa", "qty" : 2, "estimatedDuration" : 2.3, "estimatedOvertime" : 3.44, "rate" : 4, "laborExtension" : 3 }
{ "_id" : ObjectId("5a2a75fa77e864d018131a5d"), "callDate" : "22/12/2017", "time" : "16.25", "callType" : "a", "position" : "aaa", "description" : "aaaaaa", "qty" : 2, "estimatedDuration" : 2.3, "estimatedOvertime" : 3.44, "rate" : 4, "laborExtension" : 3 }
以下是我的模型
type RhinoJobs struct {
ID bson.ObjectId `db:"id" json:"id" bson:"_id"`
CallDate string `db:"call_date" json:"callDate" bson:"callDate"`
Time string `db:"time" json:"time" bson:"time"`
CallType string `db:"call_type" json:"callType" bson:"callType"`
Position string `db:"position" json:"position" bson:"position"`
Description string `db:"description" json:"description" bson:"description"`
Qty int `db:"qty" json:"qty" bson:"qty"`
EstimatedDuration float64 `db:"estimated_duration" json:"estimatedDuration" bson:"estimatedDuration"`
EstimatedOvertime float64 `db:"estimated_overtime" json:"estimatedOvertime" bson:"estimatedOvertime"`
Rate float64 `db:"rate" json:"rate" bson:"rate"`
LaborExtension float64 `db:"labor_extension" json:"laborExtension" bson:"laborExtension"`
}
我想通过对象 ID 搜索这些记录
"gopkg.in/mgo.v2"
func GetMongoSession() (*mgo.Session, error) {
if mgoSession == nil {
var err error
mgoSession, err = mgo.Dial(mongoConnectionUrl)
if err != nil {
return nil, err
}
}
return mgoSession.Clone(), nil
}
func GetJobByID(objID string) (models.RhinoJobs, error) {
var job models.RhinoJobs
s, err := commons.GetMongoSession()
if err != nil {
errMsg := "error occurred while creating mongoDB connection stack:" + err.Error()
print(err.Error())
return job, errors.New(errMsg)
}
defer s.Close()
err = s.DB("rhino").C("jobs").FindId(bson.ObjectIdHex("5a2a75f777e864d018131a59")).One(&job)
if err != nil {
print(err.Error())
errMsg := "error occurred while getting data :" + err.Error()
return job, errors.New(errMsg)
}
return job, nil
}
但是当我尝试通过以下代码获取所有集合记录时,它工作正常
err := s.DB("rhino").C("jobs").Find(nil).All(&jobs)
我还检查了以下SO Q&A,但没有用
使用存储在数组中的 _id 从 golang 查询 mongodb https://stackoverflow.com/questions/26428281/querying-mongodb-from-golang-using-the-id-stored-in-an-array
如何在golang和mongodb中通过id查找 https://stackoverflow.com/questions/35364816/how-to-find-by-id-in-golang-and-mongodb
无法使用 mgo 和 golang 检索“_id”值 https://stackoverflow.com/questions/20215510/cannot-retrieve-id-value-using-mgo-with-golang