SQLite Cache

SQLiteCache(path: str = get_cache_root() / 'cache.sqlite', expiry: Optional[int] = 14)

The SQLiteCache object to cache search results from ComicVine.

PARAMETER DESCRIPTION
path

Path to database.

TYPE: str DEFAULT: get_cache_root() / 'cache.sqlite'

expiry

How long to keep cache results.

TYPE: Optional[int] DEFAULT: 14

ATTRIBUTE DESCRIPTION
expiry

How long to keep cache results.

TYPE: Optional[int]

con

Database connection

TYPE: sqlite3.Connection

cur

Database cursor

TYPE: sqlite3.Cursor

Functions

delete()

Remove all expired data from the cache database.

get(key: str) -> Optional[Dict[str, Any]]

Retrieve data from the cache database.

PARAMETER DESCRIPTION
key

Search string

TYPE: str

RETURNS DESCRIPTION
Optional[Dict[str, Any]]

None or select results.

insert(query: str, response: str)

Insert data into the cache database.

PARAMETER DESCRIPTION
query

Search string

TYPE: str

response

Data to save

TYPE: str

select(query: str) -> Dict[str, Any]

Retrieve data from the cache database.

PARAMETER DESCRIPTION
query

Search string

TYPE: str

RETURNS DESCRIPTION
Dict[str, Any]

Empty dict or select results.

store(key: str, value: str)

Insert data into the cache database.

PARAMETER DESCRIPTION
key

Search string

TYPE: str

value

Data to save

TYPE: str