eshirazi

import socks
import pytds
from sqlalchemy import create_engine
from sqlalchemy.pool import StaticPool

host = ...
port = 1433
user = ...
password = ...
socks_proxy_host = ...

eshirazi

# On mac, run these first:
# - brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
# - brew update
# - brew install msodbcsql17 mssql-tools
#
# Install requirements:
# - pip install pyodbc sqlalchemny

import urllib
from sqlalchemy import create_engine

eshirazi

import sqlalchemy.event

def show_query_stack_traces():
    base_path = os.path.abspath(os.path.join(os.path.dirname(__file__), ".."))

    def catch_queries_callback(connection, cursor, query, *_):
        print query
        stacktrace = [
            (file_path, val1, val2, line_contents)
            for (file_path, val1, val2, line_contents) in traceback.extract_stack()