python / db-api 2.0 / compatibility with sqlite3 API

[danielebriggi]

Working list of API to implement in SQLite Cloud driver to be compatible with Python sqlite3 API (based on PEP 249)

Compatibility with DB-API 2.0

• Constructors
  • connect()
• Globals
  • apilevel
  • threadsafety
  • paramstyle
• Exceptions
  • currently only SQCloudException is raised
    • Warning
    • Error
    • InterfaceError
    • DatabaseError
    • DataError
    • OperationalError
    • IntegrityError
    • InternalError
    • ProgrammingError
    • NotSupportedError
• Connection Objects
  • close()
  • commit()
  • rollback()
  • cursor()
• Cursor Objects
  • description
  • rowcount
• Cursor methods
  • callproc() - not implemented in sqlite3
  • close()
  • execute()
  • executemany()
  • fetchone()
  • fetchmany()
  • fetchall()
  • nextset()
  • arraysize
  • setinputsizes() - not implemented in sqlite3
  • setoutputsize() - not implemented in sqlite3
  • support native SQLite type: int, float, text, blob, null
• Type Objects and Constructors
  • The module exports the constructors and singletons
• Optional DB API Extensions
  • Cursor.rownumber
  • _All exception classes defined by the DB API standard should be exposed on the Connection objects
  • Cursor.connection
  • Cursor.scroll - not implemented in sqlite3
  • Cursor.messages - not implemented in sqlite3
  • Connection.messages - not implemented in sqlite3
  • Cursor.next()
  • Cursor.iter()
  • Cursor.lastrowid
  • Connection.autocommit - autocommit always enabled
  • Blob Objects (py >= 3.11)
• Optional Error Handling Extensions
• Optional Two-Phase Commit Extensions

Compatibility with SQLite3

(Incomplete list, to integrate with the list for DB-API 2.0)

• 12.6.1. Module functions and constants
  • sqlite3.PARSE_DECLTYPES
  • sqlite3.register_converter()
  • sqlite3.register_adapter()
• 12.6.2. Connection Objects
  • isolation_level - always set to None, autocommit mode
  • in_transaction
  • executescript() - not currently supported by SQLite Cloud
  • row_factory
  • text_factory
  • total_changes
  • create_function() - not currently supported by SQLite Cloud
  • create_aggregate() - not currently supported by SQLite Cloud
  • create_collation() - not currently supported by SQLite Cloud
  • set_authorizer() not currently supported by SQLite Cloud
  • set_progress_handler() - not currently supported by SQLite Cloud
  • set_trace_callback() - not currently supported by SQLite Cloud
• 12.6.3. Cursor Objects
  • executescript() - not currently supported by SQLite Cloud
• Row Objects
• 12.6.6. SQLite and Python types
  • _We support the conversions of native types: NULL, INTEGER, REAL, TEXT, BLOB
• 12.6.6.2. Using adapters to store additional Python types in SQLite databases
• Converting SQLite values to custom Python types
• Accessing columns by name instead of by index
• Using the connection as a context manager

[danielebriggi]

List updated after #27