Python SQLite-カーソルオブジェクト

sqlite3.Cursorクラスは、SQLiteステートメントを実行し、クエリの結果セットからデータを取得するメソッドを呼び出すことができるインスタンスです。 Cursorオブジェクトは、Connectionオブジェクト/クラスのcursor（）メソッドを使用して作成できます。

例

import sqlite3
#Connecting to sqlite
conn = sqlite3.connect('example.db')

#Creating a cursor object using the cursor() method
cursor = conn.cursor()

以下は、Cursorクラス/オブジェクトによって提供されるさまざまなメソッドです。

Method	Description
execute()	This routine executes an SQL statement. The SQL statement may be parameterized (i.e., placeholders instead of SQL literals). The psycopg2 module supports placeholder using %s sign たとえば、cursor.execute（ "insert into people values（％s、％s）"、（who、age））
executemany()	This routine executes an SQL command against all parameter sequences or mappings found in the sequence sql.
fetchone()	This method fetches the next row of a query result set, returning a single sequence, or None when no more data is available.
fetchmany()	This routine fetches the next set of rows of a query result, returning a list. An empty list is returned when no more rows are available. The method tries to fetch as many rows as indicated by the size parameter.
fetchall()	This routine fetches all (remaining) rows of a query result, returning a list. An empty list is returned when no rows are available.

以下は、カーソルクラスのプロパティです-

Method	Description
arraySize	This is a read/write property you can set the number of rows returned by the fetchmany() method.
description	This is a read only property which returns the list containing the description of columns in a result-set.
lastrowid	This is a read only property, if there are any auto-incremented columns in the table, this returns the value generated for that column in the last INSERT or, UPDATE operation.
rowcount	This returns the number of rows returned/updated in case of SELECT and UPDATE operations.
connection	This read-only attribute provides the SQLite database Connection used by the Cursor object.