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

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

Python sqlite3 Module

The Python sqlite3 module is an SQL interface, this module acts lightweight, self-contained and server less database. SQLite is determined for applications, file-based storage and this is also useful for medium-sized databases.

In this function once the connection is established then we can create a cursor object which acts as a bridge between our python code and the database, this enables the code to execute SQL commands and retrieves data.

Following are the sqlite3 functions, which can be worked with SQLite database from out Python program.

sqlite3.connect()

This API function opens a connection to the SQLite database file. If database is opened successfully, this returns a connection object.

connection.cursor()

This creates a cursor which is used for database programming with Python. This function accepts a single optional parameter cursorClass.

cursor.execute()

This executes an SQL statements which can be parameterized i.e., placeholders instead of SQL literals.

connection.execute()

This executes the cursor object and it creates an intermediate cursor object by calling the cursor method.

connection.executemany()

This function executes an SQL command against all parameter sequences or mappings in the sql sequence.

connection.executemany()

This is a shortcut that creates an intermediate cursor object by calling the cursor method with the parameters.

cursor.executescript()

This function executes the multiple statements in the form of scripts.

connection.excutescript()

This is the shortcut that creates an intermediate cursor object by calling the cursor method.

connection.commit()

It returns the total number of database rows that have been modified, inserted, or deleted.

connection.total_changes()

This function returns the current transaction until the last call to commit() is not visible from the other database.

connection.rollback()

This function rolls back any changes to the database from the last call to commit().

connection.close()

This function closes the database connection and doesn't call commit() function to close the database connection.

cursor.fetchone()

This functions fetches the next row of a query that results a single sequence, or None when no more data is available.

cursor.fetchmany()

This function fetches the next set of rows of a query that returns a list. A list is returned when no rows are available.

cursor.fetchall()

This function fetches all rows of a query that returns a list.

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