def Handle_LogIn(self):
print("button pressed")
db = DatabaseManager(self.db_file_loc, self.protected_table_prefix)
username = self.user_name_tf.text()
password = self.password_tf.text()
try:
if db.is_valid_string(username) and db.is_valid_string(password):
#Both user name and password have to be valid strings to continue
if not db.doesTableExist(self.account_info_table_name):
print("Must create account before")
#Gets the account from the databse with the same password
#If the isn't a match then it returns none
row_with_entered_pass = db.get_row_at(
self.account_info_table_name,
column_name=account_columns[0],
column_value=password)
# print(row_with_entered_pass)
if not row_with_entered_pass == None:
#If the there is a password match then save the info
password_db = row_with_entered_pass[0]
user_name_db = row_with_entered_pass[1]
if password_db == password and user_name_db == username:
#If the user name and password entered match the
#user name and password in the db then it's a valid login
self.valid_login()
else:
ErrorBox = QtWidgets.QMessageBox()
ErrorBox.warning(
self, 'No Account Found',
"No account found for the combination of user name and password",
ErrorBox.Ok)
else:
ErrorBox = QtWidgets.QMessageBox()
ErrorBox.warning(
self, 'No Account Found',
"No account found for the combination of user name and password",
ErrorBox.Ok)
else:
raise Exception()
except:
ErrorBox = QtWidgets.QMessageBox()
ErrorBox.critical(
self, 'Text Entry Error',
"Text entries can only have letters numbers, and underscores",
ErrorBox.Ok)
class DatabaseManagerTester(unittest.TestCase):
def setUp(self):
sqlite_file = 'test.db'
self.db = DatabaseManager(sqlite_file, '__ADMIN__')
filename = "Test_Files/DatabaseManagerTest_15.csv"
self.ingestor = Ingestor(filename)
self.ingestor.readCSV()
tempHeaders = self.ingestor.getCSVHeaders()
self.searchCritera = [
tempHeaders[0], tempHeaders[1], tempHeaders[2], tempHeaders[4],
tempHeaders[5], tempHeaders[6]
]
searchCriteraTwoD = self.ingestor.getHeaderIndex(
self.searchCritera, tempHeaders)
self.ingestor.searchRows(searchCriteraTwoD, self.ingestor.getRows())
self.searchCritera = self.db.remove_spaces(self.searchCritera)
self.new_table = 'Test_15'
def test_create_new_table(self):
self.assertTrue(
self.db.create_table_list(self.new_table, self.searchCritera,
'string'))
def test_add_row_list(self):
self.assertTrue(
self.db.add_list_of_rows(self.new_table, self.searchCritera,
self.ingestor.getRows()))
def test_get_headers(self):
expectedReturn = [
'Street_Address', "owner's_first_name", 'last_name', 'email',
'phone_Number', 'Loan_Amount'
]
self.assertEqual(self.db.get_headers(self.new_table), expectedReturn)
def test_get_table(self):
pass
def test_get_table_names(self):
tables_in_db = self.db.get_table_names()
self.assertTrue(self.new_table in tables_in_db)
def test_get_row_at_with_column(self):
column_to_use = "72 Pearson Drive"
row_from_db = self.db.get_row_at(self.new_table,
column_name=self.searchCritera[0],
column_value=column_to_use)
expectedRetun = [
u'72 Pearson Drive', u'Bartholemy', u'Parnaby',
u'*****@*****.**', u'+55 (385) 326-3642', u'$44,795.68 '
]
#The lists are the same but it doesn't think they are equal
#self.assertEqual(row_from_db,expectedRetun)
def test_get_row_at_with_rowid(self):
rowid = 3
row_from_db = self.db.get_row_at(self.new_table, row_id=rowid)
expectedRetun = [
u'72 Pearson Drive', u'Bartholemy', u'Parnaby',
u'*****@*****.**', u'+55 (385) 326-3642', u'$44,795.68 '
]
#self.assertEqual(row_from_db,expectedRetun)
def test_delete_row(self):
rowid = 9
rowToDel = self.db.get_row_at(self.new_table, row_id=rowid)
rowAfterToDel = self.db.get_row_at(self.new_table, row_id=rowid + 1)
self.db.delete_row_at(self.new_table, rowid)
self.assertEqual(self.db.get_row_at(self.new_table, row_id=rowid),
rowAfterToDel)
def test_update_row(self):
rowid = 9
old_row = self.db.get_row_at(self.new_table, row_id=rowid)
updated_row1 = [
"a house", "josh", "green", "*****@*****.**",
"228-192-2819", "$2.17"
]
self.db.update_row_at(self.new_table,
primary_key=rowid,
new_row=updated_row1)
self.assertTrue(old_row is not updated_row1)
class Ui_CalendarForm(QtWidgets.QDialog):
calendar_to_lists_signal = QtCore.pyqtSignal()
calendar_to_login_signal = QtCore.pyqtSignal()
def __init__(self, db_file, protected_table_prefix):
try:
super().__init__()
self.setupUi()
# for the table
self.protected_table_prefix = protected_table_prefix
self.db = DatabaseManager(db_file, self.protected_table_prefix)
self.db_file_loc = db_file
self.event_info_table_name = protected_table_prefix + "Event_Information"
except Exception as er:
print('Error message:', er.args[0])
return False
# creates method that handles the add event button and opens the dialog window
def EventButton_handler(self):
try:
self.ui_update = Ui_Dialog('programData.db', '__ADMIN__')
self.ui_update.calendar_dialog_signal.connect(self.offpass)
self.ui_update.exec_()
except Exception as er:
print('Error message:', er.args[0])
return False
#self.calendar.
#passes
def offpass(self):
pass
# creates method that handles lists page button and changes widget to the show lists page
def handle_listsPageButton(self):
self.calendar_to_lists_signal.emit()
# creates method that handles the profile page button and it opens the profile page
def handle_profilePageButton(self):
try:
self.createProfileWidget = UI_ProfilePage()
self.createProfileWidget.create_account_done_signal.connect()
self.createProfileWidget.exec_()
except Exception as er:
print('Error message:', er.args[0])
return False
# creates method that handles the search page button and it should open the show list ui page
def handle_searchPageButton(self):
try:
self.calendar_to_login_signal.emit()
except Exception as er:
print('Error message:', er.args[0])
return False
# creates method that handles the home page button and it just refreshes the page
def handle_homePageButton(self):
self.update()
# creates a method that sets the label on the page to the date that is selected from the calendar
def showDate(self, date):
try:
dater = date.toString("MM-dd-yy")
self.label.setText(dater)
if not self.db.doesTableExist(self.event_info_table_name):
self.label_3.setText('No events')
row = self.db.get_row_at(self.event_info_table_name,
Event_Columns[0], dater)
if not row == None:
self.label_3.setText(row[1])
else:
self.label_3.setText('No events')
except Exception as er:
print('Error message:', er.args[0])
return False
def setupUi(self):
# auto generated code from Qt Designer, creates all elements of the page
try:
self.setObjectName("CalendarForm")
self.setEnabled(True)
self.resize(1650, 950)
self.setLayoutDirection(QtCore.Qt.LeftToRight)
self.setAutoFillBackground(True)
self.CompNameLabel = QtWidgets.QLabel(self)
self.CompNameLabel.setGeometry(QtCore.QRect(0, 0, 300, 75))
font = QtGui.QFont()
font.setFamily("MS Shell Dlg 2")
font.setPointSize(16)
font.setBold(True)
font.setItalic(False)
font.setWeight(75)
self.CompNameLabel.setFont(font)
self.CompNameLabel.setAutoFillBackground(True)
self.CompNameLabel.setFrameShape(QtWidgets.QFrame.NoFrame)
self.CompNameLabel.setFrameShadow(QtWidgets.QFrame.Plain)
self.CompNameLabel.setTextFormat(QtCore.Qt.AutoText)
self.CompNameLabel.setScaledContents(False)
self.CompNameLabel.setAlignment(QtCore.Qt.AlignCenter)
self.CompNameLabel.setWordWrap(False)
self.CompNameLabel.setObjectName("CompNameLabel")
self.calendar = QtWidgets.QCalendarWidget(self)
self.calendar.setGeometry(QtCore.QRect(75, 175, 750, 700))
font = QtGui.QFont()
font.setFamily("MS Shell Dlg 2")
font.setPointSize(8)
font.setBold(False)
font.setItalic(False)
font.setUnderline(False)
font.setWeight(50)
font.setStrikeOut(False)
font.setKerning(True)
self.calendar.setFont(font)
self.calendar.setLayoutDirection(QtCore.Qt.LeftToRight)
self.calendar.setAutoFillBackground(True)
self.calendar.setFirstDayOfWeek(QtCore.Qt.Sunday)
self.calendar.setGridVisible(True)
self.calendar.setSelectionMode(
QtWidgets.QCalendarWidget.SingleSelection)
self.calendar.setHorizontalHeaderFormat(
QtWidgets.QCalendarWidget.LongDayNames)
self.calendar.setVerticalHeaderFormat(
QtWidgets.QCalendarWidget.NoVerticalHeader)
self.calendar.setNavigationBarVisible(True)
self.calendar.setDateEditEnabled(True)
self.calendar.setObjectName("calendar")
self.horizontalLayoutWidget = QtWidgets.QWidget(self)
self.horizontalLayoutWidget.setGeometry(
QtCore.QRect(1410, 100, 160, 80))
self.horizontalLayoutWidget.setObjectName("horizontalLayoutWidget")
self.horizontalLayout = QtWidgets.QHBoxLayout(
self.horizontalLayoutWidget)
self.horizontalLayout.setContentsMargins(0, 0, 0, 0)
self.horizontalLayout.setObjectName("horizontalLayout")
self.EventButton = QtWidgets.QPushButton(
self.horizontalLayoutWidget)
self.EventButton.setIconSize(QtCore.QSize(20, 20))
self.EventButton.setCheckable(False)
self.EventButton.setAutoRepeat(False)
self.EventButton.setAutoDefault(False)
self.EventButton.setFlat(False)
self.EventButton.setObjectName("EventButton")
self.horizontalLayout.addWidget(self.EventButton)
self.horizontalLayoutWidget_2 = QtWidgets.QWidget(self)
self.horizontalLayoutWidget_2.setGeometry(
QtCore.QRect(1110, 0, 461, 76))
self.horizontalLayoutWidget_2.setObjectName(
"horizontalLayoutWidget_2")
self.horizontalLayout_2 = QtWidgets.QHBoxLayout(
self.horizontalLayoutWidget_2)
self.horizontalLayout_2.setContentsMargins(0, 0, 0, 0)
self.horizontalLayout_2.setObjectName("horizontalLayout_2")
self.HomePageButton = QtWidgets.QPushButton(
self.horizontalLayoutWidget_2)
self.HomePageButton.setObjectName("HomePageButton")
self.horizontalLayout_2.addWidget(self.HomePageButton)
self.ListsPageButton = QtWidgets.QPushButton(
self.horizontalLayoutWidget_2)
self.ListsPageButton.setObjectName("ListsPageButton")
self.horizontalLayout_2.addWidget(self.ListsPageButton)
self.SearchPageButton = QtWidgets.QPushButton(
self.horizontalLayoutWidget_2)
self.SearchPageButton.setObjectName("SearchPageButton")
self.horizontalLayout_2.addWidget(self.SearchPageButton)
self.label = QtWidgets.QLabel(self)
self.label.setGeometry(QtCore.QRect(975, 159, 150, 50))
font = QtGui.QFont()
font.setPointSize(22)
font.setBold(True)
font.setWeight(75)
self.label.setFont(font)
self.label.setAutoFillBackground(False)
self.label.setObjectName("label")
self.label_2 = QtWidgets.QLabel(self)
self.label_2.setGeometry(QtCore.QRect(875, 134, 300, 100))
font = QtGui.QFont()
font.setPointSize(20)
font.setBold(True)
font.setUnderline(True)
font.setWeight(75)
self.label_2.setFont(font)
self.label_2.setAutoFillBackground(False)
self.label_2.setObjectName("label_2")
self.label_3 = QtWidgets.QTextBrowser(self)
self.label_3.setGeometry(QtCore.QRect(875, 250, 700, 625))
self.label_3.setAutoFillBackground(False)
self.label_3.setAlignment(QtCore.Qt.AlignTop)
self.label_3.setObjectName("label_3")
self.label_3.setFontPointSize(20)
self.label_4 = QtWidgets.QLabel(self)
self.label_4.setGeometry(QtCore.QRect(925, 775, 100, 50))
font = QtGui.QFont()
font.setBold(False)
font.setUnderline(True)
font.setWeight(50)
self.label_4.setFont(font)
self.label_4.setAutoFillBackground(False)
self.label_4.setObjectName("label_4")
self.label_5 = QtWidgets.QLabel(self)
self.label_5.setGeometry(QtCore.QRect(925, 825, 100, 50))
font = QtGui.QFont()
font.setUnderline(True)
self.label_5.setFont(font)
self.label_5.setAutoFillBackground(False)
self.label_5.setObjectName("label_5")
self.line = QtWidgets.QFrame(self)
self.line.setGeometry(QtCore.QRect(10, 75, 1630, 20))
self.line.setFrameShape(QtWidgets.QFrame.HLine)
self.line.setFrameShadow(QtWidgets.QFrame.Sunken)
self.line.setObjectName("line")
self.retranslateUi()
# these lines create connects to the buttons with there corresponding methods
self.calendar.clicked[QtCore.QDate].connect(self.showDate)
date = self.calendar.selectedDate()
self.ListsPageButton.clicked.connect(self.handle_listsPageButton)
self.SearchPageButton.clicked.connect(self.handle_searchPageButton)
self.HomePageButton.clicked.connect(self.handle_homePageButton)
self.EventButton.clicked.connect(self.EventButton_handler)
QtCore.QMetaObject.connectSlotsByName(self)
except Exception as er:
print('Error message:', er.args[0])
return False
# code that is auto generated from Qt Designer
def retranslateUi(self):
_translate = QtCore.QCoreApplication.translate
self.setWindowTitle(_translate("CalendarForm", "Calendar"))
self.CompNameLabel.setText(
_translate("CalendarForm", "Chicago Turnkey Properties"))
self.EventButton.setText(_translate("CalendarForm", "Add Event"))
self.HomePageButton.setText(_translate("CalendarForm", "Home"))
self.ListsPageButton.setText(_translate("CalendarForm", "Leads Page"))
self.SearchPageButton.setText(_translate("CalendarForm", "Sign out"))
self.label.setText(_translate("CalendarForm", ""))
self.label_2.setText(_translate("CalendarForm", "Event:"))
self.label_3.setText(_translate("CalendarForm", " "))
self.label_4.setText(_translate("CalendarForm", ""))
self.label_5.setText(_translate("CalendarForm", ""))
class Ui_MainWindow(QtWidgets.QWidget):
log_out_signal = QtCore.pyqtSignal()
goto_profile_signal = QtCore.pyqtSignal()
goto_calendar_signal = QtCore.pyqtSignal()
def __init__(self, db_file, protected_table_prefix):
super().__init__()
self.protected_table_prefix = protected_table_prefix
self.db = DatabaseManager(db_file, self.protected_table_prefix)
self.tables_in_db = self.db.get_table_names()
self.db_file_loc = db_file
self.curr_table = None
def setup_main_widget(self, width, height):
"""
Sets up the widgets for the window
"""
#self.centralwidget = QtWidgets.QWidget()
#self.centralwidget.setObjectName("centralwidget")
#self = QtWidgets.QWidget()
self.setGeometry(QtCore.QRect(0, 0, width, height))
self.setObjectName("gridLayoutWidget")
self.gridLayout = QtWidgets.QGridLayout(self)
self.gridLayout.setContentsMargins(5, 5, 5, 5)
self.gridLayout.setSpacing(5)
self.gridLayout.setObjectName("gridLayout")
#Search bar text entry
self.searchBar = QtWidgets.QLineEdit(self)
self.searchBar.setPlaceholderText("Search Term")
self.searchBar.returnPressed.connect(self.get_search_key)
self.searchBar.setObjectName("SearchBar")
self.gridLayout.addWidget(self.searchBar, 1, 2, 1, 1)
self.searchBar.setMaximumWidth(500)
self.scrollArea = QtWidgets.QScrollArea(self)
#self.scrollArea.setHorizontalScrollBarPolicy(QtCore.Qt.ScrollBarAlwaysOn)
self.scrollArea.setWidgetResizable(True)
self.scrollArea.setObjectName("scrollArea")
#Scroll Window
self.table = QtWidgets.QTableWidget(20, 10)
self.table.cellDoubleClicked.connect(self.table_item_clicked)
self.scrollArea.setWidget(self.table)
self.gridLayout.addWidget(self.scrollArea, 3, 0, 1, 4)
self.searchButton = QtWidgets.QPushButton("Search Table", self)
self.searchButton.setObjectName("searchButton")
self.searchButton.clicked.connect(self.get_search_key)
self.gridLayout.addWidget(self.searchButton, 1, 3, 1, 1)
#Create combo box with the ability to switch tables
self.comboBox = QtWidgets.QComboBox(self)
self.comboBox.setObjectName("comboBox")
self.add_combo_box_items(self.db.get_table_names(), self.comboBox)
self.comboBox.activated.connect(self.switch_curr_table_comboBox)
self.gridLayout.addWidget(self.comboBox, 1, 0, 1, 1)
QtCore.QMetaObject.connectSlotsByName(self)
print(self.tables_in_db)
if (self.tables_in_db != []):
print(self.tables_in_db[0])
print("Tables in db")
self.set_curr_table_name(self.tables_in_db[0])
self.update_table(self.db.get_table(self.tables_in_db[0]),
self.db.get_headers(self.tables_in_db[0]))
else:
print("Nothing in db")
pass
def setup_menu_bar(self):
"""
Sets up the menu bar. Main windows have their own menu bar and this
provides a menu bar on completion
"""
#Menu Bar
self.menubar = QtWidgets.QMenuBar()
self.menubar.setDefaultUp(False)
self.menubar.setNativeMenuBar(True)
fileMenu = self.menubar.addMenu("File")
fileMenu.addAction("Home", self.switchCalendar)
fileMenu.addAction("Log Out", self.log_out)
editMenu = self.menubar.addMenu("Edit")
editMenu.addAction('Import CSV', self.open_csv_import)
editMenu.addSeparator()
editMenu.addAction('Clear Table', self.clear_table)
editMenu.addAction('Delete Table', self.delete_table)
self.viewMenu = self.menubar.addMenu("View")
self.add_menu_items(self.db.get_table_names(),
self.viewMenu.addMenu("Switch Table"))
self.viewMenu.addAction("Update Table", self.update_menu_action)
return self.menubar
def update_table(self, row_list, header_list):
"""
Updates the contents of the table using a list of rows
and a list of column headers
"""
#Get the table in the windows
table = self.get_table()
#Set the number of rows and the number of column
#Using the lists from parameters
table.setRowCount(len(row_list))
table.setColumnCount(len(header_list))
table.setHorizontalHeaderLabels(header_list)
#Adds the rows of data
self.add_items(table, row_list)
#Resizes the cells to fit text without clipping
#1 = stretch to max string length
#table.horizontalHeader().setSectionResizeMode(1)
table.resizeColumnsToContents()
table.setSelectionBehavior(QtWidgets.QTableView.SelectRows)
self.set_table(table)
def add_items(self, table, row_list):
"""
Adds a list of rows to the table
"""
row_count = 0
for row in row_list:
self.add_item(table, row_count, row)
row_count += 1
def add_item(self, table, row_num, row):
"""
Adds a row to the table by creating table widgets
The text in the widget is aligned in the center
"""
col = 0
for value in row:
if type(value) == int:
value = str(value)
item = QtWidgets.QTableWidgetItem(value)
#item.setFlags(QtCore.Qt.ItemIsEditable)
item.setFlags(QtCore.Qt.ItemIsEnabled)
#item.setFlags(QtCore.Qt.ItemIsSelectable)
#0x0080 align vertical centered
#0x0004 align horizontally centered
item.setTextAlignment(0x0080 | 0x0004)
table.setItem(row_num, col, item)
col = col + 1
def set_table(self, new_table):
"""
Sets the current windows table to the paramater table
"""
self.table = new_table
def get_table(self):
"""
Returns the table in the window
"""
return self.table
def update_menu_action(self):
"""
Updates table when button is pressed
"""
self.update_table(self.db.get_table(self.curr_table),
self.db.get_headers(self.curr_table))
# if self.curr_table == None
# self.set_curr_table_name()
def open_csv_import(self):
"""
Opens the file browser and the csv importer window. On completion
the table is updated to the imported table
"""
#https://stackoverflow.com/questions/4838890/python-pyqt-popup-window
#Explained how to make another widget pop up
#Key is to make a widget and use self.widget
file = file_browser("File Browser").openFileNameDialog()
if (file != None):
self.csv_importer = csv_importer_popup("CSV Importer",
self.db_file_loc,
self.tables_in_db,
self.protected_table_prefix)
#This links the import signal to the import close window
self.csv_importer.importDoneSignal.connect(self.import_closed)
self.csv_importer.run_popup(file)
#Runs to the window
self.csv_importer.exec_()
def import_closed(self, str):
"""
When the csv importer is closed a signal is emitted with the table
name of the imported table. It updates various refernces to the table name
"""
#This method is called when the import window closed
print('Refreshing table')
#Call the update menu action to refresh the table
self.set_curr_table_name(str)
self.update_view_menu()
self.update_combobox()
self.update_menu_action()
def set_curr_table_name(self, new_table_name):
"""
Sets the current table to the paramater
"""
self.curr_table = new_table_name
def switch_curr_table_menubar(self):
"""
When a view -> switch table option is clicked it changes the current
Table to the option's text and refreshes the table
"""
self.set_curr_table_name(self.menubar.sender().text())
self.update_menu_action()
def switch_curr_table_comboBox(self, selectedItem):
"""
When a combo box option is clicked it changes the current
Table to the option's text and refreshes the table
"""
#print(self.tables_in_db[selectedItem])
self.set_curr_table_name(self.tables_in_db[selectedItem])
self.update_menu_action()
def add_menu_items(self, table_names, menu):
"""
Adds a action to the menu provided by creating new actions using the
table names list inputed
"""
for name in table_names:
menu.addAction(name, self.switch_curr_table_menubar)
def add_combo_box_items(self, table_names, comboBox):
"""
Creates combo box entries for each table in the data base. Each entry
is clickable and when clicked will update the table
"""
for name in table_names:
comboBox.addItem(name)
def clear_table(self):
"""
Clears the current table and verifies if the users wants to clear it
"""
choice = QtWidgets.QMessageBox.question(
self, 'Confirmation',
"Are you sure you want to clear \"%s\" table? \nTHIS OPERATION IS NOT RECOVERABLE"
% self.curr_table,
QtWidgets.QMessageBox.Yes | QtWidgets.QMessageBox.No)
if choice == QtWidgets.QMessageBox.Yes:
self.db.clear_table(self.curr_table)
self.update_menu_action()
def delete_table(self):
"""
Delete the current table and verifies if the users wants to delete it
"""
choice = QtWidgets.QMessageBox.question(
self, 'Confirmation',
"Are you sure you want to delete \"%s\" table? \nTHIS OPERATION IS NOT RECOVERABLE"
% self.curr_table,
QtWidgets.QMessageBox.Yes | QtWidgets.QMessageBox.No)
if choice == QtWidgets.QMessageBox.Yes:
self.db.delete_table(self.curr_table)
self.update_view_menu()
self.update_combobox()
if (self.tables_in_db != []):
self.set_curr_table_name(self.tables_in_db[0])
self.update_table(self.db.get_table(self.tables_in_db[0]),
self.db.get_headers(self.tables_in_db[0]))
else:
self.set_curr_table_name(None)
self.update_table([], [])
def update_view_menu(self):
"""
Updates the options in the view -> switch table menu to display
any new tables that were added during an import
"""
self.viewMenu.clear()
self.tables_in_db = self.db.get_table_names()
self.add_menu_items(self.tables_in_db,
self.viewMenu.addMenu("Switch Table"))
self.viewMenu.addAction("Update Table", self.update_menu_action)
def update_combobox(self):
"""
Updates the options in the switch table combo box to display
any new tables that were added during an import
"""
self.comboBox.clear()
self.add_combo_box_items(self.tables_in_db, self.comboBox)
def table_item_clicked(self, row, column):
"""
When a cell is clicked inside the table this retrieves its row
from the data base for the pop up window to display
"""
#The double clicked signal returns the row and column of the
#double clicked item. It will automatically pass those into the method
#if the paramaters are row and column
selectedRow = self.db.get_row_at(table_name=self.curr_table,
row_id=row + 1)
columHeaders = self.db.get_headers(self.curr_table)
Table_name = self.curr_table
self.profilePage = UI_ProfilePage(list(selectedRow), columHeaders,
self.curr_table, self.db_file_loc,
self.protected_table_prefix, row + 1)
self.profilePage.rejected.connect(self.save_profile)
#self.profilePage.filltable(columnHeaders,selectedRow)
#The selected row is returned as a tuple. It is converted to a list
self.profilePage.filltable()
def save_profile(self):
self.update_menu_action()
def get_search_key(self):
"""
Gets the text from the search bar and checks if it is a valid entry. If so
then pass it to the search table method
"""
# print("CLICKED")
try:
key = self.searchBar.displayText()
if (self.db.is_valid_string(key)):
# print(key)
self.search_table(key)
elif (key == ""):
self.update_menu_action()
except:
QtWidgets.QMessageBox.critical(
self, 'Invalid Text',
"Search values can only have alphanumeric values",
QtWidgets.QMessageBox.Ok)
def search_table(self, search_key):
"""
Searches the database for the search key inputed
"""
rows = self.db.search_table(search_key, self.curr_table)
self.update_table(rows, self.db.get_headers(self.curr_table))
def log_out(self):
print("Logging out\nEmitting signal")
self.log_out_signal.emit()
def switchCalendar(self):
self.goto_calendar_signal.emit()
print('\nPrinting table headers')
print(db.get_headers(new_table))
print('\nPrinting all table entries')
print(db.get_table(new_table))
print("\nPrinting the names of non-protected tables in the database")
print(db.get_table_names())
print("\nPrinting the names of all tables in the database")
print(db.get_table_names(exclude_protected=False))
print("\nGet row with address %s (columns)" % ingestor.getRowAt(2)[0])
print(
db.get_row_at(new_table,
column_name=searchCritera[0],
column_value=ingestor.getRowAt(2)[0]))
print(
"\nGet row with address using column and 1435 North St. Should return nothing"
)
print(db.get_row_at(new_table, searchCritera[0], "1435 North St."))
print(
"\nGet row with address using column and 88730 Barby Park Should return something"
)
print(db.get_row_at(new_table, searchCritera[0], "88730 Barby Park"))
test_row = 9
rowToBeDel = db.get_row_at(new_table, row_id=test_row)
