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
