Have you tried this?
I did. The problem is that I need to control from my application when to
commit. So I guess I would need to work with the object in memory, push
all the CRUD operations into an array, and execute them all within one
transaction block. That means all operations are rolled back if one of
them fails. Or am I wrong?
Basically my users want to have all the INSERT, UPDATE, DELETE
statements executed by the database, so they immediately know when one
operation failed,eg due to constraints violations, and to control when
to issue a COMMIT.
Is there a way or workaround to do this in rails ? So far the only
statement I found that does an UPDATE without issuing a COMMIT when I
is update_all and even that only works when I explicitely pass (name,
value) pairs for the properties I want to update.