zschumacher/pydapper
zschumacher/pydapper has 78 GitHub stars and 13 forks. GitHot measured 0 stars in 24 hours, 0 in 7 days, and 0 in 15 days. Last checked 2026-11-15 15:53 UTC. Last push 2026-11-05.
实测星标增长
- 24小时
- 0
- 7天
- 0
- 15天
- 0
- 1个月
- 更新延迟
各周期内的星标净变化,周期相互重叠,并非每日新增。缺失的测量保持空白。星标代表关注度,不代表软件质量。
关于
A micro ORM for the python dbapi spec inspired by the Nuget package Dapper
数据README.md
原文pydapper
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, with both sync and async dbapi support.
Help
See the documentation for more details and examples for configuring all of the connectors pydapper supports.
Installation
It is recommended to only install the database apis you need for your use case. Example below is for psycopg2!
pip
pip install pydapper[psycopg2]
poetry
poetry add pydapper -E psycopg2
Supported drivers
The database support docs go into further detail about how to connect to the different drivers pydapper supports.
In addition to psycopg2, pydapper also supports.
Sync dbapis
pymssqlmysql-connector-pythonoracledbgoogle-cloud-bigquerysqlite3psycopg
Async dbapis
aiopgpsycopg
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[0] for i in cursor.description]
data = cursor.fetchall()
list_data = [Task(**dict(zip(headers, row))) for row in data]
Instead, write...
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!