· 8 years ago · Jul 14, 2018, 12:02 PM
1
2from PyQt5 import QtCore, QtGui #imports
3from PyQt5.QtWidgets import *
4from GUI9 import Ui_MainWindow
5from random import *
6import sqlite3
7import sys,os
8import datetime
9# c.execute('insert into tablename values (?,?,?)', item)
10
11class main(QMainWindow, Ui_MainWindow):
12 def __init__(self):
13 QMainWindow.__init__(self)
14 self.setupUi(self)
15 scriptDir = os.path.dirname(os.path.realpath(__file__))
16 self.setWindowIcon(QtGui.QIcon(scriptDir + os.path.sep + 'icon.jpg'))
17 #self.connection = sqlite3.connect(r'C:\Users\u s e r\Desktop\databasetest.db')
18 self.usernametb_2.setEchoMode(QLineEdit.Password)#Adding Pass chars ***
19 self.usernametb_3.setEchoMode(QLineEdit.Password)#Adding Pass chars ***
20 self.usernametb_6.setEchoMode(QLineEdit.Password)
21 self.usernametb_7.setEchoMode(QLineEdit.Password)
22
23
24 with sqlite3.connect('D:\database5.db') as conn:
25 conn.execute('''CREATE TABLE IF NOT EXISTS TechnicalReport
26 (Name TEXT NOT NULL,
27 Phone_Number INT NOT NULL,
28 Issue TEXT NOT NULL,
29 Issue_Number INT NOT NULL,
30 Date TEXT NOT NULL,
31 Notes TEXT NOT NULL);''')
32 """conn.execute('''CREATE TABLE IF NOT EXISTS TechnicalReportDemoData
33 (Name TEXT NOT NULL,
34 Phone_Number INT NOT NULL,
35 Issue TEXT NOT NULL,
36 Issue_Number INT NOT NULL,
37 Date TEXT NOT NULL,
38 Repaired TEXT NOT NULL,
39 Notes TEXT NOT NULL);''')
40 conn.execute('''CREATE TABLE IF NOT EXISTS TechnicalReportDemoData2
41 (Name TEXT NOT NULL,
42 Phone_Number INT NOT NULL,
43 Issue TEXT NOT NULL,
44 Issue_Number INT NOT NULL,
45 Date TEXT NOT NULL,
46 Repaired TEXT NOT NULL,
47 Notes TEXT NOT NULL);''')"""
48 conn.execute('''CREATE TABLE IF NOT EXISTS SellsReportNormal
49 (Item TEXT NOT NULL,
50 Item_Price INT NOT NULL,
51 Amount INT NOT NULL,
52 Total_Price INT NOT NULL,
53 Date TEXT NOT NULL);''')
54 #######################################
55 conn.execute('''CREATE TABLE IF NOT EXISTS Sells
56 (Item TEXT NOT NULL,
57 Price INT NOT NULL,
58 Selling_Price INT NOT NULL,
59 Buying_Price INT NOT NULL,
60 Profit_Money INT NOT NULL);''')
61
62 #######################################
63 conn.execute('''
64 CREATE TABLE IF NOT EXISTS Errors
65 (Error TEXT);''')
66 conn.execute('''
67 CREATE TABLE IF NOT EXISTS Phone_Numbers
68 (Name TEXT NOT NULL,
69 Phone INT NOT NULL,
70 Information TEXT NOT NULL);''')
71 try:
72 self.connection = sqlite3.connect('D:\database5.db')
73 self.query = "SELECT * FROM Sells"
74 self.result = self.connection.execute(self.query)
75 self.query2 = "SELECT * FROM SellsReportNormal"
76 self.result2 = self.connection.execute(self.query2)
77
78 self.query4 = "SELECT * FROM TechnicalReport"
79 self.result4 = self.connection.execute(self.query4)
80
81
82 self.username = 'admin'
83 self.password = 'admin'
84 self.devuser = 'admin'
85 self.devpass = 'lufmelufuhatemefku'
86
87 self.stackedWidget.setCurrentIndex(0) #############################
88 self.usernametb_2.setEchoMode(QLineEdit.Password)
89 self.usernametb_3.setEchoMode(QLineEdit.Password)
90 self.pushButton.clicked.connect(self.login)
91
92 self.pushButton_3.clicked.connect(self.loaddata)
93 self.pushButton_4.clicked.connect(self.logout)
94 self.pushButton_2.clicked.connect(self.sell)
95 self.pushButton_5.clicked.connect(self.itemspro)
96 self.pushButton_6.clicked.connect(self.loaddatareport)
97 self.pushButton_7.clicked.connect(self.insertdatatechnicalreport)
98 self.pushButton_8.clicked.connect(self.loaddatatechnicalreport)
99 self.pushButton_9.clicked.connect(self.deleteclient)
100 self.pushButton_11.clicked.connect(self.gotonormal)
101 self.pushButton_12.clicked.connect(self.loadsellsreportpro)
102 self.pushButton_13.clicked.connect(self.insertitemsells)
103 self.pushButton_14.clicked.connect(self.deletesellitem)
104 self.pushButton_15.clicked.connect(self.calculatedaymoney)
105 self.pushButton_16.clicked.connect(self.previouspage)
106 self.pushButton_17.clicked.connect(self.loaddataphonenumbers)
107 self.pushButton_18.clicked.connect(self.insertdataphonenumbers)
108 self.pushButton_19.clicked.connect(self.search)
109 self.pushButton_31.clicked.connect(self.login2)
110 self.pushButton_34.clicked.connect(self.logout2)
111 self.pushButton_32.clicked.connect(self.loadErrors)
112 self.pushButton_33.clicked.connect(self.executesql)
113 self.pushButton_35.clicked.connect(self.executepy)
114 self.x = 1
115 self.tableWidget_3.setRowCount(self.x)
116 #self.loaddatatechnicalreport()
117 except Exception as e:
118 with sqlite3.connect('D:\database5.db') as conn:
119 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
120 error = errortime+' - Error in Connections and Button ->'+str(e)
121 print(error)
122 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
123 def search(self):
124 items = self.tableWidget.findItems(
125 self.lineEdit_5.text(), QtCore.Qt.MatchRecursive)
126 if items:
127 searchresult = self.tableWidget.item(items[0].row(), 0)
128 self.tableWidget.scrollToItem(searchresult, QAbstractItemView.PositionAtCenter)
129 self.tableWidget.selectRow(items[0].row())
130
131
132 def executepy(self):
133 try:
134 executetext = self.lineEdit_4.text()
135 exec(executetext)
136 except Exception as e:
137 with sqlite3.connect('D:\database5.db') as conn:
138 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
139 error = errortime+' - While Clicking ExecutePy in Developer Section ->'+str(e)
140 print(error)
141 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
142 def loadsellsreportpro(self):
143 try:
144 self.query = "SELECT * FROM Sells"
145 self.result = self.connection.execute(self.query)
146 self.tableWidget_6.setRowCount(0)
147 for row_number, row_data in enumerate(self.result):
148 self.tableWidget_6.insertRow(row_number)
149 for column_number, data in enumerate(row_data):
150 self.tableWidget_6.setItem(row_number,column_number,QTableWidgetItem(str(data)))
151 except Exception as e:
152 with sqlite3.connect('D:\database5.db') as conn:
153 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
154 error = errortime+' - While Clicking LoadSellsReport in pro ->'+str(e)
155 print(error)
156 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
157 def calculatedaymoney(self):
158 try:
159 items_money = []
160 rowcount = self.tableWidget_2.rowCount()
161 for i in range(rowcount):
162 items_money.append(int(self.tableWidget_2.item(i,3).text()))
163 msgbx = QMessageBox.information(window, "Today's Money", "Today's Money is: %d"%(sum(items_money)))
164 except Exception as e:
165 with sqlite3.connect('D:\database5.db') as conn:
166 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
167 error = errortime+' - While Clicking Calculate in SellsReport Section ->'+str(e)
168 print(error)
169 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
170 def previouspage(self):
171 try:
172 self.stackedWidget_4.setCurrentIndex(0)
173 except Exception as e:
174 with sqlite3.connect('D:\database5.db') as conn:
175 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
176 error = errortime+' - While Clicking Previous Page in Itemspro section ->'+str(e)
177 print(error)
178 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
179 def itemspro(self):
180 try:
181 self.stackedWidget_4.setCurrentIndex(1)
182
183 self.tableWidget_4.setRowCount(0)
184 for row_number, row_data in enumerate(self.result2):
185 self.tableWidget_4.insertRow(row_number)
186 for column_number, data in enumerate(row_data):
187 self.tableWidget_4.setItem(row_number,column_number,QTableWidgetItem(str(data)))
188 except Exception as e:
189 with sqlite3.connect('D:\database5.db') as conn:
190 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
191 error = errortime+' - While Clicking itemspro in items Section ->'+str(e)
192 print(error)
193 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
194 def insertitemsells(self):
195 try:
196 with sqlite3.connect("D:\database5.db") as conn:
197 self.item = self.tableWidget_7.item(0,0).text()
198 self.real_price = self.tableWidget_7.item(0,1).text()
199 self.selling_price = self.tableWidget_7.item(0,2).text()
200 self.buying_price = self.tableWidget_7.item(0,3).text()
201 self.profit_money = self.tableWidget_7.item(0,4).text()
202 self.sellsall = (self.item,self.real_price,self.selling_price,self.buying_price,self.profit_money)
203 with sqlite3.connect('D:\database5.db') as conn:
204
205 conn.execute("INSERT INTO Sells (Item,Price,Selling_Price,Buying_Price,Profit_Money) VALUES (?,?,?,?,?)",self.sellsall);
206 self.techreportdata =conn.execute("SELECT * FROM Sells")
207 self.tableWidget_7.setRowCount(0)
208 self.tableWidget_7.setRowCount(1)
209
210 self.tableWidget_6.setRowCount(0)
211 for row_number, row_data in enumerate(self.techreportdata):
212 self.tableWidget_6.insertRow(row_number)
213 for column_number, data in enumerate(row_data):
214 self.tableWidget_6.setItem(row_number,column_number,QTableWidgetItem(str(data)))
215 except Exception as e:
216 with sqlite3.connect('D:\database5.db') as conn:
217 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
218 error = errortime+' - While Clicking Insert Item in Itemspro Section ->'+str(e)
219 print(error)
220 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
221 def deletesellitem(self):
222 try:
223 rowidd = int(self.lineEdit_2.text())
224 with sqlite3.connect('D:\database5.db') as conn:
225 conn.execute("DELETE FROM Sells WHERE _rowid_ =?",(rowidd,));
226 self.loadsellsreportpro()
227 except Exception as e:
228 with sqlite3.connect('D:\database5.db') as conn:
229 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
230 error = errortime+' - While Clicking Delete Item in Itemspro section ->'+str(e)
231 print(error)
232 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
233 def deleteclient(self):
234 try:
235 issuenum = int(self.lineEdit_3.text())
236 with sqlite3.connect('D:\database5.db') as conn:
237 conn.execute("DELETE FROM TechnicalReport WHERE Issue_Number =?",(issuenum,));
238 self.loaddatatechnicalreport()
239 except Exception as e:
240 with sqlite3.connect('D:\database5.db') as conn:
241 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
242 error = errortime+' - While Clicking Delete Client in Technical Section ->'+str(e)
243 print(error)
244 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
245 def gotoadvanced(self):
246 try:
247 self.stackedWidget_2.setCurrentIndex(1)
248 except Exception as e:
249 with sqlite3.connect('D:\database5.db') as conn:
250 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
251 error = errortime+' - While Clicking Go To Advanced ->'+str(e)
252 print(error)
253 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
254 def gotonormal(self):
255 try:
256 self.stackedWidget_2.setCurrentIndex(0)
257 except Exception as e:
258 with sqlite3.connect('D:\database5.db') as conn:
259 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
260 error = errortime+' - While Clicking Go to normal ->'+str(e)
261 print(error)
262 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
263 def sell(self):
264 try:
265 self.loaddatareport()
266 self.date = datetime.datetime.today().strftime('%d-%m-%Y')
267 self.itemnum = int(self.lineEdit.text())-1
268 self.amount = int(self.spinBox.value())
269 self.total = int(self.tableWidget.item(self.itemnum,2).text())*self.amount
270 self.itemProp =(self.tableWidget.item(self.itemnum,0).text(),self.tableWidget.item(self.itemnum,2).text(),self.amount,self.total,self.date)
271 self.itemPropAdvanced = (self.tableWidget.item(self.itemnum,0).text(), self.tableWidget.item(self.itemnum,2).text(),self.amount,self.total,0,self.date,0,0)
272 with sqlite3.connect('D:\database5.db') as conn:
273 """conn.execute('''CREATE TABLE IF NOT EXISTS SellsReportNormal
274 (Item TEXT NOT NULL,
275 Item_Price INT NOT NULL,
276 Amount INT NOT NULL,
277 Total_Price INT NOT NULL,
278 Date TEXT NOT NULL);''')
279 #######################################
280 conn.execute('''
281 CREATE TABLE IF NOT EXISTS SellsReportPro
282 (Item TEXT NOT NULL,
283 Item_Price INT NOT NULL,
284 Sold_Amount INT NOT NULL,
285 Total_Price INT NOT NULL,
286 Remain_Amount INT NOT NULL,
287 Date TEXT NOT NULL,
288 Buying_Price INT NOT NULL,
289 Profit_Money INT NOT NULL);''')"""
290 self.connection = sqlite3.connect('D:\database5.db')
291 conn.execute("INSERT INTO SellsReportNormal (Item,Item_Price,Amount,Total_Price, Date) VALUES (?,?,?,?,?)",self.itemProp);
292 print(self.itemProp)
293 msgbx = QMessageBox.information(window, "Sold", "Item Has Been Sold") #warning , information , critical , about
294 except Exception as e:
295 with sqlite3.connect('D:\database5.db') as conn:
296 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
297 error = errortime+' - While Clicking Sell ->'+str(e)
298 print(error)
299 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
300 def login(self):
301 try:
302 if self.usernametb_2.text() == self.username and self.usernametb_3.text() == self.password:
303 self.stackedWidget.setCurrentIndex(1)
304 self.tableWidget.setRowCount(1)
305 self.stackedWidget_3.setCurrentIndex(0)
306 self.stackedWidget_4.setCurrentIndex(0)
307 self.tabWidget.setCurrentIndex(0)
308 else:
309 self.pushButton.setText("ERROR")
310 except Exception as e:
311 with sqlite3.connect('D:\database5.db') as conn:
312 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
313 error = errortime+' - While Clicking Login In Main Program ->'+str(e)
314 print(error)
315 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
316 def logout(self):
317 try:
318 self.stackedWidget.setCurrentIndex(0)
319 self.pushButton.setText("Login")
320 self.usernametb_2.setText("")
321 self.usernametb_3.setText("")
322 except Exception as e:
323 with sqlite3.connect('D:\database5.db') as conn:
324 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
325 error = errortime+' - While Clicking Logout In Main Program ->'+str(e)
326 print(error)
327 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
328 def login2(self):
329 try:
330 if self.usernametb_6.text() == self.devuser and self.usernametb_7.text() == self.devpass:
331 self.stackedWidget_3.setCurrentIndex(1)
332 else:
333 self.pushButton_31.setText("ERROR")
334 except Exception as e:
335 with sqlite3.connect('D:\database5.db') as conn:
336 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
337 error = errortime+' - While Clicking Login in Developer Section ->'+str(e)
338 print(error)
339 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
340 def logout2(self):
341 try:
342 self.stackedWidget_3.setCurrentIndex(0)
343 self.pushButton_31.setText("Login")
344 self.usernametb_6.setText("")
345 self.usernametb_7.setText("")
346 except Exception as e:
347 with sqlite3.connect('D:\database5.db') as conn:
348 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
349 error = errortime+' - While Clicking Logout in Developer Section ->'+str(e)
350 print(error)
351 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
352 def loadErrors(self):
353 try:
354 self.errorquery = "SELECT * FROM Errors"
355 self.errorresult = self.connection.execute(self.errorquery)
356 for rownum,rowdata in enumerate(self.errorresult):
357 for column_number,data in enumerate(rowdata):
358 self.textEdit.append(str(data))
359 except Exception as e:
360 with sqlite3.connect('D:\database5.db') as conn:
361 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
362 error = errortime+' - While Clicking Load Errors in Developer Section ->'+str(e)
363 print(error)
364 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
365 def executesql(self):
366 try:
367 with sqlite3.connect('D:\database5.db') as conn:
368 executetext = self.textEdit.toPlainText()
369 conn.execute(executetext);
370 except Exception as e:
371 with sqlite3.connect('D:\database5.db') as conn:
372 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
373 error = errortime+' - While Clicking Execute SQL in Developer Section ->'+str(e)
374 print(error)
375 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
376
377
378 def loaddata(self):
379 try:
380 self.query = "SELECT * FROM Sells"
381 self.result = self.connection.execute(self.query)
382 self.tableWidget.setRowCount(0)
383 for row_number, row_data in enumerate(self.result):
384 self.tableWidget.insertRow(row_number)
385 for column_number, data in enumerate(row_data):
386 self.tableWidget.setItem(row_number,column_number,QTableWidgetItem(str(data)))
387 except Exception as e:
388 with sqlite3.connect('D:\database5.db') as conn:
389 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
390 error = errortime+' - While Clicking Load Data in items Section ->'+str(e)
391 print(error)
392 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
393
394 def loaddatareport(self):
395 try:
396 self.query2 = "SELECT * FROM SellsReportNormal"
397 self.result2 = self.connection.execute(self.query2)
398
399 self.tableWidget_2.setRowCount(0)
400 for row_number, row_data in enumerate(self.result2):
401 self.tableWidget_2.insertRow(row_number)
402 for column_number, data in enumerate(row_data):
403 self.tableWidget_2.setItem(row_number,column_number,QTableWidgetItem(str(data)))
404 except Exception as e:
405 with sqlite3.connect('D:\database5.db') as conn:
406 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
407 error = errortime+' - While Clicking Load Data in Sells Report Section ->'+str(e)
408 print(error)
409 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
410
411 def loaddatatechnicalreport(self):
412 try:
413 global rowcount
414 self.query4 = "SELECT * FROM TechnicalReport"
415 self.result4 = self.connection.execute(self.query4)
416 self.tableWidget_3.setRowCount(0)
417 for row_number, row_data in enumerate(self.result4):
418 self.tableWidget_3.insertRow(row_number)
419 for column_number, data in enumerate(row_data):
420 self.tableWidget_3.setItem(row_number,column_number,QTableWidgetItem(str(data)))
421 except Exception as e:
422 with sqlite3.connect('D:\database5.db') as conn:
423 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
424 error = errortime+' - While Clicking Load Data in Technical Section ->'+str(e)
425 print(error)
426 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
427
428 def loaddataphonenumbers(self):
429 try:
430 global rowcount
431 self.query4 = "SELECT * FROM Phone_Numbers"
432 self.result4 = self.connection.execute(self.query4)
433 self.tableWidget_8.setRowCount(0)
434 for row_number, row_data in enumerate(self.result4):
435 self.tableWidget_8.insertRow(row_number)
436 for column_number, data in enumerate(row_data):
437 self.tableWidget_8.setItem(row_number,column_number,QTableWidgetItem(str(data)))
438 except Exception as e:
439 with sqlite3.connect('D:\database5.db') as conn:
440 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
441 error = errortime+' - While Clicking Load Data in Phone Numbers ->'+str(e)
442 print(error)
443 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
444
445 def insertdatatechnicalreport(self):
446 try:
447 global rowcount
448 #self.loaddatatechnicalreport()
449 with sqlite3.connect("D:\database5.db") as conn:
450 self.name = self.tableWidget_5.item(0,0).text()
451 self.phone = self.tableWidget_5.item(0,1).text()
452 self.issue = self.tableWidget_5.item(0,2).text()
453 self.issuenum = self.tableWidget_5.item(0,3).text()
454 self.Date = self.tableWidget_5.item(0,4).text()
455 self.notes = self.tableWidget_5.item(0,5).text()
456 self.techreport =(self.name,self.phone,self.issue,self.issuenum,self.Date,self.notes)
457 with sqlite3.connect('D:\database5.db') as conn:
458
459 conn.execute("INSERT INTO TechnicalReport (Name,Phone_Number,Issue,Issue_Number,Date,Notes) VALUES (?,?,?,?,?,?)",self.techreport);
460 self.techreportdata =conn.execute("SELECT * FROM TechnicalReport")
461 self.tableWidget_5.setRowCount(0)
462 self.tableWidget_5.setRowCount(1)
463
464 self.tableWidget_3.setRowCount(0)
465 for row_number, row_data in enumerate(self.techreportdata):
466 self.tableWidget_3.insertRow(row_number)
467 for column_number, data in enumerate(row_data):
468 self.tableWidget_3.setItem(row_number,column_number,QTableWidgetItem(str(data)))
469 except Exception as e:
470 with sqlite3.connect('D:\database5.db') as conn:
471 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
472 error = errortime+' - While Clicking Insert Data in Technical Section ->'+str(e)
473 print(error)
474 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
475
476 def insertdataphonenumbers(self):
477 try:
478 global rowcount
479 #self.loaddatatechnicalreport()
480 with sqlite3.connect("D:\database5.db") as conn:
481 self.name = self.tableWidget_9.item(0,0).text()
482 self.phone = self.tableWidget_9.item(0,1).text()
483 self.information = self.tableWidget_9.item(0,2).text()
484 self.techreport =(self.name,self.phone,self.information)
485 with sqlite3.connect('D:\database5.db') as conn:
486
487 conn.execute("INSERT INTO Phone_Numbers (Name,Phone,Information) VALUES (?,?,?)",self.techreport);
488 self.techreportdata =conn.execute("SELECT * FROM Phone_Numbers")
489 self.tableWidget_9.setRowCount(0)
490 self.tableWidget_9.setRowCount(1)
491
492 self.tableWidget_8.setRowCount(0)
493 for row_number, row_data in enumerate(self.techreportdata):
494 self.tableWidget_8.insertRow(row_number)
495 for column_number, data in enumerate(row_data):
496 self.tableWidget_8.setItem(row_number,column_number,QTableWidgetItem(str(data)))
497 except Exception as e:
498 with sqlite3.connect('D:\database5.db') as conn:
499 errortime = datetime.datetime.now().strftime("%H:%M - %d/%m/%Y")
500 error = errortime+' - While Clicking Load Data in Phone Numbers ->'+str(e)
501 print(error)
502 conn.execute('INSERT INTO Errors (Error) VALUES(?)',(error,));
503
504 #self.loaddatatechnicalreport()
505
506
507
508 #with sqlite3.connect('D:\databasetest3.db') as conn:
509 # conn.execute("INSERT INTO SellsReport3 (Item, Sold_With, Date) VALUES (?,?,?)",self.itemProp);
510
511 #self.connection.close()
512app = QApplication(sys.argv)
513window = main()
514window.show()
515app.exec_()