SmartAdSolutions/remove_user.py at master · RamanPndy/SmartAdSolutions · 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
__author__ = 'Raman Pandey'

import ui_remove_user
from PyQt4.Qt import *
from PyQt4 import Qt,uic,QtCore,QtGui
from PyQt4.QtSql import *
from PyQt4.QtCore import *
from PyQt4.QtGui import *
import sqlite3,os,sys

# removeuserbase,removeuserform = uic.loadUiType('ui_RemoveUser.ui')
class RemoveUser(QDialog,ui_remove_user.Ui_Dialog):
    def __init__(self,scanMan,parent=None):
        super(RemoveUser,self).__init__(parent)
        # self.ui = Ui_Dialog()
        self.setupUi(self)
        self._parent = parent
        self._scanMan = scanMan
        # self.setupUi(self)
        if(os.path.exists("smartusers.db")):
            self.initView()
        QtCore.QObject.connect(self.removeButton,QtCore.SIGNAL("clicked()"),self.getUserRemoveData)
        QtCore.QObject.connect(self.cancelButton,QtCore.SIGNAL("clicked()"),self.cancelDlg)
        QtCore.QObject.connect(self.removeUsersCombo,QtCore.SIGNAL("currentIndexChanged(const QString&)"),self.clearRemoveLabel)

    def cancelDlg(self):
        self.close()

    def clearRemoveLabel(self):
        self.userRemoveStatus.setText("")

    def getUserRemoveData(self):
        self.username= str(self.removeUsersCombo.currentText())
        # print "user tO bE REMOVED : " + self.username
        if(self.username == ""):
            msgbox = QtGui.QMessageBox()
            msgbox.setWindowIcon(QtGui.QIcon(QtGui.QPixmap(':/resources/Icon.png')))
            msgbox.setWindowTitle("Information")
            msgbox.setText('There Is No User To Be Removed!!!')
            msgbox.setStandardButtons(QtGui.QMessageBox.Ok)
            msgbox.exec_()
            return
        else:
            conn = sqlite3.connect('smartusers.db')
            cur = conn.cursor()
            # query = "INSERT into users VALUES('"+str(self.userID.text())+"','"+str(self.userPassword.text())+"')"
            # cur.execute("INSERT into users VALUES('"+str(self.userID.text())+"','"+str(self.userPassword.text())+"')")
            cur.executescript("DELETE FROM users WHERE username = '"+self.username+"' ")
            conn.commit()
            print("Deleted")
            self.initView()
            self.userRemoveStatus.setText("User Removed!")
            # self._parent.displayTableData()
            # self._parent.addUserPanel.dbFetchOp()

    def initView(self):
        DATABASE_NAME = "smartusers.db"
        db = QSqlDatabase.addDatabase("QSQLITE")
        db.setDatabaseName(DATABASE_NAME)
        db.open()
        self.model = QSqlTableModel()
        self.model.setTable("users")
        self.model.select()
        self.removeUsersCombo.setModel(self.model)
        self._parent.leftpanelUserInfo.usersCombo.setModel(self.model)
        db.close()