MIME-Version: 1.0
Date: Wed, 13 Oct 2021 20:40:07 +0200
From: Paolo De Stefani <paolo@paolodestefani.it>
To: Daniele Varrazzo <daniele.varrazzo@gmail.com>
Cc: Psycopg <psycopg@postgresql.org>
Subject: Re: psycopg3 transactions
In-Reply-To: 
 <CA+mi_8Z2FT4bHN1yTiM=aS8BXkbiZLwP=KLasXGQPgBRoDPrMg@mail.gmail.com>
References: <eb5cc5d20c520e32b5963a4044b70af1@paolodestefani.it>
 <CA+mi_8bXjHTrzDLQ+n_6K2MHVsr0J32X1HA28Ey9O+-Zm6JaeQ@mail.gmail.com>
 <9a99d2d110b121542d1ea0a05066858b@paolodestefani.it>
 <CA+mi_8afF2jMifiLSvL99+Ztupy1me7xDNAv0g47WxHWbwN9vw@mail.gmail.com>
 <6683df3e65fe961aa478e61db7ad687d@paolodestefani.it>
 <CA+mi_8Z2FT4bHN1yTiM=aS8BXkbiZLwP=KLasXGQPgBRoDPrMg@mail.gmail.com>
User-Agent: Roundcube Webmail/1.4.11
Message-ID: <debfe686f16f1e5c57a3aec7db8d4c33@paolodestefani.it>
Content-Type: text/plain; charset=US-ASCII;
 format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/debfe686f16f1e5c57a3aec7db8d4c33%40paolodestefani.it>
Precedence: bulk

Il 13/10/2021 15:46 Daniele Varrazzo ha scritto:
> On Wed, 13 Oct 2021 at 15:21, Paolo De Stefani 
> <paolo@paolodestefani.it> wrote:
> 
>> I was used to wrote a "with con.cursor() as cur:" that now i hato to
>> replace with:
>> 
>> with con.transaction():
>>      with con.cursor() as cur:
>>          cur.execute("ANY SQL STATEMENT")
>> 
>> and everything works as expected (or i expect...)
> 
> You can even write:
> 
>     with con.transaction():
>         con.execute("ANY SQL STATEMENT")
> 
> But is it even useful to wrap a transaction around any single
> statement? I still think you'd be better off with an autocommit
> connection.

In my small application i use only one connection (per client). I manage 
the customer orders of a food stand. The orders have header and lines. 
In that case i do a commit only after insert/update of the 2 table's 
records so i can not use an autocommit connection.

But what i wrote before and your suggestion are just fine for my needs, 
thanks


-- 
Paolo De Stefani