最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

typescript - Kysely how to reuse select - Stack Overflow

programmeradmin2浏览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

发布评论

评论列表(0)

  1. 暂无评论