Python SQLite connection.rollback() Function

The Pythonconnection.rollback function retrieves all changes made in the current transaction and releases any database held by the connection. This function is particularly useful when a transaction fails or an exception is raised.

In SQLite, a connection refers to an active link between the application and database. This connection allows us to execute SQL commands and queries in the database.

The rollback function is used to maintain data integrity . It undergoes all changes made in the current transaction; if an error occurs, then the database remains constant.

Syntax

Following is the syntax for theconnection.rollback() function.

conn.rollback()

Parameters

This function doesn't take any parameters.

Return Value

Thisconnection.rollback() function has no return value.

Example 1

In the below example, we are going to insert employee names into the table usingconnection.rollback function.

cursor.execute("INSERT INTO employees (first_name) VALUES (%s), ()%s", ('John', 'Ben'))conn.rollback()

Output

The result is obtained as follows −

first_name-------------JohnBen

Example 2

Here, we are deleting the row from the database usingconnection.rollback() function.

cursor.execute("DELETE FROM employees WHERE first_name = ?", ('John',))print("Row deleted")print("Transaction rolled back")

Output

The output is obtained as follows −

Row deletedTransaction rolled back