def extractRangeTable(database, table, columnNumber, lower, upper): try: newTable = [] database = str(database) table = str(table) dictionary = load('metadata') value_base = dictionary.get(database) if not value_base: return None mode = dictionary.get(database)[0] j = checkMode(mode) value_return = j.extractRangeTable(database, table, int(columnNumber), lower, upper) # Decompress for tuple in value_return: newTuple = [] for register in tuple: if iscompressed(register): decompressed = zlib.decompress(register) newTuple.append(decompressed) else: newTuple.append(register) newTable.append(newTuple) return value_return except: return None
def extractRangeTable(database: str, table: str, columnNumber: int, lower: any, upper: any) -> list: try: rows = [] dbBuscada = __getDatabase(database) if dbBuscada is False: return None tbBuscada = __getTable(database, table) if tbBuscada is False: return None mode = tbBuscada["mode"] if mode == "avl": rows = avl.extractRangeTable(database, table, columnNumber, lower, upper) elif mode == "b": rows = b.extractRangeTable(database, table, columnNumber, lower, upper) elif mode == "bplus": rows = bplus.extractRangeTable(database, table, columnNumber, lower, upper) elif mode == "hash": rows = ha.extractRangeTable(database, table, columnNumber, lower, upper) elif mode == "isam": rows = isam.extractRangeTable(database, table, columnNumber, lower, upper) elif mode == "json": rows = j.extractRangeTable(database, table, lower, upper) elif mode == "dict": rows = d.extractRangeTable(database, table, columnNumber, lower, upper) return rows except: return None
def extractRangeTable(database, table, columnNumber, lower, upper): try: newTable = [] database = str(database) table = str(table) dictionary = load('metadata') value_base = dictionary.get(database) if not value_base: return None mode = dictionary.get(database)[0] j = checkMode(mode) value_return = j.extractRangeTable(database, table, int(columnNumber), lower, upper) return value_return except: return None