Mercurial > hg > ZDBInterface

comparison RestDbInterface.py @ 18:60fea3a6c695

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
better fix for psycopg 2.4. better quoting of sql arguments.
author casties
date Thu, 23 Feb 2012 21:17:14 +0100
parents 48ed91b29784
children
comparison
equal deleted inserted replaced
17:48ed91b29784 18:60fea3a6c695
179 179
180 def getTable(self,schema='public',table=None,sortBy=1,username='guest'): 180 def getTable(self,schema='public',table=None,sortBy=1,username='guest'):
181 """return table data""" 181 """return table data"""
182 logging.debug("gettable") 182 logging.debug("gettable")
183 if sortBy: 183 if sortBy:
184 data = self.executeSQL('select * from "%s"."%s" order by %s'%(schema,table,sortBy)) 184 data = self.executeSQL('select * from "%s"."%s" order by %%s'%(sqlName(schema),sqlName(table)),(sortBy,))
185 else: 185 else:
186 data = self.executeSQL('select * from "%s"."%s"'%(schema,table)) 186 data = self.executeSQL('select * from "%s"."%s"'%(sqlName(schema),sqlName(table)))
187 return data 187 return data
188 188
189 def hasTable(self,schema='public',table=None,username='guest'): 189 def hasTable(self,schema='public',table=None,username='guest'):
190 """return if table exists""" 190 """return if table exists"""
191 logging.debug("hastable") 191 logging.debug("hastable")