Jengamon/noteboek - Change JTHUFYTDQHWNQV5EVGIDMLSNA7OOPBHD52LHHCDYOMLIIWHD7AUAC

refine relations, add group permissions, and allow permissions to have subjects

Created by Jengamon on February 2, 2024

JTHUFYTDQHWNQV5EVGIDMLSNA7OOPBHD52LHHCDYOMLIIWHD7AUAC

Dependencies

[2] Z2GITYCX4GLFIH2NUNPMWNPJXKMNRLSL4FAN7YTDIFRSH6DJU2JAC

In channels

main

Change contents

Insertion in server/src/user.rs at line 123 [2.32]

[2.3136]

}
#[derive(Debug, Deserialize, Hash, PartialEq, Eq, Clone, Serialize)]
struct Record {
    #[allow(dead_code)]
    id: Thing,

Replacement in server/src/user.rs at line 133 [2.32]
B:BD[2.3232] → [2.3232:3248]
```
    id: String,
```
[2.3232]
[2.3248]
```
    id: Thing,
```
Insertion in server/src/user.rs at line 135 [2.32]
[2.3268]
[2.3268]
```
    subject: Option<Record>,
```

Replacement in server/src/user.rs at line 146 [2.32]

B:BD[2.3482] → [2.3482:3681]

        let user_permissions: Vec<Permission> = self.db.query(r#"SELECT id, aspect FROM permission WHERE ->granted->user == type::thing("user", $id)"#).bind(("id", user.id.clone())).await?.take(0)?;

[2.3482]

[2.3681]

        let user_permissions: Vec<Permission> = self
            .db
            .query(r#"SELECT id, aspect, ->granted->user FROM permission WHERE user == $id"#)
            .bind(("id", user.id.clone()))
            .await?
            .take(0)?;

Replacement in server/src/user.rs at line 157 [2.32]
B:BD[2.3790] → [2.3790:3818]
```
        _user: &Self::User,
```
[2.3790]
[2.3818]
```
        user: &Self::User,
```

Replacement in server/src/user.rs at line 159 [2.32]

B:BD[2.3870] → [2.3870:3897]

        Ok(HashSet::new())

[2.3870]

[2.3897]

        let group_permissions: Vec<Permission> = self.db.query(r#"SELECT id, aspect, ->granted->group<-member_of<-user FROM permission WHERE user == $id"#).bind(("id", user.id.clone())).await?.take(0)?;
        Ok(group_permissions.into_iter().collect())

Replacement in server/migrations/20240201_000001_create_user_and_permission_table.surql at line 5 [2.14218]

B:BD[2.14297] → [2.14297:14376]

DEFINE FIELD email ON TABLE user TYPE string ASSERT string::is::email($value);

[2.14297]

[2.14376]

DEFINE FIELD email ON TABLE user TYPE string VALUE string::lowercase($value) ASSERT string::is::email($value);

Insertion in server/migrations/20240201_000001_create_user_and_permission_table.surql at line 12 [2.14218]

[2.14743]

DEFINE FIELD subject ON TABLE permission TYPE option<record>;
DEFINE TABLE group SCHEMAFULL;
DEFINE FIELD description ON TABLE group TYPE string;
DEFINE TABLE member_of SCHEMAFULL;
DEFINE FIELD in ON TABLE member_of TYPE record<user>;
DEFINE FIELD out ON TABLE member_of TYPE record<group>;

Replacement in server/migrations/20240201_000001_create_user_and_permission_table.surql at line 22 [2.14218]
B:BD[2.14777] → [2.14777:14829]
```
DEFINE FIELD in ON TABLE granted TYPE record<user>;
```
[2.14777]
[2.14829]
```
DEFINE FIELD in ON TABLE granted TYPE record<user | group>;
```

Deletion in server/migrations/20240201_000001_create_user_and_permission_table.surql at line 24 [2.14218]

B:BD[2.14888] → [2.14888:15034]

DEFINE FIELD granted ON TABLE granted TYPE datetime DEFAULT time::now();
DEFINE INDEX unique_permissions ON TABLE granted COLUMNS in, out UNIQUE;