Skip to content

trestle.tasks.csv_to_oscal_mc

trestle.tasks.csv_to_oscal_mc ¤

OSCAL transformation tasks.

Attributes¤

HEADER_DECORATION_CHAR = '$' module-attribute ¤

L_MAP_CONFIDENCE_SCORE = MAP_CONFIDENCE_SCORE.lower() module-attribute ¤

L_MAP_COVERAGE = MAP_COVERAGE.lower() module-attribute ¤

L_MAP_RELATIONSHIP = MAP_RELATIONSHIP.lower() module-attribute ¤

L_MAP_SOURCE_ID_REF_LIST = MAP_SOURCE_ID_REF_LIST.lower() module-attribute ¤

L_MAP_TARGET_ID_REF_LIST = MAP_TARGET_ID_REF_LIST.lower() module-attribute ¤

L_SOURCE_RESOURCE = SOURCE_RESOURCE.lower() module-attribute ¤

L_TARGET_RESOURCE = TARGET_RESOURCE.lower() module-attribute ¤

MAP_CONFIDENCE_SCORE = 'Map_Confidence_Score' module-attribute ¤

MAP_COVERAGE = 'Map_Coverage' module-attribute ¤

MAP_RELATIONSHIP = 'Map_Relationship' module-attribute ¤

MAP_SOURCE_ID_REF_LIST = 'Map_Source_Id_Ref_List' module-attribute ¤

MAP_TARGET_ID_REF_LIST = 'Map_Target_Id_Ref_List' module-attribute ¤

SOURCE_RESOURCE = 'Source_Resource' module-attribute ¤

TARGET_RESOURCE = 'Target_Resource' module-attribute ¤

logger = logging.getLogger(__name__) module-attribute ¤

timestamp = datetime.datetime.now(datetime.UTC).replace(microsecond=0).isoformat() module-attribute ¤

Classes¤

CsvColumn ¤

CsvColumn.

Source code in trestle/tasks/csv_to_oscal_mc.py
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
class CsvColumn:
    """CsvColumn."""

    columns_required = [
        f'{L_SOURCE_RESOURCE}',
        f'{L_TARGET_RESOURCE}',
        f'{L_MAP_SOURCE_ID_REF_LIST}',
        f'{L_MAP_TARGET_ID_REF_LIST}',
        f'{L_MAP_RELATIONSHIP}',
    ]

    columns_optional = [f'{L_MAP_CONFIDENCE_SCORE}', f'{L_MAP_COVERAGE}']

    @staticmethod
    def get_required_column_names() -> List[str]:
        """Get required column names."""
        rval = []
        rval += CsvColumn.columns_required
        return rval

    @staticmethod
    def get_optional_column_names() -> List[str]:
        """Get optional column names."""
        rval = []
        rval += CsvColumn.columns_optional
        return rval
Attributes¤
columns_optional = [f'{L_MAP_CONFIDENCE_SCORE}', f'{L_MAP_COVERAGE}'] class-attribute instance-attribute ¤
columns_required = [f'{L_SOURCE_RESOURCE}', f'{L_TARGET_RESOURCE}', f'{L_MAP_SOURCE_ID_REF_LIST}', f'{L_MAP_TARGET_ID_REF_LIST}', f'{L_MAP_RELATIONSHIP}'] class-attribute instance-attribute ¤
Methods:¤
get_optional_column_names() staticmethod ¤

Get optional column names.

Source code in trestle/tasks/csv_to_oscal_mc.py
475
476
477
478
479
480
@staticmethod
def get_optional_column_names() -> List[str]:
    """Get optional column names."""
    rval = []
    rval += CsvColumn.columns_optional
    return rval
get_required_column_names() staticmethod ¤

Get required column names.

Source code in trestle/tasks/csv_to_oscal_mc.py
468
469
470
471
472
473
@staticmethod
def get_required_column_names() -> List[str]:
    """Get required column names."""
    rval = []
    rval += CsvColumn.columns_required
    return rval

CsvToOscalMappingCollection ¤

Bases: TaskBase


              flowchart TD
              trestle.tasks.csv_to_oscal_mc.CsvToOscalMappingCollection[CsvToOscalMappingCollection]
              trestle.tasks.base_task.TaskBase[TaskBase]

                              trestle.tasks.base_task.TaskBase --> trestle.tasks.csv_to_oscal_mc.CsvToOscalMappingCollection
                


              click trestle.tasks.csv_to_oscal_mc.CsvToOscalMappingCollection href "" "trestle.tasks.csv_to_oscal_mc.CsvToOscalMappingCollection"
              click trestle.tasks.base_task.TaskBase href "" "trestle.tasks.base_task.TaskBase"
            

Task to create OSCAL mc.json.

Attributes:

Name Type Description
name

Name of the task.

Source code in trestle/tasks/csv_to_oscal_mc.py
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
class CsvToOscalMappingCollection(TaskBase):
    """
    Task to create OSCAL mc.json.

    Attributes:
        name: Name of the task.
    """

    name = 'csv-to-oscal-mc'

    def __init__(self, config_object: Optional[configparser.SectionProxy]) -> None:
        """
        Initialize trestle task csv-to-oscal-mc.

        Args:
            config_object: Config section associated with the task.
        """
        super().__init__(config_object)

    def print_info(self) -> None:
        """Print the help string."""
        name = self.name
        oscal_name = 'mapping-collection'
        #
        logger.info(f'Help information for {name} task.')
        logger.info('')
        logger.info(f'Purpose: From csv produce OSCAL {oscal_name} file.')
        logger.info('')
        logger.info('')
        logger.info(f'Configuration flags sit under [task.{name}]:')
        text1 = '  title                = '
        text2 = '(required) the mapping collection title.'
        logger.info(text1 + text2)
        text1 = '  version              = '
        text2 = '(required) the mapping collection version.'
        logger.info(text1 + text2)
        text1 = '  csv-file             = '
        text2 = '(required) the path of the csv file.'
        text3 = ' [1st row are column headings; 2nd row are column descriptions; 3rd row and beyond is data]'
        logger.info(text1 + text2 + text3)
        text1 = '  required columns:      '
        for text2 in CsvColumn.columns_required:
            logger.info(text1 + text2)
            text1 = '                         '
        text1 = '  optional columns:      '
        for text2 in CsvColumn.columns_optional:
            logger.info(text1 + text2)
            text1 = '                         '
        text1 = '  output-dir           = '
        text2 = '(required) the path of the output directory for synthesized OSCAL .json files.'
        logger.info(text1 + text2)
        text1 = '  output-overwrite     = '
        text2 = '(optional) true [default] or false; replace existing output when true.'
        logger.info(text1 + text2)

    def configure(self) -> bool:
        """Configure."""
        ok, msg = self._configure_csv_common()
        if not ok:
            logger.warning(msg)
            return False
        return True

    def simulate(self) -> TaskOutcome:
        """Provide a simulated outcome."""
        return TaskOutcome('simulated-success')

    def execute(self) -> TaskOutcome:
        """Provide an executed outcome."""
        try:
            return self._execute()
        except Exception:
            logger.error(traceback.format_exc())
            return TaskOutcome('failure')

    def _execute(self) -> TaskOutcome:
        """Execute path core."""
        if not self.configure():
            return TaskOutcome('failure')
        # config output
        odir = self._config.get('output-dir')
        opth = pathlib.Path(odir)
        self._overwrite = self._config.getboolean('output-overwrite', True)
        # insure output dir exists
        opth.mkdir(exist_ok=True, parents=True)
        # calculate output file name & check writability
        oname = 'mapping-collection.json'
        ofile = opth / oname
        if not self._overwrite and pathlib.Path(ofile).exists():
            logger.warning(f'output: {ofile} already exists')
            return TaskOutcome('failure')
        # title
        title = self._config.get('title')
        # version
        version = self._config.get('version')
        # fetch csv
        self._csv_mgr = _CsvMgr(self._csv_path)
        # Mapping Collection manager
        self._mc_mgr = _McMgr(ofile, title, version)
        # href manager
        href_manager = HrefManager()
        # accumulators for missing ids
        ctl_missing_src = []
        ctl_missing_tgt = []
        # process each row of mapping csv
        for row in self._csv_mgr.row_generator():
            # src
            src_resource_href = self._csv_mgr.get_cell(row, L_SOURCE_RESOURCE)
            href_manager.add(src_resource_href)
            src_id_list = self._csv_mgr.get_cell(row, L_MAP_SOURCE_ID_REF_LIST).split()
            src_id_ref_list = href_manager.get_id_list(src_resource_href, src_id_list)
            # tgt
            tgt_resource_href = self._csv_mgr.get_cell(row, L_TARGET_RESOURCE)
            href_manager.add(tgt_resource_href)
            tgt_id_list = self._csv_mgr.get_cell(row, L_MAP_TARGET_ID_REF_LIST).split()
            tgt_id_ref_list = href_manager.get_id_list(tgt_resource_href, tgt_id_list)
            # Get relationship type for all rows
            relationship_type = self._csv_mgr.get_cell(row, L_MAP_RELATIONSHIP)
            # relationship mapping
            if src_id_ref_list and tgt_id_ref_list:
                src_resource_type = href_manager.get_type(src_resource_href)
                tgt_resource_type = href_manager.get_type(tgt_resource_href)
                # Get confidence score and coverage
                confidence_score_str = self._csv_mgr.get_cell(row, L_MAP_CONFIDENCE_SCORE)
                coverage_str = self._csv_mgr.get_cell(row, L_MAP_COVERAGE)
                # Get other user columns as properties
                kvp_set = {}
                for user_column_name in self._csv_mgr.get_user_column_names():
                    value = self._csv_mgr.get_cell(row, user_column_name)
                    kvp_set[user_column_name] = value
                self._mc_mgr.add_mapping(
                    src_resource_type,
                    src_resource_href,
                    tgt_resource_type,
                    tgt_resource_href,
                    src_id_ref_list,
                    tgt_id_ref_list,
                    relationship_type,
                    confidence_score_str,
                    coverage_str,
                    kvp_set,
                )
            else:
                # Track unmapped controls for gap summary - only when relationship is empty
                # If relationship is specified but controls are missing, that's an error
                if relationship_type:
                    # Relationship specified - missing controls are errors
                    if not src_id_ref_list:
                        for src_id in src_id_list:
                            if src_id not in ctl_missing_src:
                                ctl_missing_src.append(src_id)
                    if not tgt_id_ref_list:
                        for tgt_id in tgt_id_list:
                            if tgt_id not in ctl_missing_tgt:
                                ctl_missing_tgt.append(tgt_id)
                else:
                    # No relationship - track as unmapped for gap summary
                    if src_id_ref_list and not tgt_id_ref_list:
                        # Source has controls but no target = unmapped source controls
                        for src_id in src_id_list:
                            self._mc_mgr.add_unmapped_control(src_id, is_source=True)
                    elif tgt_id_ref_list and not src_id_ref_list:
                        # Target has controls but no source = unmapped target controls
                        for tgt_id in tgt_id_list:
                            self._mc_mgr.add_unmapped_control(tgt_id, is_source=False)
                    else:
                        # Both empty - keep track of ids not found in specified corresponding href
                        if not src_id_ref_list:
                            for src_id in src_id_list:
                                if src_id not in ctl_missing_src:
                                    ctl_missing_src.append(src_id)
                        if not tgt_id_ref_list:
                            for tgt_id in tgt_id_list:
                                if tgt_id not in ctl_missing_tgt:
                                    ctl_missing_tgt.append(tgt_id)
        # issues?
        text = ''
        if ctl_missing_src:
            text += f'source(s) missing from href: {ctl_missing_src}\n'
        if ctl_missing_tgt:
            text += f'target(s) missing from href: {ctl_missing_tgt}\n'
        if text:
            raise RuntimeError(text)
        # fetch synthesized mapping collection
        mapping_collection = self._mc_mgr.get_mapping_collection()
        # write OSCAL mc to file
        if self._verbose:
            logger.info(f'output: {ofile}')
        mapping_collection.oscal_write(pathlib.Path(ofile))
        return TaskOutcome('success')
Attributes¤
name = 'csv-to-oscal-mc' class-attribute instance-attribute ¤
Methods:¤
__init__(config_object) ¤

Initialize trestle task csv-to-oscal-mc.

Parameters:

Name Type Description Default
config_object Optional[SectionProxy]

Config section associated with the task.

required
Source code in trestle/tasks/csv_to_oscal_mc.py
79
80
81
82
83
84
85
86
def __init__(self, config_object: Optional[configparser.SectionProxy]) -> None:
    """
    Initialize trestle task csv-to-oscal-mc.

    Args:
        config_object: Config section associated with the task.
    """
    super().__init__(config_object)
configure() ¤

Configure.

Source code in trestle/tasks/csv_to_oscal_mc.py
124
125
126
127
128
129
130
def configure(self) -> bool:
    """Configure."""
    ok, msg = self._configure_csv_common()
    if not ok:
        logger.warning(msg)
        return False
    return True
execute() ¤

Provide an executed outcome.

Source code in trestle/tasks/csv_to_oscal_mc.py
136
137
138
139
140
141
142
def execute(self) -> TaskOutcome:
    """Provide an executed outcome."""
    try:
        return self._execute()
    except Exception:
        logger.error(traceback.format_exc())
        return TaskOutcome('failure')
print_info() ¤

Print the help string.

Source code in trestle/tasks/csv_to_oscal_mc.py
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
def print_info(self) -> None:
    """Print the help string."""
    name = self.name
    oscal_name = 'mapping-collection'
    #
    logger.info(f'Help information for {name} task.')
    logger.info('')
    logger.info(f'Purpose: From csv produce OSCAL {oscal_name} file.')
    logger.info('')
    logger.info('')
    logger.info(f'Configuration flags sit under [task.{name}]:')
    text1 = '  title                = '
    text2 = '(required) the mapping collection title.'
    logger.info(text1 + text2)
    text1 = '  version              = '
    text2 = '(required) the mapping collection version.'
    logger.info(text1 + text2)
    text1 = '  csv-file             = '
    text2 = '(required) the path of the csv file.'
    text3 = ' [1st row are column headings; 2nd row are column descriptions; 3rd row and beyond is data]'
    logger.info(text1 + text2 + text3)
    text1 = '  required columns:      '
    for text2 in CsvColumn.columns_required:
        logger.info(text1 + text2)
        text1 = '                         '
    text1 = '  optional columns:      '
    for text2 in CsvColumn.columns_optional:
        logger.info(text1 + text2)
        text1 = '                         '
    text1 = '  output-dir           = '
    text2 = '(required) the path of the output directory for synthesized OSCAL .json files.'
    logger.info(text1 + text2)
    text1 = '  output-overwrite     = '
    text2 = '(optional) true [default] or false; replace existing output when true.'
    logger.info(text1 + text2)
simulate() ¤

Provide a simulated outcome.

Source code in trestle/tasks/csv_to_oscal_mc.py
132
133
134
def simulate(self) -> TaskOutcome:
    """Provide a simulated outcome."""
    return TaskOutcome('simulated-success')

handler: python