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