Getting started - Managing SQL using Azure Python SDK
These code samples will show you how to manage SQL using Azure SDK for Python.
This project framework provides examples for the following services:
Before we run the samples, we need to make sure we have setup the credentials. Follow the instructions in register a new application using Azure portal to obtain
client secret, and
Store your credentials an environment variables. For example, in Linux-based OS, you can do
export AZURE_TENANT_ID="xxx" export AZURE_CLIENT_ID="xxx" export AZURE_CLIENT_SECRET="xxx" export SUBSCRIPTION_ID="xxx"
If you don't already have it, install Python.
This sample (and the SDK) is compatible with Python 2.7, 3.3, 3.4, 3.5 and 3.6.
General recommendation for Python development is to use a Virtual Environment. For more information, see https://docs.python.org/3/tutorial/venv.html
Install and initialize the virtual environment with the "venv" module on Python 3 (you must install virtualenv for Python 2.7):
python -m venv mytestenv # Might be "python3" or "py -3.6" depending on your Python installation cd mytestenv source bin/activate # Linux shell (Bash, ZSH, etc.) only ./scripts/activate # PowerShell only ./scripts/activate.bat # Windows CMD only
Clone the repository.
git clone https://github.com/Azure-Samples/azure-samples-python-management.git
Install the dependencies using pip.
cd azure-samples-python-management/samples/sql pip install -r requirements.txt
A demo app is included to show how to use the project.
To run the complete demo, execute
To run each individual demo, point directly to the file. For example (i.e. not complete list):
Each file is a separate code sample that no dependency on other files. You can look at whichever code sample you're interested in