def test_write_only_activity_parameters_no_activate_others(no_init):
Database("PCB").register()
obj = ExcelImporter()
obj.db_name = "PCB"
obj.data = deepcopy(DATA)
obj.write_database(activate_parameters=False)
NEW = [
{
"code": "45cb34db4147e510a2561cceec541f6b",
"database": "PCB",
"exchanges": [],
"name": "unmounted printed circuit board",
"type": "process",
"unit": "square meter",
"parameters": [{"name": "something_test", "amount": 2, "formula": "3 + 2"}],
}
]
obj = ExcelImporter()
obj.db_name = "PCB"
obj.write_activity_parameters(NEW)
assert ActivityParameter.select().count() == 1
assert ActivityParameter.get().formula == "3 + 2"
assert "parameters" not in get_activity(("PCB", "45cb34db4147e510a2561cceec541f6b"))
assert "parameters" in get_activity(("PCB", "32aa5ab78beda5b8c8efbc89587de7a5"))
def test_write_only_activity_parameters_no_activate_others(no_init):
Database("PCB").register()
obj = ExcelImporter()
obj.db_name = "PCB"
obj.data = deepcopy(DATA)
obj.write_database(activate_parameters=False)
NEW = [{
'code':
'45cb34db4147e510a2561cceec541f6b',
'database':
'PCB',
'exchanges': [],
'name':
'unmounted printed circuit board',
'type':
'process',
'unit':
'square meter',
'parameters': [{
'name': 'something_test',
'amount': 2,
'formula': '3 + 2'
}],
}]
obj = ExcelImporter()
obj.db_name = "PCB"
obj.write_activity_parameters(NEW)
assert ActivityParameter.select().count() == 1
assert ActivityParameter.get().formula == '3 + 2'
assert 'parameters' not in get_activity(
('PCB', '45cb34db4147e510a2561cceec541f6b'))
assert 'parameters' in get_activity(
('PCB', '32aa5ab78beda5b8c8efbc89587de7a5'))
def test_write_only_activity_parameters(no_init):
assert not ActivityParameter.select().count()
Database("PCB").register()
obj = ExcelImporter()
obj.db_name = "PCB"
obj.data = deepcopy(DATA)
obj.write_database()
assert ActivityParameter.select().count() == 1
assert ActivityParameter.get().amount != 7
NEW = [{
'code':
'32aa5ab78beda5b8c8efbc89587de7a5',
'database':
'PCB',
'parameters': [{
'name': 'PCB_mass_total',
'amount': 11,
'formula': '7'
}],
}]
obj.write_activity_parameters(NEW)
assert ActivityParameter.select().count() == 1
a = ActivityParameter.get()
assert a.formula == '7'
assert a.amount == 7
def test_empty_activity_parameters_dont_delete(no_init):
# Empty activity parameters aren't considered at all
# so they shouldn't be deleted if empty section provided
Database("PCB").register()
obj = ExcelImporter()
obj.db_name = "PCB"
obj.data = deepcopy(DATA)
obj.write_database()
assert len(parameters)
NEW = deepcopy(DATA)
for ds in NEW:
if "parameters" in ds:
del ds["parameters"]
Database("PCB").register()
obj = ExcelImporter()
obj.db_name = "PCB"
obj.data = NEW
obj.write_database(delete_existing=False)
assert len(parameters)
def test_write_only_database_parameters(no_init):
Database("foo").register()
obj = ExcelImporter()
obj.db_name = "foo"
obj.data = None
obj.database_parameters = deepcopy(DB)
obj.write_database_parameters(activate_parameters=False)
assert not DatabaseParameter.select().count()
assert "parameters" in obj.metadata
obj.write_database_parameters()
assert DatabaseParameter.select().count() == 3
obj.database_parameters = deepcopy(DB[:1])
obj.write_database_parameters()
assert DatabaseParameter.select().count() == 1
def test_write_only_activity_parameters(no_init):
assert not ActivityParameter.select().count()
Database("PCB").register()
obj = ExcelImporter()
obj.db_name = "PCB"
obj.data = deepcopy(DATA)
obj.write_database()
assert ActivityParameter.select().count() == 1
assert ActivityParameter.get().amount != 7
NEW = [
{
"code": "32aa5ab78beda5b8c8efbc89587de7a5",
"database": "PCB",
"parameters": [{"name": "PCB_mass_total", "amount": 11, "formula": "7"}],
}
]
obj.write_activity_parameters(NEW)
assert ActivityParameter.select().count() == 1
a = ActivityParameter.get()
assert a.formula == "7"
assert a.amount == 7
