diff options
author | Marko Kreen | 2009-09-21 11:37:28 +0000 |
---|---|---|
committer | Marko Kreen | 2009-09-21 11:37:28 +0000 |
commit | 788cb1f8fb4d7b32b0d04aea1a3356cca1434d06 (patch) | |
tree | 5314ac75b1e25533beef578e9a9e99322a724239 /python/skytools/sqltools.py | |
parent | 95b24561de4cb0e27cf55b4853b40c06bf8d5d93 (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.py | 4 |
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.""" |