@Test(groups = "unit") public void should_handle_from_json() throws Exception { assertThat( update("users") .with(set("age", fromJson("42"))) .where(eq("id", fromJson("\"user123\""))) .toString()) .isEqualTo("UPDATE users SET age=fromJson('42') WHERE id=fromJson('\"user123\"');"); assertThat( insertInto("users") .value("id", fromJson("\"user123\"")) .value("age", fromJson("42")) .toString()) .isEqualTo("INSERT INTO users (id,age) VALUES (fromJson('\"user123\"'),fromJson('42'));"); assertThat(insertInto("users").value("id", fromJson(bindMarker())).toString()) .isEqualTo("INSERT INTO users (id) VALUES (fromJson(?));"); assertThat(insertInto("users").value("id", fromJson(bindMarker("id"))).toString()) .isEqualTo("INSERT INTO users (id) VALUES (fromJson(:id));"); }
@Test(groups = "unit") public void should_handle_from_json() throws Exception { assertThat( update("users") .with(set("age", fromJson("42"))) .where(eq("id", fromJson("\"user123\""))) .toString()) .isEqualTo("UPDATE users SET age=fromJson('42') WHERE id=fromJson('\"user123\"');"); assertThat( insertInto("users") .value("id", fromJson("\"user123\"")) .value("age", fromJson("42")) .toString()) .isEqualTo("INSERT INTO users (id,age) VALUES (fromJson('\"user123\"'),fromJson('42'));"); assertThat(insertInto("users").value("id", fromJson(bindMarker())).toString()) .isEqualTo("INSERT INTO users (id) VALUES (fromJson(?));"); assertThat(insertInto("users").value("id", fromJson(bindMarker("id"))).toString()) .isEqualTo("INSERT INTO users (id) VALUES (fromJson(:id));"); }