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)