1 | public void testFiltersOnSimpleHqlDelete() {↵ | | 1 | public void testFiltersOnMultiTableHqlDelete() {↵
|
2 | Session session = openSession();↵ | | 2 | Session session = openSession();↵
|
3 | session.beginTransaction();↵ | | 3 | session.beginTransaction();↵
|
4 | Salesperson sp = new Salesperson();↵ | | 4 | Salesperson sp = new Salesperson();↵
|
5 | sp.setName( "steve" );↵ | | 5 | sp.setName( "steve" );↵
|
6 | sp.setRegion( "NA" );↵ | | 6 | sp.setRegion( "NA" );↵
|
7 | session.persist( sp );↵ | | 7 | session.persist( sp );↵
|
8 | Salesperson sp2 = new Salesperson();↵ | | 8 | Salesperson sp2 = new Salesperson();↵
|
9 | sp2.setName( "john" );↵ | | 9 | sp2.setName( "john" );↵
|
10 | sp2.setRegion( "APAC" );↵ | | 10 | sp2.setRegion( "APAC" );↵
|
11 | session.persist( sp2 );↵ | | 11 | session.persist( sp2 );↵
|
12 | session.getTransaction().commit();↵ | | 12 | session.getTransaction().commit();↵
|
13 | session.close();↵ | | 13 | session.close();↵
|
|
14 | session = openSession();↵ | | 14 | session = openSession();↵
|
15 | session.beginTransaction();↵ | | 15 | session.beginTransaction();↵
|
16 | session.enableFilter( "region" ).setParameter( "region", "NA" );↵ | | 16 | session.enableFilter( "region" ).setParameter( "region", "NA" );↵
|
17 | int count = session.createQuery( "delete from Salesperson" ).executeUpdate();↵ | | 17 | int count = session.createQuery( "delete from Salesperson" ).executeUpdate();↵
|
18 | assertEquals( 1, count );↵ | | 18 | assertEquals( 1, count );↵
|
19 | session.delete( sp2 );↵ | | 19 | session.delete( sp2 );↵
|
20 | session.getTransaction().commit();↵ | | 20 | session.getTransaction().commit();↵
|
21 | session.close();↵ | | 21 | session.close();↵
|
22 | | | 22 |
|