def extractTable(database: str, table: str) -> list:
try:
b.dicDB[database][table][0] = serializar.rollback(database + "-" +
table + "-B")
except:
pass
return b.extractTable(database, table)
def extractRangeTable(database: str, table: str, columnNumber: int, lower: any,
upper: any) -> list:
try:
b.dicDB[database][table][0] = serializar.rollback(database + "-" +
table + "-B")
except:
pass
return b.extractRangeTable(database, table, columnNumber, lower, upper)
def alterDropPK(database: str, table: str) -> int:
try:
b.dicDB[database][table][0] = serializar.rollback(database + "-" + table + "-B")
except:
pass
r = b.alterDropPK(database, table)
try:
b.dicDB[database][table][0] = bt.arbolB(b.grade)
serializar.commit(b, "BDD")
except:
pass
return r
def alterAddColumn(database: str, table: str, default: any) -> int:
try:
b.dicDB[database][table][0] = serializar.rollback(database + "-" + table + "-B")
except:
pass
r = b.alterAddColumn(database, table, default)
try:
b.dicDB[database][table][0] = bt.arbolB(b.grade)
serializar.commit(b, "BDD")
except:
pass
return r
def delete(database: str, table: str, columns: list) -> int:
try:
b.dicDB[database][table][0] = serializar.rollback(database + "-" + table + "-B")
except:
pass
r = b.delete(database, table, columns)
try:
serializar.commit(b.dicDB[database][table][0], database + "-" + table + "-B")
b.dicDB[database][table][0] = bt.arbolB(b.grade)
serializar.commit(b, "BDD")
except:
pass
return r
def loadCSV(file: str, database: str, table: str) -> list:
try:
b.dicDB[database][table][0] = serializar.rollback(database + "-" + table + "-B")
except:
pass
r = b.loadCSV(file, database, table)
try:
serializar.commit(b.dicDB[database][table][0], database + "-" + table + "-B")
b.dicDB[database][table][0] = bt.arbolB(b.grade)
serializar.commit(b, "BDD")
except:
pass
return r
def insert(database: str, table: str, register: list) -> int:
try:
b.dicDB[database][table][0] = serializar.rollback(database + "-" + table + "-B")
except:
pass
r = b.insert(database, table, register)
try:
serializar.commit(b.dicDB[database][table][0], database + "-" + table + "-B")
b.dicDB[database][table][0] = bt.arbolB(b.grade)
serializar.commit(b, "BDD")
except:
pass
return r
# File: B Mode Package
# License: Released under MIT License
# Notice: Copyright (c) 2020 TytusDB Team
from storage.b import DataBase as db
from storage.b import Serializable as serializar
from storage.b import Estructura_ArbolB as bt
b = db.DB()
try:
b = serializar.rollback("BDD")
except:
serializar.commit(b, "BDD")
#---------------------FUNCIONES BASES DE DATOS----------------------#
def createDatabase(database: str) -> int:
r = b.createDatabase(database)
serializar.commit(b, "BDD")
return r
def showDatabases() -> list:
return b.showDatabases()
def alterDatabase(databaseOld, databaseNew) -> int:
r = b.alterDatabase(databaseOld, databaseNew)
serializar.commit(b, "BDD")
#para encriptar y desencriptar
from cryptography.fernet import Fernet
MODES = ['avl', 'b', 'bplus', 'dict', 'isam', 'json', 'hash']
HEX_SYMBOLS = [
"0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "A", "B", "C", "D", "E",
"F"
]
VALID_ENCODING = ["utf8", "iso-8859-1", "ascii"]
DB_NAME_PATTERN = "^[a-zA-Z][a-zA-Z0-9#@$_]*"
# Obteniendo la lista general de bases de datos a partir del binario almacenado
# Si no existe el binario, se crea una nueva lista de bases de datos y se almacena
# el binario
try:
databases = Serializable.rollback("lista_bases_de_datos")
except FileNotFoundError:
databases = DBList()
Serializable.commit(databases, "lista_bases_de_datos")
# Descripción:
# Crea una nueva base de datos
# Parámetros:
# database:str - El nombre de la nueva base de datos
# mode:str - El modo de almacenamiento a utilizar en la base de datos
# encoding:str - La codificación utilizada por la base de datos
# Valores de Retorno:
# 0 - Operación exitosa
# 1 - Error en la operación
# 2 - Base de datos existente
