Package com.couchbase.client.java.query

Examples of com.couchbase.client.java.query.Query

145
146
147
148
149
150
151
152
153
154
            " LIKE \"%@gmail.com\"", query.toString());
    }

    @Test
    public void test14() {
        Query query = select("fname", "email")
            .from("tutorial")
            .keys(x(JsonArray.from("dave", "ian")));
        assertEquals("SELECT fname, email FROM tutorial KEYS [\"dave\",\"ian\"]", query.toString());
    }
View Full Code Here
153
154
155
156
157
158
159
160
161
162
        assertEquals("SELECT fname, email FROM tutorial KEYS [\"dave\",\"ian\"]", query.toString());
    }

    @Test
    public void test15() {
        Query query = select("children[0:2]")
            .from("tutorial")
            .where(x("children[0:2] IS NOT MISSING"));
        assertEquals("SELECT children[0:2] FROM tutorial WHERE children[0:2] IS NOT MISSING", query.toString());
    }
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
    // ====================================
    //

    @Test
    public void testSelect() {
        Query query = new DefaultSelectPath(null).select(x("firstname"), x("lastname"));
        assertEquals("SELECT firstname, lastname", query.toString());

        query = new DefaultSelectPath(null).selectAll(x("firstname"));
        assertEquals("SELECT ALL firstname", query.toString());
    }
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
        assertEquals("SELECT ALL firstname", query.toString());
    }

    @Test
    public void testSelectWithUnion() {
        Query query = new DefaultSelectPath(null)
            .select(x("firstname"), x("lastname"))
            .union()
            .select(x("a"), x("b"));
        assertEquals("SELECT firstname, lastname UNION SELECT a, b", query.toString());
    }
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
        assertEquals("SELECT firstname, lastname UNION SELECT a, b", query.toString());
    }

    @Test
    public void testOrderBy() {
        Query query = new DefaultOrderByPath(null).orderBy(Sort.asc("firstname"));
        assertEquals("ORDER BY firstname ASC", query.toString());

        query = new DefaultOrderByPath(null).orderBy(Sort.asc("firstname"), Sort.desc("lastname"));
        assertEquals("ORDER BY firstname ASC, lastname DESC", query.toString());
    }
View Full Code Here
142
143
144
145
146
147
148
149
        assertEquals("ORDER BY firstname ASC, lastname DESC", query.toString());
    }

    @Test
    public void testOrderByWithLimit() {
        Query query = new DefaultOrderByPath(null).orderBy(Sort.asc("firstname")).limit(5);
        assertEquals("ORDER BY firstname ASC LIMIT 5", query.toString());
    }
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
        assertEquals("ORDER BY firstname ASC LIMIT 5", query.toString());
    }

    @Test
    public void testOrderByWithLimitAndOffset() {
        Query query = new DefaultOrderByPath(null)
            .orderBy(Sort.asc("firstname"), Sort.desc("lastname"))
            .limit(5)
            .offset(10);
        assertEquals("ORDER BY firstname ASC, lastname DESC LIMIT 5 OFFSET 10", query.toString());
    }
View Full Code Here
157
158
159
160
161
162
163
164
165
166
        assertEquals("ORDER BY firstname ASC, lastname DESC LIMIT 5 OFFSET 10", query.toString());
    }

    @Test
    public void testOrderByWithOffset() {
        Query query = new DefaultOrderByPath(null)
            .orderBy(Sort.asc("firstname"), Sort.desc("lastname"))
            .offset(3);
        assertEquals("ORDER BY firstname ASC, lastname DESC OFFSET 3", query.toString());
    }
View Full Code Here
165
166
167
168
169
170
171
172
        assertEquals("ORDER BY firstname ASC, lastname DESC OFFSET 3", query.toString());
    }

    @Test
    public void testOffset() {
        Query query = new DefaultOffsetPath(null).offset(3);
        assertEquals("OFFSET 3", query.toString());
    }
View Full Code Here
171
172
173
174
175
176
177
178
        assertEquals("OFFSET 3", query.toString());
    }

    @Test
    public void testLimitWithOffset() {
        Query query = new DefaultLimitPath(null).limit(4).offset(3);
        assertEquals("LIMIT 4 OFFSET 3", query.toString());
    }
View Full Code Here
TOP

Related Classes of com.couchbase.client.java.query.Query

  • com.couchbase.client.java.query.dsl.SelectDslSmokeTest
  • com.couchbase.client.java.query.dsl.SelectDslTest
    • 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.