Package org.apache.torque.criteria

Examples of org.apache.torque.criteria.Criteria.addSelectColumn()


                NullableOIntegerFkPeer.doSelectSingleRecord(
                criteria, new IntegerMapper()));
        for (NullableOIntegerFk nullableOIntegerFk : expected)
        {
            criteria = NullableOIntegerFkPeer.buildCriteria(nullableOIntegerFk);
            criteria.addSelectColumn(new Count("*"));
            Assert.assertEquals(
                    "Expected but not found : " + nullableOIntegerFk,
                    new Integer(1),
                    NullableOIntegerFkPeer.doSelectSingleRecord(
                            criteria, new IntegerMapper()));
View Full Code Here


                CompPkOtherFkPeer.doSelectSingleRecord(
                criteria, new IntegerMapper()));
        for (CompPkOtherFk compPkOtherFk : expected)
        {
            criteria = CompPkOtherFkPeer.buildCriteria(compPkOtherFk);
            criteria.addSelectColumn(new Count("*"));
            Assert.assertEquals(
                    "Expected but not found : " + compPkOtherFk,
                    new Integer(1),
                    CompPkOtherFkPeer.doSelectSingleRecord(
                            criteria, new IntegerMapper()));
View Full Code Here

                CompPkContainsFkPeer.doSelectSingleRecord(
                criteria, new IntegerMapper()));
        for (CompPkContainsFk compPkContainsFk : expected)
        {
            criteria = CompPkContainsFkPeer.buildCriteria(compPkContainsFk);
            criteria.addSelectColumn(new Count("*"));
            Assert.assertEquals(
                    "Expected but not found : " + compPkContainsFk,
                    new Integer(1),
                    CompPkContainsFkPeer.doSelectSingleRecord(
                            criteria, new IntegerMapper()));
View Full Code Here

     * is set.
     */
    public void testignoreCaseUnknownColumnType() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("unknownTable.column1"));
        criteria.where(new ColumnImpl("column1"), "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT unknownTable.column1 FROM unknownTable "
View Full Code Here

    }

    public void testIgnoreCaseStringColumnType() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(stringColumnMap);
        criteria.where(stringColumnMap, "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT TABLE.COLUMN1 FROM TABLE "
View Full Code Here

    }

    public void testIgnoreCaseIntegerColumnType() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(integerColumnMap);
        criteria.where(integerColumnMap, "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT TABLE.COLUMN4 FROM TABLE "
View Full Code Here

    public void testAlias() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", "table");
        criteria.addSelectColumn(new ColumnImpl("alias.column1"));
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.column1 FROM table alias",
                query.toString());
    }
View Full Code Here

    public void testAliasWithDefaultSchema() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", "table");
        criteria.addSelectColumn(new ColumnImpl("alias.column1"));
        String oldSchema = database.getSchema();
        try
        {
            database.setSchema("schema1");
            criteria.setDbName(database.getName());
View Full Code Here

    public void testAliasWithIgnoreCaseUnknownColumnType() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", "table");
        criteria.addSelectColumn(new ColumnImpl("alias.column1"));
        criteria.where(new ColumnImpl("alias.column1"), "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.column1 FROM table alias "
View Full Code Here

            .where(new ColumnImpl("table2.column2"),
                    new ColumnImpl("table2.column3"));

        Criteria criteria = new Criteria();
        criteria.addAlias("alias", subquery);
        criteria.addSelectColumn(new ColumnImpl("alias.column1"));

        Query query = SqlBuilder.buildQuery(criteria);

        assertEquals(
                "SELECT alias.column1 FROM ("
View Full Code Here

TOP
Copyright © 2018 www.massapi.com. 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.