|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
async getAdminByPermissions(permission: Permission) { const query = this.adminRepository .createQueryBuilder('user') .leftJoinAndSelect( 'user_permission', 'permission', 'user.id = permission.user_id', ) .select([ 'user.id as id', 'user.email as email', 'user.is_root as is_root', 'permission.permission_id as permission_id', ]) .where('user.is_root = :isRoot', { isRoot: true }) .orWhere('permission.permission_id = :permissionId', { permissionId: permission, }) return await query.getRawMany() } |
NodeJS – TypeOrm Example
Author: admin - Posted: 21/01/21 - Update: 04/01/23
