WHERE Clauses

import { readFn } from '@remcostoeten/drizzleasy/server'

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

function readUsers() {
  return readFn<TUser>()
}

async function examples() {
  const read = readUsers()
  const active = await read('users').where({ status: 'active' })()
  const admins = await read('users').where({ status: 'active' }).where({ role: 'admin' })()
}

.where({ status: 'active' })
.where({ isActive: true })
.where({ count: 0 })

// Not equal
.where({ status: '!inactive' })

.where({ age: '>18' })
.where({ age: '>=21' })
.where({ price: '<100' })
.where({ rating: '<=4.5' })

.where({ name: '*john*' })    // contains
.where({ name: 'john*' })     // starts with
.where({ email: '*@gmail.com' }) // ends with

.where({ role: ['admin', 'moderator'] })
.where({ status: ['active', 'pending'] })

type TProduct = { id: string; name: string; price: number; category: string; inStock: boolean; rating: number }

function readProducts() {
  return readFn<TProduct>()
}

async function affordableQuality() {
  const read = readProducts()
  return read('products')
    .where({ price: '<100' })
    .where({ inStock: true })
    .where({ rating: '>=4.0' })
    .where({ category: ['electronics', 'books'] })()
}

type TPost = { id: string; title: string; status: 'draft' | 'published'; authorId: string }

function readPosts() {
  return readFn<TPost>()
}

async function publishedReactPosts() {
  const read = readPosts()
  return read('posts').where({ status: 'published' }).where({ title: '*React*' })()
}