Re: [psycopg] Nested transactions support for code composability - Mailing list psycopg

From Christophe Pettus
Subject Re: [psycopg] Nested transactions support for code composability
Date
Msg-id 2C0DAD9D-A5AF-4E66-9A79-6DD5C49F7657@thebuild.com
Whole thread Raw
In response to [psycopg] Nested transactions support for code composability  (Daniel Fortunov <psycopg-list@danielfortunov.com>)
Responses Re: [psycopg] Nested transactions support for code composability  (Daniel Fortunov <psycopg-list@danielfortunov.com>)
List psycopg
> On Jan 16, 2017, at 15:26, Daniel Fortunov <psycopg-list@danielfortunov.com> wrote:
>
> I'd like to implement support for nested transactions in psycopg2 using a context manager that internally uses
postgressavepoints to implement the ability to nest transactions within each other, with sensible commit and rollback
semantics.

You can see two existing examples of this, based on Django.  Django implements the @atomic() decorator, which was based
onmy @xact() decorator: 

    https://github.com/Xof/xact

They can almost certainly be eased out of the Django infrastructure easily enough!

--
-- Christophe Pettus
   xof@thebuild.com



psycopg by date:

Previous
From: Daniel Fortunov
Date:
Subject: [psycopg] Nested transactions support for code composability
Next
From: Wes McKinney
Date:
Subject: Re: [psycopg] Turbo ODBC