Package org.apache.torque.criteria

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

1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
    public void testInnerJoinWithExcplicitExistingRightTable()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addJoin(
                new ColumnImpl("table2.column2"),
                new ColumnImpl("table3.column3"),
                Criteria.INNER_JOIN);
        criteria.addJoin(
View Full Code Here
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
    public void testInnerJoinWithExcplicitExistingRightTableAndOperator()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addJoin(
                "table2",
                "table3",
                new Criterion(
                    new ColumnImpl("table2.column2"),
View Full Code Here
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
    public void testInnerJoinExcplicitWithExistingRightAndLeftTable()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addJoin(
                new ColumnImpl("table2.column2"),
                new ColumnImpl("table3.column3"),
                Criteria.INNER_JOIN);
        criteria.addJoin(
View Full Code Here
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
                new ColumnImpl("table2.column2"));
        Criterion join = new Criterion(join1).and(join2).and(join3);

        Criteria criteria = new Criteria();
        criteria.setDbName(databasePostgresql.getName());
        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addJoin("table1", "table2", join, Criteria.INNER_JOIN);

        Query query = SqlBuilder.buildQuery(criteria);

        assertEquals(
View Full Code Here
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
    public void testLeftJoin()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addJoin(
                new ColumnImpl("table1.column"),
                new ColumnImpl("table2.column"),
                Criteria.LEFT_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
View Full Code Here
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
    public void testLeftJoinWithExistingRightTable()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(
                new ColumnImpl("table1.column1"));
        criteria.addJoin(
                new ColumnImpl("table2.column2"),
                new ColumnImpl("table3.column3"),
                Criteria.INNER_JOIN);
View Full Code Here
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
    public void testRightJoin()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addJoin(
                new ColumnImpl("table1.column"),
                new ColumnImpl("table2.column"),
                Criteria.RIGHT_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
View Full Code Here
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
    public void testRightJoinWithExistingRightTable()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(
                new ColumnImpl("table1.column1"));
        criteria.addJoin(
                new ColumnImpl("table2.column2"),
                new ColumnImpl("table3.column3"),
                Criteria.INNER_JOIN);
View Full Code Here
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
    public void testInnerJoinImplicitWithAlias()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("alias.column1"));
        criteria.addAlias("alias", "table1");
        criteria.addJoin(
                new ColumnImpl("alias.column"),
                new ColumnImpl("table2.column"));
        Query query = SqlBuilder.buildQuery(criteria);
View Full Code Here
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
    public void testInnerJoinImplicitWithDefaultSchema()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("*"));
        criteria.addJoin(
                new ColumnImpl("table1.column"),
                new ColumnImpl("table2.column"));
        String oldSchema = database.getSchema();
        try
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.