def sqlExec(self, sql): # Execute a SQL query and, return [header, data, rowCount] connector = PostGisDBConnector(self.uri) #print "DEBUG dbrequest : sql = " + sql try: c = connector._execute(None, unicode(sql)) data = [] header = connector._get_cursor_columns(c) except: print "Erreur SQL : " + str(sql) # debug purpose raise if header is None: header = [] if len(header) > 0: data = connector._fetchall(c) row_count = c.rowcount if row_count == -1: row_count = len(data) if c: c.close() del c connector.__del__() return [header, data, row_count]