def show_data_bases():
data_bases = storage.showDatabases()
tree_window = Toplevel(main_window)
main_window.iconify()
tree_window.geometry('715x580+200+75')
tree_window.title('Bases de datos')
main_tree = Frame(tree_window)
main_tree.pack(fill=BOTH, expand=1)
main_tree.configure(background='black')
canvas_tree = Canvas(tree_window, width=650, height=470)
canvas_tree.place(x=20, y=75)
scroll = Scrollbar(main_tree, orient=VERTICAL, command=canvas_tree.yview)
scroll.pack(side=RIGHT, fill=Y)
canvas_tree.configure(yscrollcommand=scroll.set)
canvas_tree.bind(
'<Configure>',
lambda e: canvas_tree.configure(scrollregion=canvas_tree.bbox('all')))
scroll_tree = Scrollbar(main_tree,
orient=HORIZONTAL,
command=canvas_tree.xview)
scroll_tree.pack(side=BOTTOM, fill=X)
canvas_tree.configure(xscrollcommand=scroll_tree.set)
canvas_tree.bind(
'<Configure>',
lambda e: canvas_tree.configure(scrollregion=canvas_tree.bbox('all')))
frame_tree = Frame(canvas_tree)
canvas_tree.create_window((0, 0),
width=10000,
height=5000,
window=frame_tree,
anchor='nw')
xview = 10
yview = 5
contador = 0
names = []
for x in data_bases:
names.append(x)
Button(frame_tree,
text=x,
font='Helvetica 8 bold italic',
fg='white',
bg='black',
command=lambda database=x: show_tables(tree_window, database),
width=15,
padx=15,
pady=5).place(x=xview, y=yview)
xview += 160
contador += 1
if contador == 4:
contador = 0
xview = 10
yview += 40
Button(main_tree,
text='Regresar',
font='Helvetica 10 bold italic',
command=lambda: close_table_window(tree_window, main_window),
bg='red',
width=15,
pady=3).place(x=20, y=15)
print(f.createDatabase("prueba3","b","iso-8859-1"),"esperado 0")
print(f.createDatabase("pruebá4","isam","ascii"),"esperado 0")
print(f.createDatabase("prueba5","avl","utf8"),"esperado 0")
print(f.createDatabase("prueba6","dict","iso-8859-1"),"esperado 0")
print(f.createDatabase("prueba7","json","ascii"),"esperado 0")
print(f.createDatabase("prueba7","bplus","utf8"),"esperado 2")
print(f.createDatabase("212prueba7","b","iso-8859-1"),"esperado 1")
print(f.createDatabase("212prueba7","bplus","ascii"),"esperado 1")
print(f.createDatabase("212prueba7","isam","utf8"),"esperado 1")
print(f.createDatabase("212prueba7","hash","iso-8859-1"),"esperado 1")
print(f.createDatabase("212prueba7","avl","ascii"),"esperado 1")
print(f.createDatabase("212prueba7","json","utf8"),"esperado 1")
print(f.createDatabase("212prueba7","dict","iso-8859-1"),"esperado 1")
print(f.createDatabase("prueba8","bplus","utf"),"esperado 4")
print(f.createDatabase("prueba9","bplu","ascii"),"esperado 3")
print(f.showDatabases())
print(f.alterDatabase('prueba1','editPrueba1'),"esperado 0")
print(f.showDatabases())
print(f.dropDatabase('editPrueba1'),"esperado 0")
print(f.showDatabases())
print(f.createDatabase("pruebaBplus","bplus","ascii"),"esperando 0")
print(f.alterDatabaseMode("prueba2","bplus"),"esperando 0")
#--------------Creación de tablas para prueba-------------------#
#Area para crear bases de datos
print("Estado BD:",f.createDatabase("BD1","b","utf8"))#Sistema de Asignaciones
print("Estado BD:",f.createDatabase("BD2","b","utf8"))#Sistema de Compras de productos
print("Estado BD:",f.createDatabase("BD3","b","utf8"))#Sistema de Accesos de usuario para una base de datos
print("Estado BD:",f.createDatabase("BD4","b","utf8"))#Sistema de Peliculas y Series para una pagina web
print("Estado BD:",f.showDatabases())#Nos deberia mostrar todas las bases de datos
"/ 0")
print("CREATE DATABASE: (áéíóú)", f.createDatabase("áéíóú", "json", "utf8"),
"/ 0")
print("CREATE DATABASE: ", f.createDatabase("85DBav", "avl", "utf8"), "/1")
print("CREATE DATABASE: ", f.createDatabase(2, "avl", "utf8"), "/1")
print("CREATE DATABASE: ", f.createDatabase("DBavl", "avl", "utf8"), "/ 2")
print("CREATE DATABASE: ", f.createDatabase("DBhashplus", "hashplus", "utf8"),
"/ 3")
print("CREATE DATABASE: ", f.createDatabase("DBhashplus", "hashplus", "utf8"),
"/ ¿3-2?")
print("CREATE DATABASE: ",
f.createDatabase("DBhashplus", "hashplus", "utf8plis"), "/ ¿4-3-2?")
print("CREATE DATABASE: ", f.createDatabase("DBavl2", "avl", "utf8plus"),
"/ 4\n")
print("SHOW DATABASE: ", f.showDatabases(), "\n")
print("ALTER DATABASE: ", f.alterDatabase('áéíóú', 'editPrueba1'), "/ 0")
print("ALTER DATABASE: ", f.alterDatabase(5, 'editPrueba1'), "/ 1")
print("ALTER DATABASE: ", f.alterDatabase("test", 'editPrueba1'), "/ 2")
print("ALTER DATABASE: ", f.alterDatabase('editPrueba1', 'editPrueba1'),
"/ 3\n")
print("SHOW DATABASE: ", f.showDatabases(), "\n")
print("DROP DATABASE: ", f.dropDatabase('editPrueba1'), "/ 0")
print("SHOW DATABASE: ", f.showDatabases())
print("ALTER DATABASE MODE: ", f.alterDatabaseMode("DBavl", "b"), "/ 0")
print("********** DROP ALL: ", f.dropAll())
def salir(self):
self.ventana.destroy()
PantallaBD(j.showDatabases())
elif j.databasesinfo[1][database][table]['mode'] == 'bplus':
bplus = BPlusM.Read(
'Data/BPlusMode/' + database + '/' + table + '/', table)
bplus.graficar(database, table)
return 'Data/BPlusMode/' + database + '/' + table + '/' + table + '.png'
elif j.databasesinfo[1][database][table]['mode'] == 'isam':
ISAMM.chart(database, table)
os.remove('isam.dot')
return 'isam.png'
elif j.databasesinfo[1][database][table]['mode'] == 'hash':
tmp = HashM._storage.Cargar(database, table)
tmp.Grafico()
os.remove('hash.dot')
return 'hash.png'
else:
return 'img/no-graficable.png'
except:
return 'img/no-graficable.png'
def chartBlockchain(database, table):
try:
BC.chartBlockchain(database, table)
os.remove('blockchain.dot')
return 'blockchain.png'
except:
return 'img/no-modoseguro.png'
PantallaBD(j.showDatabases())