sqlite cursor class

The cursor class in sqlite3 python module provides methods to execute one or more SQL statements and to fetch query results of specified count

Classes Updated 25 Jan 2017 1 min read

Overview

Generally a database cursor enables iterating over a recordset.

With the execute() method of the cursor class from sqlite3 module it is not just retrieval of data but any SQL command to

  • create a table
  • insert rows
  • delete rows
  • update rows
  • query rows
  • execute other database operations

can be run on a SQLite database through the cursor object.

Sqlite3 module through the class Cursor provides several methods for executing various SQL commands and DB operations.

List of methods provided by Cursor class of Sqlite3 module

Method NameDescription
execute(sqlStatement, [parameters])Executes an SQL statement on the SQLite database
executemany(sqlStatement, [parameters])Executes an SQL statement on the SQLite database. The statement is executed ‘n’ number of times once for each parameter specified in the parameters
executescript(sqlScript)Executes a SQL script. This is a non-standard way.
fetchmany(numRows=cursor.arraysize)From a SQL query result, fetches the next set of rows as specified by the parameter numRows. The results are returned as python list object.
fetchall()From a SQL query result, fetches all the rows. The results are returned as python list object.
close()Closes the cursor object. Python will raise a ProgrammingError exception if any further operation is attempted on a closed cursor.