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