Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:122278
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.700.6\))
Message-ID: <325E790F-5E88-4559-862F-6C4ACBC89779@sakiot.com>
Date: Mon, 5 Feb 2024 09:32:39 +0900
To: PHP internals <internals@lists.php.net>
Subject: [Proposal] Add `savepoint()` method to PDO
From: saki@sakiot.com (Saki Takamachi)

Hi internals,

I'm thinking of adding a `savepoint(string $name)` method to PDO. =
Similarly, add `releaseSavepoint(string $name)` and change the signature =
of `rollback()` to `rollback(?string $name =3D null)`.

Savepoint is a feature defined in SQL99, so it is a feature supported by =
many databases. Therefore, I thought it would be a good idea to support =
this with PDO.

If we use `savepoint()` before a transaction has started, it is expected =
that a `PDOException` will be thrown. Similarly, if we use =
`releaseSavepoint()` or `rollback('savepoint_name=E2=80=99)` when there =
is no savepoint, an exception will be thrown.

Only pdo_odbc cannot predict what kind of database will be used, but in =
the odbc3 API, we can use `supportsSavepoints()` to find out whether the =
database supports savepoints.

FYI, mysqli already has support for savepoints.

I would like to know your opinion.

Regard.

Saki=