For Java Driver 4.6, is it possible to use the DAO interface to append or prepend to a collection column (ie, a SET or a LIST), rather than overwriting it?
I understand that I can just write a custom query using @Query annotation and writing out the whole query, but it would be nice to just keep all the defaults that a @Update method would do, besides for this one list that I want to append to.
My table (podcasts) has a column (found_by_queries) definition that looks like this:
CREATE TABLE podcasts ( ... found_by_queries LIST<frozen<search_query>> ... )
`search_query` is a UDT if it makes a difference:
CREATE TYPE search_query (term TEXT, search_type TEXT, external_api TEXT, updated_at TIMESTAMP);
And the DAO definition is pretty standard:
@Update void save(Podcast podcast);
Currently calling `save` seems to overwrite my `found_by_queries` list rather than append. Is there a way to append or prepend instead?
Thanks!