Opened 14 years ago

Closed 11 years ago

#13742 closed New feature (fixed)

implement savepoints for sqlite3

Reported by: Tay Ray Chuan Owned by: Aymeric Augustin
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords: sqlite3 savepoints nested transactions
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: yes Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

sqlite3 has supported nested transactions/savepoints since sqlite3 3.6.8; support it.

Attachments (1)

0001-implement-savepoints-for-sqlite3.patch​ (4.0 KB) - added by Tay Ray Chuan 14 years ago.

Download all attachments as: .zip

Change History (9)

Changed 14 years ago by Tay Ray Chuan

Attachment: 0001-implement-savepoints-for-sqlite3.patch​ added

comment:1 Changed 13 years ago by Russell Keith-Magee

Triage Stage: Unreviewed → Accepted

comment:2 Changed 13 years ago by Julien Phalip

Severity: → Normal
Type: → New feature

comment:3 Changed 13 years ago by Julien Phalip

Needs tests: set

It'd be great if tests could be written for this. See also #15507 which asks for savepoints support with MySQL.

comment:4 Changed 12 years ago by Aymeric Augustin

UI/UX: unset

Change UI/UX from NULL to False.

comment:5 Changed 12 years ago by Aymeric Augustin

Easy pickings: unset

Change Easy pickings from NULL to False.

comment:6 Changed 11 years ago by Claude Paroz

#15506 was a duplicate with a patch.

comment:7 Changed 11 years ago by Aymeric Augustin

Owner: changed from nobody to Aymeric Augustin
Status: new → assigned

comment:8 Changed 11 years ago by Aymeric Augustin <aymeric.augustin@…>

Resolution: → fixed
Status: assigned → closed

In 14cddf51c5f001bb426ce7f7a83fdc52c8d8aee9:

Merged branch 'database-level-autocommit'.

Fixed #2227: atomic supports nesting.
Fixed #6623: commit_manually is deprecated and atomic doesn't suffer from this defect.
Fixed #8320: the problem wasn't identified, but the legacy transaction management is deprecated.
Fixed #10744: the problem wasn't identified, but the legacy transaction management is deprecated.
Fixed #10813: since autocommit is enabled, it isn't necessary to rollback after errors any more.
Fixed #13742: savepoints are now implemented for SQLite.
Fixed #13870: transaction management in long running processes isn't a problem any more, and it's documented.
Fixed #14970: while it digresses on transaction management, this ticket essentially asks for autocommit on PostgreSQL.
Fixed #15694: atomic supports nesting.
Fixed #17887: autocommit makes it impossible for a connection to stay "idle of transaction".

Note: See TracTickets for help on using tickets.
Back to Top