anodb 4.0.1

Convenient Wrapper around AioSQL and a Database Connection

AnoDB

Convenient Wrapper around aiosql and a Database Connection.

Description

This class creates a persistent database connection and imports SQL queries from a file.

If the connection is broken, a new connection is attempted.

Compared do aiosql, the point is not to need to pass a connection as an argument on each call: The DB class embeds both connection and query methods.

Example

Install the module with pip install anodb or whatever method you like. Once available, you can use it:

import anodb
db = anodb.DB('sqlite3', 'test.db', 'test.sql')

db.do_some_insert(key=1, val='hello')
db.do_some_update(key=1, val='world')
print("data", db.do_some_select(key=1))
db.commit()

db.close()

With file test.sql containing something like:

-- name: do_some_select
SELECT * FROM Stuff WHERE key = :key;

-- name: do_some_insert!
INSERT INTO Stuff(key, val) VALUES (:key, :val);

-- name: do_some_update!
UPDATE Stuff SET val = :val WHERE key = :key;

Versions

Sources are available on GitHub.

4.0.1

Add package __version__. Minor update for pytest_postgresql 4.0.0.

4.0

Add psycopg 3 support, and make it the default for Postgres.

3.0

Package as a simple module. Use simpler setup.cfg packaging. Include tests in package. Add coverage test and make test coverage reach 100%.

2.2

Setup explicit logger instead of relying on default.

2.1

Make cursor() reconnect if needed.

Add automatic reconnection tests.

2.0

Swith from AnoSQL to AioSQL.

1.3

Make options accept different types.

Make queries optional, and allow to load from files or strings.

1.2

Add options string parameter to constructor.

1.1

Add **conn_options parameter to constructor.

Add cursor() method.

1.0

Initial release.

TODO

• add support for other drivers? eg. pg8000, pygresql
• add support for psycopg3 connection pool?