# HG changeset patch
# User fknauft
# Date 1303999226 -7200
# Node ID 11dea0923d2fba154b81ceb89ad6cfabfa79493a
# Parent  0a1dee5076129ddf5e73aa37bf93063ad75593d6
Upload of xml-tables with empty Cells possible

diff -r 0a1dee507612 -r 11dea0923d2f RestDbInterface.py
--- a/RestDbInterface.py	Thu Apr 28 14:40:33 2011 +0200
+++ b/RestDbInterface.py	Thu Apr 28 16:00:26 2011 +0200
@@ -342,10 +342,15 @@
     def getTable(self,schema='public',table=None,sortBy=1,username='guest'):
         """return table data"""
         logging.debug("gettable")
-        if sortBy:
+        try:
+          if sortBy:
             data = self.executeSQL('select * from "%s"."%s" order by %s'%(schema,table,sortBy))
-        else:
+          else:
             data = self.executeSQL('select * from "%s"."%s"'%(schema,table))
+        except:
+            """ table does not exist """
+            fields=self.get
+            self.createEmptyTable(schema, table, fields)
         return data
 
     def hasTable(self,schema='public',table=None,username='guest'):
@@ -570,9 +575,17 @@
                         colNodes=node[1].getElementsByTagNameNS(namespace, colTagName)
                         data = []
                         hasData = False
+                        lineIndex=0
                         for colNode in colNodes:
+                            lineIndex+=1
                             dataNodes=colNode.getElementsByTagNameNS(namespace, dataTagName)
                             if len(dataNodes) > 0:
+                                dataIndex=0
+                                if colNode.hasAttribute('index'):
+                                   dataIndex=colNode.getAttribute('index')
+                                if dataIndex>lineIndex:
+                                    data.append("")
+                                    lineIndex+=1                                     
                                 val = getTextFromNode(dataNodes[0])
                                 hasData = True
                             else: