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 $

    /**
     * Testcase for andDate().
     */
    public void testAndDate() throws TorqueException
    {
        c.whereDate(new ColumnImpl("TABLE", "DATE_COLUMN"),
                2003,
                0,
                22,
                Criteria.GREATER_THAN);
        c.andDate(new ColumnImpl("TABLE", "DATE_COLUMN"),
                2004,
                2,
                24,
                Criteria.LESS_THAN);

View Full Code Here

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


        Query query = SqlBuilder.buildQuery(criteria);

View Full Code Here

     */
    public void testDateWhere() throws TorqueException
    {
        Calendar cal = new GregorianCalendar(2003, 0, 22);
        Date date = cal.getTime();
        c.where(new ColumnImpl("TABLE", "DATE_COLUMN"), date);


        Query result = SqlBuilder.buildQuery(c);
        assertEquals(
                "SELECT  FROM TABLE WHERE "
                    + "TABLE.DATE_COLUMN=?",

View Full Code Here

                preparedStatementReplacements.get(0));
    }


    public void testAndCurrentDate() throws TorqueException
    {
        c.where(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

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


        Query query = SqlBuilder.buildQuery(criteria);

View Full Code Here

        assertEquals(0, preparedStatementReplacements.size());
    }


    public void testAndCurrentTime() throws TorqueException
    {
        c.where(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

     * Test the orVerbatimSql method with from Columns.
     */
    public void testOrVerbatimSqlWithFromColumns() throws Exception
    {
        Criteria criteria = new Criteria()
            .where(new ColumnImpl("table1.a"), "a")
            .orVerbatimSql(
                "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

        assertEquals(0, preparedStatementReplacements.size());
    }


    public void testCriteriaOffsetLimit() throws TorqueException
    {
        c.whereDate(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

    }


    public void testCriteriaWithOffsetNoLimitPostgresql()
            throws TorqueException
    {
        c.whereDate(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

    {
        Criteria criteria = new Criteria()
            .whereVerbatimSql(
                "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

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.