Package com.couchbase.client.java.query

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

64
65
66
67
68
69
70
71
72
        assertEquals("SELECT children[0].fname AS cname FROM tutorial WHERE fname = \"Dave\"", query.toString());
    }

    @Test
    public void test4() {
        Query query = select(meta().as("meta"))
            .from("tutorial");
        assertEquals("SELECT META() AS meta FROM tutorial", query.toString());
    }
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
        assertEquals("SELECT META() AS meta FROM tutorial", query.toString());
    }

    @Test
    public void test5() {
        Query query = select(x("fname"), x("age"), x("age/7").as("age_dog_years"))
            .from("tutorial")
            .where(x("fname").eq(s("Dave")));
        assertEquals("SELECT fname, age, age/7 AS age_dog_years FROM tutorial WHERE fname = \"Dave\"",
            query.toString());
    }
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
            query.toString());
    }

    @Test
    public void test6() {
        Query query = select(x("fname"), x("age"), round(x("age/7")).as("age_dog_years"))
            .from("tutorial")
            .where(x("fname").eq(s("Dave")));
        assertEquals("SELECT fname, age, ROUND(age/7) AS age_dog_years FROM tutorial WHERE fname = \"Dave\"",
            query.toString());
    }
View Full Code Here
89
90
91
92
93
94
95
96
97
            query.toString());
    }

    @Test
    public void test7() {
        Query query = select(x("fname").concat(s(" ")).concat(x("lname")).as("full_name"))
            .from("tutorial");
        assertEquals("SELECT fname || \" \" || lname AS full_name FROM tutorial", query.toString());
    }
View Full Code Here
96
97
98
99
100
101
102
103
104
105
        assertEquals("SELECT fname || \" \" || lname AS full_name FROM tutorial", query.toString());
    }

    @Test
    public void test8() {
        Query query = select("fname", "age")
            .from("tutorial")
            .where(x("age").gt(x("30")));
        assertEquals("SELECT fname, age FROM tutorial WHERE age > 30", query.toString());
    }
View Full Code Here
104
105
106
107
108
109
110
111
112
113
        assertEquals("SELECT fname, age FROM tutorial WHERE age > 30", query.toString());
    }

    @Test
    public void test9() {
        Query query = select("fname", "email")
            .from("tutorial")
            .where(x("email").like(s("%@yahoo.com")));
        assertEquals("SELECT fname, email FROM tutorial WHERE email LIKE \"%@yahoo.com\"", query.toString());
    }
View Full Code Here
112
113
114
115
116
117
118
119
120
        assertEquals("SELECT fname, email FROM tutorial WHERE email LIKE \"%@yahoo.com\"", query.toString());
    }

    @Test
    public void test10() {
        Query query = selectDistinct("orderlines[0].productId")
            .from("orders");
        assertEquals("SELECT DISTINCT orderlines[0].productId FROM orders", query.toString());
    }
View Full Code Here
119
120
121
122
123
124
125
126
127
128
        assertEquals("SELECT DISTINCT orderlines[0].productId FROM orders", query.toString());
    }

    @Test
    public void test11() {
        Query query = select("fname", "children")
            .from("tutorial")
            .where(x("children").is(NULL()));
        assertEquals("SELECT fname, children FROM tutorial WHERE children IS NULL", query.toString());
    }
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
        assertEquals("SELECT fname, children FROM tutorial WHERE children IS NULL", query.toString());
    }

    @Test
    public void test12() {
        Query query = select("fname", "children")
            .from("tutorial")
            .where(x("ANY child IN tutorial.children SATISFIES child.age > 10 END"));
        assertEquals("SELECT fname, children FROM tutorial WHERE ANY child IN tutorial.children " +
            "SATISFIES child.age > 10 END", query.toString());
    }
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
            "SATISFIES child.age > 10 END", query.toString());
    }

    @Test
    public void test13() {
        Query query = select("fname", "email", "children")
            .from("tutorial")
            .where(length(x("children")).gt(x("0")).and(x("email")).like(s("%@gmail.com")));
        assertEquals("SELECT fname, email, children FROM tutorial WHERE LENGTH(children) > 0 AND email" +
            " LIKE \"%@gmail.com\"", 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.