duckdb-cursor 0.2

DuckDB cursor wrapper

DuckDB-Cursor

DuckDB-Cursor is simple DuckDB wrapper.

Install

First install library,

pip install duckdb-cursor

Usage

Create an CURSOR object,

from duckdb import connect
from duckdb_cursor import CURSOR

cur = CURSOR(connect("db.duckdb"))
cur.set("INSERT INTO users VALUES(1, ?);", ('Wendys', ))
del cur

can select one row,

cur = CURSOR(connect("db.duckdb"))
row = cur.get("SELECT name FROM users WHERE id=1;", as_dict=True, one=True)
del cur

print(row['name'])

can select all rows,

cur = CURSOR(connect("db.duckdb"))
rows = cur.get("SELECT name FROM users;")
del cur

print(rows)

Contributing

DuckDB-Cursor is developed on GitLab. You are very welcome to open issues or propose merge requests.

Help

This README is the best place to start, after that try opening an issue.