tinkr 0.0.43

Tinkr is a web framework for quickly building full-stack web applications with Leptos.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153

#[cfg(feature = "ssr")]
use crate::AppError;

#[cfg(feature = "ssr")]
use serde::{Deserialize, Serialize};

#[cfg(feature = "ssr")]
use crate::user::AdapterUser;

#[cfg(feature = "ssr")]
use surrealdb::RecordId;

#[cfg(feature = "ssr")]
#[allow(async_fn_in_trait)]
pub trait StorageAuthed<NoId, WithId>
where
    Self: Clone + Serialize + for<'de> Deserialize<'de> + 'static,
    NoId: Clone + Sync + Send + Serialize + 'static,
    WithId: Clone + Sync + Send + Serialize + for<'de> Deserialize<'de> + 'static,
{
    const TABLE_NAME: &str;

    /// Create or insert a new item
    // async fn create(content: NoId) -> Result<WithId, AppError>;

    async fn create_by_user(user: AdapterUser, content: NoId) -> Result<WithId, AppError> {
        let db = crate::db_init().await?;

        let table = Self::TABLE_NAME;
        let query = format!(
            r#"
            LET $record = CREATE {table} CONTENT $content;
            UPDATE $record SET created_by_user_id = $user_id, created_at = time::now(), updated_at = time::now();
        "#
        );

        let mut result = db
            .query(query)
            .bind(("content", content))
            .bind(("user_id", user.id))
            .await?;

        let created_item: Option<WithId> = result.take(1)?;

        match created_item {
            Some(token) => Ok(token),
            None => Err(AppError::GenericError("Failed to create token".into())),
        }
    }

    async fn get_by_id(id: RecordId) -> Result<WithId, AppError> {
        let db = crate::db_init().await?;
        let item: Option<WithId> = db.select(id).await?;
        match item {
            Some(item) => Ok(item),
            None => Err(AppError::NotFound("Item not found".into())),
        }
    }

    async fn get_many() -> Result<Vec<WithId>, AppError> {
        let db = crate::db_init().await?;

        let items: Vec<WithId> = db.select(Self::TABLE_NAME).await?;

        Ok(items)
    }

    async fn get_by_user(user: AdapterUser) -> Result<Vec<WithId>, AppError> {
        use crate::db_init;
        let client = db_init().await?;
        let tablename = Self::TABLE_NAME;
        let query = format!(
            "SELECT * FROM {tablename} WHERE created_by_user_id = $user_id ORDER BY created_at DESC;"
        );

        let mut result = client.query(query).bind(("user_id", user.id)).await?;

        let items: Vec<WithId> = result.take(0)?;

        Ok(items)
    }

    async fn update(user: AdapterUser, _id: RecordId, content: WithId) -> Result<WithId, AppError> {
        // todo look up user permissions;

        let db = crate::db_init().await?;

        let query = format!(
            r#"
            LET $record = UPDATE $content.id MERGE $content;
            UPDATE $record SET created_by_user_id = $user_id, created_at = time::now(), updated_at = time::now();
            SELECT * from $record;
            "#
        );

        let mut response = db
            .query(query)
            .bind(("content", content))
            .bind(("user_id", user.id))
            .await?;

        let updated_item: Option<WithId> = response.take(2)?;

        match updated_item {
            Some(item) => Ok(item),
            None => Err(AppError::NotFound("Item not found".into())),
        }
    }

    async fn update_self(&self) -> Result<WithId, AppError> {
        let db = crate::db_init().await?;

        let mut query = db
            .query("UPDATE $content.id CONTENT $content")
            .bind(("content", self.clone()))
            .await?;

        let updated_item: Option<WithId> = query.take(0)?;

        match updated_item {
            Some(item) => Ok(item),
            None => Err(AppError::NotFound("Item not found".into())),
        }
    }

    async fn delete(_user: AdapterUser, id: RecordId) -> Result<bool, AppError> {
        // todo look up user permissions;

        let db = crate::db_init().await?;
        let deleted: Option<WithId> = db.delete(id).await?;

        match deleted {
            Some(_) => Ok(true),
            None => Err(AppError::NotFound("Item not found".into())),
        }
    }

    async fn delete_self(&self) -> Result<bool, AppError> {
        let db = crate::db_init().await?;

        let mut query = db
            .query("DELETE $content.id;")
            .bind(("content", self.clone()))
            .await?;

        let deleted: Option<WithId> = query.take(0)?;

        match deleted {
            Some(_) => Ok(true),
            None => Err(AppError::NotFound("Item not found".into())),
        }
    }
}