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
  • [x] connect()
• Globals
  • [x] apilevel
  • [x] threadsafety
  • [x] paramstyle
• Exceptions
  • currently only SQCloudException is raised
  • [ ] Warning
  • [ ] Error
  • [ ] InterfaceError
  • [ ] DatabaseError
  • [ ] DataError
  • [ ] OperationalError
  • [ ] IntegrityError
  • [ ] InternalError
  • [ ] ProgrammingError
  • [ ] NotSupportedError
• Connection Objects
  • [x] close()
  • [ ] commit()
  • [ ] rollback()
  • [x] cursor()
• Cursor Objects
  • [x] description
  • [ ] rowcount
    • partially - row changes from Insert/Update/Delete is not set
• Cursor methods
  • [ ] callproc()
  • [x] close()
  • [x] execute()
  • [x] executemany()
  • [x] fetchone()
  • [x] fetchmany()
  • [x] fetchall()
  • [ ] nextset()
  • [x] arraysize
  • [ ] setinputsizes()
  • [ ] setoutputsize()
  • [ ] 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
  • [x] Cursor.connection
  • [ ] Cursor.scroll
  • [ ] Cursor.messages
  • [ ] Connection.messages
  • [x] Cursor.next()
  • [x] Cursor.iter()
  • [ ] Cursor.lastrowid
  • [ ] Connection.autocommit
• [ ] 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
  • [ ] in_transaction
  • [ ] executescript()
  • [x] row_factory
  • [ ] text_factory
  • [ ] total_changes
• 12.6.3. Cursor Objects
  • [ ] executescript()
• [ ] 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
  • utilizzato in sqlite3 per commit transaction, non per conn.close()