rogerbinns / apsw

Another Python SQLite wrapper
https://rogerbinns.github.io/apsw/
Other
733 stars 97 forks source link

BEGIN/END becomes BEGIN/COMMIT #454

Closed raffaem closed 1 year ago

raffaem commented 1 year ago

The Tips section of the docs says:ù that we can use BEGIN/END to set transaction boundary, but the provided example uses BEGIN/COMMIT, not BEGIN/END:

You can use BEGIN/END to set the transaction boundary:

# this will be one transaction
db.execute("BEGIN")
db.execute("INSERT ...")
db.execute("INSERT ...")
db.execute("INSERT ...")
db.execute("COMMIT")
rogerbinns commented 1 year ago

Thanks for spotting this. Technically END is a synonym for COMMIT and can be followed by an optional TRANSACTION. But the help text should be clear and unambiguous so I will only use COMMIT.