public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Denis Laxalde <[email protected]>
To: [email protected]
Subject: Re: Executing on the connection?
Date: Tue, 8 Dec 2020 06:44:56 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CA+mi_8Yc92bX3qhTqXq4LkGyn5VmQj6uRAcVebpqt398Tm4EJA@mail.gmail.com>
<CA+mi_8Y+fuzZcT+boRwcQKPd58B=bc324MA2=TAd6xuAvfuMmw@mail.gmail.com>
<[email protected]>
On 12/8/20 5:51 AM, Denis Laxalde wrote:
> Daniele Varrazzo a écrit :
>> On Wed, 2 Dec 2020 at 11:20, Daniele Varrazzo
>> <[email protected]> wrote:
>>
>>> I'm toying with the idea of adding a 'connection.execute(query,
>>> [params])' methd, which would basically just create a cursor
>>> internally, query on it, and return it. No parameter could be passed
>>> to the cursor() call, so it could only create the most standard,
>>> client-side cursor (or whatever the default for the connection is, if
>>> there is some form of cursor_factory, which hasn't been implemented in
>>> psycopg3 yet). For anything more fancy, cursor() should be called
>>> explicitly.
>>
>> This is what I've pushed earlier:
>>
>> https://www.psycopg.org/psycopg3/docs/connection.html#psycopg3.Connection.execute
>>
>>
>
> It did not strike me earlier, but it looks a bit weird to have
> connection.execute() return a "cursor" to read results while this
> "cursor" can also be used to execute commands. So, perhaps, another
> object, with only the interface for result retrieval would be more
> appropriate?
Why? It is no different from now where you can reuse a cursor.
>
> Otherwise, that's a very nice addition, thanks!
>
>
--
Adrian Klaver
[email protected]
view thread (13+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Executing on the connection?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox