Function createCliSession

freebuff/web/src/app/onboard/_db.ts:129–175

(
  userId: string,
  fingerprintId: string,
  fingerprintHash: string,
  sessionToken?: string,
)

}

export async function createCliSession(
  userId: string,
  fingerprintId: string,
  fingerprintHash: string,
  sessionToken?: string,
): Promise<boolean> {
  return db.transaction(async (tx: DbTransaction) => {
    await tx
      .insert(schema.fingerprint)
      .values({ id: fingerprintId })
      .onConflictDoNothing()

    const session = await tx
      .insert(schema.session)
      .values({
        sessionToken: crypto.randomUUID(),
        userId,
        expires: MAX_DATE,
        fingerprint_id: fingerprintId,
        cli_auth_hash: fingerprintHash,
        type: 'cli',
      })
      .onConflictDoNothing()
      .returning({ userId: schema.session.userId })

    if (sessionToken) {
      await tx
        .update(schema.session)
        .set({ fingerprint_id: fingerprintId })
        .where(
          and(
            eq(schema.session.sessionToken, sessionToken),
            eq(schema.session.userId, userId),
            isNull(schema.session.fingerprint_id),
            eq(schema.session.type, 'web'),
          ),
        )
    } else {
      logger.warn(
        { fingerprintId, userId },
        'No session token found, cannot link web session to fingerprint',
      )
    }

    return session.length > 0
  })
}