dsjj15012 2014-10-24 10:46
浏览 152
已采纳

使用Mgo创建自定义ID

I'm currently starting with GoLang and MongoDB.I'm writing a small web application, a blog to be more specific (which is like the first webapp I write when I try new languages). Everything works fine with MGO even if I had some troubles at first. But now I'd like to access each blog entry (articles will be referred as entries to stick with my models) separately. I could use the ObjectID in the url. But that's damn ugly. For example :
mydomain.com/entries/543fd8940e82533995000002/
That's not user friendly. I did a lot of research on the internet to find a suitable solution, because using any other database engine I could just use the id (and that would be fine).

Could someone help me with the creation of a custom (public) id which would auto-increment when I insert a new entry and that I could use in the url ?

Here is the code of my model for now :

package models

import (
    "time"

    "labix.org/v2/mgo"
    "labix.org/v2/mgo/bson"
)

type (
    Entries []Entry
    Entry   struct {
        ID      bson.ObjectId `bson:"_id,omitempty"`
        Title   string        `bson:"title"`
        Short   string        `bson:"short"`
        Content string        `bson:"content"`
        Posted  time.Time     `bson:"posted"`
    }
)

// Insert an entry to the database
func InsertEntry(database *mgo.Database, entry *Entry) error {
    entry.ID = bson.NewObjectId()
    return database.C("entries").Insert(entry)
}

// Find an entry by id
func GetEntryByID(database *mgo.Database, id string) (entry Entry, err error) {
    bid := bson.ObjectIdHex(id)
    err = database.C("entries").FindId(bid).One(&entry)
    return
}

// Retrieves all the entries
func AllEntries(database *mgo.Database) (entries Entries, err error) {
    err = database.C("entries").Find(nil).All(&entries)
    return
}

// Retrieve all the entries sorted by date.
func AllEntriesByDate(database *mgo.Database) (entries Entries, err error) {
    err = database.C("entries").Find(nil).Sort("-posted").All(&entries)
    return
}

// Counts all the entries.
func CountAllEntries(database *mgo.Database) (count int, err error) {
    count, err = database.C("entries").Find(nil).Count()
    return
}
  • 写回答

1条回答 默认 最新

  • duai1683 2014-10-24 11:04
    关注

    As you know the _id is a mandatory field, that is automatically fill by the driver when you do not set it. This is the behavior that you have in your current application/code. You can find information about this type and its generation here: http://docs.mongodb.org/manual/reference/object-id/

    However, you can create your own _id and set the value to anything that makes sense for your business.

    This is why I am do not understand the following statement:

    I did a lot of research on the internet to find a suitable solution, because using any other database engine I could just use the id (and that would be fine).

    You can use any value you want as soon as it is unique for your collection.

    About the auto-increment, MongoDB does not provide any auto increment field, so you have to implement it yourself, and call the increment from your application.

    For example you create a new collection that contains your "sequences/counters": (showing shell commands not go)

    {
      _id : "entry",
      sequence : 0
    }
    

    Then when you want an new id for your document you have first to update, with a findand modify the document you have created with a simple $inc operation

    var ret = db.counters.findAndModify(
              {
                query: { _id: "entry" },
                update: { $inc: { seq: 1 } },
                new: true
              }
       );
    

    You can then use the returned value into you new document as an _id.

    This pattern is documented here: http://docs.mongodb.org/manual/tutorial/create-an-auto-incrementing-field/

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

报告相同问题?

悬赏问题

  • ¥20 测距传感器数据手册i2c
  • ¥15 RPA正常跑,cmd输入cookies跑不出来
  • ¥15 求帮我调试一下freefem代码
  • ¥15 matlab代码解决,怎么运行
  • ¥15 R语言Rstudio突然无法启动
  • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
  • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法