Index of the db module
-
m
web.db
...
- Database API
(part of web.py)
-
C
UnknownDB
...
- raised for unsupported dbms
-
C
UnknownParamstyle
...
- raised for unsupported db paramstyles
-
C
SQLQuery
...
- You can pass this sort of thing as a clause in any db function.
Otherwise, you can pass a dictionary to the keyword argument
vars
and the function will call reparam for you.
-
f
sqlquote
...
- Ensures
a is quoted properly for use in a SQL query.
-
f
sqlors
...
-
left is a SQL clause liketablename.arg = `
and lst is a list of values. Returns a reparam-style
pair featuring the SQL that ORs together the clause
for each item in the lst.
-
f
reparam
...
- Takes a string and a dictionary and interpolates the string
using values from the dictionary. Returns an
SQLQuery for the result.
-
f
query
...
- 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.
-
f
select
...
- Selects
what from tables with clauses where, order,
group, limit, and offset. Uses vars to interpolate.
Otherwise, each clause can be a SQLQuery.
-
f
transact
...
- Start a transaction.
-
f
rollback
...
- Rolls back a transaction.
-
f
connect
...
- Connects to the specified database.
-
f
aparam
...
- Returns the appropriate string to be used to interpolate
a value with the current
web.ctx.db_module or simply %s
if there isn't one.
-
f
update
...
- Update
tables with clause where (interpolated using vars)
and setting values.
-
f
commit
...
- Commits a transaction.
-
f
sqllist
...
- Converts the arguments for use in something like a WHERE clause.
-
f
insert
...
- Inserts
values into tablename. Returns current sequence ID.
Set seqname to the ID if it's not the default, or to False
if there isn't one.
-
f
delete
...
- Deletes from
table with clauses where and using.