graph LR
  A[Next.js App Router] --> B[twitterapi.io]
  A --> C[PostgreSQL]
  C --> D[Drizzle ORM]
  D --> E[The Roast Bot Frontend]

import { drizzle } from 'drizzle-orm/postgres-js';
import postgres from 'postgres';

const connection = postgres(process.env.DATABASE_URL!);
export const db = drizzle(connection);

export const getTweets = async (userId: string) => {
  const res = await fetch(
    `https://api.twitterapi.io/v1/user_tweets?user_id=${userId}`,
    {
      headers: { 'x-api-key': `${process.env.TWITTERAPI_KEY}` },
    }
  );
  return res.json();
};

import { pgTable, text, timestamp } from 'drizzle-orm/pg-core';

export const tweets = pgTable('tweets', {
  id: text('id').primaryKey(),
  userId: text('user_id').notNull(),
  content: text('content').notNull(),
  scrapedAt: timestamp('scraped_at').defaultNow(),
});

import { db } from '@/lib/db';
import { tweets } from '@/drizzle/schema';

export async function POST(req: Request) {
  const { userId } = await req.json();
  const tweetData = await getTweets(userId);
  await db.insert(tweets).values(tweetData).onConflictDoNothing();

  return new Response(JSON.stringify({ success: true }), {
    status: 200,
    headers: { 'Content-Type': 'application/json' },
  });
}