def FuncConnectDataBase(self):
try:
self.database = self.ChooseDataBase.currentText()
Connect = connection.connecttoserver("localhost","root","mysql123.installer",self.database)
Connect.commit()
self.connect.emit(self.database)
self.close()
except:
QMessageBox.information(self,"Warning!","Connection failed!")
def GetTables(self):
self.Connect = connection.connecttoserver("localhost", "root",
"mysql123.installer",
self.dbname)
cursor = self.Connect.cursor()
cursor.execute("SHOW TABLES")
self.listoftables = cursor.fetchall()
self.listoftables = [
i[0] for i in self.listoftables
] #change to list, in we have tables name in some database
def FuncChooseTable(self):
self.Connect = connection.connecttoserver("localhost", "root",
"mysql123.installer",
self.dbname)
self.cursor = self.Connect.cursor()
self.table = self.ChooseTable.currentText()
#take columns names and display to tablewidget
self.cursor.execute(f"SHOW COLUMNS FROM {self.table}")
columns = self.cursor.fetchall()
self.num_of_col = len(columns)
self.Values.setColumnCount(self.num_of_col)
for i, columnname in enumerate(columns):
self.Values.setHorizontalHeaderItem(
i, QTableWidgetItem(columnname[0]))
def CreateTable(self):
name = self.NameNewTable.text()
fields = self.Query.text()
try:
Connect = connection.connecttoserver("localhost", "root",
"mysql123.installer",
self.dbname)
cursor = Connect.cursor()
cursor.execute(f"CREATE TABLE {name} ({fields})")
Connect.commit()
QMessageBox.information(self, "Warning!", "SUCCESS!")
self.close()
except:
QMessageBox.information(self, "Warning!", "FAILED!")