duanguane1670 2019-07-17 16:46
浏览 713
已采纳

如何结合bson.M过滤器

I am trying to combine some filters with no success. I am using the mongodb driver for go

// FindOneByID returns an error on fail, otherwise, it sets the {out} by the result.
func FindOneByID(collectionName string, id *primitive.ObjectID, out interface{}, considerArchivedItems bool) error {
    ctx, _ := context.WithTimeout(context.Background(), 2*time.Second)
    var filter bson.M

    if considerArchivedItems {
        filter = bson.M{"_id": id}
    } else {
        filter = bson.M{"$and": bson.A{ bson.M{"_id": id}, bson.M{isArchived: bson.M{"$ne": false}}}}
    }

    return database.Collection(collectionName).FindOne(ctx, filter).Decode(out)
}

Now, I insert an object as archived and trying to get the document. The document is inserted as archived, so I want to consider archived items.

However, when I pass in the else, document can be either archived or not (false or true), I still get it anyway. So it means that my $and doesn’t work..

const (
    databaseNameUnitTests           = "database_name_unit_tests"
    databaseCollectionNameUnitTests = "database_name_unit_tests"
)

type Test struct {
    ID          *primitive.ObjectID `protobuf:"bytes,1,opt,name=id,proto3" json:"_id,omitempty" bson:"_id,omitempty"`
    IsArchived  bool                `protobuf:"varint,2,opt,name=IsArchived,proto3" json:"is_archived,omitempty" bson:"is_archived,omitempty"`
    Description string              `protobuf:"varint,3,opt,name=Description,proto3" json:"description,omitempty" bson:"description,omitempty"`
}

// func
    var item Test
    err := mongodb.FindOneByID(databaseCollectionNameUnitTests, insertedID, &item, false)

The following query from Robo 3T : db.getCollection('database_name_unit_tests').find({$and:[{"_id":ObjectId("5d2e8afeb0e106fbe0d5af21")},{"is_archived": {$ne:false}}]}) this works tho, where am I wrong?

  • 写回答

1条回答 默认 最新

  • doumu4916 2019-07-17 19:18
    关注

    I have a lot of trouble getting bson.A to work with $and statements, try using bson.D instead.

    bson.D{{"$and", []bson.D{
       bson.D{{"_id",id}},
       bson.D{{"isArchived", bson.D{{"$ne", false}}}},
    }}}
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 广告联盟的兜底广告是什么意思
  • ¥15 如何证明高斯噪声的包络公式
  • ¥150 寻找王者荣耀开发作者,合作或者解答
  • ¥15 乳腺癌数据集 相关矩阵 特征选择
  • ¥15 我的游戏账号被盗取,请问我该怎么做
  • ¥15 通关usb3.0.push文件,导致usb频繁断连
  • ¥15 有没有能解决微信公众号,只能实时拍照,没有选择相册上传功能,我不懂任何技术,,有没有给我发个软件就能搞定的方法
  • ¥15 Pythontxt文本可视化
  • ¥15 如何基于Ryu环境下使用scapy包进行数据包构造
  • ¥15 springboot国际化