def cmd_extractTable(self, nombreBase, nombreTabla, where, listaCampos,
listaSelect):
#if existeTabla(nombreTabla, nombreBase) == 1:
ob = pn.DevolverTabla(self.tabla)
mc.listadoResp = mc.devolverTabla(
ob.ejecutarNumpy(nombreBase, nombreTabla, where, listaCampos,
listaSelect))
EDDResp.extractTable(condb.extractTable(nombreBase, nombreTabla))
def cmd_showDatabases(self):
mc.listadoResp = condb.showDatabases()
print(mc.listadoResp)
EDDResp.showdatabase(condb.showDatabases())
def cmd_alterTable(self, database, tableOld, tableNew):
if existeTabla(tableOld, database) == 1:
self.tabla.modificarNombreTabla_TS(database, tableOld, tableNew)
EDDResp.alterTable(condb.alterTable(database, tableOld, tableNew))
def cmd_alterDropPK(self, database, table):
if existeTabla(table, database) == 1:
EDDResp.alterDropPK(condb.alterDropPK(database, table))
def cmd_alterAddPK(self, database, table, columns):
if existeTabla(table, database) == 1:
EDDResp.alterAddPK(condb.alterAddPK(database, table, columns))
def cmd_extractRangeTable(self, database, table, lower, upper):
if existeTabla(table, database) == 1:
EDDResp.extractRangeTable(
condb.extractRangeTable(database, table, lower, upper))
def cmd_createTable(self, database, table, numberColumns):
if verificarTablaDuplicada(table, database) == 1:
self.tabla.agregaraTS('0', table, 'tabla', database, '', '')
EDDResp.createtable(
condb.createTable(database, table, numberColumns))
def dropDatabase(self, database):
if existeBase(database) == 1:
self.tabla.eliminarTS_Base(database)
EDDResp.dropdatabase(condb.dropDatabase(database))
def cmd_alterDatabase(self, databaseOld, databaseNew):
if existeBase(databaseOld) == 1:
self.tabla.modificarTS_Base(databaseOld, databaseNew)
EDDResp.alterdatabase(condb.alterDatabase(databaseOld,
databaseNew))
def cmd_showDatabases(self):
EDDResp.showdatabase(condb.showDatabases())
def cmd_createdatabase(self, database):
if verificarBasesDuplicada(database) == 1:
self.tabla.agregaraTS('0', database, 'base', 'global', '', '')
EDDResp.createdatabase(condb.createDatabase(database))