From 794b3137a109d1b391420692dfec5b3bd302d2d1 Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Fri, 3 Dec 2010 15:49:32 +0200 Subject: [PATCH] magic_insert: allow pre-quoted table name --- python/skytools/sqltools.py | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/python/skytools/sqltools.py b/python/skytools/sqltools.py index 500aeb47..e2dd17b6 100644 --- a/python/skytools/sqltools.py +++ b/python/skytools/sqltools.py @@ -263,7 +263,7 @@ def _gen_list_insert(tbl, row, fields, qfields): fmt = "insert into %s (%s) values (%s);" return fmt % (tbl, ",".join(qfields), ",".join(tmp)) -def magic_insert(curs, tablename, data, fields = None, use_insert = 0): +def magic_insert(curs, tablename, data, fields = None, use_insert = 0, quoted_table = False): r"""Copy/insert a list of dict/list data to database. If curs == None, then the copy or insert statements are returned @@ -294,7 +294,10 @@ def magic_insert(curs, tablename, data, fields = None, use_insert = 0): row_func = _gen_list_copy qfields = [quote_ident(f) for f in fields] - qtablename = quote_fqident(tablename) + if quoted_table: + qtablename = tablename + else: + qtablename = quote_fqident(tablename) # init processing buf = StringIO() -- 2.39.5