def alterDatabase(databaseOld, databaseNew):
try:
if not existDB(databaseOld):
return 2
if existDB(databaseNew):
return 3
return alterDB(databaseOld, databaseNew)
except:
return 1
def createDatabase(database: str):
try:
if existDB(database):
return 2
return insertDB(database)
except:
return 1
def dropDatabase(database:str):
try:
if not existDB(database):
return 2
return dropDB(database)
except:
return 1
def insert(database: str, table: str, register: list):
try:
if not existDB(database): return 2
if not existTable(database, table): return 3
return insertRegistro(database, table, register)
except:
return 1
def extractRow(database: str, table: str, columns: list):
try:
if not existDB(database): return []
if not existTable(database, table): return []
return extraerPorColumna(database, table, columns)
except:
return []
def extractTable(database: str, table: str):
try:
if not existDB(database): return None
if not existTable(database, table): return None
return extraerRegistros(database, table)
except:
return 1
def alterAddPK(database: str, table: str, columns: list):
try:
if not existDB(database): return 2
if not existTable(database, table): return 3
return alterAPK(database, table, columns)
except:
return 1
def alterDropColumn(database: str, table: str, columnNumber: int):
try:
if not existDB(database): return 2
if not existTable(database, table): return 3
return dropColumn(database, table, columnNumber)
except:
return 1
def truncate(database: str, table: str):
try:
if not existDB(database): return 2
if not existTable(database, table): return 3
return truncateRegistros(database, table)
except:
return 1
def alterAddColumn(database: str, table: str, default: any):
try:
if not existDB(database): return 2
if not existTable(database, table): return 3
return addColumn(database, table, default)
except:
return 1
def update(database: str, table: str, register: dict, columns: list):
try:
if not existDB(database): return 2
if not existTable(database, table): return 3
return updateRegistro(database, table, register, columns)
except:
return 1
def delete(database: str, table: str, columns: list):
try:
if not existDB(database): return 2
if not existTable(database, table): return 3
return deleteRegistro(database, table, columns)
except:
return 1
def alterDropPK(database: str, table: str):
try:
if not existDB(database): return 2
if not existTable(database, table): return 3
return alterDPK(database, table)
except:
return 1
def showTables(database: str):
try:
if not existDB(database):
return None
return showTBS(database)
except:
return None
def extractRangeTable(database: str, table: str, columnNumber: int, lower: any,
upper: any):
try:
if not existDB(database): return None
if not existTable(database, table): return None
return extraerRango(database, table, columnNumber, lower, upper)
except:
return 1
def extractTable(database: str, table: str):
try:
if not existDB(database): return None
if not existTable(database, table): return None
return extraerRegistros(database, table)
except Exception:
import traceback
traceback.print_exc()
return
def createTable(database: str, table: str, numberColumns: int):
try:
if not existDB(database):
return 2
if existTable(database,table):
return 3
return insertTable(database, table, Estructura(numberColumns) )
except:
return 1
def dropTable(database: str, table: str):
try:
if not existDB(database):
return 2
if not existTable(database, table):
return 3
return dropTB(database, table)
except:
return 1
def alterTable(database: str, tableOld: str, tableNew: str):
try:
if not existDB(database):
return 2
if not existTable(database, tableOld):
return 3
if existTable(database,tableNew):
return 4
return alterTB(database,tableOld, tableNew)
except:
return 1
