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('')
