def alterDatabaseDecompress(database: str) -> int: r = f.alterDatabaseDecompress(database) serializar.commit(f, "GOD") return r
# File: storageManager # License: Released under MIT License # Notice: Copyright (c) 2020 TytusDB Team from storage import mainMode as r from storage import Serializable as serializar f = r.main() try: f = serializar.rollback("GOD") except: serializar.commit(f, "GOD") #---------------------FUNCIONES DE UNIFICACION DE MODOS DE ALMACENAMIENTO----------------------# def createDatabase(database: str, mode: str, encoding: str) -> int: r = f.createDatabase(database, mode, encoding) serializar.commit(f, "GOD") return r # ---------------------FUNCIONES DE ADMINISTRACION DEL MODO DE ALMACENAMIENTO----------------------# def alterDatabaseMode(database: str, mode: str) -> int: r = f.alterDatabaseMode(database, mode) serializar.commit(f, "GOD") return r def alterTableMode(database: str, table: str, mode: str) -> int: r = f.alterTableMode(database, table, mode) serializar.commit(f, "GOD")
def alterTableAddIndex(database: str, table: str, indexName: str, columns: list) -> int: r = f.alterTableAddIndex(database, table, indexName, columns) serializar.commit(f, "GOD") return r
def alterDatabaseEncoding(database: str, encoding: str) -> int: r = f.alterDatabaseEncoding(database, encoding) serializar.commit(f, "GOD") return r
def delete(database: str, table: str, columns: list) -> int: r = f.delete(database, table, columns) serializar.commit(f, "GOD") return r
def alterTableMode(database: str, table: str, mode: str) -> int: r = f.alterTableMode(database, table, mode) serializar.commit(f, "GOD") return r
def alterDatabase(databaseOld, databaseNew) -> int: r = f.alterDatabase(databaseOld, databaseNew) serializar.commit(f, "GOD") return r
def loadCSV(file: str, database: str, table: str) -> list: r = f.loadCSV(file, database, table) serializar.commit(f, "GOD") return r
def graphDSD(database: str) -> str: r = f.graphDSD(database) serializar.commit(f, "GOD") return r
def graphDF(database: str, table: str) -> str: r = f.graphDF(database, table) serializar.commit(f, "GOD") return r
def safeModeOff(database: str, table: str) -> int: r = f.safeModeOff(database, table) serializar.commit(f, "GOD") return r
def decrypt(cipherBackup: str, password: str) -> str: r = f.decrypt(cipherBackup, password) serializar.commit(f, "GOD") return r
def encrypt(backup: str, password: str) -> str: r = f.encrypt(backup, password) serializar.commit(f, "GOD") return r
def alterDropColumn(database: str, table: str, columnNumber: int) -> int: r = f.alterDropColumn(database, table, columnNumber) serializar.commit(f, "GOD") return r
def dropDatabase(database: str) -> int: r = f.dropDatabase(database) serializar.commit(f, "GOD") return r
def insert(database: str, table: str, register: list) -> int: r = f.insert(database, table, register) serializar.commit(f, "GOD") return r
def createTable(database: str, table: str, numberColumns: int) -> int: r = f.createTable(database, table, numberColumns) serializar.commit(f, "GOD") return r
def update(database: str, table: str, register: dict, columns: list) -> int: r = f.update(database, table, register, columns) serializar.commit(f, "GOD") return r
def createDatabase(database: str, mode: str, encoding: str) -> int: r = f.createDatabase(database, mode, encoding) serializar.commit(f, "GOD") return r
def truncate(database: str, table: str) -> int: r = f.truncate(database, table) serializar.commit(f, "GOD") return r
def alterAddPK(database: str, table: str, columns: list) -> int: r = f.alterAddPK(database, table, columns) serializar.commit(f, "GOD") return r
def alterTableAddFK(database: str, table: str, indexName: str, columns: list, tableRef: str, columnsRef: list) -> int: r = f.alterTableAddFK(database, table, indexName, columns, tableRef, columnsRef) serializar.commit(f, "GOD") return r
def alterDropPK(database: str, table: str) -> int: r = f.alterDropPK(database, table) serializar.commit(f, "GOD") return r
def alterTableDropIndex(database: str, table: str, indexName: str) -> int: r = f.alterTableDropIndex(database, table, indexName) serializar.commit(f, "GOD") return r
def alterTable(database: str, tableOld: str, tableNew: str) -> int: r = f.alterTable(database, tableOld, tableNew) serializar.commit(f, "GOD") return r
def checksumTable(database: str, table:str, mode: str) -> str: r = f.checksumTable(database, table, mode) serializar.commit(f, "GOD") return r
def alterAddColumn(database: str, table: str, default: any) -> int: r = f.alterAddColumn(database, table, default) serializar.commit(f, "GOD") return r
def alterTableCompress(database: str, table: str, level: int) -> int: r = f.alterTableCompress(database, table, level) serializar.commit(f, "GOD") return r
def rows_picture(database, table, canvas, frame): storage.checkData() try: print('entre') data = Serializable.Read('./Data/', "Data") db = data.get(database) dataTable = Serializable.Read('./Data/', "DataTables") tab = dataTable.get(database + "_" + table) if db: if tab: if tab[1] == 'avl': res = storage.avl.extractTable(database, table) try: avl_graph.graphAVL(database, table) canvas.image = PhotoImage(file=f'./tmp/grafo-avl.png') Label(frame, image=canvas.image).place(x=50, y=50) except: return res elif tab[1] == 'b': res = storage.b.extractTable(database, table) try: table_aux = Serializable.Read( f'./Data/B/', database + '-' + table + '-b') table_aux.graficar() canvas.image = PhotoImage(file='salida.png') Label(frame, image=canvas.image).place(x=50, y=50) except: return res elif tab[1] == 'bplus': res = storage.bplus.extractTable(database, table) try: table_aux = Serializable.Read( f'./Data/BPlusMode/{database}/{table}/', table) table_aux.graficar(database, table) canvas.image = PhotoImage( file= f'./Data/BPlusMode/{database}/{table}/{table}.png') Label(frame, image=canvas.image).place(x=50, y=50) except: pass return res elif tab[1] == 'dict': res = storage.dict.extractTable(database, table) elif tab[1] == 'isam': res = storage.isam.extractTable(database, table) try: storage.isam.chart(database, table) canvas.image = PhotoImage(file='isam.png') Label(frame, image=canvas.image).place(x=50, y=50) except: return res elif tab[1] == 'json': res = storage.json.extractTable(database, table) elif tab[1] == 'hash': res = storage.hash.extractTable(database, table) try: table_aux = Serializable.Read( f'./Data/hash/{database}/', table) table_aux.Grafico() canvas.image = PhotoImage(file='hash.png') Label(frame, image=canvas.image).place(x=50, y=50) except: return res return res return None except: print('error') return None print('')