Fork me on GitHub

SQLAlchemy backend

class cork.sqlalchemy_backend.SqlRowProxy(sql_dict, key, *args, **kwargs)[source]

Bases: dict

clear() → None. Remove all items from D.
copy() → a shallow copy of D
fromkeys(S[, v]) → New dict with keys from S and values equal to v.

v defaults to None.

get(k[, d]) → D[k] if k in D, else d. d defaults to None.
has_key(k) → True if D has a key k, else False
items() → list of D's (key, value) pairs, as 2-tuples
iteritems() → an iterator over the (key, value) items of D
iterkeys() → an iterator over the keys of D
itervalues() → an iterator over the values of D
keys() → list of D's keys
pop(k[, d]) → v, remove specified key and return the corresponding value.

If key is not found, d is returned if given, otherwise KeyError is raised

popitem() → (k, v), remove and return some (key, value) pair as a

2-tuple; but raise KeyError if D is empty.

setdefault(k[, d]) → D.get(k,d), also set D[k]=d if k not in D
update([E, ]**F) → None. Update D from dict/iterable E and F.

If E present and has a .keys() method, does: for k in E: D[k] = E[k] If E present and lacks .keys() method, does: for (k, v) in E: D[k] = v In either case, this is followed by: for k in F: D[k] = F[k]

values() → list of D's values
viewitems() → a set-like object providing a view on D's items
viewkeys() → a set-like object providing a view on D's keys
viewvalues() → an object providing a view on D's values
class cork.sqlalchemy_backend.SqlTable(engine, table, key_col_name)[source]

Bases: cork.base_backend.Table

Provides dictionary-like access to an SQL table.

iteritems()[source]

Iterate over table rows

pop(key)[source]
insert(d)[source]
empty_table()[source]
class cork.sqlalchemy_backend.SqlSingleValueTable(engine, table, key_col_name, col_name)[source]

Bases: cork.sqlalchemy_backend.SqlTable

empty_table()
insert(d)
iteritems()

Iterate over table rows

pop(key)
class cork.sqlalchemy_backend.SqlAlchemyBackend(db_full_url, users_tname='users', roles_tname='roles', pending_reg_tname='register', initialize=False, **kwargs)[source]

Bases: cork.base_backend.Backend

save_users()[source]
save_roles()[source]
save_pending_registrations()[source]