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#
| Attribute | Type | Description |
|---|---|---|
columns | tuple[str, ...] | |
column_types | tuple[str, ...] | |
rows | tuple[tuple[Value, ...], ...] | |
rows_affected | int | |
last_insert_rowid | int | None |
Functions#
__init__#
__init__(columns, column_types, rows, rows_affected, last_insert_rowid) -> None| Parameter | Type | Description |
|---|---|---|
columns | tuple[str, ...] | |
column_types | tuple[str, ...] | |
rows | tuple[tuple[Value, ...], ...] | |
rows_affected | int | |
last_insert_rowid | int | 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