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 basic where condition on a string.
     */
    public void testWhereString()
    {
        final Column column = new ColumnImpl("myTable", "myColumn");
        final String value = "myValue";


        c.where(column, value);


        // Verify that the Criterion is not composite

View Full Code Here

     * Test basic where condition on a string. The condition is reversed, i.e
     * the String preceeds the column.
     */
    public void testWhereStringReversed()
    {
        final Column column = new ColumnImpl("myTable", "myColumn");
        final String value = "myValue";


        c.where(value, column);


        // Verify that the Criterion is not composite

View Full Code Here

     * Test basic where condition on a string with a non-equal.
     * comparison operator.
     */
    public void testWhereNotEqual()
    {
        final Column column = new ColumnImpl("myTable", "myColumn");
        final String value = "myValue";


        // Add the string
        c.where(column, value, Criteria.NOT_EQUAL);

View Full Code Here

     * as comparison operator in the two-arg where method.
     */
    public void testWhereUnaryOperator()
    {
        // prepare
        final Column column = new ColumnImpl("myTable", "myColumn");
        final SqlEnum operator = SqlEnum.ISNOTNULL;


        // execute
        c.where(column, operator);

View Full Code Here

     * as comparison operator in the two-arg or method.
     */
    public void testOrUnaryOperator()
    {
        // prepare
        final Column column = new ColumnImpl("myTable", "myColumn");
        final SqlEnum operator = SqlEnum.ISNOTNULL;


        // execute
        c.or(column, operator);

View Full Code Here

    /**
     * Test where condition with several ANDs compairing against Strings.
     */
    public void testAndString() 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";
        final String value2b = "2b";
        Criteria c = new Criteria().where(column1, value1a)

View Full Code Here

    /**
     * Test where condition with several ANDs compairing against Strings.
     */
    public void testAndString()
    {
        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";
        final String value2b = "2b";

View Full Code Here

    /**
     * Test where condition with several ORs compairing against Strings.
     */
    public void testOrString() 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";
        final String value2b = "2b";
        Criteria c = new Criteria().where(column1, value1a)

View Full Code Here

    /**
     * Test that nesting Criterions works for equals comparison.
     */
    public void testNestedCriterionComparisonEqual() 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";


        Criterion crit2 =
            new Criterion(column2, value2, Criteria.EQUAL);
        Criterion crit3 =
            new Criterion(column3, value3, Criteria.EQUAL);
        Criterion crit4 =
            new Criterion(column4, value4, Criteria.EQUAL);
        Criterion crit5 =
            new Criterion(column5, value5, Criteria.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=?) "

View Full Code Here

    /**
     * Test where condition with several ANDs compairing against Strings.
     */
    public void testAndCriterions() 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

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.