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)