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 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]))
