Struct RowSet 

pub struct RowSet {
    pub columns: Vec<Column>,
    pub rows: Vec<Row>,
}

The result of a database query.

Examples

Load a set of rows from a local PostgreSQL database, and iterate over them selecting one field from each. The columns collection allows you to find column indexes for column names; you can bypass this lookup if you name specific columns in the query.

use spin_sdk::pg3::{Connection, Decode};

let db = Connection::open("host=localhost user=postgres password=my_password dbname=mydb")?;

let query_result = db.query(
    "SELECT * FROM users WHERE age >= $1",
    &[min_age.into()]
)?;

let name_index = query_result.columns.iter().position(|c| c.name == "name").unwrap();

for row in &query_result.rows {
    let name = String::decode(&row[name_index])?;
    println!("Found user {name}");
}

A set of database rows

Fields

columns: Vec<Column>

rows: Vec<Row>

Trait Implementations

impl Clone for RowSet

fn clone(&self) -> RowSet

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for RowSet

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.