def showDatabases(self):
r_list = []
try:
tmp = binary_file.rollback("databases")
self._showDatabases(tmp, r_list)
except FileNotFoundError:
pass
return r_list
def createDatabase(self, database):
r_value = 0
try:
self.root = binary_file.rollback("databases")
verificar_bdexistente = self.searchDatabase(database)
if verificar_bdexistente is None:
r_value = self._createDatabase(database, self.root)
else:
r_value = 2
except FileNotFoundError:
r_value = self._createDatabase(database, self.root)
finally:
if r_value not in [1, 2]:
binary_file.commit(r_value, "databases")
r_value = 0
return r_value
def assignTables(self, database, nodo_Nuevo):
r_value = 0
try:
self.root = binary_file.rollback("databases")
verificar_bdexistente = self.searchDatabase(database)
if verificar_bdexistente is None:
r_value = self._assignTables(database, self.root, nodo_Nuevo)
else:
r_value = 2
except FileNotFoundError:
r_value = self._assignTables(database, self.root, nodo_Nuevo)
finally:
if r_value not in [1, 2]:
binary_file.commit(r_value, "databases")
r_value = 0
return r_value
def dropTable(self, database, table):
try:
try:
temp = self.searchDatabase(database)
try:
self.root = binary_file.rollback("databases")
self._dropTable(database, self.root, table)
print("asd")
binary_file.commit(self.root, "databases")
except:
return 3
except:
return 2
except:
return 1
def searchDatabase(self, name):
self.root = binary_file.rollback("databases")
return self._searchDatabase(name, self.root)
def getRoot(self):
return binary_file.rollback("databases")
def insert(self,database,table,tupla):
self.root = binary_file.rollback("databases")
self._insert(database, self.root, table,tupla)
binary_file.commit(self.root,"databases")
def createTable(self, database, table, numberColums):
self.root = binary_file.rollback("databases")
table_temp = Tabla(table, numberColums)
self._createTable(database, self.root, table_temp)
binary_file.commit(self.root, "databases")
