pymongo-常用语句整理

pymongo-常用语句整理

connection

import re, time, json
from pymongo import MongoClient
MONGO_CONN = MongoClient('127.0.0.1', 27017)
db_auth = MONGO_CONN['admin']
db_auth.authenticate('mongo_user', 'mongo_pswd')

TABLE = MONGO_CONN.DB_NAME.COLLECTION_NAME

insert_one

dict_item = {
	'name' 'hugh',
	'age' '18',
	'gender' 'm',
}
TABLE.insert_one(dict_item)

update

dict_item = {
	'name' 'hugh',
	'age' '18',
	'gender' 'm',
}
dict_query = {'name': 'hugh'}
TABLE.update_one(dict_query , {'$set': dict_item})

select, and, or

dict_query = {'gender': 'f', 'age': 18}
dict_show = {'name':1, 'age': 1}
TABLE.find(dict_query, dict_show).sort('age': -1) # 降序
TABLE.find(dict_query, dict_show).sort('age': 1) # 升序

# and
age > 12 and name like '%user%'
dict_query = {
	'age': {'$gt': 12},
	'name': {re.comple('user')},
}

# or
name = 'hugh' or age > 12
dict_query = {
	'$or': [
		{'name': 'hugh'},
		{'age ': {'$gt': 12}},
	]
}

# 不存在 、 不为空
dict_query = {'name':{'$exists': Flase}}
dict_query = {'name':{'$ne': None}}
TABLE.find(dict_query)

delete 记录

dict_query = {'name': 'hugh'}
# delete_one
TABLE.delete_one(dict_query)
# delete_many
TABLE.delete_many(dict_query)

delete html列字段

$unset - 删除字段

dict_query = {'name': 'hugh'}
dict_delete = {'html': 1}
TABLE.update_one(dict_query , {'$unset': dict_delete})