MongoDB usage in Python
MongoDB for Python
#1 surroundings##
Python3.7.3
pymongo==3.7.2
#1 ready##
from pymongo import MongoClient
#1.1 Link to MongoDB
client =MongoClient('localhost',27017)
#1.2 Link database###
db=client.proxy #proxy is a database name of my MongoDB
#1.3 Connection set (table name)
collection=db.proxytable #proxytable is a collection name of proxy in my MongoDB
#2 operating##
#2.1 Find all data in the collection###
for item in collection.find():print(item) #item is each row of data
#2.2 Find a single data in the collection###
collection.find_one({"port":"8118"}) #Get the first data with port equal to 8118
for foo in collection.find({"port":"8118"}):print(foo)
# Data with port less than 9000 is sorted by ip
# Because my port in MongoDB stores string type data,So when comparing the size,Than the first character,If it is int type data,Normal comparison
for foo in collection.find({"port":{"$lt":"9000"}}).sort("ip"):print(foo)
collection.count() #Statistics collection data
#2.3 Insert data into the collection###
collection.insert({ip:'122.235.240.108',pory:8989})
#2.4 Update the data in the collection, the first brace is the update condition, and the second brace is the content after the update
collection.update({ip:'122.235.240.108'},{port:'8980'})
#2.5 Add index
from pymongo import ASCENDING, DESCENDING
users.create_index([("ip", DESCENDING),("port", ASCENDING)])
# ASCENDING is set to 1 to identify the index in ascending order,-1 descending
#2.6 Delete all data in collection###
collection.remove()
#2.7 Delete collection###
collection.drop()
#2.8 Data output###
mongoexport -d test -c users --csv -f name,age -o e:\python\users.csv
Recommended Posts