def test_get_new_supplier_id():
mfg_name = "GenericSupplierNameDONOTUSE"
supplier_id = airtable_api.get_supplier_id(mfg_name)
supplier = Airtable(airtable_api.OPERATIONS_ID, "Suppliers")
result = supplier.get(supplier_id)
assert result is not None
supplier.delete(supplier_id)
assert result['fields']['Name'] == mfg_name
def test_get_new_manufacturer_id():
mfg_name = "GenericTestManufacturerNameDONOTUSE"
manufacturer_id = airtable_api.get_manufacturer_id(mfg_name)
manufacturer = Airtable(airtable_api.OPERATIONS_ID, "Manufacturers")
result = manufacturer.get(manufacturer_id)
assert result is not None
manufacturer.delete(manufacturer_id)
assert result['fields']['Name'] == mfg_name
def delete_from_airtable(rec_id, table_name):
"""
wrapper function to delete a record in airtable
:param rec_id: the record to delete
:param table_name: from this table
"""
logger.info('## Deleting {} from {}'.format(rec_id, table_name))
table = Airtable(intake_form_constants.AIRTABLE_BASE_KEY, table_name, api_key=os.environ['AIRTABLE_KEY'])
table.delete(rec_id)
logger.info('## Deleted Successfully')
def test_add_part():
user, org = create_user_and_organization()
create_some_fake_parts(org)
part = Part.objects.first()
part_id = airtable_api.add_part(part)
inventory = Airtable(airtable_api.OPERATIONS_ID, "Inventory")
result = inventory.get(part_id)
assert result is not None
inventory.delete(part_id)
def test_add_new_mfg_part():
user, org = create_user_and_organization()
create_some_fake_parts(org)
mfg_part = ManufacturerPart.objects.first()
created_id = airtable_api.add_mfg_part(mfg_part)
manufacturer_parts = Airtable(airtable_api.OPERATIONS_ID,
"Manufacturer Parts")
result = manufacturer_parts.get(created_id)
assert result is not None
manufacturer_parts.delete(created_id)
# Insert
rec = airtable.insert({"text": "A", "number": 1, "boolean": True})
# Get
assert airtable.get(rec["id"])
# Update
rv = airtable.update(rec["id"], {"text": "B"})
assert rv["fields"]["text"] == "B"
# Replace
rv = airtable.replace(rec["id"], {"text": "C"})
assert rv["fields"]["text"] == "C"
# Get all
assert airtable.get_all()
# Delete
assert airtable.delete(rec["id"])
# Batch Insert
records = airtable.batch_insert([{
"text": "A",
"number": 1,
"boolean": True
} for _ in range(100)])
# Batch Delete
records = airtable.batch_delete([r["id"] for r in records])
assert len(records) == 100
def delete_request(request_id):
table = Airtable(BASE_ID, REQUESTS_TABLE_NAME, api_key=API_KEY)
logging.info('delete_request')
table.delete(request_id)
