下午对数据查询进行了代码测试:
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89 |
package
mainimport
( "crypto/rand" "encoding/hex" "fmt" "labix.org/v2/mgo" "labix.org/v2/mgo/bson" "time")var ( mgoSession *mgo.Session databaseName = "myDB" tbl_person = "persons" tbl_log = "logs")type Person struct { Id string Name string Inserted time.Time}type Log struct { LogId string Log string LogUser mgo.DBRef Inserted time.Time}func main() { session, err := mgo.Dial("localhost:27017") if
err != nil { panic(err) } defer session.Close() session.SetMode(mgo.Monotonic, true) session.DB(databaseName).DropDatabase() c := session.DB(databaseName).C(tbl_person) d := session.DB(databaseName).C(tbl_log) _ = c.Insert(&Person{"111", "ssl1", time.Now()}) _ = c.Insert(&Person{"222", "ssl1", time.Now()}) _ = c.Insert(&Person{"333", "ssl1", time.Now()}) for
i := 0; i < 10; i++ { _ = d.Insert(&Log{GenerateUUID(), "这是一个测试日志", mgo.DBRef{tbl_person, "111", databaseName}, time.Now()}) } for
i := 0; i < 10; i++ { _ = d.Insert(&Log{GenerateUUID(), "这是一个测试日志", mgo.DBRef{tbl_person, "222", databaseName}, time.Now()}) } for
i := 0; i < 10; i++ { _ = d.Insert(&Log{GenerateUUID(), "这是一个测试日志", mgo.DBRef{tbl_person, "333", databaseName}, time.Now()}) } personcount, _ := c.Find(bson.M{}).Count() fmt.Println(personcount) logcount, _ := d.Find(bson.M{}).Count() fmt.Println(logcount) //在这里loguser.$db值未用变量,测试了一下数据库名大小敏感问题,结果结果:数据库区分大小写!!!! //如果是在同一个数据库中,loguser.$db可不写 p1logcount, _ := d.Find(bson.M{"loguser.$ref": tbl_person, "loguser.$id": "111", "loguser.$db": "myDB"}).Count() fmt.Println(p1logcount) result1 := []Log{} err = d.Find(bson.M{}).All(&result1) fmt.Println(result1)}func GenerateUUID() string { uuid := make([]byte, 16) n, err := rand.Read(uuid) if
n != len(uuid) || err != nil { return
"" } uuid[8] = 0x80
// variant bits see page 5 uuid[4] = 0x40
// version 4 Pseudo Random, see page 7 return
hex.EncodeToString(uuid)} |
结果正确:
[ `run` | done: 179.164361ms ] 3 30 10
参考:
原文：http://www.cnblogs.com/forrestsun/p/3533239.html