Package org.dspace.xoai.services.api.database

Examples of org.dspace.xoai.services.api.database.DatabaseQuery

65
66
67
68
69
70
71
72
73
74
75
76
            public Filter getFilter() {
                return new DateFromFilter(DATE);
            }
        }, Scope.Query));

        DatabaseQuery result = underTest.buildQuery(scopedFilters, START, LENGTH);

        assertThat(result.getQuery(), is("SELECT i.* FROM item i  WHERE i.in_archive=true AND (i.last_modified >= ?) ORDER BY i.item_id OFFSET ? LIMIT ?"));
        assertThat(((java.sql.Date)result.getParameters().get(0)).getTime(), is(fromDate(DATE).getTime()));
        assertThat((Integer) result.getParameters().get(1), is(START));
        assertThat((Integer) result.getParameters().get(2), is(LENGTH));
    }
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
102
103
            }
        };
        scopedFilters.add(new ScopedFilter(new AndCondition(getFilterResolver(),
                fromCondition, untilCondition), Scope.Query));

        DatabaseQuery result = underTest.buildQuery(scopedFilters, START, LENGTH);

        assertThat(result.getQuery(), is("SELECT i.* FROM item i  WHERE i.in_archive=true AND ((i.last_modified >= ?) AND (i.last_modified <= ?)) ORDER BY i.item_id OFFSET ? LIMIT ?"));
        assertThat(((java.sql.Date)result.getParameters().get(0)).getTime(), is(fromDate(DATE).getTime()));
        assertThat(((java.sql.Date)result.getParameters().get(1)).getTime(), is(untilDate(DATE).getTime()));
        assertThat((Integer) result.getParameters().get(2), is(START));
        assertThat((Integer) result.getParameters().get(3), is(LENGTH));
    }
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
124
        scopedFilters.add(new ScopedFilter(new CustomCondition(getFilterResolver(),
                DSpaceMetadataExistsFilter.class,
                filterConfiguration),
                Scope.Query));

        DatabaseQuery result = underTest.buildQuery(scopedFilters, START, LENGTH);

        assertThat(result.getQuery(), is("SELECT i.* FROM item i  WHERE i.in_archive=true AND ((EXISTS (SELECT tmp.* FROM metadatavalue tmp WHERE tmp.resource_id=i.item_id AND tmp.resource_type_id=" + Constants.ITEM + " AND tmp.metadata_field_id=?))) ORDER BY i.item_id OFFSET ? LIMIT ?"));
        assertThat(((Integer) result.getParameters().get(0)), is(1));
        assertThat((Integer) result.getParameters().get(1), is(START));
        assertThat((Integer) result.getParameters().get(2), is(LENGTH));
    }
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
148
149
        scopedFilters.add(new ScopedFilter(new CustomCondition(getFilterResolver(),
                DSpaceMetadataExistsFilter.class,
                filterConfiguration),
                Scope.Query));

        DatabaseQuery result = underTest.buildQuery(scopedFilters, START, LENGTH);

        assertThat(result.getQuery(), is("SELECT i.* FROM item i  WHERE i.in_archive=true AND ((EXISTS (SELECT tmp.* FROM metadatavalue tmp WHERE tmp.resource_id=i.item_id AND tmp.resource_type_id=" + Constants.ITEM + " AND tmp.metadata_field_id=?) OR EXISTS (SELECT tmp.* FROM metadatavalue tmp WHERE tmp.resource_id=i.item_id AND tmp.resource_type_id=" + Constants.ITEM + " AND tmp.metadata_field_id=?))) ORDER BY i.item_id OFFSET ? LIMIT ?"));
        assertThat(((Integer) result.getParameters().get(0)), is(1));
        assertThat(((Integer) result.getParameters().get(1)), is(2));
        assertThat((Integer) result.getParameters().get(2), is(START));
        assertThat((Integer) result.getParameters().get(3), is(LENGTH));
    }
View Full Code Here
156
157
158
159
160
161
162
163
164
165
166
167
            public Filter getFilter() {
                return new DateFromFilter(DATE);
            }
        }, Scope.MetadataFormat));

        DatabaseQuery result = underTest.buildQuery(scopedFilters, START, LENGTH);

        assertThat(result.getQuery(), is("SELECT i.* FROM item i  WHERE i.in_archive=true AND (item.deleted:true OR (i.last_modified >= ?)) ORDER BY i.item_id OFFSET ? LIMIT ?"));
        assertThat(((java.sql.Date)result.getParameters().get(0)).getTime(), is(fromDate(DATE).getTime()));
        assertThat((Integer) result.getParameters().get(1), is(START));
        assertThat((Integer) result.getParameters().get(2), is(LENGTH));
    }
View Full Code Here
180
181
182
183
184
185
186
187
188
189
190
191
            public Filter getFilter() {
                return new DSpaceSetSpecFilter(collectionsService, handleResolver, SET);
            }
        }, Scope.Query));

        DatabaseQuery result = underTest.buildQuery(scopedFilters, START, LENGTH);

        assertThat(result.getQuery(), is("SELECT i.* FROM item i  WHERE i.in_archive=true AND (i.last_modified >= ?) AND true ORDER BY i.item_id OFFSET ? LIMIT ?"));
        assertThat(((java.sql.Date)result.getParameters().get(0)).getTime(), is(fromDate(DATE).getTime()));
        assertThat((Integer) result.getParameters().get(1), is(START));
        assertThat((Integer) result.getParameters().get(2), is(LENGTH));
    }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
        }
        parameters.add(offset);
        parameters.add(length);

        try {
            return new DatabaseQuery(contextService.getContext())
                    .withCountQuery(countQuery, countParameters)
                    .withQuery(query)
                    .withParameters(parameters);
        } catch (ContextServiceException e) {
            throw new DatabaseQueryException(e);
View Full Code Here
TOP

Related Classes of org.dspace.xoai.services.api.database.DatabaseQuery

  • org.dspace.xoai.services.impl.database.DSpaceDatabaseQueryResolver
  • org.dspace.xoai.tests.unit.services.impl.database.DSpaceDatabaseQueryResolverTest
    • Copyright © 2018 www.massapicom. 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.