[feature] Add openAI integration for extracting tags from articles

2 files changed, 21 insertions, 1 deletions

diff --git a/db/prisma/migrations/20240207204211_drop_extra_field_in_tags_links/migration.sql b/db/prisma/migrations/20240207204211_drop_extra_field_in_tags_links/migration.sql
new file mode 100644
index 00000000..78184041
--- /dev/null
+++ b/db/prisma/migrations/20240207204211_drop_extra_field_in_tags_links/migration.sql
@@ -0,0 +1,21 @@
+/*
+  Warnings:
+
+  - You are about to drop the column `bookmarkTagsId` on the `TagsOnLinks` table. All the data in the column will be lost.
+
+*/
+-- RedefineTables
+PRAGMA foreign_keys=OFF;
+CREATE TABLE "new_TagsOnLinks" (
+    "linkId" TEXT NOT NULL,
+    "tagId" TEXT NOT NULL,
+    "attachedAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    CONSTRAINT "TagsOnLinks_linkId_fkey" FOREIGN KEY ("linkId") REFERENCES "BookmarkedLink" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
+    CONSTRAINT "TagsOnLinks_tagId_fkey" FOREIGN KEY ("tagId") REFERENCES "BookmarkTags" ("id") ON DELETE CASCADE ON UPDATE CASCADE
+);
+INSERT INTO "new_TagsOnLinks" ("attachedAt", "linkId", "tagId") SELECT "attachedAt", "linkId", "tagId" FROM "TagsOnLinks";
+DROP TABLE "TagsOnLinks";
+ALTER TABLE "new_TagsOnLinks" RENAME TO "TagsOnLinks";
+CREATE UNIQUE INDEX "TagsOnLinks_linkId_tagId_key" ON "TagsOnLinks"("linkId", "tagId");
+PRAGMA foreign_key_check;
+PRAGMA foreign_keys=ON;
diff --git a/db/prisma/schema.prisma b/db/prisma/schema.prisma
index f5b83b66..0e6d080c 100644
--- a/db/prisma/schema.prisma
+++ b/db/prisma/schema.prisma
@@ -100,7 +100,6 @@ model TagsOnLinks {
   tagId String
 
   attachedAt     DateTime @default(now())
-  bookmarkTagsId String
 
   @@unique([linkId, tagId])
 }