Mercurial > sqlpython
diff docs/source/capabilities.rst @ 445:b34ea206c7d1
debug bind var dependence on arg.parsed.expanded
author | catherine@Drou |
---|---|
date | Tue, 09 Feb 2010 13:48:24 -0500 |
parents | e89db2eaa0b4 |
children | 46589473c36b |
line wrap: on
line diff
--- a/docs/source/capabilities.rst Tue Feb 09 08:24:30 2010 -0500 +++ b/docs/source/capabilities.rst Tue Feb 09 13:48:24 2010 -0500 @@ -37,6 +37,9 @@ History ======= +If used on a *nix machine with ``readline`` installed, then ``bash``-like access +to the command history is available. + The up- and down-arrow keys allow you to scroll through the lines entered so far in your sqlpython session. @@ -249,6 +252,17 @@ When the `autobind` sqlpython parameter is True, a `bind` statement is issued automatically after every query that returns exactly one row. +Once bind variables are defined, they can be used in SQL statements. The syntax +is dependnent on which RDBMS is being queried. + +---------- ------------------------------------------ +RDBMS bind variable example +---------- ------------------------------------------ +Oracle SELECT * FROM party WHERE name = :name; +postgreSQL SELECT * FROM party WHERE name = %(name)s; +MySQL SELECT * FROM party WHERE name = ; +---------- ------------------------------------------ + Bind variables are available from within Python as a dictionary named `binds` (see Python). Substitution variables