dinao 1.1.0

A simple database API

Introduction

What is DINAO? Well it might be easier to tell you what its not. DINAO Is Not An ORM. If you want an ORM, SQLAlchemy is absolutely the best python has to offer.

Target Audience

Do you like writing SQL? Do you hate all the boiler plate involved with setting up connections and cursors then cleaning them up? Would you just like something simple that executes a query and can map the results to simple data classes? Then DINAO is for you!

Influences and Guiding Principles

The APIs implemented mirror libraries I’ve used in other ecosystems. Specifically you may notice similarities to the JDBI Declarative API or the MyBatis interface mappers. This is because I very much like this approach. You’re the developer, I’m just here to reduce the number of lines of code you have to write to meet your goal. At the end of the day you know your schema and database better than I do, and so you know what kinds of queries you need to write better than I do.

How do you pronounce DINAO?

You pronounce it “Dino” like “Dinosaur”. Going back to plain old SQL probably seems rather archaic after all.

Usage

Install via pip:

$ pip install dinao

You will also need to install your backend driver. Backends + drivers supported are:

• Sqlite3 via Python’s standard library

• PostgreSQL via psycopg2

Basic Example

DINAO focuses binding functions to scoped connections / transactions against the database and using function signatures and type hinting to infer mapping and query parametrization.

Below shows a simple example of DINAO usage. For more comprehensive usage and feature showcase see examples.

from typing import List
from dataclasses import dataclass
from dinao.backend import create_connection_pool, Connection
from dinao.binding import FunctionBinder

binder = FunctionBinder()

@dataclass
class MyModel:
    name: str
    value: int

@binder.execute(
    "CREATE TABLE IF NOT EXISTS my_table ( "
    "  name VARCHAR(32) PRIMARY KEY, "
    "  value INTEGER DEFAULT 0"
    ")"
)
def make_table():
    pass


@binder.execute(
    "INSERT INTO my_table (name, value) VALUES(#{model.name}, #{model.value}) "
    "ON CONFLICT (name) DO UPDATE "
    "  SET value = #{model.value} "
    "WHERE my_table.name = #{model.name}"
)
def upsert(model: MyModel) -> int:
    pass


@binder.query("SELECT name, value FROM my_table WHERE my_table.name LIKE #{search_term}")
def search(search_term: str) -> List[MyModel]:
    pass


@binder.transaction()
def populate(cnx: Connection = None):
    make_table()
    cnx.commit()
    upsert(MyModel("testing", 52))
    upsert(MyModel("test", 39))
    upsert(MyModel("other_thing", 20))


if __name__ == '__main__':
    con_url = "sqlite3:///tmp/example.db"
    db_pool = create_connection_pool(con_url)
    binder.pool = db_pool
    populate()
    for model in search("test%"):
        print(f"{model.name}: {model.value}")

Contributing

Check out our code of conduct and contributing documentation.