def form_btn_click(self): """checks textboxes of form, if name, surname, door and plate number is provided; adds car into database """ elem_list = {} keys = self.form_boxes.keys() for key in keys: elem_list[key] = self.form_boxes[key].text() result = self.form_check(elem_list) if result == True: conf = Fconfig(CONFIG_FILE) db_name = conf.get_db_name() car = CarRecorder(elem_list, db_name) car.add_car(CAR_TABLE) self.set_view_tab()
def set_view_tab(self): """sets view tab, which would be used to view database and delete records from database. """ x_size = int(self.conf.get_config("view")["table_size_x"]) y_size = int(self.conf.get_config("view")["table_size_y"]) db_name = self.conf.get_db_name() viewer = CarRecorder(credentials={}, db_name=db_name) car_info = viewer.get_table_info(CAR_TABLE) columns = self.conf.get_table_fields(CAR_TABLE) self.view_table.setColumnCount(len(columns)) self.view_table.setRowCount(len(car_info)) col_str = ",".join(columns) self.view_table.setHorizontalHeaderLabels(QtCore.QString(col_str).split(",")) self.view_table.resize(x_size, y_size) self.tabs.addTab(self.view_tab, "View Cars") for i in range(0, len(car_info)): for idx, val in enumerate(columns): self.view_table.setItem(i, idx, QtGui.QTableWidgetItem(car_info[i][val]))
def set_view_tab(self): """sets view tab, which would be used to view database and delete records from database. """ x_size = \ int(self.conf.get_config('view')['table_size_x']) y_size = \ int(self.conf.get_config('view')['table_size_y']) db_name = self.conf.get_db_name() viewer = CarRecorder(credentials={}, db_name=db_name) car_info = viewer.get_table_info(CAR_TABLE) columns = self.conf.get_table_fields(CAR_TABLE) self.view_table.setColumnCount(len(columns)) self.view_table.setRowCount(len(car_info)) col_str = ','.join(columns) self.view_table.setHorizontalHeaderLabels \ (QtCore.QString(col_str).split(',')) self.view_table.resize(x_size, y_size) self.tabs.addTab(self.view_tab, "View Cars") for i in range(0, len(car_info)): for idx, val in enumerate(columns): self.view_table.setItem(i, idx, QtGui.QTableWidgetItem( car_info[i][val]))