Examples of org.apache.torque.ColumnImpl

org.apache.torque.ColumnImpl
An implementation of the column interface. This class is immutable, i.e cannot be changed once constructed. @version $Id: ColumnImpl.java 1448414 2013-02-20 21:06:35Z tfischer $

     * Test that nesting Criterions works for other comparisons than equal.
     */
    public void testNestedCriterionComparisonLessGreaterThan()
            throws TorqueException
    {
        final Column column2 = new ColumnImpl("myTable2", "myColumn2");
        final String value2 = "myValue2";


        final Column column3 = new ColumnImpl("myTable3", "myColumn3");
        final String value3 = "myValue3";


        final Column column4 = new ColumnImpl("myTable4", "myColumn4");
        final String value4 = "myValue4";


        final Column column5 = new ColumnImpl("myTable5", "myColumn5");
        final String value5 = "myValue5";


        c = new Criteria();
        Criterion crit2 = new Criterion(
                column2,
                value2,
                Criteria.LESS_THAN);
        Criterion crit3 = new Criterion(
                column3,
                value3,
                Criteria.LESS_EQUAL);
        Criterion crit4 = new Criterion(
                column4,
                value4,
                Criteria.GREATER_THAN);
        Criterion crit5 = new Criterion(
                column5,
                value5,
                Criteria.GREATER_EQUAL);


        crit2.and(crit3).or(crit4).and(crit5);
        c.where(crit2);
        c.addSelectColumn(new ColumnImpl(null, "myTable2", null, "*"));
        String expect =
            "SELECT * FROM myTable2, myTable3, myTable4, myTable5 WHERE "
                + "(((myTable2.myColumn2<? "
                    + "AND myTable3.myColumn3<=?) "
                + "OR myTable4.myColumn4>?) "

View Full Code Here

    /**
     * Test where condition with several ORs compairing against Strings.
     */
    public void testOrCriterions() throws Exception
    {
        final Column column1 = new ColumnImpl("myTable", "myColumn1");
        final Column column2 = new ColumnImpl("myTable", "myColumn2");
        final String value1a = "1a";
        final String value1b = "1b";
        final String value2a = "2a";
        Criterion criterion1 = new Criterion(column1, value1a);
        Criterion criterion2 = new Criterion(column1, value1b);

View Full Code Here

     * Tests &lt;= and =&gt;.
     */
    public void testBetweenCriterion() throws TorqueException
    {
        Criterion cn1 = new Criterion(
                new ColumnImpl("INVOICE", "COST"),
                -1,
                Criteria.GREATER_EQUAL);
        Criterion cn2 = new Criterion(
                new ColumnImpl("INVOICE", "COST"),
                1,
                Criteria.LESS_EQUAL);
        c.where(cn1).and(cn2);
        String expect =
            "SELECT  FROM INVOICE WHERE "

View Full Code Here

     * Test Criterion.setIgnoreCase().
     */
    public void testCriterionIgnoreCase() throws TorqueException
    {
        Criterion criterion1 = new Criterion(
                new ColumnImpl("TABLE", "COLUMN1"), "FoObAr1", Criteria.LIKE);
        criterion1.setIgnoreCase(true);
        Criterion criterion2 = new Criterion(
                new ColumnImpl("TABLE", "COLUMN2"), "FoObAr2", Criteria.EQUAL);
        criterion2.setIgnoreCase(true);
        Criterion criterion3 = new Criterion(
                new ColumnImpl("TABLE", "COLUMN3"), "FoObAr3", Criteria.EQUAL);
        Criterion criterion4 = new Criterion(
                new ColumnImpl("TABLE", "COLUMN4"), new Integer(1), Criteria.EQUAL);
        criterion4.setIgnoreCase(true);
        c.where(criterion1.and(criterion2).and(criterion3).and(criterion4));
        c.addSelectColumn(new ColumnImpl(null, "TABLE", null, "*"));
        c.setDbName("postgresql");
        Query result = SqlBuilder.buildQuery(c);


        String expect = "SELECT * FROM TABLE WHERE "
            + "(UPPER(TABLE.COLUMN1)=UPPER(?)"

View Full Code Here

     * Test the andVerbatimSql method with null replacements.
     */
    public void testAndVerbatimSqlReplacementNull() throws Exception
    {
        Criteria criteria = new Criteria()
            .where(new ColumnImpl("table1.a"), "a")
            .andVerbatimSql(
                "foo(table1.x) = bar(table2.y)",
                null);


        Query query = SqlBuilder.buildQuery(criteria);

View Full Code Here

    /**
     * Test that true is evaluated correctly in Mysql.
     */
    public void testBooleanMysql() throws TorqueException
    {
        c.where(new ColumnImpl("TABLE", "COLUMN"), true);
        c.setDbName("mysql");


        Query result = SqlBuilder.buildQuery(c);


        assertEquals(

View Full Code Here

     * Test the andVerbatimSql method with replacements.
     */
    public void testAndVerbatimSqlWithReplacements() throws Exception
    {
        Criteria criteria = new Criteria()
            .where(new ColumnImpl("table1.a"), "a")
            .andVerbatimSql(
                "foo(table1.x, ?) = bar(table2.y, ?)",
                new Object[] {"y", "z"});


        Query query = SqlBuilder.buildQuery(criteria);

View Full Code Here

     * Test that true is evaluated correctly in Postgresql.
     */
    public void testBooleanPostgresql() throws TorqueException
    {
        // test the postgresql variation
        c.where(new ColumnImpl("TABLE", "COLUMN"), true);
        c.setDbName("postgresql");


        Query result = SqlBuilder.buildQuery(c);


        assertEquals(

View Full Code Here

     * Test the andVerbatimSql method with from Columns.
     */
    public void testAndVerbatimSqlWithFromColumns() throws Exception
    {
        Criteria criteria = new Criteria()
            .where(new ColumnImpl("table1.a"), "a")
            .andVerbatimSql(
                "foo(table1.x) = bar(table2.y)",
                new Object[] {},
                new ColumnImpl("table1.x"),
                new ColumnImpl("table2.y"));


        Query query = SqlBuilder.buildQuery(criteria);


        assertEquals(
                "SELECT  FROM table1, table2 "

View Full Code Here

    /**
     * Testcase for whereDate()
     */
    public void testWhereDate() throws TorqueException
    {
         c.whereDate(new ColumnImpl("TABLE", "DATE_COLUMN"), 2003, 0, 22);


        Query result = SqlBuilder.buildQuery(c);


        assertEquals(
                "SELECT  FROM TABLE WHERE TABLE.DATE_COLUMN=?",

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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

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.