-use crate::{
- schema::{comment, comment_alias_1, comment_like, comment_saved},
- source::post::Post,
- Url,
-};
-use serde::Serialize;
+use crate::newtypes::{CommentId, DbUrl, LanguageId, LtreeDef, PersonId, PostId};
+use diesel_ltree::Ltree;
+use serde::{Deserialize, Serialize};
-// WITH RECURSIVE MyTree AS (
-// SELECT * FROM comment WHERE parent_id IS NULL
-// UNION ALL
-// SELECT m.* FROM comment AS m JOIN MyTree AS t ON m.parent_id = t.id
-// )
-// SELECT * FROM MyTree;
+#[cfg(feature = "full")]
+use crate::schema::{comment, comment_like, comment_saved};
-#[derive(Clone, Queryable, Associations, Identifiable, PartialEq, Debug, Serialize)]
-#[belongs_to(Post)]
-#[table_name = "comment"]
+#[derive(Clone, PartialEq, Eq, Debug, Serialize, Deserialize)]
+#[cfg_attr(feature = "full", derive(Queryable, Associations, Identifiable))]
+#[cfg_attr(feature = "full", diesel(belongs_to(crate::source::post::Post)))]
+#[cfg_attr(feature = "full", diesel(table_name = comment))]
pub struct Comment {
- pub id: i32,
- pub creator_id: i32,
- pub post_id: i32,
- pub parent_id: Option<i32>,
+ pub id: CommentId,
+ pub creator_id: PersonId,
+ pub post_id: PostId,
pub content: String,
pub removed: bool,
- pub read: bool, // Whether the recipient has read the comment or not
pub published: chrono::NaiveDateTime,
pub updated: Option<chrono::NaiveDateTime>,
pub deleted: bool,
- pub ap_id: Url,
+ pub ap_id: DbUrl,
pub local: bool,
+ #[serde(with = "LtreeDef")]
+ pub path: Ltree,
+ pub distinguished: bool,
+ pub language_id: LanguageId,
}
-#[derive(Clone, Queryable, Associations, Identifiable, PartialEq, Debug, Serialize)]
-#[belongs_to(Post)]
-#[table_name = "comment_alias_1"]
-pub struct CommentAlias1 {
- pub id: i32,
- pub creator_id: i32,
- pub post_id: i32,
- pub parent_id: Option<i32>,
- pub content: String,
- pub removed: bool,
- pub read: bool, // Whether the recipient has read the comment or not
- pub published: chrono::NaiveDateTime,
- pub updated: Option<chrono::NaiveDateTime>,
- pub deleted: bool,
- pub ap_id: Url,
- pub local: bool,
-}
-
-#[derive(Insertable, AsChangeset, Clone)]
-#[table_name = "comment"]
+#[derive(Clone, Default)]
+#[cfg_attr(feature = "full", derive(Insertable, AsChangeset))]
+#[cfg_attr(feature = "full", diesel(table_name = comment))]
pub struct CommentForm {
- pub creator_id: i32,
- pub post_id: i32,
- pub parent_id: Option<i32>,
+ pub creator_id: PersonId,
+ pub post_id: PostId,
pub content: String,
pub removed: Option<bool>,
- pub read: Option<bool>,
pub published: Option<chrono::NaiveDateTime>,
pub updated: Option<chrono::NaiveDateTime>,
pub deleted: Option<bool>,
- pub ap_id: Option<Url>,
- pub local: bool,
+ pub ap_id: Option<DbUrl>,
+ pub local: Option<bool>,
+ pub distinguished: Option<bool>,
+ pub language_id: Option<LanguageId>,
}
-#[derive(Identifiable, Queryable, Associations, PartialEq, Debug, Clone)]
-#[belongs_to(Comment)]
-#[table_name = "comment_like"]
+#[derive(PartialEq, Eq, Debug, Clone)]
+#[cfg_attr(feature = "full", derive(Identifiable, Queryable, Associations))]
+#[cfg_attr(feature = "full", diesel(belongs_to(crate::source::comment::Comment)))]
+#[cfg_attr(feature = "full", diesel(table_name = comment_like))]
pub struct CommentLike {
pub id: i32,
- pub person_id: i32,
- pub comment_id: i32,
- pub post_id: i32, // TODO this is redundant
+ pub person_id: PersonId,
+ pub comment_id: CommentId,
+ pub post_id: PostId, // TODO this is redundant
pub score: i16,
pub published: chrono::NaiveDateTime,
}
-#[derive(Insertable, AsChangeset, Clone)]
-#[table_name = "comment_like"]
+#[derive(Clone)]
+#[cfg_attr(feature = "full", derive(Insertable, AsChangeset))]
+#[cfg_attr(feature = "full", diesel(table_name = comment_like))]
pub struct CommentLikeForm {
- pub person_id: i32,
- pub comment_id: i32,
- pub post_id: i32, // TODO this is redundant
+ pub person_id: PersonId,
+ pub comment_id: CommentId,
+ pub post_id: PostId, // TODO this is redundant
pub score: i16,
}
-#[derive(Identifiable, Queryable, Associations, PartialEq, Debug)]
-#[belongs_to(Comment)]
-#[table_name = "comment_saved"]
+#[derive(PartialEq, Eq, Debug)]
+#[cfg_attr(feature = "full", derive(Identifiable, Queryable, Associations))]
+#[cfg_attr(feature = "full", diesel(belongs_to(crate::source::comment::Comment)))]
+#[cfg_attr(feature = "full", diesel(table_name = comment_saved))]
pub struct CommentSaved {
pub id: i32,
- pub comment_id: i32,
- pub person_id: i32,
+ pub comment_id: CommentId,
+ pub person_id: PersonId,
pub published: chrono::NaiveDateTime,
}
-#[derive(Insertable, AsChangeset)]
-#[table_name = "comment_saved"]
+#[cfg_attr(feature = "full", derive(Insertable, AsChangeset))]
+#[cfg_attr(feature = "full", diesel(table_name = comment_saved))]
pub struct CommentSavedForm {
- pub comment_id: i32,
- pub person_id: i32,
+ pub comment_id: CommentId,
+ pub person_id: PersonId,
}