From 23a537ac98066dc3994100548890112aa6e8d8ac Mon Sep 17 00:00:00 2001
From: Boris Kolpackov <boris@codesynthesis.com>
Date: Mon, 14 Jan 2013 16:01:06 +0200
Subject: Add support for MSSQL ROWVERSION

ODB can now use ROWVERSION column as an optimistic concurrency version.
---
 mssql/types/driver.cxx | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)

(limited to 'mssql/types/driver.cxx')

diff --git a/mssql/types/driver.cxx b/mssql/types/driver.cxx
index 6390950..a779079 100644
--- a/mssql/types/driver.cxx
+++ b/mssql/types/driver.cxx
@@ -217,6 +217,32 @@ main (int argc, char* argv[])
         assert (o == *p);
       }
     }
+
+    // Test optimistic concurrency using ROWVERSION.
+    //
+    {
+      rowversion o;
+      o.str = "abc";
+
+      {
+        transaction t (db->begin ());
+        db->persist (o);
+        assert (o.version != 0);
+        t.commit ();
+      }
+
+      {
+        transaction t (db->begin ());
+        auto_ptr<rowversion> p (db->load<rowversion> (o.id_));
+        assert (p->version == o.version);
+        p->str += 'd';
+        db->update (*p);
+        assert (p->version > o.version);
+        db->reload (o);
+        assert (o.version == p->version);
+        t.commit ();
+      }
+    }
   }
   catch (const odb::exception& e)
   {
-- 
cgit v1.1