|
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) |
|
Definition at line 26 of file dbsqlite.py.
◆ __init__()
def python.dbsqlite.SQLhash.__init__ |
( |
|
self, |
|
|
|
filename = ':memory:' , |
|
|
|
flags = 'r' , |
|
|
|
mode = None |
|
) |
| |
Definition at line 27 of file dbsqlite.py.
27 def __init__(self, filename=':memory:
', flags='r', mode=None):
34 if os.path.exists(filename):
37 MAKE_SHELF =
'CREATE TABLE IF NOT EXISTS shelf (key TEXT PRIMARY KEY NOT NULL, value BLOB)'
38 self.conn = sqlite3.connect(filename)
39 self.conn.text_factory = str
40 if 'r' not in flags
or filename==
':memory:':
◆ __del__()
def python.dbsqlite.SQLhash.__del__ |
( |
|
self | ) |
|
◆ __bool__()
def python.dbsqlite.SQLhash.__bool__ |
( |
|
self | ) |
|
Definition at line 49 of file dbsqlite.py.
51 GET_BOOL =
'SELECT MAX(ROWID) FROM shelf'
52 return self.conn.
execute(GET_BOOL).fetchone()[0]
is not None
◆ __contains__()
def python.dbsqlite.SQLhash.__contains__ |
( |
|
self, |
|
|
|
key |
|
) |
| |
Definition at line 78 of file dbsqlite.py.
79 HAS_ITEM =
'SELECT 1 FROM shelf WHERE key = ?'
80 return self.conn.
execute(HAS_ITEM, (key,)).fetchone()
is not None
◆ __delitem__()
def python.dbsqlite.SQLhash.__delitem__ |
( |
|
self, |
|
|
|
key |
|
) |
| |
Definition at line 96 of file dbsqlite.py.
96 def __delitem__(self, key):
99 DEL_ITEM =
'DELETE FROM shelf WHERE key = ?'
100 self.conn.
execute(DEL_ITEM, (key,))
◆ __getitem__()
def python.dbsqlite.SQLhash.__getitem__ |
( |
|
self, |
|
|
|
key |
|
) |
| |
Definition at line 82 of file dbsqlite.py.
83 GET_ITEM =
'SELECT value FROM shelf WHERE key = ?'
84 item = self.conn.
execute(GET_ITEM, (key,)).fetchone()
88 return pickle.loads(item[0])
◆ __iter__()
def python.dbsqlite.SQLhash.__iter__ |
( |
|
self | ) |
|
Definition at line 63 of file dbsqlite.py.
64 return self.iterkeys()
◆ __len__()
def python.dbsqlite.SQLhash.__len__ |
( |
|
self | ) |
|
Definition at line 45 of file dbsqlite.py.
46 GET_LEN =
'SELECT COUNT(*) FROM shelf'
47 return self.conn.
execute(GET_LEN).fetchone()[0]
◆ __setitem__()
def python.dbsqlite.SQLhash.__setitem__ |
( |
|
self, |
|
|
|
key, |
|
|
|
value |
|
) |
| |
Definition at line 90 of file dbsqlite.py.
91 ADD_ITEM =
'REPLACE INTO shelf (key, value) VALUES (?,?)'
92 value = pickle.dumps(value)
93 self.conn.
execute(ADD_ITEM, (key, value))
◆ clear()
def python.dbsqlite.SQLhash.clear |
( |
|
self | ) |
|
Definition at line 116 of file dbsqlite.py.
117 CLEAR_ALL =
'DELETE FROM shelf; VACUUM;'
118 self.conn.executescript(CLEAR_ALL)
◆ close()
def python.dbsqlite.SQLhash.close |
( |
|
self | ) |
|
Definition at line 125 of file dbsqlite.py.
126 if self.conn
is not None:
◆ items()
def python.dbsqlite.SQLhash.items |
( |
|
self | ) |
|
◆ iteritems()
def python.dbsqlite.SQLhash.iteritems |
( |
|
self | ) |
|
Definition at line 74 of file dbsqlite.py.
75 GET_ITEMS =
'SELECT key, value FROM shelf ORDER BY ROWID'
76 return SQLHashItemIterator(self.conn, GET_ITEMS, (0, 1))
◆ iterkeys()
def python.dbsqlite.SQLhash.iterkeys |
( |
|
self | ) |
|
Definition at line 66 of file dbsqlite.py.
67 GET_KEYS =
'SELECT key FROM shelf ORDER BY ROWID'
68 return SQLHashKeyIterator(self.conn, GET_KEYS, (0,))
◆ itervalues()
def python.dbsqlite.SQLhash.itervalues |
( |
|
self | ) |
|
Definition at line 70 of file dbsqlite.py.
71 GET_VALUES =
'SELECT value FROM shelf ORDER BY ROWID'
72 return SQLHashValueIterator(self.conn, GET_VALUES, (0,))
◆ keys()
def python.dbsqlite.SQLhash.keys |
( |
|
self | ) |
|
◆ sync()
def python.dbsqlite.SQLhash.sync |
( |
|
self | ) |
|
Definition at line 121 of file dbsqlite.py.
122 if self.conn
is not None:
◆ update()
def python.dbsqlite.SQLhash.update |
( |
|
self, |
|
|
|
items = () , |
|
|
** |
kwds |
|
) |
| |
Definition at line 103 of file dbsqlite.py.
103 def update(self, items=(), **kwds):
105 items = items.items()
106 items = [(k,pickle.dumps(v))
for k,v
in items]
107 except AttributeError:
110 UPDATE_ITEMS =
'REPLACE INTO shelf (key, value) VALUES (?, ?)'
111 self.conn.executemany(UPDATE_ITEMS, items)
◆ values()
def python.dbsqlite.SQLhash.values |
( |
|
self | ) |
|
◆ conn
python.dbsqlite.SQLhash.conn |
The documentation for this class was generated from the following file: