azure77 0.1.0

Upload, query and manage data on Azure SQL Server from Python

azure77

Upload, query and manage data on Azure SQL Server from Python.

Installation

pip install azure77

Quick Start

from azure77 import ConnectionManager

# Connect to Azure SQL
cm = ConnectionManager(
    server="your-server.database.windows.net",
    database="your-db",
    user="your-user",
    password="your-pass",
)

# Test connection
result = cm.test_connection()
print(result.success, result.message)

Features

• Connection management — Azure SQL via pyodbc or pymssql
• Client/schema organization — each client maps to a SQL schema
• File upload — CSV, XLSX, XLS with auto encoding/detection
• Column normalization — lowercase, accent-free, SQL-safe names
• Type inference — automatic INTEGER, DECIMAL, DATE, NVARCHAR
• SQL query execution — with safety validation (blocks DROP, DELETE, etc.)
• Query history — stored in local SQLite
• Dataset browsing — metadata, import logs, schema diff
• Benchmark — measure upload performance across strategies

CLI

azure77 connection test          # Test Azure SQL connection
azure77 connection status        # Show config status
azure77 client list              # List clients
azure77 client create "Nome"     # Create client
azure77 upload preview file.csv  # Preview file
azure77 upload import file.csv --client adl --table vendas
azure77 datasets list adl        # List datasets
azure77 benchmark run file.csv   # Run benchmark

Configuration

Create a .env file:

AZURE77_SERVER=server.database.windows.net
AZURE77_DATABASE=dbname
AZURE77_USER=username
AZURE77_PASSWORD=password

Or pass directly:

cm = ConnectionManager(
    server="...",
    database="...",
    user="...",
    password="...",
    driver="pymssql",  # or "pyodbc"
)

License

MIT