Mongo分页技巧
提供mongo的各种增删改查操作包括分页
from pymongo import MongoClient from config import MONGODB_HOST,MONGODB_NAME,MONGODB_PORT client = MongoClient(MONGODB_HOST, MONGODB_PORT) client.admin.authenticate("databasesUser",":password",mechanism='SCRAM-SHA-1') db = client[MONGODB_NAME] class CollectionOperation(): def __init__(self,table): self.table = db[table] def add(self,data): result = self.table.insert(data) print(type(result)) return type(result) def delete(self,data): finall = self.table.delete_one(data) return finall def update(self,data,newData): ret = self.table.update_one(data, {"$set": newData}) return ret def get(self,data): ret = [] finall = self.table.find(data) ret1 = list(finall) try: for item in ret1: item.pop('_id') ret.append(item) except: return ret return ret def page(self,num,page): ret = [] finall = self.table.find({}).limit(int(num)).skip(int(page)) ret1 = list(finall) try: for item in ret1: item.pop('_id') ret.append(item) except: return ret下面是配置页
""" 项目 配置文件 """ """"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""" Mongodb 数据库运行参数 """"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""" MONGODB_NAME = '数据库集合的名称' MONGODB_HOST = '数据库ip地址' MONGODB_PORT = 27017 #mongo默认端口下面是mongo建表
from mongo import CollectionOperation """ mongodb数据库的各个集合 """ # 用户信息表 db_user = CollectionOperation('login')