Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://www.tutorialspoint.com/python/python_sqlite3_connection_rollback_function.htm below:

Python SQLite connection.rollback() Function

The Python connection.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.

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

conn.rollback()

This function doesn't take any parameters.

This connection.rollback() function has no return value.

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

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

The result is obtained as follows −

first_name
-------------
John
Ben

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

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

The output is obtained as follows −

Row deleted
Transaction rolled back

python_modules.htm

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4