Showing ID from surrealdb - why do I see [object] on the web page? #2870

szabgab · 2024-09-28T14:06:42Z

szabgab
Sep 28, 2024

I store my data in a SurrealDB, but when I fetch the data with the generated id I cannot seem to be able to display it on the web page. When I print with rocket::info! to the console then I see the real ID, but, then on the web page generated by it shows up as [object]. Why is that? What am I doing wrong? How to fix to show the real ID?

main.rs

#[macro_use]
extern crate rocket;

use rocket::form::Form;
use rocket::State;
use rocket_dyn_templates::{context, Template};

use surrealdb::engine::remote::ws::Client;
use surrealdb::Surreal;

pub mod db;
use crate::db::Item;

#[derive(FromForm)]
struct AddForm<'r> {
    title: &'r str,
}

async fn form_and_list(dbh: &State<Surreal<Client>>) -> Template {
    let items: Vec<Item> = db::get_items(dbh).await.unwrap();
    for item in &items {
        rocket::info!("{} {}", item.id.id, item.title);
    }
    Template::render(
        "index",
        context! {
            title: "TODO",
            items,
        },
    )
}

#[get("/")]
async fn get_index(dbh: &State<Surreal<Client>>) -> Template {
    form_and_list(dbh).await
}

#[post("/", data = "<input>")]
async fn post_index(dbh: &State<Surreal<Client>>, input: Form<AddForm<'_>>) -> Template {
    rocket::info!("Add '{}'", input.title);
    let title = input.title.trim();
    db::add_item(dbh, title).await.unwrap();
    form_and_list(dbh).await
}

#[launch]
fn rocket() -> _ {
    rocket::build()
        .mount("/", routes![get_index, post_index,])
        .attach(Template::fairing())
        .attach(db::fairing())
}

db.rs:

use chrono::{DateTime, Utc};
use rocket::fairing::AdHoc;
use serde::{Deserialize, Serialize};
use surrealdb::engine::remote::ws::Client;
use surrealdb::engine::remote::ws::Ws;
use surrealdb::opt::auth::Root;
use surrealdb::opt::Resource;
use surrealdb::sql::{Id, Thing};
use surrealdb::Surreal;

#[derive(Debug, Deserialize, Serialize, Clone, PartialEq)]
pub struct Item {
    pub id: Thing,
    pub title: String,
    pub date: DateTime<Utc>,
}

/// # Panics
///
/// Panics when it fails to connect to the database
#[must_use]
pub fn fairing() -> AdHoc {
    AdHoc::on_ignite("Managed Database Connection", |rocket| async {
        let address = "127.0.0.1:8000";
        let username = "root";
        let password = "root";
        let db_namespace = "todo";
        let db_database = "todo";

        let dbh = Surreal::new::<Ws>(address).await.unwrap();

        dbh.signin(Root { username, password }).await.unwrap();

        dbh.use_ns(db_namespace).use_db(db_database).await.unwrap();

        rocket.manage(dbh)
    })
}

pub async fn add_item(dbh: &Surreal<Client>, title: &str) -> surrealdb::Result<()> {
    let utc: DateTime<Utc> = Utc::now();

    let id = Id::ulid();

    let entry = Item {
        id: Thing::from(("items", id)),
        title: title.to_owned(),
        date: utc,
    };

    dbh.create(Resource::from("items")).content(entry).await?;

    Ok(())
}

pub async fn get_items(dbh: &Surreal<Client>) -> surrealdb::Result<Vec<Item>> {
    let mut response = dbh.query("SELECT * FROM items;").await?;
    let entries: Vec<Item> = response.take(0)?;
    Ok(entries)
}

templates/index.html.tera

<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>{{title}}</title>
  </head>
  <body>
      <h1><a href="/">{{title}}</a></h1>
       <form method="POST" action="/">
           <input name="title"><br>
           <input type="submit" value="Add"><br>
       </form>
       <ul>
       {% for item in items %}
       <li><a href="/item/{{item.id.id}}">{{item.title}} {{item.id.id}}</a></li>
       {% endfor %}
       </ul>
  </body>
</html>

Full Source code: https://github.com/szabgab/rust.code-maven.com/tree/main/slides/rust/examples/rocket/simple-todo-with-surrealdb
also with instructions: https://rust.code-maven.com/slides/rust/simple-todo-list-with-rocket-and-surrealdb.html

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Showing ID from surrealdb - why do I see [object] on the web page? #2870

{{title}}

Replies: 0 comments

Select a reply

Showing ID from surrealdb - why do I see [object] on the web page? #2870

szabgab Sep 28, 2024

Replies: 0 comments

szabgab
Sep 28, 2024