Typeorm NOT IN

2种用法

id: Not(In(notNeedDeletePromptCategoryRelation))

  if (relation.length > 0) {
                // 删除映射关系
                await this.reo.query(`delete from ** where p = '${p}' and id not in (${relation.join(',')})`);
            } else {
                await this.reo.delete({
                    promptId: promptId,
                });
            }