本文实例讲述了Python操作MongoDB数据库的方法。分享给大家供大家参考,具体如下:
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
|
>>> import pymongo >>> client = pymongo.MongoClient ( 'localhost' , 27017 ) >>> db = client.students >>> db.collection_names() [ 'students' ] >>> students = db.students >>> students.find() <pymongo.cursor.Cursor object at 0x0000017A74305FD0 > >>> for item in students.find(): print (item) { '_id' : ObjectId( '59394a87ae09c56bd9c1d375' ), 'name' : 'zhangsan' , 'age' : 18.0 , 'sex' : 'male' } >>> wangwu = { 'name' : 'wangwu' , 'age' : 20 , 'sex' : 'male' } >>> students.insert(wangwu) ObjectId( '593a7c5fedb5a1abeb757052' ) >>> for item in students.find({ 'name' : 'wangwu' }): print (item) { '_id' : ObjectId( '593a7c5fedb5a1abeb757052' ), 'name' : 'wangwu' , 'age' : 20 , 'sex' : 'male' } >>> students.find_one() { '_id' : ObjectId( '59394a87ae09c56bd9c1d375' ), 'name' : 'zhangsan' , 'age' : 18.0 , 'sex' : 'male' } >>> students.find_one({ 'name' : 'wangwu' }) { '_id' : ObjectId( '593a7c5fedb5a1abeb757052' ), 'name' : 'wangwu' , 'age' : 20 , 'sex' : 'male' } >>> students.find().count() 2 >>> students.remove({ 'name' : 'wangwu' }) { 'ok' : 1 , 'n' : 1 } >>> for item in students.find(): print (item) { '_id' : ObjectId( '59394a87ae09c56bd9c1d375' ), 'name' : 'zhangsan' , 'age' : 18.0 , 'sex' : 'male' } >>> students.find().count() 1 >>> students.create_index([( 'name' ,pymongo.ASCENDING)]) 'name_1' >>> students.update({ 'name' : 'zhangsan' },{ '$set' :{ 'age' : 25 }}) { 'ok' : 1 , 'nModified' : 1 , 'n' : 1 , 'updatedExisting' : True } >>> students.find_one() { '_id' : ObjectId( '59394a87ae09c56bd9c1d375' ), 'name' : 'zhangsan' , 'age' : 25 , 'sex' : 'male' } >>> students.update({ 'age' : 25 },{ '$set' :{ 'sex' : 'Female' }}) { 'ok' : 1 , 'nModified' : 1 , 'n' : 1 , 'updatedExisting' : True } >>> students.remove() { 'ok' : 1 , 'n' : 1 } >>> students.find().count() 0 >>> zhangsan = { 'name' : 'zhangsan' , 'age' : 25 , 'sex' : 'Male' } >>> lisi = { 'name' : 'lisi' , 'age' : 21 , 'sex' : 'Male' } >>> wangwu = { 'name' : 'wangwu' , 'age' : 22 , 'sex' : 'Female' } >>> students.insert_many([zhangsan,lisi,wangwu]) <pymongo.results.InsertManyResult object at 0x0000017A749FC5E8 > >>> for item in students.find().sort( 'name' ,pymongo.ASCENDING): print (item) { '_id' : ObjectId( '593a806bedb5a1abeb757054' ), 'name' : 'lisi' , 'age' : 21 , 'sex' : 'Male' } { '_id' : ObjectId( '593a806bedb5a1abeb757055' ), 'name' : 'wangwu' , 'age' : 22 , 'sex' : 'Female' } { '_id' : ObjectId( '593a806bedb5a1abeb757053' ), 'name' : 'zhangsan' , 'age' : 25 , 'sex' : 'Male' } >>> for item in students.find().sort([( 'sex' ,pymongo.DESCENDING),( 'name' ,pymongo.ASCENDING)]): print (item) { '_id' : ObjectId( '593a806bedb5a1abeb757054' ), 'name' : 'lisi' , 'age' : 21 , 'sex' : 'Male' } { '_id' : ObjectId( '593a806bedb5a1abeb757053' ), 'name' : 'zhangsan' , 'age' : 25 , 'sex' : 'Male' } { '_id' : ObjectId( '593a806bedb5a1abeb757055' ), 'name' : 'wangwu' , 'age' : 22 , 'sex' : 'Female' } >>> |
希望本文所述对大家Python程序设计有所帮助。
原文链接:http://blog.csdn.net/chengqiuming/article/details/78601256