GitHub

ResultSet

API reference for ResultSet.

A statement's result (@libsql/client's ResultSet): the rows as values in column order, and for a statement without rows the rows it changed and the last inserted rowid. column_types are the declared types a remote server reports (empty for a local database: sqlite3 does not expose them).

Attributes

AttributeTypeDescription
columnstuple[str, ...]
column_typestuple[str, ...]
rowstuple[tuple[Value, ...], ...]
rows_affectedint
last_insert_rowidint | None

Functions

__init__

__init__(columns, column_types, rows, rows_affected, last_insert_rowid) -> None
ParameterTypeDescription
columnstuple[str, ...]
column_typestuple[str, ...]
rowstuple[tuple[Value, ...], ...]
rows_affectedint
last_insert_rowidint | None

records

records() -> list[dict[str, Value]]

The rows as column name to value; of columns with the same name, the first one's value.

Returns list[dict[str, Value]]

def records(self) -> list[dict[str, Value]]:
    """The rows as column name to value; of columns with the same
    name, the first one's value."""
    names = self.columns
    records: list[dict[str, Value]] = []
    for row in self.rows:
        record: dict[str, Value] = {}
        for name, value in zip(names, row, strict=True):
            record.setdefault(name, value)
        records.append(record)
    return records