How to select all IDs and values from a table?

[HaoYang670]

I have a table which stores many Users. Is there a way to collect all IDs in type of Vec<(ID, User)> or HashMap<ID, User> from the table?

[Dhghomon]

You could use meta::id to pull out the id and then pull that out and collect it into a HashMap. Here's a quick example that might help:

use serde::{Deserialize, Serialize};
use std::collections::HashMap;
use surrealdb::engine::remote::ws::Ws;
use surrealdb::opt::auth::Root;
use surrealdb::{Error, Surreal};

#[derive(Serialize, Deserialize, Debug, Clone)]
struct User {
    id: String,
    name: String,
}

#[tokio::main]
async fn main() -> Result<(), Error> {
    let db = Surreal::new::<Ws>("localhost:8000").await?;

    db.signin(Root {
        username: "root",
        password: "root",
    })
    .await?;

    db.use_ns("namespace").use_db("database").await?;

    let stuff = db
        .query("select name, meta::id(id) AS id FROM user")
        .await
        .unwrap()
        .take::<Vec<User>>(0)
        .unwrap()
        .into_iter()
        .map(|user| (user.id.clone(), user.clone()))
        .collect::<HashMap<String, User>>();
    println!("{stuff:#?}");

    Ok(())
}

[HaoYang670]

Thanks. meta:id works. Thanks a lot