@Test(groups = "short") public void should_delete_set_element() throws Exception { // given session().execute("INSERT INTO test_coll (k, c) VALUES (1, {'foo','bar','qix'})"); // when BuiltStatement statement = delete().setElt("c", "foo").from("test_coll").where(eq("k", 1)); session().execute(statement); // then Set<String> actual = session().execute("SELECT c FROM test_coll WHERE k = 1").one().getSet("c", String.class); assertThat(actual).containsOnly("bar", "qix"); }
@Test(groups = "short") public void should_delete_set_element_with_bind_marker() throws Exception { // given session().execute("INSERT INTO test_coll (k, c) VALUES (1, {'foo','bar','qix'})"); // when BuiltStatement statement = delete().setElt("c", bindMarker()).from("test_coll").where(eq("k", 1)); PreparedStatement ps = session().prepare(statement); session().execute(ps.bind("foo")); // then Set<String> actual = session().execute("SELECT c FROM test_coll WHERE k = 1").one().getSet("c", String.class); assertThat(actual).containsOnly("bar", "qix"); }
@Test(groups = "short") public void should_delete_set_element() throws Exception { // given session().execute("INSERT INTO test_coll (k, c) VALUES (1, {'foo','bar','qix'})"); // when BuiltStatement statement = delete().setElt("c", "foo").from("test_coll").where(eq("k", 1)); session().execute(statement); // then Set<String> actual = session().execute("SELECT c FROM test_coll WHERE k = 1").one().getSet("c", String.class); assertThat(actual).containsOnly("bar", "qix"); }
@Test(groups = "short") public void should_delete_set_element_with_bind_marker() throws Exception { // given session().execute("INSERT INTO test_coll (k, c) VALUES (1, {'foo','bar','qix'})"); // when BuiltStatement statement = delete().setElt("c", bindMarker()).from("test_coll").where(eq("k", 1)); PreparedStatement ps = session().prepare(statement); session().execute(ps.bind("foo")); // then Set<String> actual = session().execute("SELECT c FROM test_coll WHERE k = 1").one().getSet("c", String.class); assertThat(actual).containsOnly("bar", "qix"); }