Download this example as a Jupyter notebook or a Python script.

Database-specific configuration options#

Granta MI BoM Analytics work with an off-the-shelf Granta MI Restricted Substances database. However, there are some situations in which additional run-time configuration changes are required:

  • If the database key or table names have been modified from their default values, these must be set on the Connection object.

  • If the number of linked records is very large, the batch sizes should be changed for each query. For more information, see Batching requests.

Specify a custom database key or table name#

The default database key, MI_Restricted_Substances, is used if no database key is specified. To specify a key, use the Connection.set_database_details() method. The specified key is then used for all queries made with this Connection object.

[1]:

from ansys.grantami.bomanalytics import Connection

server_url = "http://my_grantami_server/mi_servicelayer"
cxn = Connection(server_url).with_credentials("user_name", "password").connect()
cxn.set_database_details(database_key="ACME_SUBSTANCES_DATABASE")
cxn

[1]:

<BomServicesClient: url="http://my_grantami_server/mi_servicelayer", maximum_spec_link_depth="unlimited", dbkey="ACME_SUBSTANCES_DATABASE">

It is also possible to specify alternative names for the relevant restricted substances tables, if they have been modified from the defaults. You provide the names to the .set_database_details() method in the same way.

[2]:

cxn.set_database_details(in_house_materials_table_name="ACME Materials")
cxn

[2]:

<BomServicesClient: url="http://my_grantami_server/mi_servicelayer", maximum_spec_link_depth="unlimited", dbkey="MI_Restricted_Substances", inhouse_materials_table_name="ACME Materials">

Batch size#

The queries that can be performed with this package are batched if they exceed a certain size. This is achieved by splitting the list of parts, materials, etc. into smaller lists to reduce the overall time taken to perform the query. Default batch sizes have been chosen based on typical tabular attribute sizes, but these might need to be changed in some situations. For examples, see the relevant page in the API documentation.

The batch size is included in the query __repr__. The following cell shows a SpecificationComplianceQuery object with the default batch size.

[3]:

from ansys.grantami.bomanalytics import queries

spec_query = queries.SpecificationComplianceQuery()
spec_query

[3]:

<SpecificationComplianceQuery: 0 specifications, batch size = 10, 0 indicators>

You can manually set the batch size like this:

[4]:

spec_query = spec_query.with_batch_size(5)
spec_query

[4]:

<SpecificationComplianceQuery: 0 specifications, batch size = 5, 0 indicators>