Package org.hibernate.test.legacy

Examples of org.hibernate.test.legacy.Simple

97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
    Iterator iter = s.createQuery( "select max(s.count) from Simple s" ).iterate();

    if ( getDialect() instanceof MySQLDialect ) assertTrue( iter.hasNext() && iter.next()==null );

    Simple simple = new Simple();
    simple.setName("Simple Dialect Function Test");
    simple.setAddress("Simple Address");
    simple.setPay(new Float(45.8));
    simple.setCount(2);
    s.save(simple, new Long(10) );

    // Test to make sure allocating an specified object operates correctly.
    assertTrue(
        s.createQuery( "select new org.hibernate.test.legacy.S(s.count, s.address) from Simple s" ).list().size() == 1
    );

    // Quick check the base dialect functions operate correctly
    assertTrue(
        s.createQuery( "select max(s.count) from Simple s" ).list().size() == 1
    );
    assertTrue(
        s.createQuery( "select count(*) from Simple s" ).list().size() == 1
    );

    if ( getDialect() instanceof Cache71Dialect) {
      // Check Oracle Dialect mix of dialect functions - no args (no parenthesis and single arg functions
      List rset = s.createQuery( "select s.name, sysdate, floor(s.pay), round(s.pay,0) from Simple s" ).list();
      assertNotNull("Name string should have been returned",(((Object[])rset.get(0))[0]));
      assertNotNull("Todays Date should have been returned",(((Object[])rset.get(0))[1]));
      assertEquals("floor(45.8) result was incorrect ", new Integer(45), ( (Object[]) rset.get(0) )[2] );
      assertEquals("round(45.8) result was incorrect ", new Float(46), ( (Object[]) rset.get(0) )[3] );

      simple.setPay(new Float(-45.8));
      s.update(simple);

      // Test type conversions while using nested functions (Float to Int).
      rset = s.createQuery( "select abs(round(s.pay,0)) from Simple s" ).list();
      assertEquals("abs(round(-45.8)) result was incorrect ", new Float(46), rset.get(0));

      // Test a larger depth 3 function example - Not a useful combo other than for testing
      assertTrue(
          s.createQuery( "select floor(round(sysdate,1)) from Simple s" ).list().size() == 1
      );

      // Test the oracle standard NVL funtion as a test of multi-param functions...
      simple.setPay(null);
      s.update(simple);
      Double value = (Double) s.createQuery("select mod( nvl(s.pay, 5000), 2 ) from Simple as s where s.id = 10").list().get(0);
      assertTrue( 0 == value.intValue() );
    }

View Full Code Here
168
169
170
171
172
173
174
175
176
177
178
179
  }

  public void testSetProperties() throws Exception {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    Simple simple = new Simple();
    simple.setName("Simple 1");
    s.save(simple, new Long(10) );
    Query q = s.createQuery("from Simple s where s.name=:name and s.count=:count");
    q.setProperties(simple);
    assertTrue( q.list().get(0)==simple );
    //misuse of "Single" as a propertyobject, but it was the first testclass i found with a collection ;)
View Full Code Here
230
231
232
233
234
235
236
237
238
239
240
241
  }

  public void testNothinToUpdate() throws Exception {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    Simple simple = new Simple();
    simple.setName("Simple 1");
    s.save( simple, new Long(10) );
    t.commit();
    s.close();

    s = openSession();
View Full Code Here
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
  }

  public void testCachedQuery() throws Exception {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    Simple simple = new Simple();
    simple.setName("Simple 1");
    s.save( simple, new Long(10) );
    t.commit();
    s.close();

    s = openSession();
    t = s.beginTransaction();
    Query q = s.createQuery("from Simple s where s.name=?");
    q.setCacheable(true);
    q.setString(0, "Simple 1");
    assertTrue( q.list().size()==1 );
    assertTrue( q.list().size()==1 );
    assertTrue( q.list().size()==1 );
    q = s.createQuery("from Simple s where s.name=:name");
    q.setCacheable(true);
    q.setString("name", "Simple 1");
    assertTrue( q.list().size()==1 );
    simple = (Simple) q.list().get(0);

    q.setString("name", "Simple 2");
    assertTrue( q.list().size()==0 );
    assertTrue( q.list().size()==0 );
    simple.setName("Simple 2");
    assertTrue( q.list().size()==1 );
    assertTrue( q.list().size()==1 );
    t.commit();
    s.close();
View Full Code Here
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
  }

  public void testCachedQueryRegion() throws Exception {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    Simple simple = new Simple();
    simple.setName("Simple 1");
    s.save( simple, new Long(10) );
    t.commit();
    s.close();

    s = openSession();
    t = s.beginTransaction();
    Query q = s.createQuery("from Simple s where s.name=?");
    q.setCacheRegion("foo");
    q.setCacheable(true);
    q.setString(0, "Simple 1");
    assertTrue( q.list().size()==1 );
    assertTrue( q.list().size()==1 );
    assertTrue( q.list().size()==1 );
    q = s.createQuery("from Simple s where s.name=:name");
    q.setCacheRegion("foo");
    q.setCacheable(true);
    q.setString("name", "Simple 1");
    assertTrue( q.list().size()==1 );
    simple = (Simple) q.list().get(0);

    q.setString("name", "Simple 2");
    assertTrue( q.list().size()==0 );
    assertTrue( q.list().size()==0 );
    simple.setName("Simple 2");
    assertTrue( q.list().size()==1 );
    assertTrue( q.list().size()==1 );
    t.commit();
    s.close();
View Full Code Here
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
  }

  public void testSQLFunctions() throws Exception {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    Simple simple = new Simple();
    simple.setName("Simple 1");
    s.save(simple, new Long(10) );

    if ( getDialect() instanceof Cache71Dialect) {
      s.createQuery( "from Simple s where repeat('foo', 3) = 'foofoofoo'" ).list();
      s.createQuery( "from Simple s where repeat(s.name, 3) = 'foofoofoo'" ).list();
      s.createQuery( "from Simple s where repeat( lower(s.name), (3 + (1-1)) / 2) = 'foofoofoo'" ).list();
    }

    assertTrue(
        s.createQuery( "from Simple s where upper( s.name ) ='SIMPLE 1'" ).list().size()==1
    );
    if ( !(getDialect() instanceof HSQLDialect) ) {
      assertTrue(
          s.createQuery(
              "from Simple s where not( upper( s.name ) ='yada' or 1=2 or 'foo'='bar' or not('foo'='foo') or 'foo' like 'bar' )"
          ).list()
              .size()==1
      );
    }
    if ( !(getDialect() instanceof MySQLDialect) && !(getDialect() instanceof SybaseDialect) && !(getDialect() instanceof MckoiDialect) && !(getDialect() instanceof InterbaseDialect) && !(getDialect() instanceof TimesTenDialect) ) { //My SQL has a funny concatenation operator
      assertTrue(
          s.createQuery( "from Simple s where lower( s.name || ' foo' ) ='simple 1 foo'" ).list().size()==1
      );
    }
        /* + is not concat in Cache
        if ( (getDialect() instanceof Cache71Dialect) ) {
      assertTrue(
        s.find("from Simple s where lower( cons.name ' foo' ) ='simple 1 foo'").size()==1
      );
    }
    */
    if ( (getDialect() instanceof Cache71Dialect) ) {
      assertTrue(
          s.createQuery( "from Simple s where lower( concat(s.name, ' foo') ) ='simple 1 foo'" ).list().size()==1
      );
    }

    Simple other = new Simple();
    other.setName("Simple 2");
    other.setCount(12);
    simple.setOther(other);
    s.save( other, new Long(20) );
    //s.find("from Simple s where s.name ## 'cat|rat|bag'");
    assertTrue(
        s.createQuery( "from Simple s where upper( s.other.name ) ='SIMPLE 2'" ).list().size()==1
    );
    assertTrue(
        s.createQuery( "from Simple s where not ( upper( s.other.name ) ='SIMPLE 2' )" ).list().size()==0
    );
    assertTrue(
        s.createQuery(
            "select distinct s from Simple s where ( ( s.other.count + 3 ) = (15*2)/2 and s.count = 69) or ( ( s.other.count + 2 ) / 7 ) = 2"
        ).list()
            .size()==1
    );
    assertTrue(
        s.createQuery(
            "select s from Simple s where ( ( s.other.count + 3 ) = (15*2)/2 and s.count = 69) or ( ( s.other.count + 2 ) / 7 ) = 2 order by s.other.count"
        ).list()
            .size()==1
    );
    Simple min = new Simple();
    min.setCount(-1);
    s.save(min, new Long(30) );
    if ( ! (getDialect() instanceof MySQLDialect) && ! (getDialect() instanceof HSQLDialect) ) { //My SQL has no subqueries
      assertTrue(
          s.createQuery( "from Simple s where s.count > ( select min(sim.count) from Simple sim )" )
              .list()
View Full Code Here
618
619
620
621
622
623
624
625
626
627
628
629
    log.info("Using function named [" + functionName + "] for 'function as alias' test");
    String query = "select " + functionName + " from Simple as " + functionName + " where " + functionName + ".id = 10";

    Session s = openSession();
    Transaction t = s.beginTransaction();
    Simple simple = new Simple();
    simple.setName("Simple 1");
    s.save( simple, new Long(10) );
    t.commit();
    s.close();

    s = openSession();
View Full Code Here
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
  }

  public void testCachedQueryOnInsert() throws Exception {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    Simple simple = new Simple();
    simple.setName("Simple 1");
    s.save( simple, new Long(10) );
    t.commit();
    s.close();

    s = openSession();
    t = s.beginTransaction();
    Query q = s.createQuery("from Simple s");
    List list = q.setCacheable(true).list();
    assertTrue( list.size()==1 );
    t.commit();
    s.close();

    s = openSession();
    t = s.beginTransaction();
    q = s.createQuery("from Simple s");
    list = q.setCacheable(true).list();
    assertTrue( list.size()==1 );
    t.commit();
    s.close();

    s = openSession();
    t = s.beginTransaction();
    Simple simple2 = new Simple();
    simple2.setCount(133);
    s.save( simple2, new Long(12) );
    t.commit();
    s.close();

    s = openSession();
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
      s.delete("from Simple");
      s.flush();
      Simple[] simples = new Simple[n];
      Serializable[] ids = new Serializable[n];
      for ( int i=0; i<n; i++ ) {
        simples[i] = new Simple();
        simples[i].init();
        simples[i].setCount(i);
        ids[i] = new Long(i);
        s.save(simples[i], ids[i]);
      }
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
      s.delete("from Simple");
      s.flush();
      Simple[] simples = new Simple[n];
      Serializable[] ids = new Serializable[n];
      for ( int i=0; i<n; i++ ) {
        simples[i] = new Simple();
        simples[i].init();
        simples[i].setCount(i);
        ids[i] = new Long(i);
        s.save(simples[i], ids[i]);
      }
View Full Code Here
TOP

Related Classes of org.hibernate.test.legacy.Simple

  • org.hibernate.test.dialect.functional.cache.SQLFunctionsInterSystemsTest
  • org.hibernate.test.perf.NewerPerformanceTest
  • org.hibernate.test.perf.NewPerformanceTest
  • org.hibernate.test.perf.PerformanceTest
    • Copyright © 2018 www.massapicom. 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.