How to use :update?

[Madd0g]

I'm wondering how to use :update and what's possible to update? only value columns?

for example, in #140 - there's this relation mentioned:

:create beliefs {
    belief_id: Uuid,
    character_id: Uuid,
    belief: String,
    last_accessed_at: Validity default [floor(now()), true],
    =>
    details: String default "",
    parent_belief_id: Uuid? default null,
    valence: Float default 0,
    aspects: [(String, Float, String, String)] default [],
    belief_embedding: <F32; 768>,
    details_embedding: <F32; 768>,
}

and I see last_accessed_at there as part of the keys - does that mean that keys can be updated? after all why have validity/last_anything if you can't update it?

I've only seen validity used in examples as a one of the values, not as one of the keys - does that make any difference regarding what it can be used for?

How to do an update on a relation like the above? Actually same question for :replace, which also doesn't have an example.

Thanks

[Madd0g]

never mind, figured it out, it's the same mechanics as :create, I hadn't realized it's that easy.

[jamesfebin]

Can you please give an example query, struggling with this.

[jamesfebin]

I figured it out; here's a basic CRUD example for people who are still struggling.

Creating stored relation

:create person{
id : Int,
=>
name : String,
Age: Int
}

Inserting a row

?[id, name, Age] <- [[1, "Alice", 30]]
:put person {id, name, Age}

Fetching a row

?[id, name, Age] := *person[id, name, Age], Age>20

Updating a row

?[id, name] := id = 1, *person{id}, name = "John"
:update person {id => name}

Deleting a row

?[id] := id = 1, *person{id}
:rm person {id}

[vrn21]

can you look at here