It is known that we can update a MongoDB document atomically using the findAndModify method. But how can we do it with a PanacheMongoRepository? The PanacheMongoRepository interface has methods such as find and update, but nothing like findAndModify. Is repository.update(updateDocument).where(queryDocument)…
In spring, we can declare a custom query like this @Query( value = "SELECT * FROM USERS u WHERE u.status = 1", nativeQuery = true) Collection<User> findAllActiveUsersNative(); but in Quarkus I cannot find a reference on how to do this…
I'm working on a project that uses Quarkus with Panache and PostgreSQL, and I'm trying to store JSON data as JSONB in the database. However, when I insert JSON data into the database, it gets escaped, and I'd like to…
In my PostgreSQL table I have a parts column of type json. I want to check if the given argument is contained in my json column. This query works in the database: select * from elements we where parts::text like…