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

com.couchbase.client.java.query.Query

    // ====================================
    //


    @Test
    public void testSimpleFrom() {
        Query query = new DefaultFromPath(null).from("default");
        assertEquals("FROM default", query.toString());


        query = new DefaultFromPath(null).from("beer-sample").as("b");
        assertEquals("FROM beer-sample AS b", query.toString());
    }

View Full Code Here

        assertEquals("FROM beer-sample AS b", query.toString());
    }


    @Test
    public void testFromWithKeys() {
        Query query = new DefaultFromPath(null)
            .from("beer-sample")
            .as("b")
            .keys("my-brewery");
        assertEquals("FROM beer-sample AS b KEYS [\"my-brewery\"]", query.toString());


        query = new DefaultFromPath(null)
            .from("beer-sample")
            .keys(JsonArray.from("key1", "key2"));
        assertEquals("FROM beer-sample KEYS [\"key1\",\"key2\"]", query.toString());
    }

View Full Code Here

        assertEquals("FROM beer-sample KEYS [\"key1\",\"key2\"]", query.toString());
    }


    @Test
    public void testUnnest() {
        Query query = new DefaultFromPath(null)
            .from("tutorial").as("contact")
            .unnest("contact.children")
            .where(x("contact.fname").eq(s("Dave")));
        assertEquals("FROM tutorial AS contact UNNEST contact.children WHERE contact.fname = \"Dave\"",
            query.toString());


        query = new DefaultFromPath(null)
            .from("default")
            .leftOuterUnnest("foo.bar")
            .leftUnnest("bar.baz")
            .innerUnnest("x.y");
        assertEquals("FROM default LEFT OUTER UNNEST foo.bar LEFT UNNEST bar.baz INNER UNNEST x.y", query.toString());
    }

View Full Code Here

        assertEquals("FROM default LEFT OUTER UNNEST foo.bar LEFT UNNEST bar.baz INNER UNNEST x.y", query.toString());
    }


    @Test
    public void testNest() {
        Query query = new DefaultFromPath(null)
            .from("users_with_orders").as("user")
            .nest("orders_with_users").as("orders");
        assertEquals("FROM users_with_orders AS user NEST orders_with_users AS orders", query.toString());


        query = new DefaultFromPath(null)
            .from("default")
            .leftOuterNest("foo.bar")
            .leftNest("bar.baz")
            .innerNest("x.y");
        assertEquals("FROM default LEFT OUTER NEST foo.bar LEFT NEST bar.baz INNER NEST x.y", query.toString());
    }

View Full Code Here

        assertEquals("FROM default LEFT OUTER NEST foo.bar LEFT NEST bar.baz INNER NEST x.y", query.toString());
    }


    @Test
    public void testNestWithKeys() {
        Query query = new DefaultFromPath(null)
            .from("users_with_orders").as("user")
            .nest("orders_with_users").as("orders")
            .keys(x(JsonArray.from("key1", "key2")));
        assertEquals("FROM users_with_orders AS user NEST orders_with_users AS orders KEYS [\"key1\",\"key2\"]",
            query.toString());
    }

View Full Code Here

    }




    @Test
    public void testJoin() {
        Query query = new DefaultFromPath(null)
            .from("users_with_orders").as("user")
            .join("orders_with_users").as("orders");
        assertEquals("FROM users_with_orders AS user JOIN orders_with_users AS orders", query.toString());


        query = new DefaultFromPath(null)
            .from("default")
            .leftOuterJoin("foo.bar")
            .leftJoin("bar.baz")
            .innerJoin("x.y");
        assertEquals("FROM default LEFT OUTER JOIN foo.bar LEFT JOIN bar.baz INNER JOIN x.y", query.toString());
    }

View Full Code Here

        assertEquals("FROM default LEFT OUTER JOIN foo.bar LEFT JOIN bar.baz INNER JOIN x.y", query.toString());
    }


    @Test
    public void testJoinWithKeys() {
        Query query = new DefaultFromPath(null)
            .from("users_with_orders").as("user")
            .join("orders_with_users").as("orders")
            .keys(x(JsonArray.from("key1", "key2")));
        assertEquals("FROM users_with_orders AS user JOIN orders_with_users AS orders KEYS [\"key1\",\"key2\"]",
            query.toString());
    }

View Full Code Here

 */
public class SelectDslSmokeTest {


    @Test
    public void test1() {
        Query query = select(s("Hello World")
            .as("Greeting"));
        assertEquals("SELECT \"Hello World\" AS Greeting", query.toString());
    }

View Full Code Here

        assertEquals("SELECT \"Hello World\" AS Greeting", query.toString());
    }


    @Test
    public void test2() {
        Query query = select("*")
            .from("tutorial")
            .where(x("fname").eq(s("Ian")));
        assertEquals("SELECT * FROM tutorial WHERE fname = \"Ian\"", query.toString());
    }

View Full Code Here

        assertEquals("SELECT * FROM tutorial WHERE fname = \"Ian\"", query.toString());
    }


    @Test
    public void test3() {
        Query query = select(x("children[0].fname").as("cname"))
            .from("tutorial")
            .where(x("fname").eq(s("Dave")));
        assertEquals("SELECT children[0].fname AS cname FROM tutorial WHERE fname = \"Dave\"", query.toString());
    }

View Full Code Here

0 1 2

TOP

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

com.couchbase.client.java.query.dsl.SelectDslSmokeTest

com.couchbase.client.java.query.dsl.SelectDslTest

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.