Skip to content

AI-native design editor. Open-source Figma alternative.

2.5 KB
Raw Blame
import type { CreateWorkspaceInput, WorkspaceRole, WorkspaceSummary } from '#cloud/contract'
import type { CloudDatabase } from '#cloud/server/db'
import type { Kysely, Transaction } from 'kysely'

export type WorkspaceDatabase = Kysely<CloudDatabase> | Transaction<CloudDatabase>

function toISOString(value: Date | string): string {
  return value instanceof Date ? value.toISOString() : value
}

export async function listWorkspaces(
  database: WorkspaceDatabase,
  userId: string
): Promise<WorkspaceSummary[]> {
  const rows = await database
    .selectFrom('workspace')
    .innerJoin('workspaceMember', 'workspaceMember.workspaceId', 'workspace.id')
    .select([
      'workspace.id',
      'workspace.name',
      'workspace.slug',
      'workspace.createdAt',
      'workspace.updatedAt',
      'workspaceMember.role'
    ])
    .where('workspaceMember.userId', '=', userId)
    .orderBy('workspace.updatedAt', 'desc')
    .execute()

  return rows.map((row) => ({
    ...row,
    createdAt: toISOString(row.createdAt),
    updatedAt: toISOString(row.updatedAt)
  }))
}

export async function findWorkspace(
  database: WorkspaceDatabase,
  userId: string,
  workspaceId: string
): Promise<WorkspaceSummary | undefined> {
  const row = await database
    .selectFrom('workspace')
    .innerJoin('workspaceMember', 'workspaceMember.workspaceId', 'workspace.id')
    .select([
      'workspace.id',
      'workspace.name',
      'workspace.slug',
      'workspace.createdAt',
      'workspace.updatedAt',
      'workspaceMember.role'
    ])
    .where('workspace.id', '=', workspaceId)
    .where('workspaceMember.userId', '=', userId)
    .executeTakeFirst()
  return row
    ? {
        ...row,
        createdAt: toISOString(row.createdAt),
        updatedAt: toISOString(row.updatedAt)
      }
    : undefined
}

export async function insertWorkspace(
  database: WorkspaceDatabase,
  actorId: string,
  input: CreateWorkspaceInput & { id: string; slug: string }
): Promise<boolean> {
  const inserted = await database
    .insertInto('workspace')
    .values({
      id: input.id,
      name: input.name,
      slug: input.slug,
      createdBy: actorId
    })
    .onConflict((conflict) => conflict.column('slug').doNothing())
    .returning('id')
    .executeTakeFirst()
  return inserted !== undefined
}

export async function insertWorkspaceMember(
  database: WorkspaceDatabase,
  workspaceId: string,
  userId: string,
  role: WorkspaceRole
): Promise<void> {
  await database.insertInto('workspaceMember').values({ workspaceId, userId, role }).execute()
}