python.dbsqlite.SQLhash Class Reference

Inheritance diagram for python.dbsqlite.SQLhash:

Collaboration diagram for python.dbsqlite.SQLhash:

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

Public Attributes
	conn

Detailed Description

Definition at line 28 of file dbsqlite.py.

Constructor & Destructor Documentation

__init__()

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

Definition at line 29 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__()

def python.dbsqlite.SQLhash.__del__

(

self

)

Definition at line 133 of file dbsqlite.py.

    def __del__(self):
        self.close()
 

Member Function Documentation

__bool__()

def python.dbsqlite.SQLhash.__bool__

(

self

)

Definition at line 51 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__()

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

Definition at line 80 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__()

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

Definition at line 98 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__()

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

Definition at line 84 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__()

def python.dbsqlite.SQLhash.__iter__

(

self

)

Definition at line 65 of file dbsqlite.py.

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

__len__()

def python.dbsqlite.SQLhash.__len__

(

self

)

Definition at line 47 of file dbsqlite.py.

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

__setitem__()

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

Definition at line 92 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()

def python.dbsqlite.SQLhash.clear

(

self

)

Definition at line 118 of file dbsqlite.py.

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

close()

def python.dbsqlite.SQLhash.close

(

self

)

Definition at line 127 of file dbsqlite.py.

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

items()

def python.dbsqlite.SQLhash.items

(

self

)

Definition at line 62 of file dbsqlite.py.

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

iteritems()

def python.dbsqlite.SQLhash.iteritems

(

self

)

Definition at line 76 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()

def python.dbsqlite.SQLhash.iterkeys

(

self

)

Definition at line 68 of file dbsqlite.py.

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

itervalues()

def python.dbsqlite.SQLhash.itervalues

(

self

)

Definition at line 72 of file dbsqlite.py.

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

keys()

def python.dbsqlite.SQLhash.keys

(

self

)

Definition at line 56 of file dbsqlite.py.

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

sync()

def python.dbsqlite.SQLhash.sync

(

self

)

Definition at line 123 of file dbsqlite.py.

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

update()

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

Definition at line 105 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()

def python.dbsqlite.SQLhash.values

(

self

)

Definition at line 59 of file dbsqlite.py.

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

Member Data Documentation

conn

python.dbsqlite.SQLhash.conn

Definition at line 41 of file dbsqlite.py.

---

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

• dbsqlite.py