Inheritance diagram for python.dbsqlite.SQLhash:

Collaboration diagram for python.dbsqlite.SQLhash:

Public Member Functions
	__init__ (self, filename=':memory:', flags='r', mode=None)
	__len__ (self)
	__bool__ (self)
	keys (self)
	values (self)
	items (self)
	__iter__ (self)
	iterkeys (self)
	itervalues (self)
	iteritems (self)
	__contains__ (self, key)
	__getitem__ (self, key)
	__setitem__ (self, key, value)
	__delitem__ (self, key)
	update (self, items=(), **kwds)
	clear (self)
	sync (self)
	close (self)
	__del__ (self)

Public Attributes
	conn = sqlite3.connect(filename)

Detailed Description

Definition at line 26 of file dbsqlite.py.

Constructor & Destructor Documentation

◆ init()

python.dbsqlite.SQLhash.__init__	(	self,
		filename = ':memory:',
		flags = 'r',
		mode = None )

Definition at line 27 of file dbsqlite.py.

    def __init__(self, filename=':memory:', flags='r', mode=None):
        # XXX add flag/mode handling
        #   c -- create if it doesn't exist
        #   n -- new empty
        #   w -- open existing
        #   r -- readonly
        if 'n' in flags:
            import os
            if os.path.exists(filename):
                os.remove(filename)
 
        MAKE_SHELF = 'CREATE TABLE IF NOT EXISTS shelf (key TEXT PRIMARY KEY NOT NULL, value BLOB)'
        self.conn = sqlite3.connect(filename)
        self.conn.text_factory = str
        if 'r' not in flags or filename==':memory:':
            self.conn.execute(MAKE_SHELF)
        self.conn.commit()
 

◆ del()

python.dbsqlite.SQLhash.__del__ ( self )

Definition at line 131 of file dbsqlite.py.

    def __del__(self):
        self.close()
 

Member Function Documentation

◆ bool()

python.dbsqlite.SQLhash.__bool__ ( self )

Definition at line 49 of file dbsqlite.py.

    def __bool__(self):
        # returns None if count is zero
        GET_BOOL = 'SELECT MAX(ROWID) FROM shelf'
        return self.conn.execute(GET_BOOL).fetchone()[0] is not None
 

◆ contains()

python.dbsqlite.SQLhash.__contains__	(		self,
			key )

Definition at line 78 of file dbsqlite.py.

    def __contains__(self, key):
        HAS_ITEM = 'SELECT 1 FROM shelf WHERE key = ?'
        return self.conn.execute(HAS_ITEM, (key,)).fetchone() is not None
 

◆ delitem()

python.dbsqlite.SQLhash.__delitem__	(		self,
			key )

Definition at line 96 of file dbsqlite.py.

    def __delitem__(self, key):
        if key not in self:
            raise KeyError(key)
        DEL_ITEM = 'DELETE FROM shelf WHERE key = ?'
        self.conn.execute(DEL_ITEM, (key,))
        #self.conn.commit()
 

◆ getitem()

python.dbsqlite.SQLhash.__getitem__	(		self,
			key )

Definition at line 82 of file dbsqlite.py.

    def __getitem__(self, key):
        GET_ITEM = 'SELECT value FROM shelf WHERE key = ?'
        item = self.conn.execute(GET_ITEM, (key,)).fetchone()
        if item is None:
            raise KeyError(key)
 
        return pickle.loads(item[0])
 

◆ iter()

python.dbsqlite.SQLhash.__iter__ ( self )

Definition at line 63 of file dbsqlite.py.

    def __iter__(self):
        return self.iterkeys()
 

◆ len()

python.dbsqlite.SQLhash.__len__ ( self )

Definition at line 45 of file dbsqlite.py.

    def __len__(self):
        GET_LEN = 'SELECT COUNT(*) FROM shelf'
        return self.conn.execute(GET_LEN).fetchone()[0]
 

◆ setitem()

python.dbsqlite.SQLhash.__setitem__	(	self,
		key,
		value )

Definition at line 90 of file dbsqlite.py.

    def __setitem__(self, key, value):       
        ADD_ITEM = 'REPLACE INTO shelf (key, value) VALUES (?,?)'
        value = pickle.dumps(value)
        self.conn.execute(ADD_ITEM, (key, value))
        #self.conn.commit()
 

◆ clear()

python.dbsqlite.SQLhash.clear ( self )

Definition at line 116 of file dbsqlite.py.

    def clear(self):        
        CLEAR_ALL = 'DELETE FROM shelf; VACUUM;'
        self.conn.executescript(CLEAR_ALL)
        self.conn.commit()
 

◆ close()

python.dbsqlite.SQLhash.close ( self )

Definition at line 125 of file dbsqlite.py.

    def close(self):
        if self.conn is not None:
            self.conn.commit()
            self.conn.close()
            self.conn = None
 

◆ items()

python.dbsqlite.SQLhash.items ( self )

Definition at line 60 of file dbsqlite.py.

    def items(self):
        return list(self.iteritems())
 

◆ iteritems()

python.dbsqlite.SQLhash.iteritems ( self )

Definition at line 74 of file dbsqlite.py.

    def iteritems(self):
        GET_ITEMS = 'SELECT key, value FROM shelf ORDER BY ROWID'
        return SQLHashItemIterator(self.conn, GET_ITEMS, (0, 1))
 

◆ iterkeys()

python.dbsqlite.SQLhash.iterkeys ( self )

Definition at line 66 of file dbsqlite.py.

    def iterkeys(self):
        GET_KEYS = 'SELECT key FROM shelf ORDER BY ROWID'
        return SQLHashKeyIterator(self.conn, GET_KEYS, (0,))
 

◆ itervalues()

python.dbsqlite.SQLhash.itervalues ( self )

Definition at line 70 of file dbsqlite.py.

    def itervalues(self):
        GET_VALUES = 'SELECT value FROM shelf ORDER BY ROWID'
        return SQLHashValueIterator(self.conn, GET_VALUES, (0,))
 

◆ keys()

python.dbsqlite.SQLhash.keys ( self )

Definition at line 54 of file dbsqlite.py.

    def keys(self):
        return list(self.iterkeys())
 

◆ sync()

python.dbsqlite.SQLhash.sync ( self )

Definition at line 121 of file dbsqlite.py.

    def sync(self):
        if self.conn is not None:    
            self.conn.commit()
 

◆ update()

python.dbsqlite.SQLhash.update	(		self,
			items = (),
		**	kwds )

Definition at line 103 of file dbsqlite.py.

    def update(self, items=(), **kwds):
        try:
            items = items.items()
            items = [(k,pickle.dumps(v)) for k,v in items]
        except AttributeError:
            pass
 
        UPDATE_ITEMS = 'REPLACE INTO shelf (key, value) VALUES (?, ?)'
        self.conn.executemany(UPDATE_ITEMS, items)
        self.conn.commit()
        if kwds:
            self.update(kwds)
 

◆ values()

python.dbsqlite.SQLhash.values ( self )

Definition at line 57 of file dbsqlite.py.

    def values(self):
        return list(self.itervalues())
 

Member Data Documentation

◆ conn

python.dbsqlite.SQLhash.conn = sqlite3.connect(filename)

Definition at line 39 of file dbsqlite.py.

The documentation for this class was generated from the following file:

dbsqlite.py

Public Member Functions

Public Attributes