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
|
# 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_create_delete_table_async.py
DESCRIPTION:
These samples demonstrate creating and deleting individual tables from the
TableServiceClient and TableClient
USAGE:
python sample_create_client_async.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
2) AZURE_STORAGE_ACCOUNT_URL - the Table service account URL
3) AZURE_STORAGE_ACCOUNT_NAME - the name of the storage account
4) AZURE_STORAGE_ACCESS_KEY - the storage account access key
"""
import os
import logging
import asyncio
_LOGGER = logging.getLogger(__name__)
class CreateDeleteTable(object):
connection_string = os.getenv("AZURE_TABLES_CONNECTION_STRING")
access_key = os.getenv("AZURE_TABLES_KEY")
account_url = os.getenv("AZURE_TABLES_ACCOUNT_URL")
account_name = os.getenv("AZURE_TABLES_ACCOUNT_NAME")
table_name = "OfficeSupplies"
async def create_table(self):
from azure.data.tables.aio import TableServiceClient
from azure.core.exceptions import ResourceExistsError
# [START create_table]
async with TableServiceClient.from_connection_string(self.connection_string) as table_service_client:
try:
table_item = await table_service_client.create_table(table_name=self.table_name)
print("Created table {}!".format(table_item.table_name))
except ResourceExistsError:
print("Table already exists")
# [END create_table]
async def create_if_not_exists(self):
from azure.data.tables.aio import TableServiceClient
# [START create_if_not_exists]
async with TableServiceClient.from_connection_string(self.connection_string) as table_service_client:
table_item = TableServiceClient.create_table_if_not_exists(table_name=self.table_name)
print("Table name: {}".format(table_item.table_name))
# [END create_if_not_exists]
async def delete_table(self):
from azure.data.tables.aio import TableServiceClient
from azure.core.exceptions import ResourceNotFoundError
# [START delete_table]
async with TableServiceClient.from_connection_string(self.connection_string) as table_service_client:
try:
await table_service_client.delete_table(table_name=self.table_name)
print("Deleted table {}!".format(self.table_name))
except ResourceNotFoundError:
print("Table could not be found")
# [END delete_table]
async def create_from_table_client(self):
from azure.data.table import TableClient
# [START create_from_table_client]
async with TableClient.from_connection_string(conn_str=self.connection_string, table_name=self.table_name) as table_client:
try:
table_item = await table_client.create_table()
print("Created table {}!".format(table_item.table_name))
except ResourceExistsError:
print("Table already exists")
# [END create_from_table_client]
async def delete_from_table_client(self):
from azure.data.table import TableClient
# [START delete_from_table_client]
async with TableClient.from_connection_string(conn_str=self.connection_string, table_name=self.table_name) as table_client:
try:
await table_client.delete_table()
print("Deleted table {}!".format(self.table_name))
except ResourceNotFoundError:
print("Table already exists")
# [END delete_from_table_client]
async def main():
sample = CreateDeleteTable()
await sample.create_table()
await sample.delete_table()
if __name__ == '__main__':
asyncio.run(main())
|
