Made the backend to point to the frontend after google authentication.

Changes to be committed:
    modified:   backend/index.js
    new file:   backend/prisma/migrations/20231210070441_mig1/migration.sql
    new file:   backend/prisma/migrations/migration_lock.toml

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