def alterTableMode(database: str, table: str, mode: str): metadata_db, index_metadata = get_metadata_db(database) metadata_db = Database() if metadata_db: oldMode = metadata_db.get_mode() encoding = metadata_db.get_encondig() if mode not in ["avl","b","bPlus","dict","isam","hash","json"]: return 4 struct = get_struct(metadata_db.get_mode()) tables = struct.showTables(database) for tabla in tables: if tabla == table: listaDatos = get_Data(database, tabla, oldMode) # UNA LISTA VACIA NO EJECUTA EL FOR numberColumns = len(listaDatos[0]) #insertAlter(database+"_"+mode, tabla, numberColumns, mode, listaDatos) if metadata_db.get_table(table).get_pk_list() != []: alterAddPK(database, table,metadata_db.get_table(table).get_pk_list()) createDatabase(database+"_"+mode, mode, encoding) createTable(database+"_"+mode, table, numberColumns) for i in listaDatos: insert(database, table,i) struct.dropTable(database, table) return 0 return 3 else: return 2
def save_database_db(database, mode, encondig): new_mode = Database(database, mode, encondig) metadata_db_list.append(new_mode)