Package org.apache.torque

Examples of org.apache.torque.ColumnImpl

330
331
332
333
334
335
336
337
338
339
340
341
     * testcase for andDate()
     * issue TORQUE-42
     */
    public void testAndDate() throws TorqueException
    {
        c.addDate(new ColumnImpl("TABLE", "DATE_COLUMN"), 2003, 0, 22, Criteria.GREATER_THAN);
        c.andDate(new ColumnImpl("TABLE", "DATE_COLUMN"), 2004, 2, 24, Criteria.LESS_THAN);

        Query result = SqlBuilder.buildQuery(c);
        assertEquals(
                "SELECT  FROM TABLE WHERE "
                    + "(TABLE.DATE_COLUMN>? AND TABLE.DATE_COLUMN<?)",
View Full Code Here
356
357
358
359
360
361
362
363
364
365
366
     */
    public void testDateAdd() throws TorqueException
    {
        Calendar cal = new GregorianCalendar(2003, 0, 22);
        Date date = cal.getTime();
        c.add(new ColumnImpl("TABLE", "DATE_COLUMN"), date);

        Query result = SqlBuilder.buildQuery(c);
        assertEquals(
                "SELECT  FROM TABLE WHERE "
                    + "TABLE.DATE_COLUMN=?",
View Full Code Here
374
375
376
377
378
379
380
381
382
383
384
385
                preparedStatementReplacements.get(0));
    }

    public void testCurrentDate() throws TorqueException
    {
        c.add(new ColumnImpl("TABLE", "DATE_COLUMN"), Criteria.CURRENT_DATE);
        c.addSelectColumn(new ColumnImpl(null, "TABLE", null, "COUNT(*)"));

        Query result = SqlBuilder.buildQuery(c);
        assertEquals(
                "SELECT COUNT(*) FROM TABLE WHERE "
                    + "TABLE.DATE_COLUMN=CURRENT_DATE",
View Full Code Here
390
391
392
393
394
395
396
397
398
399
400
401
        assertEquals(0, preparedStatementReplacements.size());
    }

    public void testCurrentTime() throws TorqueException
    {
        c.add(new ColumnImpl("TABLE", "TIME_COLUMN"), Criteria.CURRENT_TIME);
        c.addSelectColumn(new ColumnImpl(null, "TABLE", null, "COUNT(*)"));

        Query result = SqlBuilder.buildQuery(c);
        assertEquals(
                "SELECT COUNT(*) FROM TABLE WHERE "
                    + "TABLE.TIME_COLUMN=CURRENT_TIME",
View Full Code Here
406
407
408
409
410
411
412
413
414
415
416
417
418
        assertEquals(0, preparedStatementReplacements.size());
    }

    public void testCriteriaOffsetLimit() throws TorqueException
    {
        c.addDate(new ColumnImpl("TABLE", "DATE_COLUMN"), 2003, 0, 22);
        c.setOffset(3).setLimit(5);
        c.addSelectColumn(new ColumnImpl(null, "TABLE", null, "COUNT(*)"));

        Query result = SqlBuilder.buildQuery(c);
        String expect
            = "SELECT COUNT(*) FROM TABLE WHERE TABLE.DATE_COLUMN=?"
                + " LIMIT 5 OFFSET 3";
View Full Code Here
420
421
422
423
424
425
426
427
428
429
430
431
432
    }

    public void testCriteriaWithOffsetNoLimitPostgresql()
            throws TorqueException
    {
        c.addDate(new ColumnImpl("TABLE", "DATE_COLUMN"), 2003, 0, 22);
        c.setOffset(3);
        c.addSelectColumn(new ColumnImpl(null, "TABLE", null, "COUNT(*)"));

        Query result = SqlBuilder.buildQuery(c);
        String expect
            = "SELECT COUNT(*) FROM TABLE WHERE TABLE.DATE_COLUMN=?"
                + " OFFSET 3";
View Full Code Here
436
437
438
439
440
441
442
443
444
445
446
447
448
    /**
     * TORQUE-87
     */
    public void testCriteriaWithOffsetNoLimitMysql() throws TorqueException
    {
        c.addDate(new ColumnImpl("TABLE", "DATE_COLUMN"), 2003, 0, 22);
        c.setOffset(3);
        c.addSelectColumn(new ColumnImpl(null, "TABLE", null, "COUNT(*)"));
        c.setDbName("mysql");

        Query result = SqlBuilder.buildQuery(c);
        String expect
            = "SELECT COUNT(*) FROM TABLE WHERE TABLE.DATE_COLUMN=?"
View Full Code Here
450
451
452
453
454
455
456
457
458
459
460
461
462
        assertEquals(expect, result.toString());
    }

    public void testCriteriaToStringLimit() throws TorqueException
    {
        c.addDate(new ColumnImpl("TABLE", "DATE_COLUMN"), 2003, 0, 22);
        c.setLimit(5);
        c.addSelectColumn(new ColumnImpl(null, "TABLE", null, "COUNT(*)"));

        Query result = SqlBuilder.buildQuery(c);
        String expect
            = "SELECT COUNT(*) FROM TABLE WHERE TABLE.DATE_COLUMN=?"
                + " LIMIT 5";
View Full Code Here
468
469
470
471
472
473
474
475
476
477
478
     * get replaced through Criteria.EQUAL if there are no SQL wildcards
     * in the given value.
     */
    public void testLikeWithoutWildcards() throws TorqueException
    {
        c.add(new ColumnImpl("TABLE", "COLUMN"), "no wildcards", Criteria.LIKE);

        Query result = SqlBuilder.buildQuery(c);
        assertEquals(
                "SELECT  FROM TABLE WHERE "
                    + "TABLE.COLUMN=?",
View Full Code Here
491
492
493
494
495
496
497
498
499
500
501
     * get replaced through Criteria.NOT_EQUAL if there are no SQL wildcards
     * in the given value.
     */
    public void testNotLikeWithoutWildcards()
    {
        c.add(new ColumnImpl("TABLE", "COLUMN"), "no wildcards", Criteria.NOT_LIKE);

        String firstExpect = "SELECT  FROM TABLE WHERE TABLE.COLUMN!=?";
        String secondExpect = "SELECT  FROM TABLE WHERE TABLE.COLUMN<>?";

        Query result = null;
View Full Code Here
TOP

Related Classes of org.apache.torque.ColumnImpl

  • org.apache.commons.lang.builder.EqualsBuilder
  • org.apache.commons.lang.builder.HashCodeBuilder
  • org.apache.torque.criteria.CriteriaTest
  • org.apache.torque.criteria.CriterionTest
  • org.apache.torque.criteria.JoinTest
  • org.apache.torque.datatypes.BooleanIntCharTest
  • org.apache.torque.generated.peer.JoinTest
  • org.apache.torque.generated.peer.WhereClauseSubselectTest
  • org.apache.torque.sql.SqlBuilder
  • org.apache.torque.sql.SqlBuilderTest
    • 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.