db-api-2

IronPython db-api 2.0

Does anyone know which if any db-api 2.0 drivers work with IronPython? If so, has anyone tried using it with SQLAlchemy, SQLObject or the Django ORM? ...

How do I determine the proper `paramstyle` when all I have is a `Connection` object?

I have an instance of a Connection (required to DB API 2.0-compliant), but I don't have the module from which it was imported. The problem is that I am trying to use named parameters, but I don't know which paramstyle to use. Since paramstyle is a module-level constant, I can't just ask the Connection. I tried using inspect.getmodule() ...

Cancel query execution in pyscopg2

Hi, How would one go about cancelling execution of a query statement using pyscopg2 (the python Postgres driver)? As an example, let's say I have the following code: import psycopg2 cnx_string = "something_appropriate" conn = psycopg2.connect(cnx_string) cur = conn.cursor() cur.execute("long_running_query") Then I want to cancel th...