def alterTable(database: str, tableOld: str, tableNew: str) -> int: try: retorno = 1 db = __buscarLlaveBaseDato(database) if db is not None: modoDB = db[0] tablas = db[2] if tablas: if tablas.get(tableOld) is not None: modoDB = tablas[tableOld] if modoDB == "avl": retorno = avl.alterTable(database, tableOld, tableNew) elif modoDB == "b": retorno = b.alterTable(database, tableOld, tableNew) elif modoDB == "bplus": retorno = bPlus.alterTable(database, tableOld, tableNew) elif modoDB == "dict": retorno = dic.alterTable(database, tableOld, tableNew) elif modoDB == "isam": retorno = isam.alterTable(database, tableOld, tableNew) elif modoDB == "json": retorno = json.alterTable(database, tableOld, tableNew) elif modoDB == "hash": retorno = hash.alterTable(database, tableOld, tableNew) return retorno else: return 2 except Exception: return 1
def alterTable(database, tableOld, tableNew): if searchInMode(tableOld) != None: currentMode = searchInMode(tableOld) if currentMode == 'avl': avlList.append(tableNew) return avl.alterTable(database, tableOld, tableNew) elif currentMode == 'b': bList.append(tableNew) return b.alterTable(database, tableOld, tableNew) elif currentMode == 'bplus': bplusList.append(tableNew) return bplus.alterTable(database, tableOld, tableNew) elif currentMode == 'dict': dictList.append(tableNew) return DM.alterTable(database, tableOld, tableNew) elif currentMode == 'isam': isamList.append(tableNew) return isam.alterTable(database, tableOld, tableNew) elif currentMode == 'json': jsonList.append(tableNew) return j.alterTable(database, tableOld, tableNew) elif currentMode == 'hash': hashList.append(tableNew) return Hash.alterTable(database, tableOld, tableNew) else: return 2
def alterTable(database: str, tableOld: str, tableNew: str) -> int: """Renames a table in a database Parameters:\n database (str): name of the database tableOld (str): name of the target table tableNew (str): new name of the table Returns:\n 0: successful operation 1: an error ocurred 2: non-existent database 3: non-existent target table 4: new table name occupied """ bd = _database(database) if bd: tb = _table(database, tableOld) if tb: mode = tb["modo"] val = -1 if mode == "avl": val = avl.alterTable(database, tableOld, tableNew) elif mode == "b": val = b.alterTable(database, tableOld, tableNew) elif mode == "bplus": val = bplus.alterTable(database, tableOld, tableNew) elif mode == "hash": val = hash.alterTable(database, tableOld, tableNew) elif mode == "isam": val = isam.alterTable(database, tableOld, tableNew) elif mode == "json": val = json.alterTable(database, tableOld, tableNew) elif mode == "dict": val = dict.alterTable(database, tableOld, tableNew) if val == 0: _table(database, tableOld)["nombre"]=tableNew _Guardar() return val else: return 3 else: return 2
def alterTable(database, old_table, new_table): ModeDB, indexDB = exist_Alter(database) if ModeDB: mode = ModeDB.get_mode() if mode.lower().strip() == "avl": return avl.alterTable(database, old_table, new_table) elif mode.lower().strip() == "b": return b.alterTable(database, old_table, new_table) elif mode.lower().strip() == "bPlus".lower(): return bPlus.alterTable(database, old_table, new_table) elif mode.lower().strip() == "dict": return diccionario.alterTable(database, old_table, new_table) elif mode.lower().strip() == "hash": return hash.alterTable(database, old_table, new_table) elif mode.lower().strip() == "isam": return isam.alterTable(database, old_table, new_table) elif mode.lower().strip() == "json": return json.alterTable(database, old_table, new_table)