@raven-worx can you help how to get data in QLineEdit going to my database by Clicking Submit button? here is my code i am using python 2.17.13
import os
import sys
import mysql.connector
from PyQt4.QtSql import *
from PyQt4.QtGui import *
from PyQt4.QtCore import *
from PyQt4 import QtGui, QtCore
class Window(QtGui.QMainWindow):
def init(self):
super(Window, self).init()
self.setGeometry(50,50,0,0)
self.setFixedSize(900,600)
self.setWindowTitle("IMS Delta EarthMoving")
self.setWindowIcon(QtGui.QIcon('delta.png'))
pic = QtGui.QLabel(self)
pic.setGeometry(240, -165, 698, 500)
pic.setPixmap(QtGui.QPixmap(os.getcwd() + "/delta2.png"))
self.Input()
self.search()
self.button()
self.database()
def search(self):
assetSearch = QLabel("Asset search",self)
assetSearch.move(10,10)
AssetTag=QLineEdit(self)
fbox=QFormLayout()
fbox.addRow(AssetTag)
AssetTag.move(75,15)#left-right and up-down
AssetTag.resize(150,20)
def Input(self):
INPUT1LABEL = QLabel("INPUT1",self)
INPUT1LABEL.move(10,225)
INPUT1 = QLineEdit(self)
fbox=QFormLayout()
fbox.addRow(INPUT1)
INPUT1.move(75,230)
INPUT1.resize(150,20)
btnSubmit = QtGui.QPushButton("Submit",self)
btnSubmit.clicked.connect(self.submit_function)
btnSubmit.resize(btnSubmit.minimumSizeHint())
btnSubmit.move(150,470)
def button(self):
btnQuit = QtGui.QPushButton("Quit", self)
btnQuit.clicked.connect(self.close_application)
btnQuit.resize(btnQuit.minimumSizeHint())
btnQuit.move(150,138) #.move(left-right,top-bottom()
btnSearch = QtGui.QPushButton("Search", self)
#btnSearch.clicked.connect(self.) #add function for this ButtonBox
btnSearch.resize(btnSearch.minimumSizeHint())
btnSearch.move(150,40)
btnUpdate = QtGui.QPushButton("Update",self)
btnUpdate.clicked.connect(self.update_confirmation)
btnUpdate.resize(btnUpdate.minimumSizeHint())
btnUpdate.move(150,90)
btnDelete = QtGui.QPushButton("Delete",self)
#btnDelete.clicked.connect(self.) add function for this ButtonBox
btnDelete.resize(btnDelete.minimumSizeHint())
btnDelete.move(150,114)
self.show()
def close_application(self):
choice = QtGui.QMessageBox.question(self, 'Exit',"Are you sure?",QtGui.QMessageBox.Yes | QtGui.QMessageBox.No)
if choice == QtGui.QMessageBox.Yes:
sys.exit()
else:
pass
def update_confirmation(self):
choice = QtGui.QMessageBox.question(self,'Notice!',"Are you sure?",QtGui.QMessageBox.Yes | QtGui.QMessageBox.No)
if choice == QtGui.QMessageBox.Yes:
#put the function here!
choice = QtGui.QMessageBox.question(self,'IMS',"Query saved",QtGui.QMessageBox.Ok)
if choice == QtGui.QMessageBox.Ok:
pass
else:
pass
def submit_function(self):
con = mysql.connector.connect(user="root",password="admingelo",host="localhost",database="test")
manager = con.cursor()
Date = 'Ai'
Name = 'g'
Sex = 'g'
insert_this_data = ("INSERT INTO test_table(name,age,sex) VALUES(%s,%s,%s)")
data = (Date,Name,Sex)
manager.execute(insert_this_data,data)
con.commit()
print "Insert Successful!"
def database(self): #Table data view
table = QTableWidget(self)
db = QSqlDatabase.addDatabase("QMYSQL")
db.setHostName("localhost")
db.setDatabaseName("test")
db.setUserName("root")
db.setPassword("admingelo")
if (db.open()==False):
QMessageBox.critical(None, "Database Error",
db.lastError().text())
query = QSqlQuery ("SELECT * FROM sfo")
table.setColumnCount(query.record().count())
table.setRowCount(query.size())
index=0
while (query.next()):
table.setItem(index,0,QTableWidgetItem(query.value(0).toString()))
table.setItem(index,1,QTableWidgetItem(query.value(1).toString()))
table.setItem(index,2,QTableWidgetItem(query.value(2).toString()))
table.setItem(index,3,QTableWidgetItem(query.value(3).toString()))
table.setItem(index,4,QTableWidgetItem(query.value(4).toString()))
table.setItem(index,5,QTableWidgetItem(query.value(5).toString()))
index = index+1
table.show()
table.resize(618,360)
table.move(240,230)
def run():
app = QtGui.QApplication(sys.argv)
GUI = Window()
sys.exit(app.exec_())
run()
