Method insert_data

src/ifcpatch/ifcpatch/recipes/Ifc2Sql.py:546–624

(self, ifc_class: str)

        self.c.execute(statement)

    def insert_data(self, ifc_class: str) -> None:
        elements = self.file.by_type(ifc_class, include_subtypes=False)

        rows: list[list[Any]] = []
        id_map_rows: list[tuple[int, str]] = []
        pset_rows: list[tuple[int, str, str, Any]] = []

        for element in elements:
            nested_indices: list[int] = []
            values: list[Any] = [element.id()]
            for i, attribute in enumerate(element):
                if isinstance(attribute, ifcopenshell.entity_instance):
                    if attribute.id():
                        values.append(attribute.id())
                    else:
                        values.append(json.dumps({"type": attribute.is_a(), "value": attribute.wrappedValue}))
                elif (
                    self.should_expand
                    and attribute
                    and isinstance(attribute, tuple)
                    and isinstance(attribute[0], ifcopenshell.entity_instance)
                ):
                    nested_indices.append(i + 1)
                    serialised_attribute = self.serialise_value(element, attribute)
                    if attribute[0].id():
                        values.append(serialised_attribute)
                    else:
                        values.append(json.dumps(serialised_attribute))
                elif isinstance(attribute, tuple):
                    attribute = self.serialise_value(element, attribute)
                    values.append(json.dumps(attribute))
                else:
                    values.append(attribute)

            if self.should_get_inverses:
                values.append(json.dumps([e.id() for e in self.file.get_inverse(element)]))

            if self.should_expand:
                rows.extend(self.get_permutations(values, nested_indices))
            else:
                rows.append(values)

            id_map_rows.append((element.id(), ifc_class))

            if self.should_get_psets:
                psets = ifcopenshell.util.element.get_psets(element)
                for pset_name, pset_data in psets.items():
                    for prop_name, value in pset_data.items():
                        if prop_name == "id":
                            continue
                        if isinstance(value, list):
                            value = json.dumps(value)
                        pset_rows.append((element.id(), pset_name, prop_name, value))

            if self.should_get_geometry:
                if element.id() not in self.shape_rows and (placement := getattr(element, "ObjectPlacement", None)):
                    m = ifcopenshell.util.placement.get_local_placement(placement)
                    x, y, z = m[:, 3][0:3].tolist()