A pure python lib inspired by the dotnet lib dapper
A pure python library inspired by the NuGet library dapper.
pydapper is built on top of the dbapi 2.0 spec to provide more convenient methods for working with databases in python.
See the documentation for more details.
It is recommended to only install the database apis you need for your use case. Example below is for psycopg2!
pip install pydapper[psycopg2]
poetry add pydapper -E psycopg2
Never write this again...
from psycopg2 import connect @dataclass class Task: id: int description: str due_date: datetime.date with connect("postgresql://pydapper:pydapper@localhost/pydapper") as conn: with conn.cursor() as cursor: cursor.execute("select id, description, due_date from task") headers = [i for i in cursor.description] data = cursor.fetchall() list_data = [Task(**dict(zip(headers, row))) for row in data]
from dataclasses import dataclass import datetime import pydapper @dataclass class Task: id: int description: str due_date: datetime.date with pydapper.connect("postgresql+psycopg2://pydapper:pydapper@locahost/pydapper") as commands: tasks = commands.query("select id, description, due_date from task;", model=Task)
(This script is complete, it should run "as is")
Buy me a coffee
If you find this project useful, consider buying me a coffee!
Release history Release notifications | RSS feed
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
pydapper-0.8.0.tar.gz (12.5 kB view hashes)
pydapper-0.8.0-py3-none-any.whl (17.0 kB view hashes)