summaryrefslogtreecommitdiff
path: root/python/skytools/sqltools.py
diff options
context:
space:
mode:
authorMarko Kreen2009-09-21 11:37:28 +0000
committerMarko Kreen2009-09-21 11:37:28 +0000
commit788cb1f8fb4d7b32b0d04aea1a3356cca1434d06 (patch)
tree5314ac75b1e25533beef578e9a9e99322a724239 /python/skytools/sqltools.py
parent95b24561de4cb0e27cf55b4853b40c06bf8d5d93 (diff)
sqltools: make mk_update_sql()/mk_delete_sql() use ONLY
This will make urlencoded events behave same as sql events.
Diffstat (limited to 'python/skytools/sqltools.py')
-rw-r--r--python/skytools/sqltools.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/python/skytools/sqltools.py b/python/skytools/sqltools.py
index c0e7e554..3037df69 100644
--- a/python/skytools/sqltools.py
+++ b/python/skytools/sqltools.py
@@ -530,7 +530,7 @@ def mk_update_sql(row, tbl, pkey_list, field_map = None):
col = quote_ident(col)
val = quote_literal(val)
set_list.append("%s = %s" % (col, val))
- return "update %s set %s where %s;" % (quote_fqident(tbl),
+ return "update only %s set %s where %s;" % (quote_fqident(tbl),
", ".join(set_list), " and ".join(whe_list))
def mk_delete_sql(row, tbl, pkey_list, field_map = None):
@@ -545,7 +545,7 @@ def mk_delete_sql(row, tbl, pkey_list, field_map = None):
val = quote_literal(row[k])
whe_list.append("%s = %s" % (col, val))
whe_str = " and ".join(whe_list)
- return "delete from %s where %s;" % (quote_fqident(tbl), whe_str)
+ return "delete from only %s where %s;" % (quote_fqident(tbl), whe_str)
class QArgConf:
"""Per-query arg-type config object."""