database work

1 files changed, 19 insertions, 6 deletions

diff --git a/src/artwork.rs b/src/artwork.rs
index 78b39af..458fd38 100644
--- a/src/artwork.rs
+++ b/src/artwork.rs
@@ -1,14 +1,27 @@
+use time::{OffsetDateTime, PrimitiveDateTime};
+use uuid::Uuid;
+
+use crate::{artist::Artist, comment::Comment, file::File};
+
+#[derive(sqlx::FromRow)]
 pub struct Artwork {
     /// artwork id
-    id: Option<usize>,
+    id: Option<i32>,
     /// name of the artwork
-    title: Option<String>,
+    pub title: Option<String>,
     /// description of the artwork
-    description: Option<String>,
+    pub description: Option<String>,
     /// source url of the artwork
-    url_source: Option<String>,
+    pub url_source: Option<String>,
+    /// artwork creation time
+    created_at: Option<PrimitiveDateTime>,
     /// id of the artist
-    artist_id: usize,
+    #[sqlx(Flatten)]
+    pub artist: Artist,
     /// ids of files
-    files: Vec<usize>,
+    #[sqlx(Flatten)]
+    pub files: Vec<File>,
+    // /// TODO: comments in thread,
+    // #[sqlx(Flatten)]
+    // comments: Vec<Comment>,
 }