ensure_open_sqlite_gz

ensure_open_sqlite_gz(key: str, *subkeys: str, url: str, name: str | None = None, force: bool = False, download_kwargs: DownloadKwargs | None = None) → Generator[Connection, None, None]

Ensure and connect to a gzipped SQLite database.

Parameters:

• key – The name of the module. No funny characters. The envvar <key>_HOME where key is uppercased is checked first before using the default home directory.

• subkeys – A sequence of additional strings to join. If none are given, returns the directory for this module.

• url – The URL to download.

• name – Overrides the name of the file at the end of the URL, if given. Also useful for URLs that don’t have proper filenames with extensions.

• force – Should the download be done again, even if the path already exists? Defaults to false.

• download_kwargs – Keyword arguments to pass through to pystow.utils.download().

Yields:

An instance of sqlite3.Connection from sqlite3.connect()

Example usage: >>> import pystow >>> import pandas as pd >>> url = “https://s3.amazonaws.com/bbop-sqlite/hp.db.gz” >>> sql = “SELECT * FROM entailed_edge LIMIT 10” >>> with pystow.ensure_open_sqlite_gz(“test”, url=url) as conn: >>> df = pd.read_sql(sql, conn)