Add support for left and right joins to QueryBuilder.

gk-brown · gk-brown · commit db62367f6809 · 2020-12-18T17:59:31.000-05:00
diff --git a/httprpc-client/src/main/java/org/httprpc/sql/QueryBuilder.java b/httprpc-client/src/main/java/org/httprpc/sql/QueryBuilder.java
@@ -139,6 +139,46 @@ public QueryBuilder join(String table) {
         return this;
     }
 
+    /**
+     * Appends a "left join" clause to a query.
+     *
+     * @param table
+     * The table name.
+     *
+     * @return
+     * The {@link QueryBuilder} instance.
+     */
+    public QueryBuilder leftJoin(String table) {
+        if (table == null) {
+            throw new IllegalArgumentException();
+        }
+
+        sqlBuilder.append(" left join ");
+        sqlBuilder.append(table);
+
+        return this;
+    }
+
+    /**
+     * Appends a "right join" clause to a query.
+     *
+     * @param table
+     * The table name.
+     *
+     * @return
+     * The {@link QueryBuilder} instance.
+     */
+    public QueryBuilder rightJoin(String table) {
+        if (table == null) {
+            throw new IllegalArgumentException();
+        }
+
+        sqlBuilder.append(" right join ");
+        sqlBuilder.append(table);
+
+        return this;
+    }
+
     /**
      * Appends an "on" clause to a query.
      *
diff --git a/httprpc-client/src/test/java/org/httprpc/sql/QueryBuilderTest.java b/httprpc-client/src/test/java/org/httprpc/sql/QueryBuilderTest.java
@@ -24,13 +24,15 @@ public void testSelect() {
         String sql = QueryBuilder.select("a", "b", "c")
             .from("A")
             .join("B").on("A.id = B.id and x = 50")
-            .join("C").on("B.id = C.id")
+            .leftJoin("C").on("B.id = C.id")
+            .rightJoin("D").on("C.id = D.id")
             .where("(a > 10 or b < 200) and c = :c")
             .orderBy("a", "b").toString();
 
         assertEquals("select a, b, c from A "
             + "join B on A.id = B.id and x = 50 "
-            + "join C on B.id = C.id "
+            + "left join C on B.id = C.id "
+            + "right join D on C.id = D.id "
             + "where (a > 10 or b < 200) and c = :c "
             + "order by a, b", sql);
     }
