pymongo

 

import pymongo
from pymongo import MongoClient,GEO2D
import sqlite3
import sys
import psycopg2
import ppygis
import cx_Oracle
import datetime
import sys
import os

mongo_url = os.getenv('MONGO_META_URI',
'mongodb://username:passcode@address:50000/admin?replicaSet=rs0')
mongo_meta_data_env = os.getenv('MONGO_META_DB_ENV', 'dbname') # dbname是数据库
mongo_meta_client = MongoClient(mongo_url, authSource='admin',
authMechanism='SCRAM-SHA-1',
localThresholdMS=35)

meta_db = mongo_meta_client[mongo_meta_data_env]
collection = meta_db.mongodata  #mongodata是表

winfo_data = collection.find({},{"id":1,"date":1,"collection":1})#只显示id date collection这三列内容
winfo_data_list = list(winfo_data)##转化为列表