Python script for querying our MMS MongoDB data

gistfile1.py

from pymongo import MongoClient
from bson.code import Code
import json, re



def query():

	database = "mms"
	collection = "mods"
	address = 'beastmachine.local'


	#connect to the database
	client = MongoClient(address)
	db = client[database]
	collection = db[collection]


	#print the count of all collections that have the valueURI but is not empty
	print collection.find({"mods_name.@valueURI":  {"$exists" : True, "$ne" : ""} }).count()

	#print the number of records that have the word Matthew in the title	
	print collection.find({'mods_titleInfo.title':{'$regex': re.compile('.*Matthew.*')  }}).count()


	#loop through all the data and print each record
	#for x in collection.find({"mods_name.@valueURI":  {"$exists" : True, "$ne" : ""} }):

	#	print json.dumps(x,indent=2)


if __name__ == "__main__":

	query()