Module Contents#

class ifcpatch.recipes.Ifc2Sql.Patcher(src, file, logger, sql_type: str = 'sqlite', host: str = 'localhost', username: str = 'root', password: str = 'pass', database: str = 'test')#

Convert an IFC-SPF model to SQLite or MySQL.

There are certain controls which are hardcoded in this recipe that you may modify, including:

  • full_schema: if True, will create tables for all IFC classes, regardless if they are used or not in the dataset. If False, will only create tables for classes in the dataset.

  • is_strict: whether or not to enforce null or not null. If your dataset might contain invalid data, set this to False.

  • should_expand: if True, entities with attributes containing lists of entities will be separated into multiple rows. This means the ifc_id is no longer a unique primary key. If False, lists will be stored as JSON.

  • should_get_psets: if True, a separate psets table will be created to make it easy to query properties. This is in addition to regular IFC tables like IfcPropertySet.

  • should_get_geometry: Whether or not to process and store explicit geometry data as a blob in a separate geometry and shape table.

  • should_skip_geometry_data: Whether or not to also create tables for IfcRepresentation and IfcRepresentationItem classes. These tables are unnecessary if you are not interested in geometry.


sql_type (str) – Choose between “sqlite” or “mysql”


# Convert to SQLite
ifcpatch.execute({"input": "input.ifc", "file": model, "recipe": "Ifc2Sql", "arguments": ["sqlite"]})
create_mysql_table(self, ifc_class, declaration)#
create_sqlite_table(self, ifc_class, declaration)#
get_permutations(self, lst, indexes)#
insert_data(self, ifc_class)#
is_entity_list(self, attribute)#
serialise_value(self, element, value)#