Basically we need all of our queries to have WITH UR at the end. Looking up the documentation we were thinking that setting the transaction level to Uncommitted would be equivalent. Rather than hard coding or changing the gem to add the WITH UR to our queries.
On Wednesday, February 10, 2016 at 10:56:45 AM UTC-5, Jeremy Evans wrote: > > On Wednesday, February 10, 2016 at 7:44:19 AM UTC-8, Jonathan Greene wrote: >> >> So I am trying to determine if I set the transaction level to uncommitted >> read. Does this send the queries over to the database the same way as a >> select statement (With UR) at the end? >> >> DB.transaction(:isolation => :uncommitted) do # BEGIN >> # SET TRANSACTION ISOLATION LEVEL UNCOMMITTED >> DB[:foo].insert(1) # INSERTend # COMMIT >> >> >> > I'm not sure I understand the question. Using the :isolation option just > sends a statement to the database setting the transaction level. All other > statements are sent the same way they would be sent normally. Now, the > database may handle the statements differently depending on the isolation > level in use, but that's up to the database. > > Thanks, > Jeremy > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
