Exceptions

sqlite7 maps native SQLite result codes into package-defined exceptions and preserves SQLite metadata when available.

Base exceptions

• SQLite7Error

• Warning

• Error

SQLite-like subclasses

• InterfaceError

• DatabaseError

• DataError

• OperationalError

• IntegrityError

• InternalError

• ProgrammingError

• NotSupportedError

sqlite7-specific subclasses

• ConfigurationError

• ValidationError

• InvalidIdentifierError

• ConnectionClosedError

Example

from sqlite7 import IntegrityError, ValidationError, open_db

with open_db(":memory:") as db:
    db.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, email TEXT UNIQUE)")
    db.insert("users", ["ada@example.com"])

    try:
        db.insert("users", ["ada@example.com"])
    except IntegrityError as exc:
        print(type(exc).__name__)
        print(exc.sqlite_errorcode)
        print(exc.sqlite_errorname)

    try:
        db.insert_many("users", [{1, "bad payload"}])
    except ValidationError as exc:
        print(type(exc).__name__)
        print(str(exc))

---