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
|
# 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_query_tables_async.py
DESCRIPTION:
These samples demonstrate the following: listing and querying all Tables within
a storage account.
USAGE:
python sample_query_tables_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 asyncio
import os
from dotenv import find_dotenv, load_dotenv
class QueryTables(object):
def __init__(self):
load_dotenv(find_dotenv())
self.access_key = os.environ["TABLES_PRIMARY_STORAGE_ACCOUNT_KEY"]
self.endpoint_suffix = os.environ["TABLES_STORAGE_ENDPOINT_SUFFIX"]
self.account_name = os.environ["TABLES_STORAGE_ACCOUNT_NAME"]
self.connection_string = f"DefaultEndpointsProtocol=https;AccountName={self.account_name};AccountKey={self.access_key};EndpointSuffix={self.endpoint_suffix}"
async def tables_in_account(self):
# Instantiate the TableServiceClient from a connection string
from azure.data.tables.aio import TableServiceClient
table_service = TableServiceClient.from_connection_string(conn_str=self.connection_string)
async with table_service:
await table_service.create_table("mytableasync1")
await table_service.create_table("mytableasync2")
try:
# [START tsc_list_tables]
# List all the tables in the service
print("Listing tables:")
async for table in table_service.list_tables():
print(f"\t{table.name}")
# [END tsc_list_tables]
# [START tsc_query_tables]
# Query for "table1" in the tables created
table_name = "mytableasync1"
name_filter = f"TableName eq '{table_name}'"
print("Queried_tables")
async for table in table_service.query_tables(name_filter):
print(f"\t{table.name}")
# [END tsc_query_tables]
finally:
await self.delete_tables()
async def delete_tables(self):
from azure.data.tables.aio import TableServiceClient
ts = TableServiceClient.from_connection_string(conn_str=self.connection_string)
async with ts:
tables = ["mytableasync1", "mytableasync2"]
for table in tables:
try:
await ts.delete_table(table_name=table)
except:
pass
async def main():
sample = QueryTables()
await sample.tables_in_account()
if __name__ == "__main__":
asyncio.run(main())
|
