def alterTB(database, old, new): dbs[database][new] = dbs[database].pop(old) renombrarCarpeta('{}/{}.bin'.format(database, old), '{}/{}.bin'.format(database, new)) data[database].remove(old) data[database].append(new) hacerCommit(data, "databases") return 0
def dropDB(bd): dbs.pop(bd) data.pop(bd) removerCarpeta(bd) hacerCommit(data, "databases") return 0
def insertTable(bd, table, new: Estructura): dbs[bd][table] = new data[bd].append(table) hacerCommit(new, '{}/{}'.format(bd, table)) hacerCommit(data, 'databases') return 0
def insertDB(bd): dbs[bd] = {} data[bd] = [] crearCarpeta(bd) hacerCommit(data, "databases") return 0
def alterDB(old, new): dbs[new] = dbs.pop(old) data[new] = data.pop(old) renombrarCarpeta(old, new) hacerCommit(data, "databases") return 0
def addColumn(database: str, table: str, default: any): result = dbs[database][table].add(default) hacerCommit(dbs[database][table], '{}/{}'.format(database, table)) return result
def dropColumn(database: str, table: str, columnNumber: int): result = dbs[database][table].drop(columnNumber) hacerCommit(dbs[database][table], '{}/{}'.format(database, table)) return result
def truncateRegistros(database: str, table: str): result = dbs[database][table].truncate() hacerCommit(dbs[database][table], '{}/{}'.format(database, table)) return result
def deleteRegistro(database: str, table: str, columns: list): result = dbs[database][table].delete(columns) hacerCommit(dbs[database][table], '{}/{}'.format(database, table)) return result
def updateRegistro(database: str, table: str, register: dict, columns: list): result = dbs[database][table].update(register, columns) hacerCommit(dbs[database][table], '{}/{}'.format(database, table)) return result
def insertRegistro(database: str, table: str, register: list): result = dbs[database][table].insert(register) hacerCommit(dbs[database][table], '{}/{}'.format(database, table)) return result
def alterDPK(database: str, table: str): result = dbs[database][table].delPK() hacerCommit(dbs[database][table], '{}/{}'.format(database, table)) return result
def alterAPK(database: str, table: str, columns: list): result = dbs[database][table].setPK(columns) hacerCommit(dbs[database][table], '{}/{}'.format(database, table)) return result
def dropTB(database, table): dbs[database].pop(table) data[database].remove(table) removerArchivo('{}/{}.bin'.format(database, table)) hacerCommit(data, "databases") return 0