What is Table storage?

Azure Table Storage Service (https://azure.microsoft.com/en-us/documentation/articles/storage-python-how-to-use-table-storage/) stores a large amount of structured data. I will. This service is a ** NoSQL datastore ** that accepts authenticated calls from inside and outside the Azure cloud. The point is that you can store SQL data externally. Using PTVS This is useful when you want to use SQL with Django.

Use Azure table storage with your Flask app

Project creation

** [New project] ▶ ︎ [Python / Sample] ▶ ︎ [Polls Flask Web Projetc] ** Create a new Flask project １.png

App execution

Run and run to launch the Polls sample. ２.png Select What is your favorite season? ３.png Actually vote ４.png

You will actually be voted! ５.png

Use Azure table storage

If you select ** About ** here, the Current repository will have ** In-Memory **. Make ** Azure table storage available ** ６.png

** [Project / Right click] ▶ ︎ [Debug] ▶ ︎ [Debug Server Command] ** Fill in the Environment as below. Here, we will omit how to create storage in Azure. For details, refer to here

REPOSITORY_NAME=azuretablestorage
STORAGE_NAME=<storage account name>
STORAGE_KEY=<primary access key>

** * After filling in, right-click the solution and rebuild ** ** After execution, an error will occur, but please press [Continue]! ** ** Press About and it changed from ** In memory ** to ** Azure Table Storage **! ８.png

Deploy on Azure

[Deploy] to Azure (http://qiita.com/saiyuki1919/items/db6f9a2c705a1c9135dc) and ** [App Service] ▶ ︎ [APP] ▶ ︎ [Application Settings] ** Select and fill in the app settings in the same way as you did on VS to get Azure Table Storage.

If you deploy, it will return to ** In Memory **, so you need to set it again on Azure.

REPOSITORY_NAME=azuretablestorage
STORAGE_NAME=<storage account name>
STORAGE_KEY=<primary access key>

９.png

After execution, if you select About on the actual web, it will be ** Azure Tbale Storage ** １０.png