SQL Writer

This guide shows you how to work with Azure SQL Database locally using Azure Functions and SQLAlchemy. This lab demonstrates how to process HTTP POST requests and persist data into a local SQL database.

Prerequisites

Docker installed and running.
Dev Containers extension installed (optional).

How to execute

Setup Environment:
- Dev Container (recommended)
- Manually
Open VS Code in the project folder and execute this command in the Command Palette:
Terminal window
> Dev Containers: Reopen in Container
1. Run the setup script to install tools and dependencies:
  Terminal window
  scripts/setup-mve.sh
2. Start Infrastructure: Launch the SQL Edge and Azurite containers:
  Terminal window
  docker compose up -d
Start Azurite: From the Command Palette, select Azurite: Start Blob Service. This starts the local blob storage emulator required by the Azure Functions runtime.
Start Function Host:
Terminal window
```
func start
```
Run the Example:
Terminal window
```
python main.py
```

Validate results

This lab includes a pre-configured connection profile for the SQL Server (mssql) extension in .vscode/settings.json.

SQL Server Extension
External Client

Open the SQL Server extension in VS Code.
Select the Azure SQL Edge (Local) connection profile.
Run the following query to verify the data:
```
SELECT * FROM Users;
```

Connect using the connection details defined in .vscode/settings.json:

Server localhost.
Port 1433.
Database UserDB.

Clean Up

docker compose down -v

Troubleshooting

Issue	Solution
`ImportError: libodbc.so.2`	Run `scripts/setup-mve.sh` to install ODBC system dependencies.
`AzureWebJobsStorage` error	Ensure Azurite Blob Service is started (Azurite: Start Blob Service) and port `10000` is available.