def save_premodel_dataset(self):
'''
This method saves the entire the dataset collection, as a json
document, into the nosql implementation.
'''
# local variables
entity = Entity()
cursor = Collection()
collection = self.premodel_data['properties']['collection']
collection_adjusted = collection.lower().replace(' ', '_')
collection_count = entity.get_collection_count(self.uid)
document_count = cursor.query(collection_adjusted, 'count_documents')
# enfore collection limit: oldest collection name is obtained from the
# sql database. Then, the corresponding collection (i.e. target) is
# removed from the nosql database.
if (not self.uid and collection_count
and collection_count['result'] >= self.max_collection
and collection_adjusted):
target = entity.get_collections(self.uid)['result'][0]
cursor.query(target, 'drop_collection')
entity.remove_entity(self.uid, target)
collection_count = entity.get_collection_count(self.uid)
document_count = cursor.query(collection_adjusted,
'count_documents')
# save dataset
if (collection_adjusted and collection_count
and collection_count['result'] < self.max_collection
and document_count
and document_count['result'] < self.max_document):
current_utc = datetime.datetime.utcnow().strftime(
"%Y-%m-%dT%H:%M:%S")
self.premodel_data['properties']['datetime_saved'] = current_utc
self.premodel_data['properties']['uid'] = self.uid
document = {
'properties': self.premodel_data['properties'],
'dataset': self.dataset
}
response = cursor.query(collection_adjusted, 'insert_one',
document)
else:
response = None
# return result
if response and response['error']:
self.list_error.append(response['error'])
return {'result': None, 'error': response['error']}
elif response and response['result']:
return {'result': response['result'], 'error': None}
else:
return {'result': None, 'error': 'no dataset provided'}
def save_entity(self, session_type, session_id):
'''
This method overrides the identical method from the inherited
superclass, 'BaseData'. Specifically, this method updates an
existing entity within the corresponding database table,
'tbl_dataset_entity'.
@session_id, is synonymous to 'entity_id', and provides context to
update 'modified_xx' columns within the 'tbl_dataset_entity'
database table.
'''
# local variables
db_return = None
entity = Entity()
cursor = Collection()
premodel_settings = self.premodel_data['properties']
collection = premodel_settings['collection']
collection_adjusted = collection.lower().replace(' ', '_')
collection_count = entity.get_collection_count(self.uid)
document_count = cursor.query(collection_adjusted, 'count_documents')
# define entity properties
premodel_entity = {
'title': premodel_settings.get('session_name', None),
'uid': self.uid,
'id_entity': session_id,
}
# store entity values in database
if (
collection_adjusted and
collection_count and
collection_count['result'] < self.max_collection and
document_count and
document_count['result'] < self.max_document
):
db_save = Entity(premodel_entity, session_type)
db_return = db_save.save()
if db_return and db_return['status']:
return {'status': True, 'error': None}
else:
self.list_error.append(db_return['error'])
return {'status': False, 'error': self.list_error}
else:
return {'status': True, 'error': None}
def save_entity(self, session_type, session_id):
'''
This method overrides the identical method from the inherited
superclass, 'BaseData'. Specifically, this method updates an
existing entity within the corresponding database table,
'tbl_dataset_entity'.
@session_id, is synonymous to 'entity_id', and provides context to
update 'modified_xx' columns within the 'tbl_dataset_entity'
database table.
'''
# local variables
db_return = None
entity = Entity()
cursor = Collection()
premodel_settings = self.premodel_data['properties']
collection = premodel_settings['collection']
collection_adjusted = collection.lower().replace(' ', '_')
collection_count = entity.get_collection_count(self.uid)
document_count = cursor.query(collection_adjusted, 'count_documents')
# define entity properties
premodel_entity = {
'title': premodel_settings.get('session_name', None),
'uid': self.uid,
'id_entity': session_id,
}
# store entity values in database
if (collection_adjusted and collection_count
and collection_count['result'] < self.max_collection
and document_count
and document_count['result'] < self.max_document):
db_save = Entity(premodel_entity, session_type)
db_return = db_save.save()
if db_return and db_return['status']:
return {'status': True, 'error': None}
else:
self.list_error.append(db_return['error'])
return {'status': False, 'error': self.list_error}
else:
return {'status': True, 'error': None}
def collection_count():
'''
This router function retrieves the number of collections, saved by a
specified user.
'''
if request.method == 'POST':
# local variables
count = None
entity = Entity()
# programmatic-interface
if request.get_json():
r = request.get_json()
uid = r['uid']
count = entity.get_collection_count(uid)
if count and isinstance(count['result'], (int, long)):
return json.dumps({'count': count['result']})
else:
return json.dumps({'count': -1})
def collection_count():
'''
This router function retrieves the number of collections, saved by a
specified user.
'''
if request.method == 'POST':
# local variables
count = None
entity = Entity()
# programmatic-interface
if request.get_json():
r = request.get_json()
uid = r['uid']
count = entity.get_collection_count(uid)
if count and isinstance(count['result'], (int, long)):
return json.dumps({'count': count['result']})
else:
return json.dumps({'count': -1})
def save_entity(self, session_type, id_entity=None):
'''
This method overrides the identical method from the inherited
superclass, 'BaseData'. Specifically, this method updates an
existing entity within the corresponding database table,
'tbl_dataset_entity'.
@session_id, is synonymous to 'entity_id', and provides context to
update 'modified_xx' columns within the 'tbl_dataset_entity'
database table.
@numeric_model_type, list indices begin at 0, and needs to be corrected
by adding 1. This allows the numeric representation of the
'model_type' to relate to another database table, which maps
integer values with the corresponding 'model_type' name. The
integer column of the mapping table begins at 1.
'''
# local variables
db_return = None
entity = Entity()
cursor = Collection()
premodel_settings = self.premodel_data['properties']
collection = premodel_settings['collection']
collection_adjusted = collection.lower().replace(' ', '_')
collection_count = entity.get_collection_count(self.uid)
document_count = cursor.query(collection_adjusted, 'count_documents')
# assign numerical representation
numeric_model_type = self.list_model_type.index(self.model_type) + 1
# define entity properties
premodel_entity = {
'title': premodel_settings.get('session_name', None),
'collection': collection,
'model_type': numeric_model_type,
'uid': self.uid,
}
# store entity values in database
if (
collection_adjusted and
collection_count and
collection_count['result'] < self.max_collection and
document_count and
document_count['result'] < self.max_document
):
entity = Entity(premodel_entity, session_type)
db_return = entity.save()
# return
if db_return and db_return['error']:
self.list_error.append(db_return['error'])
return {'status': False, 'error': self.list_error}
elif db_return and db_return['status']:
return {'status': True, 'error': None, 'id': db_return['id']}
else:
return {'status': True, 'error': 'Entity was not saved', 'id': None}
def save_premodel_dataset(self):
'''
This method saves the entire the dataset collection, as a json
document, into the nosql implementation.
'''
# local variables
response = None
entity = Entity()
cursor = Collection()
collection = self.premodel_data['properties']['collection']
collection_adjusted = collection.lower().replace(' ', '_')
collection_count = entity.get_collection_count(self.uid)
document_count = cursor.query(collection_adjusted, 'count_documents')
# enfore collection limit: oldest collection name is obtained from the
# sql database. Then, the corresponding collection (i.e. target) is
# removed from the nosql database.
if (
not self.uid and
collection_count and
collection_count['result'] >= self.max_collection and
collection_adjusted
):
target = entity.get_collections(self.uid)['result'][0]
cursor.query(target, 'drop_collection')
entity.remove_entity(self.uid, target)
collection_count = entity.get_collection_count(self.uid)
document_count = cursor.query(collection_adjusted, 'count_documents')
# save dataset
if (
collection_adjusted and
collection_count and
collection_count['result'] < self.max_collection and
document_count and
document_count['result'] < self.max_document
):
current_utc = datetime.datetime.utcnow().strftime("%Y-%m-%dT%H:%M:%S")
self.premodel_data['properties']['datetime_saved'] = current_utc
if self.dataset:
document = {
'properties': self.premodel_data['properties'],
'dataset': self.dataset
}
response = cursor.query(
collection_adjusted,
'insert_one',
document
)
else:
response = None
# return result
if response and response['error']:
self.list_error.append(response['error'])
return {'result': None, 'error': response['error']}
elif response and response['result']:
return {'result': response['result'], 'error': None}
else:
return {'result': None, 'error': 'no dataset provided'}