def showTable(self, options):
table = options['table']
db = options['db']
display_query = "SELECT * from " + table
rows = query.query(display_query, db, self.screen, None, None, self.username, self.password)
tableDisplay.navigate(rows,0,0,self.screen)
self.screen.clear()
def showTable(self, options):
table = options['table']
db = options['db']
display_query = "SELECT * from " + table
rows = query.query(display_query, db, self.screen, None, None,
self.username, self.password)
tableDisplay.navigate(rows, 0, 0, self.screen)
self.screen.clear()
def run(self, string, currentDB):
result = query.query(string, currentDB, self.screen)
if result == -1:
error.throw(self.screen, "The query did not succeed.")
self.screen.clear()
elif result == 0:
error.throw(self.screen, "The query was succesful.")
self.screen.clear()
q = "INSERT INTO queries_history (query) VALUES (%s)"
query.query(q, 'queries', None, None, string)
else:
self.screen.clear()
tableDisplay.navigate(result, 0, 0, self.screen)
self.screen.clear()
q = "INSERT INTO queries_history (query) VALUES (%s)"
query.query(q, 'queries', None, None, string)
def run(self, string, currentDB):
result = query.query(string, currentDB, self.screen)
if result == -1:
error.throw(self.screen, "The query did not succeed.")
self.screen.clear()
elif result == 0:
error.throw(self.screen, "The query was succesful.")
self.screen.clear()
q = "INSERT INTO queries_history (query) VALUES (%s)"
query.query(q, 'queries', None, None, string)
else:
self.screen.clear()
tableDisplay.navigate(result, 0, 0, self.screen)
self.screen.clear()
q = "INSERT INTO queries_history (query) VALUES (%s)"
query.query(q, 'queries', None, None, string)