4 replies

Correct typing when using "columns" as param

Hello awesome people at Drizzle,

I'm having this problem and I don't know how to fix it. So...
I have this RoleManager service that has a method called

getByName

getByName

that can take in

columns

columns

.
The problem is that I can't seem to type this query in a nice way and what I've done doesn't tickle me the right way. xD

    static async getByName<TColumns extends keyof RoleModel>(
        roleName: RoleModel["name"],
        columns?: Partial<Record<TColumns, boolean>>,
    ): Promise<Pick<RoleModel, TColumns> | undefined> {
        const role = await db.query.roles
            .findFirst({ where: eq(roles.name, roleName), columns });

        return role as unknown as Pick<RoleModel, TColumns> | undefined;
    }

    static async getByName<TColumns extends keyof RoleModel>(
        roleName: RoleModel["name"],
        columns?: Partial<Record<TColumns, boolean>>,
    ): Promise<Pick<RoleModel, TColumns> | undefined> {
        const role = await db.query.roles
            .findFirst({ where: eq(roles.name, roleName), columns });

        return role as unknown as Pick<RoleModel, TColumns> | undefined;
    }

Drizzle Team•3y ago•

4 replies

KIPRI

Correct typing when using "columns" as param

Hello awesome people at Drizzle,

I'm having this problem and I don't know how to fix it. So...
I have this RoleManager service that has a method called

getByName

getByName

that can take in

columns

columns

.
The problem is that I can't seem to type this query in a nice way and what I've done doesn't tickle me the right way. xD

    static async getByName<TColumns extends keyof RoleModel>(
        roleName: RoleModel["name"],
        columns?: Partial<Record<TColumns, boolean>>,
    ): Promise<Pick<RoleModel, TColumns> | undefined> {
        const role = await db.query.roles
            .findFirst({ where: eq(roles.name, roleName), columns });

        return role as unknown as Pick<RoleModel, TColumns> | undefined;
    }

    static async getByName<TColumns extends keyof RoleModel>(
        roleName: RoleModel["name"],
        columns?: Partial<Record<TColumns, boolean>>,
    ): Promise<Pick<RoleModel, TColumns> | undefined> {
        const role = await db.query.roles
            .findFirst({ where: eq(roles.name, roleName), columns });

        return role as unknown as Pick<RoleModel, TColumns> | undefined;
    }

Correct typing when using "columns" as param

Similar Threads

Correct typing when using "columns" as param

Similar Threads

Similar Threads

Similar Threads