import pymongo
class dbUtil(object):
def __init__(self, tablename='functional_testing'):
con = pymongo.Connection('localhost', 27017)
self.db = con['test_database']
self.table = self.db[tablename]
def save(self, obj_dict):
self.table.save(obj_dict)
def insert(self, obj_list):
''' insert records in batch or single'''
self.table.insert(obj_list)
def get_by_id(self, idd):
return self.table.find_one({'id':idd})
def get_count(self, condition={}):
return self.table.find(condition).count()
def query(self, condition, sort=[("id",pymongo.ASCENDING)]):
return self.table.find(condition).sort(sort)
def create_index(self, key_list):
''' eg: create_index([("mike", pymongo.DESCENDING), ("eliot", pymongo.ASCENDING)]) '''
self.table.ensure_index(key_list, unique=True)
def remove(self, condition={}):
self.table.remove(condition)
def update(self, condition, data):
self.table.update(condition, {'$set':data}, multi=True)
def drop_table(self):
self.table.drop()
def get_all_collection_names(self):
print self.db.collection_names()
# db = dbUtil()