rust: db.update and WHERE

[mirsella]

hello !

In all the example I can find in rust, the db.update method is always ran using the (table, id) tuple, but i can't find what exactly can be the second element.
Only an id ? A condition expression ?

I would like to do something like that :

db.update((
    "news",
    format!("where link == {link}"))
  )
  .content(News {...})
  .await?;

Thank you !

[kearfy]

the id can represent a specific record's ID. Take a record id like person:john: here the table would be person, and the id would be john

[mirsella]

thanks for the answer. so there is no way in the rust client (apart from building a query ) to update a row(s) without their IDs ? thanks !

[naisofly]

@mirsella Yes, that's true. To use WHERE clauses you will need to use Surreal::query which, in your words, involves building a query.

Also Surreal::update supports updating:

• the entire table by feeding it only a table name
• a specific record by feeding it a table name and ID (i.e. record ID)
• a range of records by feeding it a table name and then specifying a range of records using the range method.

You just can't update specific records by filtering on any other field except id.

Hope this helps!