better-stack/packages/stack/src/plugins/blog/db.ts at main · better-stack-ai/better-stack · GitHub

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
import { createDbPlugin } from "@btst/db";

/**
 * Blog plugin schema
 * Defines the database table for blog posts
 */
export const blogSchema = createDbPlugin("blog", {
	post: {
		modelName: "post",
		fields: {
			title: {
				type: "string",
				required: true,
			},
			content: {
				type: "string",
				required: true,
			},
			excerpt: {
				type: "string",
				defaultValue: "",
			},
			slug: {
				type: "string",
				required: true,
				unique: true,
			},
			image: {
				type: "string",
				required: false,
			},
			published: {
				type: "boolean",
				defaultValue: false,
			},
			publishedAt: {
				type: "date",
				required: false,
			},
			authorId: {
				type: "string",
				required: false,
			},
			createdAt: {
				type: "date",
				defaultValue: () => new Date(),
			},
			updatedAt: {
				type: "date",
				defaultValue: () => new Date(),
			},
		},
	},
	tag: {
		modelName: "tag",
		fields: {
			name: {
				type: "string",
				required: true,
				unique: true,
			},
			slug: {
				type: "string",
				required: true,
				unique: true,
			},
			createdAt: {
				type: "date",
				defaultValue: () => new Date(),
			},
			updatedAt: {
				type: "date",
				defaultValue: () => new Date(),
			},
		},
	},
	postTag: {
		modelName: "postTag",
		fields: {
			postId: {
				type: "string",
				required: true,
				references: {
					model: "post",
					field: "id",
					onDelete: "cascade",
				},
			},
			tagId: {
				type: "string",
				required: true,
				references: {
					model: "tag",
					field: "id",
					onDelete: "cascade",
				},
			},
		},
	},
});