How do you select all records from a mongodb collection in golang using mgo

Question

In MongoDB doing something like db.mycollection.find() returns all documents in a collection.

When working in GoLang using the package labix.org/v2/mgo and I do for example:

query := db.C("client").Find();

It complains that it requires input in the form of an interface. All I need to do is retrieve all documents and iterate through them and display each one for now. How do I achieve this effect? All examples I have seen seem to have filters in place.

Dean · Accepted Answer · 2017-03-11T18:48:14.830

47

Found a solution:

    var results []client

    err := db.C("client").Find(nil).All(&results)
    if err != nil {
        // TODO: Do something about the error
    } else {
        fmt.Println("Results All: ", results) 
    }

edited Mar 11 '17 at 18:48

answered Jul 10 '14 at 16:02

Dean

1,226
2
20
39

16

getting nil from a database is a weak reason to `panic` – bohdan_trotsenko Jul 10 '14 at 16:35
4

however will get the user of the above code to actually read it and decide how to deal with the `nil`. From the perspective of someone coming here and copy/pasting that code being highly likely, this is a good way to get them to at least think about it.... – amlwwalker Apr 20 '16 at 14:37
2

you can use `db.c("client").Find(bson.M{}).All(&result)` – muthukumar selvaraj May 09 '18 at 12:19

score 0 · Answer 2 · answered Oct 17 '18 at 05:58

func (uc UserController) GetUsersList(w http.ResponseWriter,r *http.Request,p httprouter.Params){

var u []models.User
// Fetch user
if err := uc.session.DB("mydb").C("users").Find(nil).All(&u); err != nil {

    w.WriteHeader(404)
    fmt.Println("Results All: ", u) 
    return
}
uj, _ := json.Marshal(u)

w.Header().Set("Content-Type", "application/json")
w.WriteHeader(200)
fmt.Fprintf(w, "%s", uj)

}

How do you select all records from a mongodb collection in golang using mgo

2 Answers2

Linked