aboutsummaryrefslogtreecommitdiff
path: root/apps/web/src/app/api/addTweetsToDb/route.ts
blob: 7fe2edbaf29e6d7b319f95b5d583813059b5bb87 (plain) (blame)
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
import { db } from "@/server/db";
import { eq } from "drizzle-orm";
import { sessions, storedContent, users } from "@/server/db/schema";
import { type NextRequest, NextResponse } from "next/server";

export const runtime = "edge";

interface TweetData {
  tweetText: string;
  postUrl: string;
  authorName: string;
  handle: string;
  time: string;
  saveToUser: string;
}

export async function POST(req: NextRequest) {
  const token =
    req.cookies.get("next-auth.session-token")?.value ??
    req.cookies.get("__Secure-authjs.session-token")?.value ??
    req.cookies.get("authjs.session-token")?.value ??
    req.headers.get("Authorization")?.replace("Bearer ", "");

  if (!token) {
    return new Response(
      JSON.stringify({ message: "Invalid Key, TOKEN not found." }),
      { status: 404 },
    );
  }

  const sessionData = await db
    .select()
    .from(sessions)
    .where(eq(sessions.sessionToken, token!));

  if (!sessionData || sessionData.length === 0) {
    return new Response(
      JSON.stringify({ message: "Invalid Key, session not found." }),
      { status: 404 },
    );
  }

  const user = await db
    .select()
    .from(users)
    .where(eq(users.id, sessionData[0].userId))
    .limit(1);

  if (!user || user.length === 0) {
    return NextResponse.json(
      { message: "Invalid Key, session not found." },
      { status: 404 },
    );
  }

  const session = { session: sessionData[0], user: user[0] };

  const data = (await req.json()) as TweetData[];

  for (const tweet of data) {
    const { id } = (
      await db
        .insert(storedContent)
        .values({
          content: tweet.tweetText,
          title: "Twitter Bookmark",
          description: "",
          url: tweet.postUrl,
          baseUrl: "https://twitter.com",
          image: "https://supermemory.dhr.wtf/twitter.svg",
          savedAt: new Date(),
          user: session.user.id,
          type: "twitter-bookmark",
        })
        .returning({ id: storedContent.id })
    )[0];

    if (!id) {
      return NextResponse.json(
        {
          message: "Error",
          error:
            "Something went wrong when inserting the tweet to storedContent",
        },
        { status: 500 },
      );
    }
  }

  return NextResponse.json({ message: "OK", data: "Success" }, { status: 200 });
}