MySQL_Project/saveAIRPORT.py at main · mayank3135432/MySQL_Project · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
from PyQt5.QtCore import *

from PyQt5.QtGui import *

from PyQt5.QtWidgets import *

from PyQt5.uic import loadUiType

import sys

import mysql.connector as con


ui,_=loadUiType('/home/ateium/SQL_PROJECT/saveAIRPORT.ui')


class MainApp(QWidget,ui):

    def __init__(self):

        QWidget.__init__(self)

        self.setupUi(self)

        self.b1.clicked.connect(self.savedb)


    def savedb(self):

        try:

            mydb = con.connect(host="localhost",user="root", password="admin",db="AIRPORT")

            cursor = mydb.cursor()

            AP_NAME = self.tb1.text()

            COUNTRY = self.tb2.text()

            CITY_NAME = self.tb3.text()

            qry = "insert into AIRPORT values(%s,%s,%s)"

            value = (AP_NAME, COUNTRY, CITY_NAME)

            cursor.execute(qry,value)

            mydb.commit()

            QMessageBox.information(self,"DB Insert","Contacts saved successfully")

        except Exception as e:

            print(e)

            QMessageBox.information(self,"DB Insert","Error in save db")

def main():

    app = QApplication(sys.argv)

    window = MainApp()

    window.show()

    app.exec_()


if __name__ == '__main__':

    main()