I am new to Mongo and I have a question about deleting documents using PyMongo. I have a collection called mycollection. It has documents looking like this: { "field1":"value1", "field2":"value2", "array_field": [ "id1", "id2 ] } I want to delete…
I'm trying to connect to mongodb using python and code: myclient = pymongo.MongoClient("mongodb://root:password@mongo:27017/database_sample?authSource=admin") db = myclient.database_sample my_collection = db["database"] but I'm getting pymongo.errors.OperationFailure: Authentication failed., full error: {'ok': 0.0, 'errmsg': 'Authentication failed.', 'code': 18, 'codeName': 'AuthenticationFailed'}
I have a MongoDB collection with 8k+ documents, around 40GB. Inside it, the data follows this format: { _id: ..., _session: { _id: ... }, data: {...} } I need to get all the _session._id for my application. The following…
I was wondering if there was an actually good way to aggregate/calculate percentiles based on all data in a database. For example, data like: { 'name':'John' 'rank':5 }, { 'name':'John' 'rank':4 }, { 'name':'John' 'rank':5 }, { 'name':'James' 'rank':3 },…
api = shodan.Shodan(api_key) query = 'MongoDB Server Information n{ "process": "mongod" port:27017' build_info_arr = [] try: results = api.search(query) print('Total Results: %sn' % results['total']) for result in results['matches']: if "Authentication partially enabled" not in result['data']: print('IP: {}'.format(result['ip_str'])) ip: str =…
I have a a mongo db table in the following format [{"url":"www.example1.com", "name":"hans","age":30}, {"url":"www.example2.com", "name":"x","age":34}, {"url":"www.example3.com", "name":"y","age":35}, {"url":"www.example4.com", "name":"z","age":36}, {"url":"www.example5.com", "name":"b","age":37}] I have two tables where i need to check for under two if conditions. I did in the following…
I have a following mongodb: some records looks like {'_id': ObjectId('62790ce20375a639af1d8676'), 'visit_id': 594817704, 'transaction' : 10} some has only this form: {'_id': ObjectId('62790ce20375a639af1d8679'), 'visit_id': 594817704} Using this code I can search for all collections that consists of transaction_id: collection.find({'transaction_id': {…
This is my first question ever here so super excited to learn and apologies if the syntax is not up to mark, I will improve with time. "item" is an Array ( this doc has only one element) "adjudication" is…
I have the following schema for documents in my collection. Each document corresponds to list all the submissions made by a name. - "_id": ObjectId - "name": str - "is_team": bool - "submissions": List - time: datetime - score: float…
Basically, I have 2 collections in my MongoDB database -> Books, Scores. Books { "BOOK_ID" : "100", "BOOK_NAME" : "Book 1", "BOOK_DESC" : "abcd", }, { "BOOK_ID" : "101", "BOOK_NAME" : "Book 2", "BOOK_DESC" : "efgh", }, { "BOOK_ID" :…