sql-impressao 1.1.0

A SQL fingerprinter.

Python bindings for sql-fingerprint, a SQL fingerprinter. (Impressão digital is Portuguese for “fingerprint”.)

A quick example:

>>> from sql_impressao import fingerprint_one
>>> fingerprint_one('SELECT a, b FROM cheeses WHERE origin = "France" ORDER BY age DESC')
'SELECT ... FROM cheeses WHERE ... ORDER BY ...'

---

Improve your Django and Git skills with my books.

---

Installation

With pip:

python -m pip install sql-impressao

Python 3.9 to 3.13 supported.

Usage

fingerprint_one(sql: str, *, dialect: str | None = None) -> str

Generate the fingerprint for a single SQL string.

sql is the SQL string to fingerprint. It may contain multiple statements separated by semicolons.

dialect is an optional string that specifies the SQL dialect to use. Supported names include:

• generic - the default, a generic SQL dialect.

• mysql - MySQL dialect.

• postgresql or postgres - PostgreSQL dialect.

• sqlite - SQLite dialect.

See the source of the underlying function for a full list.

Example:

from sql_impressao import fingerprint_one

sql = 'SELECT a, b FROM cheeses WHERE origin = "France" ORDER BY age DESC'
fingerprint = fingerprint_one(sql)
assert fingerprint == "SELECT ... FROM cheeses WHERE ... ORDER BY ..."

fingerprint_many(sql: list[str], *, dialect: str | None = None) -> list[str]

Generate the fingerprints for a list of SQL strings. Doing so for a batch of strings allows sharing some state, such as savepoint ID aliases.

sql is a list of SQL strings to fingerprint. Each string may contain multiple statements separated by semicolons.

dialect is an optional string that specifies the SQL dialect to use, as above.

Example:

from sql_impressao import fingerprint_many

sqls = ["SELECT a, b FROM c", "SELECT b, c FROM d"]
fingerprints = fingerprint_many(sqls)
assert fingerprints == ["SELECT ... FROM c", "SELECT ... FROM d"]