Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkUuK-0001dz-US for psycopg@arkaria.postgresql.org; Wed, 02 Dec 2020 16:23:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kkUuJ-00055X-U8 for psycopg@arkaria.postgresql.org; Wed, 02 Dec 2020 16:23:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkUuJ-00055P-ND; Wed, 02 Dec 2020 16:23:07 +0000 Received: from mout.gmx.net ([212.227.17.21]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkUuH-0003wL-OU; Wed, 02 Dec 2020 16:23:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1606926183; bh=v7FPas85z1c68MA6n2aroSaS4gG0nwB9k+DxZdnALX0=; h=X-UI-Sender-Class:Date:From:To:Subject:References:In-Reply-To; b=fNjMZ68bpNtSPuz2NRExhwdEdJpa8kiF5m51uzy0ogMIL+bisbwlU2Axnpa8+Vwf8 7Qbcg3PhS0IAH81nQ0XDIszctF7jhr7A7ZzzSEd/CE4fLU8oaVmdzBJdbiE9TZT28B QGjQfT2FeCC7jIkMpDEKqLtVSOs2PD3OWhe6pQX8= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from hermes ([78.54.52.180]) by mail.gmx.com (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MJE27-1kUKXE1ohX-00KeZg; Wed, 02 Dec 2020 17:23:03 +0100 Received: from ncq by hermes with local (Exim 4.94) (envelope-from ) id 1kkUuD-0006O7-Vg; Wed, 02 Dec 2020 17:23:02 +0100 Date: Wed, 2 Dec 2020 17:23:01 +0100 From: Karsten Hilbert To: psycopg@lists.postgresql.org, psycopg@postgresql.org Subject: Re: Executing on the connection? Message-ID: Mail-Followup-To: psycopg@lists.postgresql.org, psycopg@postgresql.org References: <0616EEA0-1551-40C7-BB2A-A0500FE0518C@thebuild.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <0616EEA0-1551-40C7-BB2A-A0500FE0518C@thebuild.com> Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:CHMf+7thfnmi3ngMa/5FE0FWtw9svMCiO6QMbVU3L+aJV+Kz+X4 FT57SvTHfAkN+FJXECvb6Px3ywUnK2ZK/NNRY0nc6ayUsyZXqXqm+5doTjjcicWBdTLqGIr npUQm6Eu624V6mDiEV3N2p59iUvsEGAzDDo5fcZGRe/5mkEkj6c4kW3KNAYS+3wZ+DGjqgE ttoMETB6b8cuZWzZuO/lQ== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:rFYOp1WTVQk=:rvwY1ZyYoV+/tpH+HMZP+G z3cYOGTsYFkLORwnK+yrr0XNrcIDSPPubw4K5XeQy5B6Bh4d6MQSQ7XQvkPpwN9aNplPFIHjy tGPk0YNbZ6UC4tkJ5JZwP2TXPk9aJvTIkw2pV52BiE6dX9pJmxc57gDsr4fzVygyYV347DU47 I0H23gMhfQlu1PDnSCctRFhfrw4oRH4DcO5vbM2a68PNe2VBszXJ0TjKGa2IvNrjuf9Cgjd7P GnUBHnr7J4icQU/a1NWAUJoq+K7Tahirk8u7Hb3uKvYtHSNPJWUZKiLfSUJ5L/gr+Ctj8UCG0 4sZLu9F5q9uTOw343kZ1+VIiXxCOSNlBm2hsjF4DPTKzkokfJrQztDY618G8liADWMq1OPtwh g/IFRGfmpC4rWdau1boZiDrsTDpwGshH1Q1zIfuE9fqQrJ6Orzmnu+zSh4f2CYCqAzJRhTfam e9N4dm6yRGDi/nhbsAAQ/vPXwqKZ9RIYFaoE/qS7GHRqTzjVGXdoKDgw2URUGhIDNVjdYf3RW emPWkNb8piG4PvVZj6DOJluvWh2Q0vNt3mAdWV5HCVFdzIDd/k0danu5EzcRK3PLKCWYqwmz3 9TzlALgTKQ8Mgd7hGoxk1IB2CZw7rurVCTf91bLOq5/uZ8pVeowsr5H0MtDLAETG1pIWcGGj5 dmpAa35ioizzYMbhBze8bNc2K1toIA1PYQs3WXZf64XyzHrd8cAkHTNnLzGaNoQ6RfAxvM3BH 39iD/R9VlAlQXOLZYnVefDesi0w/OEw8LHv5cEquQjnfXobgR885qgA5xUXHnKFxKKEa7z7zJ 1IUcBGWpLYuARnydro0sfd/ZEaS0kwLRjs1kWaIk/hDK4oGQ59qFNk6HL2+LPr1q4rZfc2UVz DK0xTw29HWBOKYQciW6g== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk > > One little change I've made to psycopg3 cursors is to make it return > > "self" on execute() (it currently returns None, so it's totally > > unused). +1 > > As a result people could use: > > > > conn =3D psycopg3.connect(dsn) > > record =3D conn.execute(query, params).fetchone() > > # or > > for record in conn.execute(query, params): > > ... # do something +1 Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B