def test_get_schemas_mapped(self, req, db_session): """ Test if a inserted map is returned to view """ from occams_imports import models from occams_imports.views.mappings import mappings_direct_map req.json = { "source_variable": "question", "target_schema_publish_date": "2015-01-01", "choices_mapping": [{"mapped": "0", "name": "0"}, {"mapped": "1", "name": "0"}], "source_schema_publish_date": "2015-01-01", "target_schema": "ucsd_demographics", "target_variable": "ucsd_question", "source_schema": "demographics"} mappings_direct_map(None, req) mapping = db_session.query(models.Mapping).one() req.params = {'id': mapping.id} response = self._call_fut(None, req) row = response['mappings_form_rows'][0] assert row['description'] == u'question' assert row['study'] == u'DRSC' assert row['type'] == u'direct'
def test_get_schemas(self, req, db_session): """ Test if mapping is returned from view """ from occams_imports.views.mappings import mappings_direct_map req.json = { "source_variable": "question", "target_schema_publish_date": "2015-01-01", "choices_mapping": [{"mapped": "0", "name": "0"}, {"mapped": "1", "name": "0"}], "source_schema_publish_date": "2015-01-01", "target_schema": "ucsd_demographics", "target_variable": "ucsd_question", "source_schema": "demographics"} mappings_direct_map(None, req) response = self._call_fut(None, req) row = response['rows'][0] assert row['study'] == u'DRSC' assert row['study_form'] == u'demographics' assert row['target_form'] == u'ucsd_demographics'
def test_get_schemas(self, req, db_session): """ Test if mapping is returned from view """ from occams_imports.views.mappings import mappings_direct_map req.json = { u'confidence': 1, u'selected': {u'label': u'', u'variable': u'question'}, u'selected_target': {u'choices': [{u'label': u'Always', u'mapped': u'0', u'name': u'0'}, {u'label': u'Never', u'mapped': u'1', u'name': u'1'}], u'label': u'', u'variable': u'ucsd_question'}, u'site': {u'name': u'demographics', u'publish_date': u'2015-01-01'}, u'target': {u'name': u'ucsd_demographics', u'publish_date': u'2015-01-01'} } mappings_direct_map(None, req) response = self._call_fut(None, req) row = response['rows'][0] assert row['study'] == u'DRSC' assert row['study_form'] == u'demographics' assert row['target_form'] == u'ucsd_demographics'
def test_delete_mappings(self, req, db_session): """ Test if a selected mapping is deleted """ from sqlalchemy.sql import exists from occams_imports import models from occams_imports.views.mappings import mappings_direct_map req.json = { u'confidence': 1, u'selected': { u'label': u'', u'variable': u'question' }, u'selected_target': { u'choices': [{ u'label': u'Always', u'mapped': u'0', u'name': u'0' }, { u'label': u'Never', u'mapped': u'1', u'name': u'1' }], u'label': u'', u'variable': u'ucsd_question' }, u'site': { u'name': u'demographics', u'publish_date': u'2015-01-01' }, u'target': { u'name': u'ucsd_demographics', u'publish_date': u'2015-01-01' } } mappings_direct_map(None, req) mapping = db_session.query(models.Mapping).one() req.json = { 'mapped_delete': [{ 'deleteRow': True, 'mappedId': mapping.id }] } self._call_fut(None, req) mapping_exists = db_session.query( exists().where(models.Mapping.id == mapping.id)).scalar() assert mapping_exists is False
def test_get_schemas_mapped(self, req, db_session): """ Test if a inserted map is returned to view """ from occams_imports import models from occams_imports.views.mappings import mappings_direct_map req.json = { u'confidence': 1, u'selected': { u'label': u'', u'variable': u'question' }, u'selected_target': { u'choices': [{ u'label': u'Always', u'mapped': u'0', u'name': u'0' }, { u'label': u'Never', u'mapped': u'1', u'name': u'1' }], u'label': u'', u'variable': u'ucsd_question' }, u'site': { u'name': u'demographics', u'publish_date': u'2015-01-01' }, u'target': { u'name': u'ucsd_demographics', u'publish_date': u'2015-01-01' } } mappings_direct_map(None, req) mapping = db_session.query(models.Mapping).one() req.params = {'id': mapping.id} response = self._call_fut(None, req) row = response['mappings_form_rows'][0] assert row['description'] == u'question' assert row['study'] == u'DRSC' assert row['type'] == u'choice'
def test_get_schemas(self, req, db_session): """ Test if mapping is returned from view """ from occams_imports.views.mappings import mappings_direct_map req.json = { u'confidence': 1, u'selected': { u'label': u'', u'variable': u'question' }, u'selected_target': { u'choices': [{ u'label': u'Always', u'mapped': u'0', u'name': u'0' }, { u'label': u'Never', u'mapped': u'1', u'name': u'1' }], u'label': u'', u'variable': u'ucsd_question' }, u'site': { u'name': u'demographics', u'publish_date': u'2015-01-01' }, u'target': { u'name': u'ucsd_demographics', u'publish_date': u'2015-01-01' } } mappings_direct_map(None, req) response = self._call_fut(None, req) row = response['rows'][0] assert row['study'] == u'DRSC' assert row['study_form'] == u'demographics' assert row['target_form'] == u'ucsd_demographics'
def test_delete_mappings(self, req, db_session): """ Test if a selected mapping is deleted """ from sqlalchemy.sql import exists from occams_imports import models from occams_imports.views.mappings import mappings_direct_map req.json = { u'confidence': 1, u'selected': {u'label': u'', u'variable': u'question'}, u'selected_target': {u'choices': [{u'label': u'Always', u'mapped': u'0', u'name': u'0'}, {u'label': u'Never', u'mapped': u'1', u'name': u'1'}], u'label': u'', u'variable': u'ucsd_question'}, u'site': {u'name': u'demographics', u'publish_date': u'2015-01-01'}, u'target': {u'name': u'ucsd_demographics', u'publish_date': u'2015-01-01'} } mappings_direct_map(None, req) mapping = db_session.query(models.Mapping).one() req.json = { 'mapped_delete': [ {'deleteRow': True, 'mappedId': mapping.id} ] } self._call_fut(None, req) mapping_exists = db_session.query( exists().where(models.Mapping.id == mapping.id)).scalar() assert mapping_exists is False
def test_get_schemas_mapped(self, req, db_session): """ Test if a inserted map is returned to view """ from occams_imports import models from occams_imports.views.mappings import mappings_direct_map req.json = { u'confidence': 1, u'selected': {u'label': u'', u'variable': u'question'}, u'selected_target': {u'choices': [{u'label': u'Always', u'mapped': u'0', u'name': u'0'}, {u'label': u'Never', u'mapped': u'1', u'name': u'1'}], u'label': u'', u'variable': u'ucsd_question'}, u'site': {u'name': u'demographics', u'publish_date': u'2015-01-01'}, u'target': {u'name': u'ucsd_demographics', u'publish_date': u'2015-01-01'} } mappings_direct_map(None, req) mapping = db_session.query(models.Mapping).one() req.params = {'id': mapping.id} response = self._call_fut(None, req) row = response['mappings_form_rows'][0] assert row['description'] == u'question' assert row['study'] == u'DRSC' assert row['type'] == u'choice'
def test_delete_mappings(self, req, db_session): """ Test if a selected mapping is deleted """ from sqlalchemy.sql import exists from occams_imports import models from occams_imports.views.mappings import mappings_direct_map req.json = { "source_variable": "question", "target_schema_publish_date": "2015-01-01", "choices_mapping": [{"mapped": "0", "name": "0"}, {"mapped": "1", "name": "0"}], "source_schema_publish_date": "2015-01-01", "target_schema": "ucsd_demographics", "target_variable": "ucsd_question", "source_schema": "demographics"} mappings_direct_map(None, req) mapping = db_session.query(models.Mapping).one() req.json = { 'mapped_delete': [ {'deleteRow': True, 'mappedId': mapping.id} ] } self._call_fut(None, req) mapping_exists = db_session.query( exists().where(models.Mapping.id == mapping.id)).scalar() assert mapping_exists is False