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
|
const { PrismaClient } = require('@prisma/client');
const prisma = new PrismaClient();
async function seedDatabase() {
// Insert users
const user1 = await prisma.user.create({
data: {
user_data: {
create: {
total_seconds: 1000,
total_articles: 5,
},
},
email: 'user1@example.com',
password: 'hashedPassword1',
username: 'user1',
},
});
const user2 = await prisma.user.create({
data: {
user_data: {
create: {
total_seconds: 2000,
total_articles: 10,
},
},
email: 'user2@example.com',
password: 'hashedPassword2',
username: 'user2',
},
});
// Insert tags
const tag1 = await prisma.tag.create({
data: {
name: 'Tag1',
},
});
const tag2 = await prisma.tag.create({
data: {
name: 'Tag2',
},
});
// Insert courses
const course1 = await prisma.course.create({
data: {
title: 'Course 1',
description: 'Description 1',
author: {
connect: { id: user1.id },
},
tags: ['Tag1', 'Tag2'],
},
});
const course2 = await prisma.course.create({
data: {
title: 'Course 2',
description: 'Description 2',
author: {
connect: { id: user2.id },
},
tags: ['Tag1'],
},
});
// Insert course data
const courseData1 = await prisma.course_data.create({
data: {
total_readers: 50,
course: {
connect: { id: course1.id },
},
},
});
const courseData2 = await prisma.course_data.create({
data: {
total_readers: 30,
course: {
connect: { id: course2.id },
},
},
});
// Insert course feedback
await prisma.course_feedback.create({
data: {
feedback_value: 4,
feedback_text: 'Good course!',
course: {
connect: { id: course1.id },
},
author: {
connect: { id: user1.id },
},
},
});
console.log('Data seeding completed.');
}
seedDatabase()
.catch((error) => {
throw error;
})
.finally(async () => {
await prisma.$disconnect();
});
|