typescript - Kysely how to reuse select - Stack Overflow

admin2025-04-15  0

I have 5 different queries but they all use same select statement, how can i reuse the select to be used in 5 other queries

export const q_get_users = async () => {
    const users = await dbk
        .selectFrom('users as u')
        .select([
            'u.pid',
            'u.email',
            'u.first_name as firstName',
            'u.last_name as lastName',
            'u.profile_picture_url as profilePictureUrl',
            'u.date_of_birth as dateOfBirth',
            'u.user_role_type as userRoleType',
            'u.user_status as userStatus',
            'u.created_at as createdAt',
            'u.updated_at as updatedAt',
        ])
        .execute()
    return users
}

I just need to re-use the same columns in other 5

转载请注明原文地址:http://www.anycun.com/QandA/1744713749a86593.html