Package web :: Package web :: Module db :: Class SqliteDB

[frames] | no frames]

Class SqliteDB

DB --+
     |
    SqliteDB

Instance Methods

__init__(self, **keywords)
Creates a database.

source code

_process_insert_query(self, query, tablename, seqname)

source code

query(self, *a, **kw)
Execute SQL query `sql_query` using dictionary `vars` to interpolate it.

source code

Inherited from DB: delete, gen_clause, insert, multiple_insert, select, sql_clauses, transaction, update, where

Inherited from DB (private): _connect, _connect_with_pooling, _db_cursor, _db_execute, _getctx, _load_context, _param_marker, _unload_context, _where

Properties

Inherited from DB: ctx

Method Details

init(self, **keywords)
(Constructor)

Creates a database.

Overrides: DB.__init__: (inherited documentation)

_process_insert_query(self, query, tablename, seqname)

Overrides: DB._process_insert_query

query(self, *a, **kw)

Execute SQL query `sql_query` using dictionary `vars` to interpolate it. If `processed=True`, `vars` is a `reparam`-style list to use instead of interpolating.

>>> db = DB(None, {})
>>> db.query("SELECT * FROM foo", _test=True)
<sql: 'SELECT * FROM foo'>
>>> db.query("SELECT * FROM foo WHERE x = $x", vars=dict(x='f'), _test=True)
<sql: "SELECT * FROM foo WHERE x = 'f'">
>>> db.query("SELECT * FROM foo WHERE x = " + sqlquote('f'), _test=True)
<sql: "SELECT * FROM foo WHERE x = 'f'">

Overrides: DB.query: (inherited documentation)