import { defineRelations } from "drizzle-orm"
import * as s from "drizzle-orm/sqlite-core"

export const actors = s.sqliteTable("actors", {
  id: s.integer("id").primaryKey({ autoIncrement: true }),

  discordId: s.text("discord_id").unique(),
  displayName: s.text("display_name"),
  username: s.text("username"),
  avatar: s.text("avatar"),

  createdAt: s.integer("created_at", { mode: "timestamp" }).notNull(),
  updatedAt: s.integer("updated_at", { mode: "timestamp" }).notNull(),
  deletedAt: s.integer("deleted_at", { mode: "timestamp" }),
})

export const sessions = s.sqliteTable("sessions", {
  id: s.text("id").primaryKey(),
  userId: s.integer("user_id")
      .notNull()
      .references(() => actors.id),

  accessToken: s.text("access_token").notNull(),
  refreshToken: s.text("refresh_token").notNull(),
  expiresAt: s.integer("expires_at").notNull(),
  createdAt: s.integer("created_at", { mode: "timestamp" }).notNull(),

  scope: s.text("scope"),
  tokenType: s.text("token_type"),
})

export const actorRelationships = defineRelations(
  { actors, sessions },
  (r) => ({
    actors: {
      sessions: r.many.sessions({
        from: r.actors.id,
        to: r.sessions.userId,
      }),
    },
    sessions: {
      actor: r.one.actors({
        from: r.sessions.userId,
        to: r.actors.id,
      }),
    },
  })
)