Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- self.terr_list_drop = QtGui.QComboBox(self.centralwidget)
- self.terr_list_drop.setGeometry(QtCore.QRect(20, 90, 161, 21))
- self.terr_list_drop.setObjectName(_fromUtf8("terr_list_drop"))
- self.terr_list_drop.addItem(_fromUtf8("All Cards"))
- self.terr_list_drop.addItem(_fromUtf8("Available Cards"))
- self.terr_list_drop.addItem(_fromUtf8("Unavailable Cards"))
- self.terr_list_drop.activated[str].connect(self.card_query)
- self.terr_list_view_btn = QtGui.QPushButton(self.centralwidget)
- self.terr_list_view_btn.setGeometry(QtCore.QRect(200, 90, 75, 23))
- self.terr_list_view_btn.setObjectName(_fromUtf8("terr_list_view_btn"))
- self.connect(self.terr_list_drop, QtCore.SIGNAL('activated(int)'), self.setCurrentIndex)
- def cards_unavailable():
- c.execute("SELECT * FROM Cards WHERE CheckStatus='Out'")
- data = c.fetchall()
- for row in data:
- print("CardID: ",row[0])
- print("Status: ",row[1])
- print("PubID: ",row[2])
- print("Last Checked Out: ",row[3])
- print("Last Checked In: ",row[4])
- def cards_available():
- c.execute("SELECT * FROM Cards WHERE CheckStatus='In'")
- data = c.fetchall()
- for row in data:
- print("CardID: ",row[0])
- print("Status: ",row[1])
- print("PubID:",row[2])
- print("Last Checked Out: ",row[3])
- print("Last Checked In: ",row[4])
- def cards_all():
- c.execute("SELECT * FROM Cards")
- data = c.fetchall()
- for row in data:
- print("CardID: ",row[0])
- print("Status: ",row[1])
- print("PubID: ",row[2])
- print("Last Checked Out: ",row[3])
- print("Last Checked In: ",row[4])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement