twistar.dbconfig.sqlite.SQLiteDBConfig : API documentation

Line #	Kind	Name	Docs
6	Method	whereToString	Convert a conditional to the form needed for a query using the DBAPI. For instance, for most DB's question marks in the query string have to be converted to `%s`. This will vary by database.
13	Method	getLastInsertID	Using the given txn, get the id of the last inserted row.
20	Method	updateArgsToString	Convert dictionary of arguments to form needed for DB update query. This method will vary by database driver.
26	Method	insertArgsToString	Convert `{'name': value}` to an insert "values" string like `"(%s,%s,%s)"`.
31	Method	insertMany	Insert many values into a table.

Inherited from InteractionBase:

Line #	Kind	Name	Docs
0	Class Variable	LOG	If True, then all queries are logged using `twisted.python.log.msg`.
0	Class Variable	includeBlankInInsert	If True, then insert/update queries will include setting object properties that have not be set to null in their respective columns.
24	Method	logEncode	Encode the given string if necessary for printing to logs.
33	Method	log	Log the query and any args or kwargs using `twisted.python.log.msg` if `InteractionBase.LOG` is True.
47	Method	executeOperation	Simply makes same `twisted.enterprise.dbapi.ConnectionPool.runOperation` call, but with call to `log` function.
56	Method	execute	Simply makes same `twisted.enterprise.dbapi.ConnectionPool.runQuery` call, but with call to `log` function.
65	Method	executeTxn	Execute given query within the given transaction. Also, makes call to `log` function.
74	Method	select	Select rows from a table.
153	Method	insert	Insert a row into the given table.
179	Method	escapeColNames	Escape column names for insertion into SQL statement.
222	Method	delete	Delete from the given tablename.
239	Method	update	Update a row into the given table.
268	Method	valuesToHash	Given a row from a database query (values), create a hash using keys from the table schema and values from the given values;
290	Method	getSchema	Get the schema (in the form of a list of column names) for a given tablename. Use the given transaction if specified.
304	Method	insertObj	Insert the given object into its table.
323	Method	updateObj	Update the given object's row in the object's table.
340	Method	refreshObj	Update the given object based on the information in the object's table.
385	Method	count	Get the number of rows in the given table (optionally, that meet the given where criteria).
126	Method	_doselect	Private callback for actual select query call.

Line #	Kind	Name	Docs
385	Method	count	Get the number of rows in the given table (optionally, that meet the given where criteria).
222	Method	delete	Delete from the given tablename.
179	Method	escapeColNames	Escape column names for insertion into SQL statement.
56	Method	execute	Simply makes same `twisted.enterprise.dbapi.ConnectionPool.runQuery` call, but with call to `log` function.
47	Method	executeOperation	Simply makes same `twisted.enterprise.dbapi.ConnectionPool.runOperation` call, but with call to `log` function.
65	Method	executeTxn	Execute given query within the given transaction. Also, makes call to `log` function.
13	Method	getLastInsertID	Using the given txn, get the id of the last inserted row.
290	Method	getSchema	Get the schema (in the form of a list of column names) for a given tablename. Use the given transaction if specified.
0	Class Variable	includeBlankInInsert	If True, then insert/update queries will include setting object properties that have not be set to null in their respective columns.
153	Method	insert	Insert a row into the given table.
26	Method	insertArgsToString	Convert `{'name': value}` to an insert "values" string like `"(%s,%s,%s)"`.
31	Method	insertMany	Insert many values into a table.
304	Method	insertObj	Insert the given object into its table.
0	Class Variable	LOG	If True, then all queries are logged using `twisted.python.log.msg`.
33	Method	log	Log the query and any args or kwargs using `twisted.python.log.msg` if `InteractionBase.LOG` is True.
24	Method	logEncode	Encode the given string if necessary for printing to logs.
340	Method	refreshObj	Update the given object based on the information in the object's table.
74	Method	select	Select rows from a table.
239	Method	update	Update a row into the given table.
20	Method	updateArgsToString	Convert dictionary of arguments to form needed for DB update query. This method will vary by database driver.
323	Method	updateObj	Update the given object's row in the object's table.
268	Method	valuesToHash	Given a row from a database query (values), create a hash using keys from the table schema and values from the given values;
6	Method	whereToString	Convert a conditional to the form needed for a query using the DBAPI. For instance, for most DB's question marks in the query string have to be converted to `%s`. This will vary by database.
126	Method	_doselect	Private callback for actual select query call.

def whereToString(self, where):

overrides twistar.dbconfig.base.InteractionBase.whereToString

Convert a conditional to the form needed for a query using the DBAPI. For instance, for most DB's question marks in the query string have to be converted to %s. This will vary by database.

Parameters	where	Conditional of the same form as the `where` parameter in `DBObject.find`.
Returns	A conditional in the same form as the `where` parameter in `DBObject.find`.

Parameters	tablename	Table to insert a row into.
	vals	Values to insert. Should be a list of dictionaries in the form of `{'name': value, 'othername': value}`.
Returns	A `Deferred`.

Parameters	args	Values to insert. Should be a dictionary in the form of `{'name': value, 'othername': value}`.
Returns	A tuple of the form `('name = %s, othername = %s, ...', argvalues)`.

t.d.s.SQLiteDBConfig(InteractionBase) : class documentation