execute(sql[, parameters]) Executes an SQL statement. The SQL statement may be parameterized (i. e. placeholders instead of

class shelve.BsdDbShelf(dict, protocol=None, writeback=False, keyencoding='utf-8') A subclass of Shelf which exposes

lastrowid This read-only attribute provides the rowid of the last modified row. It is only set if you issued an INSERT

object.__getstate__() Classes can further influence how their instances are pickled; if the class defines the method

executemany(sql[, parameters]) This is a nonstandard shortcut that creates a cursor object by calling the cursor()

class shelve.DbfilenameShelf(filename, flag='c', protocol=None, writeback=False) A subclass of Shelf which accepts

shelve.open(filename, flag='c', protocol=None, writeback=False) Open a persistent dictionary. The filename specified is the

iterdump() Returns an iterator to dump the database in an SQL text format. Useful when saving an in-memory database for later

Shelf.close() Synchronize and close the persistent dict object. Operations on a closed shelf will fail with a

in_transaction