Created
August 6, 2014 16:15
-
-
Save kkdai/813f1aaf7cd58487472a to your computer and use it in GitHub Desktop.
go- mongoDB mgo insert and query greater than sample
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package main | |
import ( | |
"fmt" | |
"gopkg.in/mgo.v2" | |
"gopkg.in/mgo.v2/bson" | |
) | |
type msg struct { | |
// Msg string `bson:"msg"` | |
Count int `bson:"count"` | |
} | |
// Note: attribute name must be upper-case start. Or it will not save to DB. (could not identical with document (at least one upper-case)) | |
type Book struct { | |
ISBN string | |
TITLE string | |
PRICE int | |
} | |
type Person struct { | |
Name string | |
Phone string | |
} | |
func main() { | |
fmt.Println("Starting connect mongoDB....") | |
session, err := mgo.Dial(SERVER_CONNECT_STRING) | |
if err != nil { | |
panic(err) | |
} | |
defer session.Close() | |
fmt.Println("Connection works....") | |
// Optional. Switch the session to a monotonic behavior. | |
session.SetSafe(&mgo.Safe{}) | |
c := session.DB("MongoTest1").C("books") | |
fmt.Println("Getting Database count....") | |
count, err2 := c.Find(bson.M{}).Count() | |
if err2 != nil { | |
panic(err) | |
} | |
fmt.Printf("total book count = %d\n", count) | |
if count == 0 { | |
err = c.Insert(&Book{"Ale1", "Book1", 35}) | |
err = c.Insert(&Book{"Ale2", "Book2", 20}) | |
err = c.Insert(&Book{"Ale3", "Book3", 40}) | |
err = c.Insert(&Book{"Ale4", "Book4", 15}) | |
err = c.Insert(&Book{"Ale5", "Book5", 55}) | |
err = c.Insert(&Book{"Ale6", "Book6", 45}) | |
} | |
result := Book{} | |
fmt.Println("Getting data....") | |
// Find book which prices is greater than(gt) 40 | |
iter := c.Find(bson.M{"price": bson.M{"$gt": 40}}).Iter() | |
var index = 1 | |
for iter.Next(&result) { | |
fmt.Printf("current result is [%d] result =%+v\n", index, result) | |
index++ | |
} | |
//when search the DB it must all lower-case to avoid any error. | |
if err2 := iter.Close(); err2 != nil { | |
fmt.Printf("No data\n") | |
} else { | |
fmt.Printf("result =%+v\n", result) | |
} | |
} |
42 line - should be panic(err2)
(is panic(err)
now)
How would you go about doing this without bson? i have a situation where a library generates structs for me and it doesn't map bson.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
In other example:
How to insert these values ?