diff options
| -rw-r--r-- | backend/index.js | 29 | ||||
| -rw-r--r-- | backend/prisma/migrations/20231210070441_mig1/migration.sql | 80 | ||||
| -rw-r--r-- | backend/prisma/migrations/migration_lock.toml | 3 |
3 files changed, 111 insertions, 1 deletions
diff --git a/backend/index.js b/backend/index.js index 769a692..51c9f9d 100644 --- a/backend/index.js +++ b/backend/index.js @@ -19,7 +19,7 @@ app.use(passport.session()); app.set('view engine', 'ejs'); -app.get('/success', (req, res) => res.redirect("")); +app.get('/success', (req, res) => res.redirect("http://localhost:3000/")); app.get('/error', (req, res) => res.send("error logging in")); passport.serializeUser(function(user, cb) { @@ -102,6 +102,33 @@ app.post('/courses', async (req, res) => { } }) +app.get('/user_data/:param', async (req, res) => { + var request_parameter = req.params.param ; + try { + switch (request_parameter) { + case 'all': + var response = await prisma.course.findMany(); + res.send(response); + break; + default: + var response = await prisma.user.findMany({ + where:{ + id: { + equals: parseInt(request_parameter) + }, + include: { + user_data: true + } + } + }); + res.send(response); + break; + } + } catch (error) { + res.status(500); + res.send({"error" : "Nu au fost gasite rezultate"}); + } +}) app.listen(port, () => { console.log(`Example app listening on port ${port}`) diff --git a/backend/prisma/migrations/20231210070441_mig1/migration.sql b/backend/prisma/migrations/20231210070441_mig1/migration.sql new file mode 100644 index 0000000..e9acf84 --- /dev/null +++ b/backend/prisma/migrations/20231210070441_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; diff --git a/backend/prisma/migrations/migration_lock.toml b/backend/prisma/migrations/migration_lock.toml new file mode 100644 index 0000000..e5a788a --- /dev/null +++ b/backend/prisma/migrations/migration_lock.toml @@ -0,0 +1,3 @@ +# Please do not edit this file manually +# It should be added in your version-control system (i.e. Git) +provider = "mysql"
\ No newline at end of file |