1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
# coding: utf-8
# -------------------------------------------------------------------------
# Copyright (c) Microsoft Corporation. All rights reserved.
# Licensed under the MIT License. See License.txt in the project root for
# license information.
# --------------------------------------------------------------------------
"""
FILE: sample_batching.py
DESCRIPTION:
These samples demonstrate how to use the batching API to perform multiple
operations within a single request
USAGE:
python sample_batching.py
Set the environment variables with your own values before running the sample:
1) AZURE_STORAGE_CONNECTION_STRING - the connection string to your storage account
"""
from datetime import datetime, timedelta
import os
import asyncio
class CreateClients(object):
connection_string = os.getenv("AZURE_TABLES_CONNECTION_STRING")
my_table = os.getenv("AZURE_TABLES_NAME") or ""
def sample_batching(self):
# Instantiate a TableServiceClient using a connection string
entity1 = {
'PartitionKey': 'pk001',
'RowKey': 'rk001',
'Value': 4,
'day': "Monday",
'float': 4.003
}
entity2 = {
'PartitionKey': 'pk001',
'RowKey': 'rk002',
'Value': 4,
'day': "Tuesday",
'float': 4.003
}
entity3 = {
'PartitionKey': 'pk001',
'RowKey': 'rk003',
'Value': 4,
'day': "Wednesday",
'float': 4.003
}
entity4 = {
'PartitionKey': 'pk001',
'RowKey': 'rk004',
'Value': 4,
'day': "Thursday",
'float': 4.003
}
# [START batching]
from azure.data.tables import TableClient, UpdateMode
table_client = TableClient.from_connection_string(conn_str=self.connection_string, table_name="tableName")
batch = table_client.create_batch()
batch.create_entity(entity1)
batch.delete_entity(entity2)
batch.upsert_entity(entity3)
batch.update_entity(entity4, mode=UpdateMode.REPLACE)
try:
table_client.send_batch(batch)
except BatchErrorException as e:
print("There was an error with the batch operation")
print("Error: {}".format(e))
# [END batching]
if __name__ == '__main__':
sample = CreateClients()
sample.sample_batching()
|
