Skip to content

armgit / papra

Public Imported from GitHub
0

The minimalistic document archiving platform.

839 B
Raw Blame
import { integer, text } from 'drizzle-orm/sqlite-core';
import { generateId } from '../random/ids';

export function createPrimaryKeyField({
  prefix,
  idGenerator = () => generateId({ prefix }),
}: { prefix?: string; idGenerator?: () => string } = {}) {
  return {
    id: text('id').primaryKey().$default(idGenerator),
  };
}

export function createCreatedAtField() {
  return {
    createdAt: integer('created_at', { mode: 'timestamp_ms' })
      .notNull()
      .$default(() => new Date()),
  };
}

export function createUpdatedAtField() {
  return {
    updatedAt: integer('updated_at', { mode: 'timestamp_ms' })
      .notNull()
      .$default(() => new Date())
      .$onUpdate(() => new Date()),
  };
}

export function createTimestampColumns() {
  return {
    ...createCreatedAtField(),
    ...createUpdatedAtField(),
  };
}