本文共 1539 字,大约阅读时间需要 5 分钟。
引用PyMongo
创建连接Connection
>>> conn
= pymongo.Connection( ' localhost ' , 27017 ) 或
import
>>> conn
= Connection( ' localhost ' , 27017 ) 创建Connection时,指定host及port参数
连接数据库
或
连接聚集
或
查看全部聚集名称
查看聚集的一条记录
>>> db.Account.find_one()
>>> db.Account.find_one({ " UserName " : " keyword " })
查看聚集的字段
>>> db.Account.find_one({},{ " UserName " : 1 , " Email " : 1 })
{u ' UserName ' : u ' libing ' , u ' _id ' : ObjectId( ' 4ded95c3b7780a774a099b7c ' ), u ' Email ' : u ' libing@35.cn ' }
>>> db.Account.find_one({},{ " UserName " : 1 , " Email " : 1 , " _id " :0})
{u ' UserName ' : u ' libing ' , u ' Email ' : u ' libing@35.cn ' }
查看聚集的多条记录
>>> for item in db.Account.find():
item
>>> for item in db.Account.find({ " UserName " : " libing " }):
item[ " UserName " ]
查看聚集的记录统计
>>> db.Account.find().count()
>>> db.Account.find({ " UserName " : "keyword " }).count()
聚集查询结果排序
>>> db.Account.find().sort( " UserName " ) --默认为升序
>>> db.Account.find().sort( " UserName " ,pymongo.ASCENDING) --升序
>>> db.Account.find().sort( " UserName " ,pymongo.DESCENDING) --降序
聚集查询结果多列排序
>>> db.Account.find().sort([( " UserName " ,pymongo.ASCENDING),( " Email " ,pymongo.DESCENDING)])
添加记录
>>> db.Account.insert({ " AccountID " : 21 , " UserName " : " libing " })
修改记录
>>> db.Account.update({ " UserName " : " libing " },{ " $set " :{ " Email " : " libing@126.com " , " Password " : " 123 " }})
删除记录
>>> db.Account.remove() -- 全部删除
>>> db.Test.remove({ " UserName " : " keyword " })
传送门:
转载地址:http://fakai.baihongyu.com/