Racks
Racks
PostsComments
DTDrizzle Team
Created by ewilliam on 8/12/2023 in #help
how to type dynamic where condition
You can make it more generic like this: 
type Db = typeof db
type DbQuery = Db["query"]
type DbQueryWhere<K extends keyof DbQuery> = Get<Parameters<DbQuery[K]["findFirst"]>[0], "where">

function doTheThing<T extends DbQueryWhere<"events">>(where: T) {
  return db.query.events.findFirst({
    where
  })
}
type Db = typeof db
type DbQuery = Db["query"]
type DbQueryWhere<K extends keyof DbQuery> = Get<Parameters<DbQuery[K]["findFirst"]>[0], "where">

function doTheThing<T extends DbQueryWhere<"events">>(where: T) {
  return db.query.events.findFirst({
    where
  })
}
10 replies
DTDrizzle Team
Created by ewilliam on 8/12/2023 in #help
how to type dynamic where condition
What it's doing is using TypeScript to lookup the type of db, then get the type of query.events.findFirst function's first argument. I couldn't figure out how to get access to the "where" key in the first argument without using type-fest. But type-fest is a type's only library and adds no bloat to bundles.
10 replies
DTDrizzle Team
Created by ewilliam on 8/12/2023 in #help
how to type dynamic where condition
I'm actually going to use this in some of my stuff too… it is fantastic
10 replies
DTDrizzle Team
Created by ewilliam on 8/12/2023 in #help
how to type dynamic where condition
Yea it does work 🙂
10 replies
DTDrizzle Team
Created by ewilliam on 8/12/2023 in #help
how to type dynamic where condition
@ewilliam you'll need to add npm install --save type-fest But this may work: 
type EventsCondition = Get<Parameters<(typeof db)["query"]["events"]["findFirst"]>[0], "where">
async function selectEventBycondition<T extends EventsCondition>(condition: T) {
    return db.query.events.findFirst({where: condition})
}
type EventsCondition = Get<Parameters<(typeof db)["query"]["events"]["findFirst"]>[0], "where">
async function selectEventBycondition<T extends EventsCondition>(condition: T) {
    return db.query.events.findFirst({where: condition})
}
10 replies
DTDrizzle Team
Created by ewilliam on 8/12/2023 in #help
how to type dynamic where condition
I think the idea is that you wouldn't bother wrapping the db.query.events.findFirst function. The type system can probably accomplish this but whats some examples of the condition(s) that will be passed in?
10 replies