def query(self, con, sql, array): cursor = con.createStatement() resulset = cursor.executeQuery(sql) if array: return comun.parse_data_type(resulset) else: return resulset
def setQuery(self, grid, query, colid): data = comun.parse_data_type(query) headers = data[0] row = data[1:2] rows = data[1:] col_fmt = False if colid: col_fmt = ('{}', ) + ('', ) * (len(headers) - 1) self._make_columns(grid, headers, row) self.setGridData(grid, rows, col_fmt) return
def setQuery(self, grid, query, colid): data = comun.parse_data_type(query) headers = data[0] row = data[1:2] rows = data[1:] col_fmt = False if colid: col_fmt = ('{}',) + ('',) * (len(headers) - 1) self._make_columns(grid, headers, row) self.setGridData(grid, rows, col_fmt) return