Package com.google.appengine.api.datastore

Examples of com.google.appengine.api.datastore.Query.addProjection()

80
81
82
83
84
85
86
87
88
89
90
        Projection pp = new PropertyProjection("stringData", String.class);
        assertEquals("stringData", pp.getName());
        query.addProjection(pp);
        assertEquals(1, query.getProjections().size());
        pp = new PropertyProjection("intData", Integer.class);
        query.addProjection(pp);
        for (Projection p : query.getProjections()) {
            String pName = p.getName();
            assertTrue(pName.endsWith("stringData") || pName.endsWith("intData"));
        }
    }
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
    }

    @Test
    public void testBasicQuery() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringData", String.class));
        query.addProjection(new PropertyProjection("intData", Integer.class));
        String sql = "SELECT intData, stringData FROM " + kindName + " WHERE __ancestor__ is " + rootKey;
        assertEquals(sql.toLowerCase(), query.toString().toLowerCase());
        List<Entity> results = service.prepare(query).asList(fetchOption);
        assertEquals(count, results.size());
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
    @Test
    public void testBasicQuery() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringData", String.class));
        query.addProjection(new PropertyProjection("intData", Integer.class));
        String sql = "SELECT intData, stringData FROM " + kindName + " WHERE __ancestor__ is " + rootKey;
        assertEquals(sql.toLowerCase(), query.toString().toLowerCase());
        List<Entity> results = service.prepare(query).asList(fetchOption);
        assertEquals(count, results.size());
        for (Entity e : results) {
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
    }

    @Test
    public void testListQuery() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringList", String.class));
        query.addProjection(new PropertyProjection("intList", Integer.class));
        List<Entity> results = service.prepare(query).asList(fetchOption);
        // Distinct stringList data 2 * Distinct intList data 3 * entity's count 10
        assertEquals(60, results.size());
        Entity e = results.get(0);
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
    @Test
    public void testListQuery() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringList", String.class));
        query.addProjection(new PropertyProjection("intList", Integer.class));
        List<Entity> results = service.prepare(query).asList(fetchOption);
        // Distinct stringList data 2 * Distinct intList data 3 * entity's count 10
        assertEquals(60, results.size());
        Entity e = results.get(0);
        assertEquals(2, e.getProperties().size());
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
    }

    @Test
    public void testQueryOrder() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("intData", Integer.class));
        query.addSort("stringData", Query.SortDirection.DESCENDING);
        List<Entity> results = service.prepare(query).asList(fetchOption);
        assertEquals(count, results.size());
        int first = new Integer(results.get(0).getProperty("intData").toString());
        int last = new Integer(results.get(count - 1).getProperty("intData").toString());
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
    }

    @Test
    public void testQueryFilter() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringData", String.class));
        query.setFilter(new FilterPredicate("intData", FilterOperator.NOT_EQUAL, 50));
        query.addSort("intData");
        List<Entity> results = service.prepare(query).asList(fetchOption);
        assertEquals(count - 1, results.size());
        for (Entity e : results) {
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
    }

    @Test(expected = IllegalArgumentException.class)
    public void testWrongType() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringData", Integer.class));
        service.prepare(query).asIterator(fetchOption).next();
    }

    @Test
    public void testLimit() {
View Full Code Here
182
183
184
185
186
187
188
189
190
191
192
    }

    @Test
    public void testCount() {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection("stringData", String.class));
        assertEquals(count, service.prepare(query).countEntities(fetchOption));
    }

    private void checkQueryType(String property, Class<?> type) {
        Query query = new Query(kindName, rootKey);
View Full Code Here
188
189
190
191
192
193
194
195
196
197
198
        assertEquals(count, service.prepare(query).countEntities(fetchOption));
    }

    private void checkQueryType(String property, Class<?> type) {
        Query query = new Query(kindName, rootKey);
        query.addProjection(new PropertyProjection(property, type));
        String sql = "SELECT " + property + " FROM " + kindName + " WHERE __ancestor__ is " + rootKey;
        assertEquals(sql.toLowerCase(), query.toString().toLowerCase());
        List<Entity> results = service.prepare(query).asList(fetchOption);
        for (Entity e : results) {
            assertEquals(1, e.getProperties().size());
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.