|
Size: 371
Comment:
|
Size: 2016
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| ## page was renamed from pymongo | |
| Line 6: | Line 7: |
| == Install from source on Slackware== | == Install from source on Slackware == |
| Line 12: | Line 13: |
== 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
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
1 from bson import ObjectId
2 import pymongo
3 import datetime
4 mongo = pymongo.Connection("mongodb://192.168.1.1:27017/?slaveok=true")
5 #mongo = pymongo.Connection('192.168.1.1', 27017)
6 dbx = mongo['dbx']
7 collx = dbx['collx']
8
9 nowx = datetime.datetime.now();
10 currDay = datetime.datetime(nowx.year,nowx.month,nowx.day,0,0,0,0)
11
12 query={'_id':ObjectId(objx.getId()) }
13 print query
14 res = collx.find_one(query )
15 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
Array of objects in pymongo without cursor
Query with regular expression
http://docs.mongodb.org/manual/reference/operator/query/regex/
1 import pymongo
2 db.collection.find( { field: /acme.*corp/i } );
3 db.collection.find( { field: { $regex: 'acme.*corp', $options: 'i' } } );
4 ###############################################
5
6 import pymongo
7
8 mongo = pymongo.Connection("mongodb://10.0.0.130:27017/?slaveok=true")
9 dbx = mongo['dbx']
10 collx = dbx['collx']
11 res=list(collx.find({'type':'typex','sms':{'$regex':'param'}}).sort('_id',1))