Add Date, Integer and Logical data

Work with date, integer, and logical attribute types.

Connect to MI

Get a database and table.

from datetime import datetime
from GRANTA_MIScriptingToolkit import granta as mpy

mi = mpy.connect("http://my.server.name/mi_servicelayer", autologon=True)

db = mi.get_db(db_key="MI_Training")
db.unit_system = "Metric"
db.absolute_temperatures = False

tab = db.get_table("AM Builds")

Create a new record and path

Define a path in the table from a starting folder (in this case the top level folder) using path_from(). If the path does not exist, the required folders will be created. Create a new Record object at the end of the path.

now = datetime.now().strftime("%c")
record_name = f"Scripting Toolkit Example 13:{now}"
folder = tab.path_from(None, tree_path=["Blown Powder (Laser beam)", "Ti-6Al-4V"])
record = tab.create_record(name=record_name, parent=folder)
record, folder

Previous cell output:

(<record long name: scripting toolkit example may>,
 <record long name: ti-6al-4v>)

Edit the record's attributes

Access empty date, integer and logical attributes.

diagnostic_date = record.attributes["Date of Beam Profile Diagnostic"]
build_date = record.attributes["Date of Build"]
number_of_layers = record.attributes["Maximum Number of Layers"]
closed_chamber = record.attributes["Built in Closed Chamber?"]

Date attributes

Use the value property to set the date value of the attribute with either a datetime object or a properly formatted string.

diagnostic_date.value = "2020-07-12"
build_date.value = datetime.now()

Integer attributes

Use the value property to set the integer value of the attribute.

number_of_layers.value = 5

Logical attributes

Use the value property to set the logical value of the attribute.

closed_chamber.value = True

Write your changes to MI

First, specify the attributes on the record which you want to update on the server. Then write the changes to MI. The list of updated Record objects is returned.

record.set_attributes([diagnostic_date, build_date, number_of_layers, closed_chamber])
record = mi.update([record])[0]

Output the record's attributes

Access the attribute values via the same properties you used to assign them.

datetime_format = "%b %d %Y"
diagnostic_date = record.attributes["Date of Beam Profile Diagnostic"]
print(f"Date of Beam Profile Diagnostic: {diagnostic_date.value.strftime(datetime_format)}")

build_date = record.attributes['Date of Build']
print(f"Date of Build: {build_date.value.strftime(datetime_format)}")

number_of_layers = record.attributes['Maximum Number of Layers']
print(f"Maximum Number of Layers: {number_of_layers.value}")

closed_chamber = record.attributes['Built in Closed Chamber?']
print(f"Built in Closed Chamber?: {'Yes' if closed_chamber.value else 'No'}")