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

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

Python SQLite connection.total_changes() Function

The Python connection.total_changes function returns the cumulative number of changes made to the database from the specific connection.

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

The total_changes attribute represents the total number of rows that have been modified since the connection was opened. This function is useful for tracking changes in the database.

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

conn.total_changes()

This function returns an integer that represents the cumulative number of rows.

In the below example, we will insert three rows into the table using the connection.table_changes() function will return the total number of rows inserted.

import sqlite3
conn = sqlite3.connect(':memory:')
conn.execute('CREATE TABLE test(id INTEGER)')
conn.execute('INSERT INTO test(id) VALUES (1), (2), (3)')
print(conn.total_changes)

The executed output is as follows −

3

We are inserting two rows and updating one row in the database. The connection.total_changes() function will give the output as the total number of changes made in the database.

import sqlite3
conn = sqlite3.connect(':memory:')
conn.execute('CREATE TABLE test (id INTEGER, value TEXT)')
conn.execute('INSERT INTO test (id, value) VALUES (1, "A"), (2, "B")')
conn.execute('UPDATE test SET value = "C" WHERE id = 1')
print(conn.total_changes)

The result is obtained as follows −

3

We are inserting and deleting the values from the database using the connection.total_changes() function.

import sqlite3
conn = sqlite3.connect(':memory:')
conn.execute('CREATE TABLE test (id INTEGER)')
conn.execute('INSERT INTO test (id) VALUES (1)')
conn.execute('DELETE FROM test WHERE id = 1')
print(conn.total_changes)

We will get the output as follows −

2

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