ahvn.cache.db_cache module

Database-based cache backend.

class ahvn.cache.db_cache.DatabaseCache(provider=None, database=None, exclude=None, *args, **kwargs)

Bases: BaseCache

An implementation of BaseCache that stores data in a database table using JSON columns. Each cache entry is stored as a row with a string key and JSON data using the CacheORMEntity model.

Parameters:

• provider (str)

• database (str)

• exclude (Iterable[str] | None)

__init__(provider=None, database=None, exclude=None, *args, **kwargs)

Initialization.

Parameters:

• provider (str) – Database provider (‘sqlite’, ‘pg’, ‘duckdb’, etc.).

• database (str) – Database name or path (‘:memory:’ for in-memory).

• exclude (Optional[Iterable[str]]) – Keys to exclude from inputs when creating cache entries.

• *args – Additional positional arguments.

• **kwargs – Additional keyword arguments for database connection.

__len__()

Get the number of cache entries.

Returns:

The number of entries in the cache.

Return type:

int

Raises:

DatabaseError – If the count is not correctly returned from SQL.

close()

Close the database connection.