## page was renamed from pymongo
= pymongo =
PyMongo is a Python distribution containing tools for working with MongoDB, and is the recommended way to work with MongoDB from Python

[[http://api.mongodb.org/python/current/]]

== Install from source on Slackware ==
 * cd /tmp
 * git clone git://github.com/mongodb/mongo-python-driver.git pymongo
 * cd pymongo/
 * su
 * python setup.py install

== Eclipse - pydev ==
 * Window
 * Preferences
 * pydev
 * interpreter - python
 * Forced builtins
 * new
 * pymongo
 * apply Ok

== Queries ==

=== Query by _id ===
{{{#!highlight python
from bson import ObjectId
import pymongo
import datetime
mongo = pymongo.Connection("mongodb://192.168.1.1:27017/?slaveok=true")
#mongo = pymongo.Connection('192.168.1.1', 27017)
dbx = mongo['dbx']
collx = dbx['collx']

nowx = datetime.datetime.now();
currDay = datetime.datetime(nowx.year,nowx.month,nowx.day,0,0,0,0)

query={'_id':ObjectId(objx.getId()) }
print query
res = collx.find_one(query )            
print res
}}}

== Driver windows Python 2.5 ==
https://pypi.python.org/packages/2.5/p/pymongo/pymongo-2.6.3.win32-py2.5.exe

== datetime.datetime is not JSON serializable ==
{{{#!highlight python
from bson import json_util
import json

json.dumps(anObject, default=json_util.default)
}}}

== Array of objects in pymongo without cursor ==
{{{#!highlight python
import pymongo 
resList= list(collx.find({'keyx':1}) )
}}}


== Query with regular expression ==
http://docs.mongodb.org/manual/reference/operator/query/regex/

{{{#!highlight python
import pymongo 
db.collection.find( { field: /acme.*corp/i } );
db.collection.find( { field: { $regex: 'acme.*corp', $options: 'i' } } );
###############################################

import pymongo 

mongo = pymongo.Connection("mongodb://10.0.0.130:27017/?slaveok=true")    
dbx = mongo['dbx']
collx = dbx['collx']
res=list(collx.find({'type':'typex','sms':{'$regex':'param'}}).sort('_id',1))
}}}

== pymongo 3.4.0 example ==
{{{#!highlight python
import pymongo
mongouri='mongodb://127.0.0.1:27017/?slaveok=true'
print('pymongo version %s '%( pymongo.__version__) ) # 3.4.0
mongo = pymongo.MongoClient(mongouri)
db = mongo.test

print('Database name: %s '%( db.name  ))

print('Collections:')
for col in db.collection_names():
  print('  %s'%(col))

resList= list(db.collx.find({}) )
for item in resList:
  print( item )
}}}