max / makenotwork

1.9 KB · 68 lines History Blame Raw

1	//! Category and tag models.
2
3	use chrono::{DateTime, Utc};
4	use sqlx::FromRow;
5
6	use super::super::id_types::*;
7	use super::super::validated_types::*;
8
9	// ── Category models ──
10
11	/// A project category for discover-page filtering.
12	#[derive(Debug, Clone, FromRow)]
13	#[allow(dead_code)] // Fields populated by sqlx query, read during type conversion
14	pub struct DbCategory {
15	pub id: CategoryId,
16	pub name: String,
17	pub slug: Slug,
18	pub created_at: DateTime<Utc>,
19	}
20
21	/// A category with a count of public projects, for discover sidebar facets.
22	#[derive(Debug, Clone, FromRow)]
23	#[allow(dead_code)] // Fields populated by sqlx query, read during type conversion
24	pub struct DbCategoryCount {
25	pub name: String,
26	pub slug: Slug,
27	pub count: i64,
28	}
29
30	// ── Tag models ──
31
32	/// A tag in the hierarchical taxonomy.
33	///
34	/// Tag slugs use dot-notation (`audio.genre.electronic`) and are validated
35	/// by tagtree, not the general `Slug` type.
36	#[derive(Debug, Clone, FromRow)]
37	#[allow(dead_code)] // Fields populated by sqlx query, read during type conversion
38	pub struct DbTag {
39	pub id: TagId,
40	pub name: String,
41	pub slug: String,
42	pub parent_id: Option<TagId>,
43	pub sort_order: i32,
44	pub created_at: DateTime<Utc>,
45	pub path: String,
46	}
47
48	/// A tag attached to an item, with joined tag name/slug for display.
49	#[derive(Debug, Clone, FromRow)]
50	#[allow(dead_code)] // Fields populated by sqlx query, read during type conversion
51	pub struct DbItemTag {
52	pub item_id: ItemId,
53	pub tag_id: TagId,
54	pub is_primary: bool,
55	pub tag_name: String,
56	pub tag_slug: String,
57	}
58
59	/// Tag with item count, used for discover sidebar facets.
60	#[derive(Debug, Clone, FromRow)]
61	#[allow(dead_code)] // Fields populated by sqlx query, read during type conversion
62	pub struct DbTagCount {
63	pub tag_id: TagId,
64	pub tag_name: String,
65	pub tag_slug: String,
66	pub count: i64,
67	}
68