mongoDB分页/模糊查询--python

1. 
   
2. import re
   
3. from pymongo import Connection
   
4. 
   
5. connection = Connection('192.168.1.111', 27017)
   
6. db = connection.friend
   
7. pattern = re.compile(".*keyword.*")
   
8. query = {"uid":uid,\
   
9.         "$or":[{"name":pattern},\
   
10.              {"phone":pattern} ]}
    
11. page = 2
    
12. pagesize=10
    
13. pos = page*pagesize
    
14. rows = db.find(query).skip(pos).limit(pagesize)
    
15. for user in rows:
    
16.     ...
    
17.    ...

2. 
   
3. 命令行方式
4. >db.friend.find({uid:86043283,{$or:[{name:/^张.*/},{phone:/.*99$/}]}})