a pure python port of the NuGet library dapper
PYDAPPER_DSN
environment variable for connections. PR #21 by @zschumacher.cx_Oracle
. PR #17 by @zschumacher.🚀 First stable release of pydapper!
pydapper supports MySQL, PostgreSQL, Microsoft SQL Server and SQLite and strives to prevent you from ever having to write this code again:
from psycopg2 import connect
with connect("postgresql://pydapper:pydapper@localhost/pydapper") as conn:
with conn.cursor() as cursor:
cursor.execute("select * from task")
headers = [i[0] for i in cursor.description]
data = cursor.fetchall()
list_data = [dict(zip(headers, row)) for row in data]
buffered
kwarg to query
method. PR #12 by @zschumacher.initial alpha release of pydapper