From 6e68b72068a9a9d85af28905dd9d269961041a2c Mon Sep 17 00:00:00 2001 From: xAlpharax <42233094+xAlpharax@users.noreply.github.com> Date: Sun, 10 Dec 2023 11:04:56 +0200 Subject: Final demo for the presentation Changes to be committed: modified: populate_prisma.js renamed: prisma/migrations/20231210070441_mig1/migration.sql -> prisma/migrations/20231210085505_mig1/migration.sql --- backend/populate_prisma.js | 26 +++---- .../migrations/20231210070441_mig1/migration.sql | 80 ---------------------- .../migrations/20231210085505_mig1/migration.sql | 80 ++++++++++++++++++++++ 3 files changed, 93 insertions(+), 93 deletions(-) delete mode 100644 backend/prisma/migrations/20231210070441_mig1/migration.sql create mode 100644 backend/prisma/migrations/20231210085505_mig1/migration.sql diff --git a/backend/populate_prisma.js b/backend/populate_prisma.js index a1e974b..abc5305 100644 --- a/backend/populate_prisma.js +++ b/backend/populate_prisma.js @@ -34,36 +34,36 @@ async function seedDatabase() { // Insert tags const tag1 = await prisma.tag.create({ data: { - name: 'Tag1', + name: 'Programming', }, }); const tag2 = await prisma.tag.create({ data: { - name: 'Tag2', + name: 'Science', }, }); // Insert courses const course1 = await prisma.course.create({ data: { - title: 'Course 1', - description: 'Description 1', + title: 'Introduction to Computer Science', + description: 'https://pll.harvard.edu/course/cs50-introduction-computer-science', author: { connect: { id: user1.id }, }, - tags: ['Tag1', 'Tag2'], + tags: ['Programming'], }, }); const course2 = await prisma.course.create({ data: { - title: 'Course 2', - description: 'Description 2', + title: 'Introduction to Artificial Intelligence with Python', + description: 'https://pll.harvard.edu/course/cs50s-introduction-artificial-intelligence-python', author: { connect: { id: user2.id }, }, - tags: ['Tag1'], + tags: ['Programming', 'Science'], }, }); @@ -79,7 +79,7 @@ async function seedDatabase() { const courseData2 = await prisma.course_data.create({ data: { - total_readers: 30, + total_readers: 700, course: { connect: { id: course2.id }, }, @@ -89,13 +89,13 @@ async function seedDatabase() { // Insert course feedback await prisma.course_feedback.create({ data: { - feedback_value: 4, - feedback_text: 'Good course!', + feedback_value: 5, + feedback_text: 'Great course!', course: { - connect: { id: course1.id }, + connect: { id: course2.id }, }, author: { - connect: { id: user1.id }, + connect: { id: user2.id }, }, }, }); diff --git a/backend/prisma/migrations/20231210070441_mig1/migration.sql b/backend/prisma/migrations/20231210070441_mig1/migration.sql deleted file mode 100644 index e9acf84..0000000 --- a/backend/prisma/migrations/20231210070441_mig1/migration.sql +++ /dev/null @@ -1,80 +0,0 @@ --- CreateTable -CREATE TABLE `user` ( - `id` INTEGER NOT NULL AUTO_INCREMENT, - `user_data_id` INTEGER NOT NULL, - `email` VARCHAR(191) NOT NULL, - `password` VARCHAR(191) NOT NULL, - `username` VARCHAR(191) NOT NULL, - - UNIQUE INDEX `user_user_data_id_key`(`user_data_id`), - UNIQUE INDEX `user_email_key`(`email`), - UNIQUE INDEX `user_username_key`(`username`), - PRIMARY KEY (`id`) -) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; - --- CreateTable -CREATE TABLE `tag` ( - `id` INTEGER NOT NULL AUTO_INCREMENT, - `name` VARCHAR(191) NOT NULL, - - UNIQUE INDEX `tag_name_key`(`name`), - PRIMARY KEY (`id`) -) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; - --- CreateTable -CREATE TABLE `course` ( - `id` INTEGER NOT NULL AUTO_INCREMENT, - `title` VARCHAR(191) NOT NULL, - `description` VARCHAR(191) NOT NULL, - `author_id` INTEGER NOT NULL, - `tags` JSON NOT NULL, - - UNIQUE INDEX `course_title_key`(`title`), - UNIQUE INDEX `course_description_key`(`description`), - UNIQUE INDEX `course_author_id_key`(`author_id`), - PRIMARY KEY (`id`) -) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; - --- CreateTable -CREATE TABLE `user_data` ( - `id` INTEGER NOT NULL AUTO_INCREMENT, - `total_seconds` INTEGER NOT NULL, - `total_articles` INTEGER NOT NULL, - - PRIMARY KEY (`id`) -) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; - --- CreateTable -CREATE TABLE `course_data` ( - `id` INTEGER NOT NULL AUTO_INCREMENT, - `total_readers` INTEGER NOT NULL, - `courseId` INTEGER NULL, - - PRIMARY KEY (`id`) -) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; - --- CreateTable -CREATE TABLE `course_feedback` ( - `id` INTEGER NOT NULL AUTO_INCREMENT, - `feedback_value` INTEGER NOT NULL, - `feedback_text` VARCHAR(191) NOT NULL, - `course_id` INTEGER NOT NULL, - `author_id` INTEGER NOT NULL, - - PRIMARY KEY (`id`) -) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; - --- AddForeignKey -ALTER TABLE `user` ADD CONSTRAINT `user_user_data_id_fkey` FOREIGN KEY (`user_data_id`) REFERENCES `user_data`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE; - --- AddForeignKey -ALTER TABLE `course` ADD CONSTRAINT `course_author_id_fkey` FOREIGN KEY (`author_id`) REFERENCES `user`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE; - --- AddForeignKey -ALTER TABLE `course_data` ADD CONSTRAINT `course_data_courseId_fkey` FOREIGN KEY (`courseId`) REFERENCES `course`(`id`) ON DELETE SET NULL ON UPDATE CASCADE; - --- AddForeignKey -ALTER TABLE `course_feedback` ADD CONSTRAINT `course_feedback_author_id_fkey` FOREIGN KEY (`author_id`) REFERENCES `user`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE; - --- AddForeignKey -ALTER TABLE `course_feedback` ADD CONSTRAINT `course_feedback_course_id_fkey` FOREIGN KEY (`course_id`) REFERENCES `course`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE; diff --git a/backend/prisma/migrations/20231210085505_mig1/migration.sql b/backend/prisma/migrations/20231210085505_mig1/migration.sql new file mode 100644 index 0000000..e9acf84 --- /dev/null +++ b/backend/prisma/migrations/20231210085505_mig1/migration.sql @@ -0,0 +1,80 @@ +-- CreateTable +CREATE TABLE `user` ( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `user_data_id` INTEGER NOT NULL, + `email` VARCHAR(191) NOT NULL, + `password` VARCHAR(191) NOT NULL, + `username` VARCHAR(191) NOT NULL, + + UNIQUE INDEX `user_user_data_id_key`(`user_data_id`), + UNIQUE INDEX `user_email_key`(`email`), + UNIQUE INDEX `user_username_key`(`username`), + PRIMARY KEY (`id`) +) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +-- CreateTable +CREATE TABLE `tag` ( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `name` VARCHAR(191) NOT NULL, + + UNIQUE INDEX `tag_name_key`(`name`), + PRIMARY KEY (`id`) +) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +-- CreateTable +CREATE TABLE `course` ( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `title` VARCHAR(191) NOT NULL, + `description` VARCHAR(191) NOT NULL, + `author_id` INTEGER NOT NULL, + `tags` JSON NOT NULL, + + UNIQUE INDEX `course_title_key`(`title`), + UNIQUE INDEX `course_description_key`(`description`), + UNIQUE INDEX `course_author_id_key`(`author_id`), + PRIMARY KEY (`id`) +) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +-- CreateTable +CREATE TABLE `user_data` ( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `total_seconds` INTEGER NOT NULL, + `total_articles` INTEGER NOT NULL, + + PRIMARY KEY (`id`) +) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +-- CreateTable +CREATE TABLE `course_data` ( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `total_readers` INTEGER NOT NULL, + `courseId` INTEGER NULL, + + PRIMARY KEY (`id`) +) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +-- CreateTable +CREATE TABLE `course_feedback` ( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `feedback_value` INTEGER NOT NULL, + `feedback_text` VARCHAR(191) NOT NULL, + `course_id` INTEGER NOT NULL, + `author_id` INTEGER NOT NULL, + + PRIMARY KEY (`id`) +) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +-- AddForeignKey +ALTER TABLE `user` ADD CONSTRAINT `user_user_data_id_fkey` FOREIGN KEY (`user_data_id`) REFERENCES `user_data`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE; + +-- AddForeignKey +ALTER TABLE `course` ADD CONSTRAINT `course_author_id_fkey` FOREIGN KEY (`author_id`) REFERENCES `user`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE; + +-- AddForeignKey +ALTER TABLE `course_data` ADD CONSTRAINT `course_data_courseId_fkey` FOREIGN KEY (`courseId`) REFERENCES `course`(`id`) ON DELETE SET NULL ON UPDATE CASCADE; + +-- AddForeignKey +ALTER TABLE `course_feedback` ADD CONSTRAINT `course_feedback_author_id_fkey` FOREIGN KEY (`author_id`) REFERENCES `user`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE; + +-- AddForeignKey +ALTER TABLE `course_feedback` ADD CONSTRAINT `course_feedback_course_id_fkey` FOREIGN KEY (`course_id`) REFERENCES `course`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE; -- cgit v1.2.3