我在 MongoDB 中的不同查詢遇到問題。我可以在 Mongo shell 中編寫它，它可以工作，但我不知道如何在 Go 代碼中實現它。這是我的 Mongo shell 代碼db.getCollection('company_role_function').distinct("rolecode", {rolecode : { $in: ['DHBK_ROLE_01','DHBK_ROLE_03' ] },productid:'IOT_Platform'})這是我的 Go 代碼1.profile.go type CompanyRoleFunction struct { Rolecode string `json:"rolecode"` Productid string `json:"productid"` Functioncode string `json:"functioncode"` Comid string `json:"comid"` }存儲庫.gopackage repositoryimport "bitbucket.org/cloud-platform/vnpt-sso-usermgnt/model"type IProfileRepository interface { FindRoleByUserProduct(string) (*model.CompanyRoleFunction, error)}mongo_driver.gopackage repositoryimport ( "bitbucket.org/cloud-platform/vnpt-sso-usermgnt/model" "go.mongodb.org/mongo-driver/bson" "gopkg.in/mgo.v2")type ProfileRepositoryMongo struct { db *mgo.Database collection string } func NewProfileRepositoryMongo(db *mgo.Database, collection string) *ProfileRepositoryMongo { return &ProfileRepositoryMongo{ db: db, collection: collection, }}//I HAVE TROUBLE HERE func (r *ProfileRepositoryMongo) FindRoleByUserProduct(rolecode arr[]string) (*model.CompanyRoleFunction, error) { var companyRoleFunction model.CompanyRoleFunction //I HAVE TROUBLE HERE err := r.db.C(r.collection).Find(bson.M{"username": username}).One(&companyRoleFunction) //I HAVE TROUBLE HERE if err != nil { return nil, err } return &companyRoleFunction, nil }
1 回答
料青山看我應如是
TA貢獻1772條經驗 獲得超8個贊
嘗試以下代碼在 mgo 中區分
package main
import (
"context"
"fmt"
"time"
"go.mongodb.org/mongo-driver/bson"
"go.mongodb.org/mongo-driver/mongo"
"go.mongodb.org/mongo-driver/mongo/options"
"gopkg.in/mgo.v2"
)
type Result struct {
Rolecode string `json:"rolecode"`
Productid string `json:"productid"`
Functioncode string `json:"functioncode"`
Comid string `json:"comid"`
}
type Results []Result
func main() {
//delete1("GV_BMVT")
//update("GV_BMVT")
check()
}
func check() {
session, err := mgo.Dial("mongodb://casuser:[email protected]:27017/users")
if err != nil {
panic(err)
}
c := session.DB("users").C("company_role_function")
results := []string{}
roleArray := []string{"DHBK_ROLE_01,", "DHBK_ROLE_03"}
err = c.Find(bson.M{"rolecode": bson.M{"$in": roleArray}, "productid": "IOT_Platform"}).Distinct("rolecode", &results)
if err != nil {
panic(err)
}
fmt.Println(results)
}
- 1 回答
- 0 關注
- 249 瀏覽
添加回答
舉報
0/150
提交
取消