def extractRow(database: str, table: str, columns: list) -> list:
try:
retorno = 1
db = __buscarLlaveBaseDato(database)
if db is not None:
modoDB = db[0]
if modoDB == "avl":
retorno = avl.extractRow(database, table, columns)
elif modoDB == "b":
retorno = b.extractRow(database, table, columns)
elif modoDB == "bplus":
retorno = bPlus.extractRow(database, table, columns)
elif modoDB == "dict":
retorno = dic.extractRow(database, table, columns)
elif modoDB == "isam":
retorno = isam.extractRow(database, table, columns)
elif modoDB == "json":
retorno = json.extractRow(database, table, columns)
elif modoDB == "hash":
retorno = hash.extractRow(database, table, columns)
return retorno
else:
return []
except Exception:
return []
def extractRow(database, table, columns):
if searchInMode(database) != None:
currentMode = searchInMode(database)
if currentMode == 'avl':
# avlList.append(tableNew)
return avl.extractRow(database, table, columns)
elif currentMode == 'b':
# bList.append(tableNew)
return b.extractRow(database, table, columns)
elif currentMode == 'bplus':
# bplusList.append(tableNew)
return bplus.extractRow(database, table, columns)
elif currentMode == 'dict':
# dictList.append(tableNew)
return DM.extractRow(database, table, columns)
elif currentMode == 'isam':
# isamList.append(tableNew)
return isam.extractRow(database, table, columns)
elif currentMode == 'json':
# jsonList.append(tableNew)
return j.extractRow(database, table, columns)
elif currentMode == 'hash':
# hashList.append(tableNew)
return Hash.extractRow(database, table, columns)
else:
return 2
def extractRow(database, table, columns):
dbs = databases.find_all(database)
if dbs == []:
return []
if databases.find_table(database, table) == None:
return []
result = []
for db in dbs:
if db.tables.search(table) == None:
continue
if db.mode == "avl":
result = avlMode.extractRow(database, table, columns)
elif db.mode == "b":
result = BMode.extractRow(database, table, columns)
elif db.mode == "bplus":
result = BPlusMode.extractRow(database, table, columns)
elif db.mode == "dict":
result = DictMode.extractRow(database, table, columns)
elif db.mode == "isam":
result = ISAMMode.extractRow(database, table, columns)
elif db.mode == "json":
result = jsonMode.extractRow(database, table, columns)
elif db.mode == "hash":
result = HashMode.extractRow(database, table, columns)
return result
def extractRow(database: str, table: str, columns: list) -> list:
"""Shows a register of a table in a database
Parameters:\n
database (str): name of the database
table (str): name of the table
columns (list): PK of target register
Returns:\n
list: succesful operation
empty list: non-existent database, non-existent table, an error ocurred
"""
bd = _database(database)
if bd:
tb = _table(database, table)
if tb:
mode = tb["modo"]
val = -1
if mode == "avl":
val = avl.extractRow(database, table, columns)
elif mode == "b":
val = b.extractRow(database, table, columns)
elif mode == "bplus":
val = bplus.extractRow(database, table, columns)
elif mode == "hash":
val = hash.extractRow(database, table, columns)
elif mode == "isam":
val = isam.extractRow(database, table, columns)
elif mode == "json":
val = json.extractRow(database, table, columns)
elif mode == "dict":
val = dict.extractRow(database, table, columns)
return val
else:
return 3
else:
return 2
def extractRow(database, table, columns):
db = databases.search(database)
if db == None:
return 2
if db.mode == "avl":
result = avlMode.extractRow(database, table, columns)
elif db.mode == "b":
result = BMode.extractRow(database, table, columns)
elif db.mode == "bplus":
result = BPlusMode.extractRow(database, table, columns)
elif db.mode == "dict":
result = DictMode.extractRow(database, table, columns)
elif db.mode == "isam":
result = ISAMMode.extractRow(database, table, columns)
elif db.mode == "json":
result = jsonMode.extractRow(database, table, columns)
elif db.mode == "hash":
result = HashMode.extractRow(database, table, columns)
return result
def extractRow(database, name_table, columns):
ModeDB, indexDB = exist_Alter(database)
if ModeDB:
mode = ModeDB.get_mode()
if mode.lower().strip() == "avl":
return avl.extractRow(database, name_table, columns)
elif mode.lower().strip() == "b":
return b.extractRow(database, name_table, columns)
elif mode.lower().strip() == "bPlus".lower():
return bPlus.extractRow(database, name_table, columns)
elif mode.lower().strip() == "dict":
return diccionario.extractRow(database, name_table, columns)
elif mode.lower().strip() == "hash":
return hash.extractRow(database, name_table, columns)
elif mode.lower().strip() == "isam":
return isam.extractRow(database, name_table, columns)
elif mode.lower().strip() == "json":
return json.extractRow(database, name_table, columns)
# return db.extractRow(database, name_table, columns) Revisar persona quien lo realizo
return None