Struct Row 

pub struct Row<'r> { /* private fields */ }

A single row borrowed from a Rows iterator. Lives only as long as the iterator; call Row::to_owned_row to detach it if you need to keep it past the next next() call.

Implementations

impl<'r> Row<'r>

pub fn get<T: FromValue>(&self, idx: usize) -> Result<T>

Value at column index idx. Returns a clean error if out of bounds or the type conversion fails.

pub fn get_by_name<T: FromValue>(&self, name: &str) -> Result<T>

Value at column named name. Case-sensitive.

Examples found in repository

examples/rust/quickstart.rs (line 26)

fn main() -> Result<()> {
    let mut conn = Connection::open_in_memory()?;

    conn.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, age INTEGER);")?;
    conn.execute("INSERT INTO users (name, age) VALUES ('alice', 30);")?;
    conn.execute("INSERT INTO users (name, age) VALUES ('bob', 25);")?;
    conn.execute("INSERT INTO users (name, age) VALUES ('charlie', 40);")?;

    println!("All users:");
    let stmt = conn.prepare("SELECT id, name, age FROM users;")?;
    let mut rows = stmt.query()?;
    while let Some(row) = rows.next()? {
        let id: i64 = row.get_by_name("id")?;
        let name: String = row.get_by_name("name")?;
        // `Option<i64>` wraps NULL cleanly — `age` is declared
        // nullable so the typed accessor surfaces None when absent.
        let age: Option<i64> = row.get_by_name("age")?;
        println!(
            "  {} — {} ({})",
            id,
            name,
            age.map(|a| a.to_string())
                .unwrap_or_else(|| "NULL".to_string())
        );
    }

    // Transactions: BEGIN + INSERT + ROLLBACK leaves the table untouched.
    conn.execute("BEGIN;")?;
    conn.execute("INSERT INTO users (name, age) VALUES ('will_vanish', 99);")?;
    println!("\nMid-transaction row count: {}", count_users(&mut conn)?);
    conn.execute("ROLLBACK;")?;
    println!(
        "Post-rollback row count:   {} (unchanged)",
        count_users(&mut conn)?
    );

    Ok(())
}

pub fn columns(&self) -> &[String]

Column names for this row.

pub fn to_owned_row(&self) -> OwnedRow

Detaches from the parent Rows iterator. Useful when you want to keep rows past the next Rows::next() call.