python+MongoDB学习笔记（四）

#coding=utf-8
from bson import ObjectId
from pymongo import MongoClient
from pymongo.cursor import Cursor
import json

m_client = MongoClient("localhost",27017)

mdb = m_client["mydb"]#连接数据库，如果指定的数据库不存在，会自动创建一个

# res =mdb.info.insert([{'name':'小铭同学'},{'name':'小雪'}])
# print(res)
# res =mdb.info.insert_one({'name':'小铭同学'})
# print(res.inserted_id)
# res =mdb.info.insert_many([{'name':'小铭同学'},{'name':'小雪'}])
# print(res.inserted_ids)
# res =mdb.mydb.insert([{'name':123},{'name':456}])    ##增


#res = mdb.info.delete_one({'name':'小雪'})     ##删


# res = mdb.info.update_one({'name':'小铭同学'},{'$set':{"name":"hh"}})
# user = mdb.info.find_one({'name':'小雪'})
# user['age'] =19
# user['hobby'] ='读书'
# print(user)
# res= mdb.info.update_one({'name':'小雪'},{'$set':{'hobby':user.get('hobby')}})  ##改


#query={"$or":[{"name":"pyh"},{"name": "小铭同学"}]}
query={"name":{"$type":2}}
res =list(mdb.mydb.find(query))      ##查

print str(res).decode('unicode-escape').encode('utf-8')
#序列化的过程
for a in res:
    #print a["_id"]
    a["_id"] = str(a.get("_id"))
    # print a["_id"]

res_json = json.dumps(res)
print res_json.decode('unicode-escape').encode('utf-8')