From d0dbd8abec1a65612a99fb56d9d68d59cc6604aa Mon Sep 17 00:00:00 2001
From: Marko Kreen
Date: Fri, 19 Nov 2010 16:13:32 +0200
Subject: magic_insert: allow shorter rows

---
 python/skytools/sqltools.py | 10 ++++++++--
 1 file changed, 8 insertions(+), 2 deletions(-)

(limited to 'python/skytools/sqltools.py')

diff --git a/python/skytools/sqltools.py b/python/skytools/sqltools.py
index b36bb58c..500aeb47 100644
--- a/python/skytools/sqltools.py
+++ b/python/skytools/sqltools.py
@@ -245,14 +245,20 @@ def _gen_dict_insert(tbl, row, fields, qfields):
 def _gen_list_copy(tbl, row, fields, qfields):
     tmp = []
     for i in range(len(fields)):
-        v = row[i]
+        try:
+            v = row[i]
+        except IndexError:
+            v = None
         tmp.append(quote_copy(v))
     return "\t".join(tmp)
 
 def _gen_list_insert(tbl, row, fields, qfields):
     tmp = []
     for i in range(len(fields)):
-        v = row[i]
+        try:
+            v = row[i]
+        except IndexError:
+            v = None
         tmp.append(quote_literal(v))
     fmt = "insert into %s (%s) values (%s);"
     return fmt % (tbl, ",".join(qfields), ",".join(tmp))
-- 
cgit v1.2.3