import { relations } from 'drizzle-orm';
import { numeric, text, pgTable } from "drizzle-orm/pg-core";


export const syncSession = pgTable("session", {
	id: text('id').primaryKey().$defaultFn(() => crypto.randomUUID()),
	authzState: text("authzState"),
	accessTokenCreated: numeric("accessTokenCreated"),
	refreshTokenCreated: numeric("refreshTokenCreated"),
	tokens: text("tokens")
})

export const syncLog = pgTable("session_log", {
	id: text("id").primaryKey(),
	sessionId: text("session_id"),
	dateTime: text("date_time"),
	msg: text("msg")
})

export const syncLogRelation = relations(syncLog, ({ one }) => ({
	author: one(syncSession, {
		fields: [syncLog.sessionId],
		references: [syncSession.id],
	})
}))

export const syncSessionLogRelation = relations(syncSession, ({ many }) => ({
	logs: many(syncLog)
}))