pythonPkg_sqlite3

Python Package >> Python Standard Library >> Data Persistence
  >> sqlite3
     DB-API 2.0 interface for SQLite databases

Reference>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

  Module functions and constants<<<<<<<<<<<<<<<<<
    >> sqlite3.PARSE_DECLTYPES
	>> sqlite3.PARSE_COLNAMES
	>> sqlite3.connect(database[,timeout,detect_types,isolation_level,check_same_thread,factory,cached_statements])
	   database, :memory: open a database resides in RAM
	   timeout, default 5.0s
	   cache_statements, default 100 statements
	>> sqlite3.register_converter(typename, callable)
	   convert bytestring to python type
	>> sqlite3.register_adapter(type, callable)
	   convert python type to sqlite type
	>> sqlite3.complete_statement(sql)
	   return bool
	>> sqlite3.enable_callback_tracebacks(flag)
	
  Connection Objects<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
    >> class sqlite3.Connection
	  >> isolation_level
	     None|DEFERRED|IMMEDIATE|EXCLUSIVE
	  >> cursor([cursorClass])
	  >> commit()
	  >> rollback()
	  >> close()
	  >> execute(sql[,parameters])
	  >> executemany(sql['paramenters])
	  >> executescript(sql_script)
	  >> create_function(name, num_params, func)
	  >> create_aggregate(name, num_params, aggregate_class)
	  >> create_collation(name, callable)
	  >> interrupt()
	  >> set_authorizer(authorizer_callback)
	     return SQLITE_OK|SQLITE_DENY|SQLITE_IGNORE
	  >> set_progress_handle(handler, n)
	  >> enable_load_extension(enabled)
	  >> load_extensions(path)
	  
	  >> row_factory
	  >> text_factory
	     unicode|str|sqlite3.OptimizedUnicode
	  >> total_changes
	  >> iterdump

  Cursor Objects<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
    >> class Cursor
	  >> execute(sql[,parameters])
	  >> executemany(sql,seq_of_paramenters)
	  >> executescript(sql_script)
	  >> fetchone()
	  >> fetchmany([size=cursor.arraysize])
	  >> fetchall()
	  >> rowcount
	  >> lastrowid
	  >> description

  Row Objects<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
    >> class Row
	  >> keys()

  SQLite and Python types<<<<<<<<<<<<<<<<<<<<<<<<
    >> SQLite types:
	   NULL|INTEGER|REAL|TEXT|BLOB
	>> python types to sqlite types
	  >> None, NULL
	  >> int, INTEGER
	  >> long, INTEGER
	  >> float, REAL
	  >> str(UTF-8 encoded), TEXT
	  >> unicode, TEXT
	  >> buffer, BLOB
	>> SQLite types to python types
	  >> NULL, None
	  >> INTEGER, int, long
	  >> REAL, float
	  >> TEXT, dependent on text_factory, unicode
	  >> BLOB, buffer