douhao8456 2019-04-30 12:34
浏览 666
已采纳

在Mongo-go-driver中创建一个唯一字段

I am very new to both Go and Mongodb and was writing my first rest-api with Go and Mongo. I am using mongo-go-driver and have the following Modal struct in Go

type Modal struct {
    Group     []string           `bson:"group" json:"group"`
    Hostname  string             `bson:"hostname" json:"hostname"`
    Overrides map[string]string  `bson:"overrides" json:"overrides"`
    Excludes  []string           `bson:"excludes" json:"excludes"`
}

I do not want to use the default ObjectId field provided by mongo-db as my primary key and instead would like to make the Hostname field as the primary key.

If I make the type of Hostname field as primitive.ObjectID, then the hostname would be unique but its value will be randomly generated string by mongodb and not the actual hostname string value.

So is there a way I can do this.

  • 写回答

1条回答 默认 最新

  • dongtui2029 2019-04-30 12:43
    关注

    You may use a unique index to enforce / allow only distinct values of a given field, e.g.:

    db.collectionname.createIndex( { "hostname": 1 }, { unique: true } )
    

    If you want to create such index using the official MongoDB driver, this is how you can do that:

    indexName, err := coll.Indexes().CreateOne(
        context.Background(),
        IndexModel{
            Keys   : bsonx.Doc{{"hostname", bsonx.Int32(1)}},
            Options: options.Index().SetUnique(true),
        },
    )
    

    But know that in MongoDB each document must have an _id property, so doing the above, documents will have an auto-generated _id field (of ObjectId type). If this doesn't bother you, you're done.

    Also note that you may map Modal.Hostname to the _id field with struct tags:

    type Modal struct {
        Group     []string           `bson:"group" json:"group"`
        Hostname  string             `bson:"_id" json:"hostname"`
        Overrides map[string]string  `bson:"overrides" json:"overrides"`
        Excludes  []string           `bson:"excludes" json:"excludes"`
    }
    

    And again, you're done. The downside of this solution is that the documents in MongoDB will not have a property named hostname, as it will be stored in _id.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥40 求一款能支持ios15以上的屏蔽越狱插件。比较好用的
  • ¥15 C++ QT对比内存字符(形式不定)
  • ¥30 C++第三方库libiconv 远程安装协助
  • ¥15 https://github.com/youlaitech/vue3-element-admin/blob/master/src/store/modules/user.ts 这2句代码如何理解
  • ¥15 duilib开发文本字串超过长度显示
  • ¥20 mysql的.ibd文件为啥那么多
  • ¥15 C++中采用栈和BFS算法求解迷宫问题
  • ¥15 关于#java#的问题:这是跳转失败出现的界面这是哪个出现问题的servlet(开发工具-ide)
  • ¥15 EBS R12费用采购跨月冲销
  • ¥15 python中用mplfinance如何做到多股同列?