Package org.hibernate

Examples of org.hibernate.Session.enableFilter()

83
84
85
86
87
88
89
90
91
92
93
    QueryPlanCache cache = ( ( SessionImplementor ) s ).getFactory().getQueryPlanCache();

    HQLQueryPlan plan1A = cache.getHQLQueryPlan( "from Person", true, getEnabledFilters( s ) );
    HQLQueryPlan plan1B = cache.getHQLQueryPlan( "from Person", false, getEnabledFilters( s ) );

    s.enableFilter( "sex" ).setParameter( "sexCode", new Character( 'F' ) );
    HQLQueryPlan plan2A = cache.getHQLQueryPlan( "from Person", true, getEnabledFilters( s ) );
    HQLQueryPlan plan2B = cache.getHQLQueryPlan( "from Person", false, getEnabledFilters( s ) );

    s.disableFilter( "sex" );
    HQLQueryPlan plan3A = cache.getHQLQueryPlan( "from Person", true, getEnabledFilters( s ) );
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
    s.disableFilter( "sex" );
    HQLQueryPlan plan3A = cache.getHQLQueryPlan( "from Person", true, getEnabledFilters( s ) );
    HQLQueryPlan plan3B = cache.getHQLQueryPlan( "from Person", false, getEnabledFilters( s ) );

    s.enableFilter( "sex" ).setParameter( "sexCode", new Character( 'M' ) );
    HQLQueryPlan plan4A = cache.getHQLQueryPlan( "from Person", true, getEnabledFilters( s ) );
    HQLQueryPlan plan4B = cache.getHQLQueryPlan( "from Person", false, getEnabledFilters( s ) );

    assertSame( plan1A, plan3A );
    assertSame( plan1B, plan3B );
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
    return new FunctionalTestClassTestSuite( DynamicFilterTest.class );
  }

  public void testSqlSyntaxOfFiltersWithUnions() {
    Session session = openSession();
    session.enableFilter( "unioned" );
    session.createQuery( "from Category" ).list();
    session.close();
  }

  public void testSecondLevelCachedCollectionsFiltering() {
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
    session.close();

    session = openSession();
    ts = ( ( SessionImplementor ) session ).getTimestamp();
    session.enableFilter( "fulfilledOrders" ).setParameter( "asOfDate", testData.lastMonth.getTime() );
    sp = ( Salesperson ) session.createQuery( "from Salesperson as s where s.id = :id" )
            .setLong( "id", testData.steveId )
            .uniqueResult();
    assertEquals( "Filtered-collection not bypassing 2L-cache", 1, sp.getOrders().size() );
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
    assertSame( "Different cache values!", cachedData, cachedData2 );

    session.close();

    session = openSession();
    session.enableFilter( "fulfilledOrders" ).setParameter( "asOfDate", testData.lastMonth.getTime() );
    sp = ( Salesperson ) session.load( Salesperson.class, testData.steveId );
    assertEquals( "Filtered-collection not bypassing 2L-cache", 1, sp.getOrders().size() );

    session.close();
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
  public void testCombinedClassAndCollectionFiltersEnabled() {
    TestData testData = new TestData();
    testData.prepare();

    Session session = openSession();
    session.enableFilter( "regionlist" ).setParameterList( "regions", new String[]{"LA", "APAC"} );
    session.enableFilter( "fulfilledOrders" ).setParameter( "asOfDate", testData.lastMonth.getTime() );

    // test retreival through hql with the collection as non-eager
    List salespersons = session.createQuery( "select s from Salesperson as s" ).list();
    assertEquals( "Incorrect salesperson count", 1, salespersons.size() );
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
    TestData testData = new TestData();
    testData.prepare();

    Session session = openSession();
    session.enableFilter( "regionlist" ).setParameterList( "regions", new String[]{"LA", "APAC"} );
    session.enableFilter( "fulfilledOrders" ).setParameter( "asOfDate", testData.lastMonth.getTime() );

    // test retreival through hql with the collection as non-eager
    List salespersons = session.createQuery( "select s from Salesperson as s" ).list();
    assertEquals( "Incorrect salesperson count", 1, salespersons.size() );
    Salesperson sp = ( Salesperson ) salespersons.get( 0 );
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
    assertEquals( "Incorrect order count", 1, sp.getOrders().size() );

    session.clear();

    session.disableFilter("regionlist");
    session.enableFilter( "regionlist" ).setParameterList( "regions", new String[]{"LA", "APAC", "APAC"} );
    // Second test retreival through hql with the collection as non-eager with different region list
    salespersons = session.createQuery( "select s from Salesperson as s" ).list();
    assertEquals( "Incorrect salesperson count", 1, salespersons.size() );
    sp = ( Salesperson ) salespersons.get( 0 );
    assertEquals( "Incorrect order count", 1, sp.getOrders().size() );
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
    log.info( "Starting HQL filter tests" );
    TestData testData = new TestData();
    testData.prepare();

    Session session = openSession();
    session.enableFilter( "region" ).setParameter( "region", "APAC" );

    session.enableFilter( "effectiveDate" )
            .setParameter( "asOfDate", testData.lastMonth.getTime() );

    log.info( "HQL against Salesperson..." );
View Full Code Here
173
174
175
176
177
178
179
180
181
182
183
    testData.prepare();

    Session session = openSession();
    session.enableFilter( "region" ).setParameter( "region", "APAC" );

    session.enableFilter( "effectiveDate" )
            .setParameter( "asOfDate", testData.lastMonth.getTime() );

    log.info( "HQL against Salesperson..." );
    List results = session.createQuery( "select s from Salesperson as s left join fetch s.orders" ).list();
    assertTrue( "Incorrect filtered HQL result count [" + results.size() + "]", results.size() == 1 );
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.