如何编写删除所有“大孩子”的Hibernate HQL查询元素？ [英] How to write Hibernate HQL query which remove all "grand children" elements?

问题描述

我想将所有学生从特定学校中删除。

$
$ b

 删除FROM students1 
 WHERE students1.group_id IN 
（SELECT id FROM group1 WHERE group1.school_id =：school_id）
  

如何转换这个SQL查询到Hibernate HQL？

我使用H2数据库引擎。

我的真实查询比较复杂和简单的级联删除学校不适合我）。

解决方案

工作脚本如下所示：

  DELETE FROM Student AS s 
 WHERE s IN 
（SELECT s FROM Student AS s WHERE s.group IN 
（ SELECT g FROM Group AS g WHERE g.school IN 
（SELECT s FROM School's WHERE s.id =：schoolId）））
  

感谢doc_180的评论

I have schools, which contains groups, which contains students.

I would like to remove all students from specific school.

In SQL I can write the following query:

DELETE FROM students1 
WHERE students1.group_id IN 
      (SELECT id FROM group1 WHERE group1.school_id = :school_id)

How to transform this SQL query to Hibernate HQL?

I use H2 database engine.

(My real query is more complex and simple cascade deletion of school is not suitable for me).

解决方案

The working script follows:

DELETE FROM Student AS s
WHERE s IN
    (SELECT s FROM Student AS s WHERE s.group IN
        (SELECT g FROM Group AS g WHERE g.school IN
            (SELECT s FROM School s WHERE s.id = :schoolId)))

Thanks to comments of doc_180

这篇关于如何编写删除所有“大孩子”的Hibernate HQL查询元素？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！