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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
|
# 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_insert_delete_entities_async.py
DESCRIPTION:
These samples demonstrate the following: inserting entities into a table
and deleting tables from a table.
USAGE:
python sample_insert_delete_entities_async.py
Set the environment variables with your own values before running the sample:
1) TABLES_STORAGE_ENDPOINT_SUFFIX - the Table service account URL suffix
2) TABLES_STORAGE_ACCOUNT_NAME - the name of the storage account
3) TABLES_PRIMARY_STORAGE_ACCOUNT_KEY - the storage account access key
"""
import os
import asyncio
from datetime import datetime
from uuid import uuid4
from dotenv import find_dotenv, load_dotenv
class InsertDeleteEntity(object):
def __init__(self):
load_dotenv(find_dotenv())
self.access_key = os.getenv("TABLES_PRIMARY_STORAGE_ACCOUNT_KEY")
self.endpoint_suffix = os.getenv("TABLES_STORAGE_ENDPOINT_SUFFIX")
self.account_name = os.getenv("TABLES_STORAGE_ACCOUNT_NAME")
self.endpoint = "{}.table.{}".format(self.account_name, self.endpoint_suffix)
self.connection_string = "DefaultEndpointsProtocol=https;AccountName={};AccountKey={};EndpointSuffix={}".format(
self.account_name, self.access_key, self.endpoint_suffix
)
self.table_name = "InsertDeleteAsync"
self.entity = {
"PartitionKey": "color",
"RowKey": "brand",
"text": "Marker",
"color": "Purple",
"price": 4.99,
"last_updated": datetime.today(),
"product_id": uuid4(),
"inventory_count": 42,
"barcode": b"135aefg8oj0ld58" # cspell:disable-line
}
async def create_entity(self):
from azure.data.tables.aio import TableClient
from azure.core.exceptions import ResourceExistsError, HttpResponseError
table_client = TableClient.from_connection_string(self.connection_string, self.table_name)
# Create a table in case it does not already exist
# [START create_entity]
async with table_client:
try:
await table_client.create_table()
except HttpResponseError:
print("Table already exists")
try:
resp = await table_client.create_entity(entity=self.entity)
print(resp)
except ResourceExistsError:
print("Entity already exists")
# [END create_entity]
async def delete_entity(self):
from azure.data.tables.aio import TableClient
from azure.core.exceptions import ResourceExistsError
from azure.core.credentials import AzureNamedKeyCredential
credential = AzureNamedKeyCredential(self.account_name, self.access_key) # type: ignore[arg-type]
table_client = TableClient(endpoint=self.endpoint, table_name=self.table_name, credential=credential)
# [START delete_entity]
async with table_client:
try:
resp = await table_client.create_entity(entity=self.entity)
except ResourceExistsError:
print("Entity already exists!")
await table_client.delete_entity(row_key=self.entity["RowKey"], partition_key=self.entity["PartitionKey"]) # type: ignore[call-overload]
print("Successfully deleted!")
# [END delete_entity]
async def clean_up(self):
from azure.data.tables.aio import TableServiceClient
tsc = TableServiceClient.from_connection_string(self.connection_string)
async with tsc:
async for table in tsc.list_tables():
await tsc.delete_table(table.name)
print("Cleaned up")
async def main():
ide = InsertDeleteEntity()
await ide.create_entity()
await ide.delete_entity()
await ide.clean_up()
if __name__ == "__main__":
asyncio.run(main())
|
