def batch_entry(): batch = TableBatch() order004 = { 'PartitionKey': 'ordersSeattle', 'RowKey': '004', 'description': 'Go grocery shopping', 'priority': 400 } order005 = { 'PartitionKey': 'ordersSeattle', 'RowKey': '005', 'description': 'Clean the bathroom', 'priority': 100 } batch.insert_entity(order004) batch.insert_entity(order005) table_service.commit_batch('ordertable', batch) order006 = { 'PartitionKey': 'ordersSeattle', 'RowKey': '006', 'description': 'Go grocery shopping', 'priority': 400 } order010 = { 'PartitionKey': 'ordersSeattle', 'RowKey': '007', 'description': 'Clean the bathroom', 'priority': 100 } with table_service.batch('ordertable') as batch: batch.insert_entity(order006) batch.insert_entity(order007)
def upload_data_to_azure(table_service): global data # Create table if it doesn't exist table_service.create_table(dataset_table_name, fail_on_exist=False) batch = TableBatch() for d in data: batch.insert_entity(d) table_service.commit_batch(dataset_table_name, batch) data = []
def update_table_storage_based_on_new_data(subscription_id, non_compliant_resources, non_compliant_ids_to_add, non_compliant_ids_to_delete, table_service): """ Makes a batch update by adding / deleting rows from the table storage """ batch = TableBatch() for ncr in non_compliant_resources: if ncr['RowKey'] in non_compliant_ids_to_add: batch.insert_entity(ncr) for row_key in non_compliant_ids_to_delete: batch.delete_entity(subscription_id, row_key) table_service.commit_batch(RECOMMENDATIONS_TABLE_NAME, batch)
def main(req: func.HttpRequest) -> func.HttpResponse: logging.info('Starting bulk insert.') ret = dict() table_name = req.headers.get('name') values = req.get_json() if table_name: retrieved_secret = getConnectionString() table_service = TableService(connection_string=retrieved_secret.value) batch = TableBatch() for i in range(0, len(values['rows'])): batch.insert_entity(values['rows'][i]) table_service.commit_batch(table_name, batch) ret['result'] = "Success" return func.HttpResponse(json.dumps(ret), status_code=200) else: ret['result'] = 'Error' return func.HttpResponse(json.dumps(ret), status_code=400)
def insert_batch(self, items: list): batch = TableBatch() for item in items: batch.insert_entity(self.get_payload(item)) return self.table.commit_batch(self.table_name, batch)
) batch = TableBatch() task008 = { 'PartitionKey': 'tasksTigard', 'RowKey': '008', 'description': 'Go grocery shopping', 'priority': 400 } task009 = { 'PartitionKey': 'tasksTigard', 'RowKey': '009', 'description': 'Clean the bathroom', 'priority': 100 } batch.insert_entity(task008) batch.insert_entity(task009) table_service.commit_batch('tasktable', batch) task010 = { 'PartitionKey': 'tasksTigard', 'RowKey': '010', 'description': 'Go grocery shopping', 'priority': 400 } task011 = { 'PartitionKey': 'tasksTigard', 'RowKey': '011', 'description': 'Clean the bathroom', 'priority': 100 }
table_service.insert_or_replace_entity('tasktable', task) # Insert a new entity print("insert or replay rowkey 003 - buy detergent") task = {'PartitionKey': 'tasksSeattle', 'RowKey': '003', 'description': 'Buy detergent', 'priority': 300} table_service.insert_or_replace_entity('tasktable', task) # batch processing - Add multiple entries print("batch processing task 004/005") batch = TableBatch() task004 = {'PartitionKey': 'tasksSeattle', 'RowKey': '004', 'description': 'Go grocery shopping', 'priority': 400} task005 = {'PartitionKey': 'tasksSeattle', 'RowKey': '005', 'description': 'Clean the bathroom', 'priority': 100} batch.insert_entity(task004) batch.insert_entity(task005) table_service.commit_batch('tasktable', batch) # alternative way to use batch, using context print("batch insert using context...") task006 = {'PartitionKey': 'tasksSeattle', 'RowKey': '006', 'description': 'Go grocery shopping', 'priority': 400} task007 = {'PartitionKey': 'tasksSeattle', 'RowKey': '007', 'newCol': 'newColVal1', 'description': 'Clean the bathroom', 'priority': 100} with table_service.batch('tasktable') as batch: batch.insert_entity(task006) batch.insert_entity(task007) # Query