def main():
usage = \
"""
%prog [options] prefix
"""
description = \
"""Use this program to clear databases in couch that match a given prefix
"""
parser = OptionParser(usage=usage, description=description)
parser.add_option("-p", "--port", dest="couch_port", default=5984, help="specify a port for couch", action="store", type=int, metavar="PORT")
parser.add_option("-n", "--host", dest="couch_host", default='localhost', help="The host name or ip address of the couch server", action="store", type=str, metavar="HOST")
parser.add_option("-u", "--user_name", dest="couch_uname", default=None, help="User name for the couch server", action="store", type=str, metavar="UNAME")
parser.add_option("-s", "--password", dest="couch_pword", default=None, help="Password for the couch server", action="store", type=str, metavar="PWORD")
#parser.add_option("-s", "--sysname", dest="sysname", default=None, help="The sysname prefix to clear in couch", action="store", type=str, metavar="SYSNAME")
(options, args) = parser.parse_args()
# Hack to set the user name and password
if len(args) ==0:
print '$ Error: no prefix argument specified'
parser.print_help()
sys.exit()
if len(args) != 1:
print '$ Error: You can not specify multiple prefixes. Received args: %s' % str(args)
parser.print_help()
sys.exit()
prefix = args[0]
if prefix is '':
print '$ Error: You can not give the empty string as a prefix!'
parser.print_help()
sys.exit()
if options.couch_uname is not None:
CFG.server.couchdb.username = options.couch_uname
if options.couch_pword is not None:
CFG.server.couchdb.password = options.couch_pword
db_server = CouchDB_DataStore(host=options.couch_host, port=options.couch_port)
print "$ Connected to couch database @: host %s, port %d" % (options.couch_host, options.couch_port)
db_list = db_server.list_datastores()
for db_name in db_list:
if db_name.startswith(prefix):
db_server.delete_datastore(db_name)
print '$ Cleared couch db named: %s' % db_name
else:
print '$ Ignoring couch db named: %s' % db_name
def get_datastore(self, ds_name, profile=DataStore.DS_PROFILE.BASIC, config=None):
"""
Factory method to get a datastore instance from given name, profile and config.
This is the central point to cache these instances, to decide persistent or mock
and to force clean the store on first use.
@param ds_name Logical name of datastore (will be scoped with sysname)
@param profile One of known constants determining the use of the store
@param config Override config to use
"""
assert ds_name, "Must provide ds_name"
if ds_name in self._datastores:
log.debug("get_datastore(): Found instance of store '%s'" % ds_name)
return self._datastores[ds_name]
scoped_name = ("%s_%s" % (get_sys_name(), ds_name)).lower()
# Imports here to prevent cyclic module dependency
from pyon.core.bootstrap import CFG
config = config or CFG
persistent = not bool(get_safe(config, "system.mockdb"))
force_clean = bool(get_safe(config, "system.force_clean"))
log.info(
"get_datastore(): Create instance of store '%s' {persistent=%s, force_clean=%s, scoped_name=%s}"
% (ds_name, persistent, force_clean, scoped_name)
)
# Persistent (CouchDB) or MockDB?
if persistent:
# Use inline import to prevent circular import dependency
from pyon.datastore.couchdb.couchdb_datastore import CouchDB_DataStore
new_ds = CouchDB_DataStore(datastore_name=scoped_name, profile=profile)
else:
# Use inline import to prevent circular import dependency
from pyon.datastore.mockdb.mockdb_datastore import MockDB_DataStore
new_ds = MockDB_DataStore(datastore_name=scoped_name) # , profile=profile)
# Clean the store instance
if force_clean:
try:
new_ds.delete_datastore(scoped_name)
except NotFound as nf:
pass
# Create store if not existing
if not new_ds.datastore_exists(scoped_name):
new_ds.create_datastore(scoped_name)
# Set a few standard datastore instance fields
new_ds.local_name = ds_name
new_ds.ds_profile = profile
self._datastores[ds_name] = new_ds
return new_ds
def get_datastore_instance(cls, ds_name, profile=DataStore.DS_PROFILE.BASIC):
scoped_name = DatastoreManager.get_scoped_name(ds_name)
# Use inline import to prevent circular import dependency
from pyon.datastore.couchdb.couchdb_datastore import CouchDB_DataStore
new_ds = CouchDB_DataStore(datastore_name=scoped_name, profile=profile)
return new_ds
def _force_clean(self, recreate=False):
from pyon.core.bootstrap import get_sys_name
datastore = CouchDB_DataStore()
dbs = datastore.list_datastores()
things_to_clean = filter(
lambda x: x.startswith('%s_' % get_sys_name()), dbs)
try:
for thing in things_to_clean:
datastore.delete_datastore(datastore_name=thing)
if recreate:
datastore.create_datastore(datastore_name=thing)
finally:
datastore.close()
def _force_clean(self, recreate=False):
from pyon.core.bootstrap import get_sys_name
datastore = CouchDB_DataStore()
dbs = datastore.list_datastores()
things_to_clean = filter(lambda x: x.startswith('%s_' % get_sys_name()), dbs)
try:
for thing in things_to_clean:
datastore.delete_datastore(datastore_name=thing)
if recreate:
datastore.create_datastore(datastore_name=thing)
finally:
datastore.close()
def _force_clean(self, recreate=False):
from pyon.core.bootstrap import get_sys_name
from pyon.datastore.datastore import DatastoreManager
if DatastoreManager.persistent is None:
DatastoreManager.persistent = not CFG.system.mockdb
if not DatastoreManager.persistent:
datastore = MockDB_DataStore()
else:
datastore = CouchDB_DataStore()
dbs = datastore.list_datastores()
things_to_clean = filter(
lambda x: x.startswith('%s_' % get_sys_name()), dbs)
try:
for thing in things_to_clean:
datastore.delete_datastore(datastore_name=thing)
if recreate:
datastore.create_datastore(datastore_name=thing)
finally:
datastore.close()
def get_datastore_instance(cls,
ds_name,
persistent=None,
profile=DataStore.DS_PROFILE.BASIC):
scoped_name = DatastoreManager.get_scoped_name(ds_name)
# Imports here to prevent cyclic module dependency
from pyon.core.bootstrap import CFG
if persistent is None:
persistent = not bool(get_safe(CFG, "system.mockdb"))
# Persistent (CouchDB) or MockDB?
if persistent:
# Use inline import to prevent circular import dependency
from pyon.datastore.couchdb.couchdb_datastore import CouchDB_DataStore
new_ds = CouchDB_DataStore(datastore_name=scoped_name,
profile=profile)
else:
# Use inline import to prevent circular import dependency
from pyon.datastore.mockdb.mockdb_datastore import MockDB_DataStore
new_ds = MockDB_DataStore(datastore_name=scoped_name)
return new_ds
def test_persistent(self):
import socket
try:
ds = CouchDB_DataStore(datastore_name="ion_test_ds", profile=DataStore.DS_PROFILE.RESOURCES)
self._do_test(ds)
# CouchDB does not like upper case characters for database names
with self.assertRaises(BadRequest):
ds.create_datastore("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.delete_datastore("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.info_datastore("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.list_objects("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.list_object_revisions("badid", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.create_doc({"foo": "bar"}, "", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.read_doc("badid", "3", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.read_doc_mult("badid", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.update_doc({"foo": "bar"}, "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.delete_doc("badid", "BadDataStoreNamePerCouchDB")
self._do_test_views(
CouchDB_DataStore(datastore_name="ion_test_ds", profile=DataStore.DS_PROFILE.RESOURCES),
is_persistent=True,
)
except socket.error:
raise SkipTest("Failed to connect to CouchDB")
def test_persistent(self):
import socket
try:
ds = CouchDB_DataStore(datastore_name='ion_test_ds',
profile=DataStore.DS_PROFILE.RESOURCES)
self._do_test(ds)
# CouchDB does not like upper case characters for database names
with self.assertRaises(BadRequest):
ds.create_datastore("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.delete_datastore("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.info_datastore("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.list_objects("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.list_object_revisions("badid", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.create_doc({"foo": "bar"}, "", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.read_doc("badid", "3", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.read_doc_mult("badid", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.update_doc({"foo": "bar"}, "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.delete_doc("badid", "BadDataStoreNamePerCouchDB")
self._do_test_views(CouchDB_DataStore(
datastore_name='ion_test_ds',
profile=DataStore.DS_PROFILE.RESOURCES),
is_persistent=True)
except socket.error:
raise SkipTest('Failed to connect to CouchDB')
def test_datastore_basic(self):
data_store = CouchDB_DataStore(datastore_name='ion_test_ds', profile=DataStore.DS_PROFILE.RESOURCES)
self.data_store = data_store
self.resources = {}
# Just in case previous run failed without cleaning up,
# delete data store
data_store.delete_datastore()
# Create should succeed and not throw error
data_store.create_datastore()
# Create should throw exception the second time
with self.assertRaises(BadRequest):
data_store.create_datastore()
# Call ops with wrong object type and make sure exception is thrown
with self.assertRaises(BadRequest):
data_store.create({"foo": "bar"})
with self.assertRaises(BadRequest):
data_store.create_mult([{"foo": "bar"}])
with self.assertRaises(BadRequest):
data_store.read({"foo": "bar"})
with self.assertRaises(BadRequest):
data_store.read_mult([{"foo": "bar"}])
with self.assertRaises(BadRequest):
data_store.update({"foo": "bar"})
with self.assertRaises(BadRequest):
data_store.delete({"foo": "bar"})
# Should see new data
self.assertIn('ion_test_ds', data_store.list_datastores())
# Something should be returned
self.assertTrue(data_store.info_datastore() is not None)
res = data_store.list_objects()
numcoredocs = len(res)
# Construct user role objects
admin_role = {
"name":"Admin",
"description":"Super user"
}
admin_role_obj = IonObject('UserRole', admin_role)
admin_role_tuple = data_store.create(admin_role_obj)
self.assertTrue(len(admin_role_tuple) == 2)
admin_role_ooi_id = admin_role_tuple[0]
data_provider_role = {
"name":"Data Provider",
"description":"User allowed to ingest data sets"
}
data_provider_role_obj = IonObject('UserRole', data_provider_role)
data_provider_role_tuple = data_store.create(data_provider_role_obj)
self.assertTrue(len(data_provider_role_tuple) == 2)
data_provider_role_ooi_id = data_provider_role_tuple[0]
marine_operator_role = {
"name":"Marine Operator",
"description":"User allowed to administer instruments"
}
marine_operator_role_obj = IonObject('UserRole', marine_operator_role)
marine_operator_role_tuple = data_store.create(marine_operator_role_obj)
self.assertTrue(len(marine_operator_role_tuple) == 2)
marine_operator_role_ooi_id = marine_operator_role_tuple[0]
role_objs = data_store.read_mult([admin_role_ooi_id, data_provider_role_ooi_id, marine_operator_role_ooi_id])
self.assertTrue(len(role_objs) == 3)
self.assertTrue(role_objs[0]._id == admin_role_ooi_id)
self.assertTrue(role_objs[1]._id == data_provider_role_ooi_id)
self.assertTrue(role_objs[2]._id == marine_operator_role_ooi_id)
# Construct three user info objects and assign them roles
hvl_contact_info = {
"individual_names_given": "Heitor Villa-Lobos",
"email": "*****@*****.**",
"variables": [
{"name": "Claim To Fame", "value": "Legendary Brazilian composer"}
]
}
hvl_contact_info_obj = IonObject('ContactInformation', hvl_contact_info)
hvl_user_info = {
"name": "Heitor Villa-Lobos",
"contact": hvl_contact_info_obj
}
hvl_user_info_obj = IonObject('UserInfo', hvl_user_info)
hvl_user_info_tuple = data_store.create(hvl_user_info_obj)
self.assertTrue(len(hvl_user_info_tuple) == 2)
heitor_villa_lobos_ooi_id = hvl_user_info_tuple[0]
ats_contact_info = {
"individual_names_given": "Andres Torres Segovia",
"email": "*****@*****.**",
"variables": [
{"name": "Claim To Fame", "value": "Legendary Concert Guitarist"}
]
}
ats_contact_info_obj = IonObject('ContactInformation', ats_contact_info)
ats_user_info = {
"name": "Andres Torres Segovia",
"contact": ats_contact_info_obj
}
ats_user_info_obj = IonObject('UserInfo', ats_user_info)
ats_user_info_tuple = data_store.create(ats_user_info_obj)
self.assertTrue(len(ats_user_info_tuple) == 2)
pok_contact_info = {
"individual_names_given": "Per-Olov Kindgren",
"email": "*****@*****.**",
"variables": [
{"name": "Claim To Fame", "value": "Composer and YouTube star"}
]
}
pok_contact_info_obj = IonObject('ContactInformation', pok_contact_info)
pok_user_info = {
"name": "Per-Olov Kindgren",
"contact": pok_contact_info_obj
}
pok_user_info_obj = IonObject('UserInfo', pok_user_info)
pok_user_info_tuple = data_store.create(pok_user_info_obj)
self.assertTrue(len(pok_user_info_tuple) == 2)
# List all objects in data store and confirm there are six docs
res = data_store.list_objects()
# There are indices. Therefore can't could all docs
self.assertTrue(len(res) == 6 + numcoredocs)
# Create an Ion object with default values set (if any)
data_set = IonObject('Dataset')
self.assertTrue(isinstance(data_set, interface.objects.Dataset))
# Assign values to object fields
data_set.description = "Real-time water data for Choptank River near Greensboro, MD"
# Write Dataset object"
write_tuple_1 = data_store.create(data_set)
self.assertTrue(len(write_tuple_1) == 2)
# Save off the object UUID
data_set_uuid = write_tuple_1[0]
# Read back the HEAD version of the object and validate fields
data_set_read_obj = data_store.read(data_set_uuid)
self.assertTrue(data_set_read_obj._id == data_set_uuid)
self.assertTrue(isinstance(data_set_read_obj, interface.objects.Dataset))
self.assertTrue(data_set_read_obj.description == "Real-time water data for Choptank River near Greensboro, MD")
self.assertTrue('type_' in data_set_read_obj)
# Update Dataset's Description field and write
data_set_read_obj.description = "Updated Description"
write_tuple_2 = data_store.update(data_set_read_obj)
self.assertTrue(len(write_tuple_2) == 2)
# Retrieve the updated Dataset
data_set_read_obj_2 = data_store.read(data_set_uuid)
self.assertTrue(data_set_read_obj_2._id == data_set_uuid)
self.assertTrue(data_set_read_obj_2.description == "Updated Description")
# List all the revisions of Dataset in data store, should be two
res = data_store.list_object_revisions(data_set_uuid)
self.assertTrue(len(res) == 2)
# Do another update to the object
data_set_read_obj_2.description = "USGS instantaneous value data for station 01491000"
write_tuple_3 = data_store.update(data_set_read_obj_2)
# List revisions of Dataset in data store, should now be three
res = data_store.list_object_revisions(data_set_uuid)
self.assertTrue(len(res) == 3)
# Retrieve original version of Dataset
obj1 = data_store.read(data_set_uuid, rev_id=write_tuple_1[1])
self.assertTrue(obj1._id == data_set_uuid)
self.assertTrue(obj1.description == "Real-time water data for Choptank River near Greensboro, MD")
# Retrieve second version of Dataset
obj2 = data_store.read(data_set_uuid, rev_id=write_tuple_2[1])
self.assertTrue(obj2._id == data_set_uuid)
self.assertTrue(obj2.description == "Updated Description")
# Retrieve third version of Dataset
obj3 = data_store.read(data_set_uuid, rev_id=write_tuple_3[1])
self.assertTrue(obj3._id == data_set_uuid)
self.assertTrue(obj3.description == "USGS instantaneous value data for station 01491000")
# Retrieve HEAD version of Dataset
head = data_store.read(data_set_uuid)
self.assertTrue(head._id == data_set_uuid)
self.assertTrue(head.description == "USGS instantaneous value data for station 01491000")
# Delete Dataset by object id
data_store.delete(head)
# Try to re-delete Dataset by object id. Should throw exception.
with self.assertRaises(NotFound):
data_store.delete(head._id)
# List all objects in data store, should be back to six
res = data_store.list_objects()
self.assertTrue(len(res) == 6 + numcoredocs)
# List revisions of now deleted Dataset, should be empty list
res = data_store.list_object_revisions(data_set_uuid)
self.assertTrue(len(res) == 0)
o1 = IonObject("Dataset", name="One more")
o2 = IonObject("Dataset", name="Another one")
res = data_store.create_mult((o1, o2))
self.assertTrue(all([success for success, oid, rev in res]))
res = data_store.list_objects()
self.assertTrue(len(res) == 8 + numcoredocs)
# Delete data store to clean up
data_store.delete_datastore()
# Assert data store is now gone
self.assertNotIn('ion_test_ds', data_store.list_datastores())
def test_datastore_views(self):
data_store = CouchDB_DataStore(datastore_name='ion_test_ds', profile=DataStore.DS_PROFILE.RESOURCES)
self.data_store = data_store
self.resources = {}
# Just in case previous run failed without cleaning up,
# delete data store
try:
data_store.delete_datastore()
except NotFound:
pass
# Create should succeed and not throw exception
data_store.create_datastore()
res = data_store.list_objects()
numcoredocs = len(res)
self.assertTrue(numcoredocs > 1)
data_store._update_views()
# HACK: Both Predicates so that this test works
from pyon.ion.resource import Predicates
Predicates[OWNER_OF] = dict(domain=[RT.ActorIdentity], range=[RT.InstrumentDevice, RT.Dataset])
Predicates[HAS_A] = dict(domain=[RT.Resource], range=[RT.Resource])
Predicates[BASED_ON] = dict(domain=[RT.Dataset], range=[RT.Dataset])
admin_user_id = self._create_resource(RT.ActorIdentity, 'John Doe', description='Marine Operator', lcstate=LCS.DEPLOYED, availability=AS.AVAILABLE)
admin_profile_id = self._create_resource(RT.UserInfo, 'J.D. Profile', description='Some User',
contact=IonObject('ContactInformation', **{"individual_names_given": "John Doe",
"email": "*****@*****.**"}))
other_user_id = self._create_resource(RT.ActorIdentity, 'Paul Smithy', description='Other user')
plat1_obj_id = self._create_resource(RT.PlatformDevice, 'Buoy1', description='My Platform')
inst1_obj_id = self._create_resource(RT.InstrumentDevice, 'CTD1', description='My Instrument')
inst2_obj_id = self._create_resource(RT.InstrumentDevice, 'CTD2', description='Other Instrument')
ds1_obj_id = self._create_resource(RT.Dataset, 'DS_CTD_L0', description='My Dataset CTD L0', lcstate=LCS.DEPLOYED, availability=AS.AVAILABLE)
ds2_obj_id = self._create_resource(RT.Dataset, 'DS_CTD_L1', description='My Dataset CTD L1')
aid1, _ = data_store.create_association(admin_user_id, OWNER_OF, inst1_obj_id)
data_store.create_association(admin_user_id, HAS_A, admin_profile_id)
data_store.create_association(admin_user_id, OWNER_OF, ds1_obj_id)
data_store.create_association(other_user_id, OWNER_OF, inst2_obj_id)
data_store.create_association(plat1_obj_id, HAS_A, inst1_obj_id)
data_store.create_association(inst1_obj_id, HAS_A, ds1_obj_id)
data_store.create_association(ds1_obj_id, BASED_ON, ds1_obj_id)
with self.assertRaises(BadRequest) as cm:
data_store.create_association(ds1_obj_id, BASED_ON, ds1_obj_id)
self.assertTrue(cm.exception.message.startswith("Association between"))
# Subject -> Object direction
obj_ids1, obj_assocs1 = data_store.find_objects(admin_user_id, id_only=True)
self.assertEquals(len(obj_ids1), 3)
self.assertEquals(len(obj_assocs1), 3)
self.assertEquals(set(obj_ids1), set([inst1_obj_id, ds1_obj_id, admin_profile_id]))
obj_ids1n, obj_assocs1n = data_store.find_objects("Non_Existent", id_only=True)
self.assertEquals(len(obj_ids1n), 0)
self.assertEquals(len(obj_assocs1n), 0)
obj_ids1a, obj_assocs1a = data_store.find_objects(admin_user_id, id_only=False)
self.assertEquals(len(obj_ids1a), 3)
self.assertEquals(len(obj_assocs1a), 3)
self.assertEquals(set([o._id for o in obj_ids1a]), set([inst1_obj_id, ds1_obj_id, admin_profile_id]))
self.assertEquals(set([type(o).__name__ for o in obj_ids1a]), set([RT.UserInfo, RT.InstrumentDevice, RT.Dataset]))
obj_ids1an, obj_assocs1an = data_store.find_objects("Non_Existent", id_only=False)
self.assertEquals(len(obj_ids1an), 0)
self.assertEquals(len(obj_assocs1an), 0)
obj_ids2, obj_assocs2 = data_store.find_objects(admin_user_id, OWNER_OF, id_only=True)
self.assertEquals(len(obj_ids2), 2)
self.assertEquals(len(obj_assocs2), 2)
self.assertEquals(set(obj_ids2), set([inst1_obj_id, ds1_obj_id]))
obj_ids3, _ = data_store.find_objects(admin_user_id, OWNER_OF, RT.InstrumentDevice, id_only=True)
self.assertEquals(len(obj_ids3), 1)
self.assertEquals(obj_ids3[0], inst1_obj_id)
# Object -> Subject direction
sub_ids1, sub_assoc1 = data_store.find_subjects(None, None, inst1_obj_id, id_only=True)
self.assertEquals(len(sub_ids1), 2)
self.assertEquals(len(sub_assoc1), 2)
self.assertEquals(set(sub_ids1), set([admin_user_id, plat1_obj_id]))
sub_ids1a, sub_assoc1a = data_store.find_subjects(None, None, inst1_obj_id, id_only=False)
self.assertEquals(len(sub_ids1a), 2)
self.assertEquals(len(sub_assoc1a), 2)
self.assertEquals(set([o._id for o in sub_ids1a]), set([admin_user_id, plat1_obj_id]))
sub_ids1an, sub_assoc1an = data_store.find_subjects(None, None, "Non_Existent", id_only=False)
self.assertEquals(len(sub_ids1an), 0)
self.assertEquals(len(sub_assoc1an), 0)
sub_ids2, sub_assoc2 = data_store.find_subjects(None, OWNER_OF, inst1_obj_id, id_only=True)
self.assertEquals(len(sub_ids2), 1)
self.assertEquals(len(sub_assoc2), 1)
self.assertEquals(set(sub_ids2), set([admin_user_id]))
sub_ids3, _ = data_store.find_subjects(RT.ActorIdentity, OWNER_OF, inst1_obj_id, id_only=True)
self.assertEquals(len(sub_ids3), 1)
self.assertEquals(set(sub_ids3), set([admin_user_id]))
data_store._update_views()
# Find all resources
res_ids1, res_assoc1 = data_store.find_res_by_type(None, None, id_only=True)
self.assertEquals(len(res_ids1), 8)
self.assertEquals(len(res_assoc1), 8)
# Find resources by type
res_ids1, res_assoc1 = data_store.find_res_by_type(RT.ActorIdentity, id_only=True)
self.assertEquals(len(res_ids1), 2)
self.assertEquals(len(res_assoc1), 2)
self.assertEquals(set(res_ids1), set([admin_user_id, other_user_id]))
res_ids1a, res_assoc1a = data_store.find_res_by_type(RT.ActorIdentity, id_only=False)
self.assertEquals(len(res_ids1a), 2)
self.assertEquals(len(res_assoc1a), 2)
self.assertEquals(set([o._id for o in res_ids1a]), set([admin_user_id, other_user_id]))
res_ids2n, res_assoc2n = data_store.find_res_by_type("NONE##", id_only=True)
self.assertEquals(len(res_ids2n), 0)
self.assertEquals(len(res_assoc2n), 0)
# Find resources by lcstate
res_ids1, res_assoc1 = data_store.find_res_by_lcstate(LCS.DEPLOYED, id_only=True)
self.assertEquals(len(res_ids1), 2)
self.assertEquals(len(res_assoc1), 2)
self.assertEquals(set(res_ids1), set([admin_user_id, ds1_obj_id]))
res_ids1a, res_assoc1a = data_store.find_res_by_lcstate(lcstate(LCS.DEPLOYED, AS.AVAILABLE), id_only=False)
self.assertEquals(len(res_ids1a), 2)
self.assertEquals(len(res_assoc1a), 2)
self.assertEquals(set([o._id for o in res_ids1a]), set([admin_user_id, ds1_obj_id]))
self.assertEquals(set([type(o).__name__ for o in res_ids1a]), set([RT.ActorIdentity, RT.Dataset]))
res_ids2, res_assoc2 = data_store.find_res_by_lcstate( AS.AVAILABLE, RT.ActorIdentity, id_only=True)
self.assertEquals(len(res_ids2), 1)
self.assertEquals(len(res_assoc2), 1)
self.assertEquals(set(res_ids2), set([admin_user_id]))
# Find resources by name
res_ids1, res_assoc1 = data_store.find_res_by_name('CTD1', id_only=True)
self.assertEquals(len(res_ids1), 1)
self.assertEquals(len(res_assoc1), 1)
self.assertEquals(set(res_ids1), set([inst1_obj_id]))
res_ids1a, res_assoc1a = data_store.find_res_by_name('CTD2', id_only=False)
self.assertEquals(len(res_ids1a), 1)
self.assertEquals(len(res_assoc1a), 1)
self.assertEquals(set([o._id for o in res_ids1a]), set([inst2_obj_id]))
self.assertEquals(set([type(o).__name__ for o in res_ids1a]), set([RT.InstrumentDevice]))
res_ids2, res_assoc2 = data_store.find_res_by_name( 'John Doe', RT.ActorIdentity, id_only=True)
self.assertEquals(len(res_ids2), 1)
self.assertEquals(len(res_assoc2), 1)
self.assertEquals(set(res_ids2), set([admin_user_id]))
res_ids2n, res_assoc2n = data_store.find_res_by_name("NONE##", "XXXXX", id_only=True)
self.assertEquals(len(res_ids2n), 0)
self.assertEquals(len(res_assoc2n), 0)
# Find associations by triple
assocs = data_store.find_associations(admin_user_id, OWNER_OF, inst1_obj_id, id_only=True)
self.assertEquals(len(assocs), 1)
self.assertEquals(assocs[0], aid1)
assocs = data_store.find_associations(admin_user_id, OWNER_OF, inst1_obj_id, id_only=False)
self.assertEquals(len(assocs), 1)
self.assertEquals(type(assocs[0]).__name__, "Association")
assocs = data_store.find_associations(admin_user_id, None, inst1_obj_id, id_only=True)
self.assertEquals(len(assocs), 1)
self.assertEquals(assocs[0], aid1)
assocs = data_store.find_associations(subject=inst1_obj_id, id_only=True)
self.assertEquals(len(assocs), 1)
assocs = data_store.find_associations(obj=inst1_obj_id, id_only=True)
self.assertEquals(len(assocs), 2)
assocs = data_store.find_associations(None, OWNER_OF, None, id_only=True)
self.assertEquals(len(assocs), 3)
assocs = data_store.find_associations(anyside=inst1_obj_id, id_only=True)
self.assertEquals(len(assocs), 3)
assocs = data_store.find_associations(anyside=inst1_obj_id, predicate=HAS_A, id_only=True)
self.assertEquals(len(assocs), 2)
assocs = data_store.find_associations(anyside=[inst1_obj_id,other_user_id], id_only=True)
self.assertEquals(len(assocs), 4)
assocs = data_store.find_associations(anyside=[[inst1_obj_id, HAS_A], [other_user_id, OWNER_OF]], id_only=True)
self.assertEquals(len(assocs), 3)
assocs = data_store.find_associations(anyside=[(inst1_obj_id, HAS_A), (other_user_id, OWNER_OF)], id_only=True)
self.assertEquals(len(assocs), 3)
# Test regression bug: Inherited resources in associations
idev1_obj_id = self._create_resource(RT.InstrumentDevice, 'id1', description='')
iag1_obj_id = self._create_resource(RT.InstrumentAgentInstance, 'ia1', description='')
data_store.create_association(idev1_obj_id, PRED.hasAgentInstance, iag1_obj_id)
att1 = self._create_resource(RT.Attachment, 'att1', keywords=[])
att2 = self._create_resource(RT.Attachment, 'att2', keywords=['FOO'])
att3 = self._create_resource(RT.Attachment, 'att3', keywords=['BAR','FOO'])
res_list,key_list = data_store.find_resources_ext(restype="NONE", keyword="FOO")
self.assertEqual(len(res_list), 0)
res_list,key_list = data_store.find_resources_ext(keyword="FOO")
self.assertEqual(len(res_list), 2)
res_list,key_list = data_store.find_resources_ext(restype=RT.Attachment, keyword="FOO")
self.assertEqual(len(res_list), 2)
res_list,key_list = data_store.find_resources_ext(restype=RT.Attachment, keyword="FOO", limit=1)
self.assertEqual(len(res_list), 1)
res_list,key_list = data_store.find_resources_ext(restype=RT.Attachment, keyword="FOO", limit=1, skip=1)
self.assertEqual(len(res_list), 1)
res_list,key_list = data_store.find_resources_ext(restype="NONE", nested_type="ContactInformation")
self.assertEqual(len(res_list), 0)
res_list,key_list = data_store.find_resources_ext(nested_type="ContactInformation")
self.assertEqual(len(res_list), 1)
res_list,key_list = data_store.find_resources_ext(restype=RT.UserInfo, nested_type="ContactInformation", id_only=False)
self.assertEqual(len(res_list), 1)
self.assertEqual(res_list[0]._get_type(), RT.UserInfo)
# Find by attribute
admin_user2_id = self._create_resource(RT.UserInfo, 'Other User',
contact=IonObject('ContactInformation', **{"individual_names_given": "Frank",
"email": "*****@*****.**"}),
alt_ids=["ALT_ID1"])
admin_user3_id = self._create_resource(RT.UserInfo, 'Different User',
contact=IonObject('ContactInformation', **{"individual_names_given": "Frank",
"email": "*****@*****.**"}),
alt_ids=["NS1:ALT_ID2", "ALT_ID2"])
res_list,key_list = data_store.find_resources(restype="UserInfo")
self.assertEqual(len(res_list), 3)
res_list,key_list = data_store.find_resources_ext(restype="UserInfo", attr_name="contact.email")
self.assertEqual(len(res_list), 3)
res_list,key_list = data_store.find_resources_ext(restype="UserInfo", attr_name="contact.email", attr_value="*****@*****.**")
self.assertEqual(len(res_list), 1)
res_list,key_list = data_store.find_resources_ext(restype="UserInfo", attr_name="contact.email", attr_value="DOES NOT EXIST")
self.assertEqual(len(res_list), 0)
# Find by alternate id
res_list,key_list = data_store.find_resources_ext(alt_id="ALT_ID1")
self.assertEqual(len(res_list), 1)
res_list,key_list = data_store.find_resources_ext(alt_id="ALT_ID2")
self.assertEqual(len(res_list), 2)
res_list,key_list = data_store.find_resources_ext(alt_id="ALT_ID2", alt_id_ns="NS1")
self.assertEqual(len(res_list), 1)
res_list,key_list = data_store.find_resources_ext(alt_id="ALT_ID2", alt_id_ns="_")
self.assertEqual(len(res_list), 1)
res_list,key_list = data_store.find_resources_ext(alt_id="ALT_ID2", alt_id_ns="BULL")
self.assertEqual(len(res_list), 0)
res_list,key_list = data_store.find_resources_ext(alt_id=None, alt_id_ns="NS1")
self.assertEqual(len(res_list), 1)
res_list,key_list = data_store.find_resources_ext(alt_id=None, alt_id_ns="_", id_only=True)
self.assertEqual(len(res_list), 2)
res_list,key_list = data_store.find_resources_ext(alt_id=None, alt_id_ns="_", id_only=False)
self.assertEqual(len(res_list), 2)
def test_datastore_attach(self):
data_store = CouchDB_DataStore(datastore_name='ion_test_ds', profile=DataStore.DS_PROFILE.RESOURCES)
self.data_store = data_store
self.resources = {}
# Create an Ion object with default values set (if any)
data_set = IonObject('Dataset')
self.assertTrue(isinstance(data_set, interface.objects.Dataset))
# Assign values to object fields
data_set.description = "Real-time water data for Choptank River near Greensboro, MD"
# Write Dataset object"
write_tuple_1 = data_store.create(data_set)
# Save off the object UUID
data_set_uuid = write_tuple_1[0]
# Read back the HEAD version of the object
data_set_read_obj = data_store.read(data_set_uuid)
# Update Dataset's Description field and write
data_set_read_obj.description = "Updated Description"
write_tuple_2 = data_store.update(data_set_read_obj)
# test attachment related stuff
# create attachment
ds_id_and_rev = {}
attachment_name = 'resource.attachment'
ds_id_and_rev['_id'] = write_tuple_2[0]
ds_id_and_rev['_rev'] = write_tuple_2[1]
data = "\x89PNG\r\n\x1a\n\x00\x00\x00\rIHDR\x00\x00\x00\x10\x00\x00\x00\x10\x08\x03\x00\x00\x00(-\x0fS\x00\x00\x00\x03sBIT\x08\x08\x08\xdb\xe1O\xe0\x00\x00\x00~PLTEf3\x00\xfc\xf7\xe0\xee\xcc\x00\xd3\xa0\x00\xcc\x99\x00\xec\xcdc\x9fl\x00\xdd\xb2\x00\xff\xff\xff|I\x00\xf9\xdb\x00\xdd\xb5\x19\xd9\xad\x10\xb6\x83\x00\xf8\xd6\x00\xf2\xc5\x00\xd8\xab\x00n;\x00\xff\xcc\x00\xd6\xa4\t\xeb\xb8\x00\x83Q\x00\xadz\x00\xff\xde\x00\xff\xd6\x00\xd6\xa3\x00\xdf\xaf\x00\xde\xad\x10\xbc\x8e\x00\xec\xbe\x00\xec\xd4d\xff\xe3\x00tA\x00\xf6\xc4\x00\xf6\xce\x00\xa5u\x00\xde\xa5\x00\xf7\xbd\x00\xd6\xad\x08\xdd\xaf\x19\x8cR\x00\xea\xb7\x00\xee\xe9\xdf\xc5\x00\x00\x00\tpHYs\x00\x00\n\xf0\x00\x00\n\xf0\x01B\xac4\x98\x00\x00\x00\x1ctEXtSoftware\x00Adobe Fireworks CS4\x06\xb2\xd3\xa0\x00\x00\x00\x15tEXtCreation Time\x0029/4/09Oq\xfdE\x00\x00\x00\xadIDAT\x18\x95M\x8f\x8d\x0e\x820\x0c\x84;ZdC~f\x07\xb2\x11D\x86\x89\xe8\xfb\xbf\xa0+h\xe2\x97\\\xd2^\x93\xb6\x07:1\x9f)q\x9e\xa5\x06\xad\xd5\x13\x8b\xac,\xb3\x02\x9d\x12C\xa1-\xef;M\x08*\x19\xce\x0e?\x1a\xeb4\xcc\xd4\x0c\x831\x87V\xca\xa1\x1a\xd3\x08@\xe4\xbd\xb7\x15P;\xc8\xd4{\x91\xbf\x11\x90\xffg\xdd\x8di\xfa\xb6\x0bs2Z\xff\xe8yg2\xdc\x11T\x96\xc7\x05\xa5\xef\x96+\xa7\xa59E\xae\xe1\x84cm^1\xa6\xb3\xda\x85\xc8\xd8/\x17se\x0eN^'\x8c\xc7\x8e\x88\xa8\xf6p\x8e\xc2;\xc6.\xd0\x11.\x91o\x12\x7f\xcb\xa5\xfe\x00\x89]\x10:\xf5\x00\x0e\xbf\x00\x00\x00\x00IEND\xaeB`\x82"
some_text = "SOME TEXT"
# create attachment with no data
with self.assertRaises(BadRequest):
data_store.create_attachment(doc=ds_id_and_rev, data=None,
attachment_name=attachment_name,
content_type=None, datastore_name="")
# create attachment with no attachment
with self.assertRaises(BadRequest):
data_store.create_attachment(doc=ds_id_and_rev, data=data,
attachment_name=None, content_type=None, datastore_name="")
#create attachment by passing a doc parameter that
# is a dictionary containing _rev and _id elements
data_store.create_attachment(doc=ds_id_and_rev, data=data,
attachment_name=attachment_name,
content_type=None, datastore_name="")
# read attachment by passing a doc parameter that is a dictionary
# containing _rev and _id elements and verify that the content read
# is same as the content put in
content_read = data_store.read_attachment(doc=ds_id_and_rev,
attachment_name=attachment_name,
datastore_name="")
self.assertEquals(data, content_read)
# update attachment by passing a doc parameter that is a dictionary
# containing _rev and _id elements
data_store.update_attachment(ds_id_and_rev, attachment_name, data=some_text)
# read the attachment passing only the doc _id and verify that content has changed
content_read = data_store.read_attachment(doc=ds_id_and_rev['_id'],
attachment_name=attachment_name,
datastore_name="")
self.assertNotEquals(data, content_read)
self.assertEquals(some_text, content_read)
# delete attachment by passing a doc parameter that is a dictionary containing _rev
# and _id elements
data_store.delete_attachment(doc=ds_id_and_rev, attachment_name=attachment_name)
# interestingly, deleting an attachment that does not exist works
# pass a doc parameter that is a dictionary containing _rev and _id elements
data_store.delete_attachment(doc=ds_id_and_rev['_id'], attachment_name='no_such_file')
#create attachment by passing a doc parameter that is string indicating _id
data_store.create_attachment(doc=ds_id_and_rev['_id'], data=data,
attachment_name=attachment_name, content_type=None,
datastore_name="")
# read attachment by passing a doc parameter that is a string indicating _id
# and verify that the content read is same as the content put in
content_read = data_store.read_attachment(doc=ds_id_and_rev['_id'],
attachment_name=attachment_name,
datastore_name="")
self.assertEquals(data, content_read)
# update attachment by passing a doc parameter that is a string indicating _id
data_store.update_attachment(ds_id_and_rev['_id'], attachment_name, data=some_text)
# create another attachment and
# list attachments by passing a doc parameter that is a dictionary
# containing _rev and _id elements
data_store.create_attachment(doc=ds_id_and_rev['_id'], data=data,
attachment_name=attachment_name+"_01", content_type=None,
datastore_name="")
_attachments = data_store.list_attachments(doc=ds_id_and_rev)
#refer to a previous version of the document
updated_ds_id_and_rev = {}
updated_ds_id_and_rev['_id'] = write_tuple_1[0]
updated_ds_id_and_rev['_rev'] = write_tuple_1[1]
# deleting attachment from the previous (wrong) revision raises document update conflict
with self.assertRaises(Exception):
data_store.delete_attachment(doc=updated_ds_id_and_rev, attachment_name=attachment_name)
# operations on previous versions are not allowed
with self.assertRaises(Exception):
data_store.create_attachment(doc=updated_ds_id_and_rev, data=some_text,
attachment_name=attachment_name, content_type=None,
datastore_name="")
# send in an incorrect document _id
with self.assertRaises(NotFound):
data_store.create_attachment(doc="incorrect_id", data=data,
attachment_name=attachment_name, content_type=None,
datastore_name="")
# send in an incorrect document _id
with self.assertRaises(NotFound):
data_store.read_attachment(doc="incorrect_id", attachment_name=attachment_name,
datastore_name="")
# send in an incorrect attachment_name
with self.assertRaises(NotFound):
data_store.read_attachment(doc=ds_id_and_rev['_id'],
attachment_name="incorrect_attachment", datastore_name="")
# send in an incorrect document_id
with self.assertRaises(NotFound):
data_store.update_attachment(doc="incorrect_id", attachment_name=attachment_name,
data=some_text)
# send in an incorrect attachment_name; this should work because update creates an
# attachment when it can't find an attachment to update
data_store.update_attachment(ds_id_and_rev['_id'], attachment_name="incorrect_attachment",
data=some_text)
# send in an incorrect attachment_name; interestingly, this is not an error
data_store.delete_attachment(doc=ds_id_and_rev['_id'], attachment_name='no_such_file')
# send in an incorrect document_id
with self.assertRaises(NotFound):
data_store.delete_attachment(doc="incorrect_id", attachment_name='no_such_file')
def test_datastore_database(self):
ds = CouchDB_DataStore(datastore_name='ion_test_ds', profile=DataStore.DS_PROFILE.RESOURCES)
# CouchDB does not like upper case characters for database names
with self.assertRaises(BadRequest):
ds.create_datastore("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.delete_datastore("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.info_datastore("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.list_objects("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.list_object_revisions("badid", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.create_doc({"foo": "bar"}, "", datastore_name="BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.read_doc("badid", "3", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.read_doc_mult("badid", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.update_doc({"foo": "bar"}, "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.delete_doc("badid", "BadDataStoreNamePerCouchDB")
def test_persistent(self):
import socket
try:
ds = CouchDB_DataStore(datastore_name='ion_test_ds', profile=DataStore.DS_PROFILE.RESOURCES)
self._do_test(ds)
# CouchDB does not like upper case characters for database names
with self.assertRaises(BadRequest):
ds.create_datastore("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.delete_datastore("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.info_datastore("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.list_objects("BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.list_object_revisions("badid", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.create_doc({"foo": "bar"}, "", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.read_doc("badid", "3", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.read_doc_mult("badid", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.update_doc({"foo": "bar"}, "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.delete_doc("badid", "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.find_doc([['type_', DataStore.EQUAL, 'foo']], "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.find_by_idref_doc([['type_', DataStore.EQUAL, 'UserInfo'], DataStore.AND, ['name', DataStore.EQUAL, 'foo']], 'roles', "BadDataStoreNamePerCouchDB")
with self.assertRaises(BadRequest):
ds.resolve_idref_doc("Subject", "Predicate", "Object", "BadDataStoreNamePerCouchDB")
self._do_test_views(CouchDB_DataStore(datastore_name='ion_test_ds', profile=DataStore.DS_PROFILE.RESOURCES), is_persistent=True)
except socket.error:
raise SkipTest('Failed to connect to CouchDB')
def test_persistent(self):
import socket
try:
ds = CouchDB_DataStore(datastore_name='my_ds')
self._do_test(ds)
# CouchDB does not like upper case characters for database names
create_failed = False
try:
ds.create_datastore("BadDataStoreNamePerCouchDB")
except BadRequest:
create_failed = True
self.assertTrue(create_failed)
delete_failed = False
try:
ds.delete_datastore("BadDataStoreNamePerCouchDB")
except BadRequest:
delete_failed = True
self.assertTrue(delete_failed)
info_failed = False
try:
ds.info_datastore("BadDataStoreNamePerCouchDB")
except BadRequest:
info_failed = True
self.assertTrue(info_failed)
list_objects_failed = False
try:
ds.list_objects("BadDataStoreNamePerCouchDB")
except BadRequest:
list_objects_failed = True
self.assertTrue(list_objects_failed)
list_object_revisions_failed = False
try:
ds.list_object_revisions("badid", "BadDataStoreNamePerCouchDB")
except BadRequest:
list_object_revisions_failed = True
self.assertTrue(list_object_revisions_failed)
create_failed = False
try:
ds.create_doc({"foo": "bar"}, "", "BadDataStoreNamePerCouchDB")
except BadRequest:
create_failed = True
self.assertTrue(create_failed)
read_failed = False
try:
ds.read_doc("badid", "3", "BadDataStoreNamePerCouchDB")
except BadRequest:
read_failed = True
self.assertTrue(read_failed)
read_mult_failed = False
try:
ds.read_doc_mult("badid", "BadDataStoreNamePerCouchDB")
except BadRequest:
read_mult_failed = True
self.assertTrue(read_mult_failed)
update_failed = False
try:
ds.update_doc({"foo": "bar"}, "BadDataStoreNamePerCouchDB")
except BadRequest:
update_failed = True
self.assertTrue(update_failed)
delete_failed = False
try:
ds.delete_doc("badid", "BadDataStoreNamePerCouchDB")
except BadRequest:
delete_failed = True
self.assertTrue(delete_failed)
find_failed = False
try:
ds.find_doc([['type_', DataStore.EQUAL, 'foo']], "BadDataStoreNamePerCouchDB")
except BadRequest:
find_failed = True
self.assertTrue(find_failed)
find__by_idref_failed = False
try:
ds.find_by_idref_doc([['type_', DataStore.EQUAL, 'UserInfo'], DataStore.AND, ['name', DataStore.EQUAL, 'foo']], 'roles', "BadDataStoreNamePerCouchDB")
except BadRequest:
find__by_idref_failed = True
self.assertTrue(find__by_idref_failed)
resolve_idref_failed = False
try:
ds.resolve_idref_doc("Subject", "Predicate", "Object", "BadDataStoreNamePerCouchDB")
except BadRequest:
resolve_idref_failed = True
self.assertTrue(resolve_idref_failed)
self._do_test_views(CouchDB_DataStore(datastore_name='my_ds'), is_persistent=True)
except socket.error:
raise SkipTest('Failed to connect to CouchDB')
