Search code examples
stringmongodbgobsonmgo

Insert a mgo query []M.bson result into a file.txt as a string


i have to insert into a file the result of a mgo query MongoDB converted in Go to get the id of images

 var path="/home/Medo/text.txt"

   pipe := cc.Pipe([]bson.M{
              {"$unwind": "$images"}, 
              {"$group": bson.M{"_id": "null", "images":bson.M{"$push": "$images"}}},

              {"$project": bson.M{"_id": 0}}})

    response := []bson.M{}
    errResponse := pipe.All(&response)
    if errResponse != nil {
        fmt.Println("error Response: ",errResponse)
    }
    fmt.Println(response) // to print for making sure that it is working 

    data, err := bson.Marshal(&response)
    s:=string(data)

    if err22 != nil {
        fmt.Println("error insertion ", err22)
    } 

Here is the part where I have to create a file and write on it.

The problem is when I got the result of the query in the text file I got an enumeration values in the last of each value for example:

id of images 
23456678`0`
24578689`1`
23678654`2`
12890762`3`
76543890`4`
64744848`5`

so for each value i got a number sorted in the last , and i can't figure out how , after getting the reponse from the query i converted the Bson to []Byte and then to Stringbut it keeps me getting that enumeration sorted values in the last of each results

I'd like to drop those 0 1 2 3 4 5

    var _, errExistFile = os.Stat(path)

    if os.IsNotExist(errExistFile) {
        var file, errCreateFile = os.Create(path)
        if isError(erro) {
            return
        }
        defer file.Close()
    }

    fmt.Println("==> done creating file", path)
    var file, errii = os.OpenFile(path, os.O_RDWR, 0644)
    if isError(errii) {
        return
    }
    defer file.Close()

    // write some text line-by-line to file
    _, erri := file.WriteString(s)
    if isError(erri) {
        return
    }

    erri = file.Sync()
    if isError(erri) {
        return
    }

    fmt.Println("==> done writing to file")

Solution

  • You could declare a simple struct eg

    simple struct {
      ID    idtype `bson:"_id"`
      Image int    `bson:"images"`
    }
    

    The function to put the image ids into the file would be

    open file stuff…
    
    result := simple{}
    iter := collection.Find(nil).Iter()
    for iter.Next(&result){
     file.WriteString(fmt.Sprintf("%d\n",result.Image))
    }
    iter.Close()