Quickstart

type TUser = {
  id: string
  name: string
  email: string
  age: number
  status: 'active' | 'inactive'
}

import { createFn, readFn, updateFn, destroyFn } from '@remcostoeten/drizzleasy/server'

function createCrud() {
  const create = createFn<TUser>()
  const read = readFn<TUser>()
  const update = updateFn<TUser>()
  const destroy = destroyFn<TUser>()
  return { create, read, update, destroy }
}

const { create } = createCrud()

async function createUser() {
  return create('users')({
    name: 'John',
    email: 'john@example.com',
    age: 25,
    status: 'active'
  })
}

const { read } = createCrud()

async function listUsers() {
  return read('users')()
}

async function listActiveAdults() {
  return read('users')
    .where({ status: 'active' })
    .where({ age: '>18' })()
}

async function getUserById(id: string) {
  return read('users').byId(id)
}

const { update } = createCrud()

async function deactivateUser(id: string) {
  return update('users')(id, { status: 'inactive' })
}

const { destroy } = createCrud()

async function deleteUser(id: string) {
  return destroy('users')(id)
}