Python Sqlite3

The sqlite3 module is a database interface library (implementing the DB-API as per PEP 249) for Sqlite.

Contents

  1. Python Sqlite3
    1. Usage
    2. Classes
      1. Blob
        1. Close
        2. Read
        3. Seek
        4. Tell
        5. Write
      2. Connection
        1. Backup
        2. BlobOpen
        3. Close
        4. Commit
        5. Cursor
        6. Create_Aggregate
        7. Create_Collation
        8. Create_Function
        9. Create_Window_Function
        10. Deserialize
        11. Enable_Load_Extension
        12. Execute
        13. ExecuteMany
        14. ExecuteScript
        15. GetLimit
        16. Interrupt
        17. In_Transaction
        18. Isolation_Level
        19. IterDump
        20. Load_Extension
        21. RollBack
        22. Row_Factory
        23. Serialize
        24. SetLimit
        25. Set_Progress_Handler
        26. Set_Trace_Callback
        27. Text_Factory
        28. Total_Changes
      3. Cursor
        1. ArraySize
        2. Close
        3. Connection
        4. Description
        5. Execute
        6. ExecuteMany
        7. ExecuteScript
        8. FetchAll
        9. FetchMany
        10. FetchOne
        11. LastRowId
        12. RowCount
        13. Row_Factory
        14. SetInputSizes
        15. SetOutputSize
      4. PrepareProtocol
      5. Row
        1. Keys
    3. Functions
      1. Complete_Statement
      2. Connect
      3. Enable_Callback_Tracebacks
      4. Register_Adapter
      5. Register_Converter
    4. Constants
    5. Exceptions
    6. See also

Usage

import sqlite3

con = sqlite3.connect("example.db")
cur = con.cursor()

# list tables
for i, n in enumerate(cur.execute("SELECT name FROM sqlite_schema WHERE type='table'")):
    print(i, n[0])

# print SQL definition of the 'example' table
sql = list(cur.execute("SELECT sql FROM sqlite_schema WHERE name='example'"))
print(sql[0][0])

# cleanup
con.close()

Classes

Blob

Close

Read

Seek

Tell

Write

Connection

See the example.

Backup

BlobOpen

Close

Commit

Cursor

Create_Aggregate

Create_Collation

Create_Function

Create_Window_Function

Deserialize

Enable_Load_Extension

Execute

ExecuteMany

ExecuteScript

GetLimit

Interrupt

In_Transaction

Isolation_Level

IterDump

Load_Extension

RollBack

Row_Factory

Serialize

SetLimit

Set_Progress_Handler

Set_Trace_Callback

Text_Factory

Total_Changes

Cursor

See the example.

ArraySize

Close

Connection

Description

Execute

ExecuteMany

ExecuteScript

FetchAll

FetchMany

FetchOne

LastRowId

RowCount

Row_Factory

SetInputSizes

SetOutputSize

PrepareProtocol

Row

Keys

Functions

Complete_Statement

Connect

See the example.

Enable_Callback_Tracebacks

Register_Adapter

Register_Converter

Constants

Name

Meaning

PARSE_COLNAMES

PARSE_DECLTYPES

SQLITE_OK

SQLITE_DENY

SQLITE_IGNORE

apilevel

internal implementation detail of DB-API; always "2.0"

paramstyle

always "qmark"

sqlite_version

runtime version of Sqlite as a string

sqlite_version_info

runtime version of Sqlite as an integer tuple

threadsafety

version

module version as a string

version_info

module version as an integer tuple

Exceptions

Name

Meaning

Warning

not used by the module but provided for higher-level libraries

Error

base class of all below exceptions; adds two attributes (sqlite_errorcode, sqlite_errorname)

InterfaceError

DatabaseError

DataError

OperationalError

IntegrityError

InternalError

ProgrammingError

NotSupportedError

See also

Python sqlite3 module documentation

CategoryRicottone