[Database] MongoDB (4) Dot Notation 内嵌对象查询

时间：2010-08-18 来源：※ABeen※

Dot Notation (Reaching into Objects)

查看数据

In [4]: list(t.find())
Out[4]:
[{u'_id': ObjectId('4c6bf0fb421aa90705000000'),
  u'address': {u'city': u'shandong', u'postcode': 350, u'state': u'china'},
  u'age': 28,
  u'email': u'[email protected]',
  u'name': u'abeen'},
 {u'_id': ObjectId('4c6bf125421aa90705000001'),
  u'address': {u'city': u'beijing', u'postcode': 64, u'state': u'china'},
  u'age': 22,
  u'email': u'[email protected]',
  u'name': u'shanshan'}]

查找"address的city"为"shandong"

In [5]: list(t.find({"address.city":"shandong"}))
Out[5]:
[{u'_id': ObjectId('4c6bf0fb421aa90705000000'),
  u'address': {u'city': u'shandong', u'postcode': 350, u'state': u'china'},
  u'age': 28,
  u'email': u'[email protected]',
  u'name': u'abeen'}]

利用嵌入对象信息条件查找(嵌入对象的key和value必须全使用)

In [8]: list(t.find({"address":{"city": "shandong", "postcode": 350, "state": "china"}}))
Out[8]:
[{u'_id': ObjectId('4c6bf0fb421aa90705000000'),
  u'address': {u'city': u'shandong', u'postcode': 350, u'state': u'china'},
  u'age': 28,
  u'email': u'[email protected]',
  u'name': u'abeen'}]

Array Element by Position
数组元素按位置查找

In [24]: list(t.find({"name":"meinv"}))
Out[24]:
[{u'_id': ObjectId('4c6bf67c421aa9075c000000'),
  u'age': 46,
  u'likes': [u'apple', u'grape', u'watermelon'],
  u'name': u'meinv'},
 {u'_id': ObjectId('4c6bf7a4421aa9075c000001'),
  u'age': 46,
  u'comments': [{u'by': u'abeen', u'title': u'this is the title'},
                {u'by': u'shanshan', u'title': u'shuo wo ni shi shi'}],
  u'name': u'meinv'}]

查找爱好的第一项是"grape"的

In [25]: list(t.find({"likes.1": "grape"}))
Out[25]:
[{u'_id': ObjectId('4c6bf67c421aa9075c000000'),
  u'age': 46,
  u'likes': [u'apple', u'grape', u'watermelon'],
  u'name': u'meinv'}]

查找第一条评论是"abeen"发的信息

In [27]: list(t.find({"comments.0.by": "abeen"}))
Out[27]:
[{u'_id': ObjectId('4c6bf7a4421aa9075c000001'),
  u'age': 46,
  u'comments': [{u'by': u'abeen', u'title': u'this is the title'},
                {u'by': u'shanshan', u'title': u'shuo wo ni shi shi'}],
  u'name': u'meinv'}]

Matching with $elemMatch
未完