**Course Title:** PySide6 Application Development **Section Title:** Integrating Databases with PySide6 **Topic:** Building a simple CRUD app with SQLite and displaying data in a table.(Lab topic) **Objective:** In this lab topic, we will create a simple CRUD (Create, Read, Update, Delete) application using PySide6 that integrates with an SQLite database and displays data in a table. By the end of this topic, you will have hands-on experience with creating a database application and understanding how to interact with a database using PySide6. **Prerequisites:** * Familiarity with PySide6 and Qt * Understanding of SQL databases and CRUD operations * Experience with working with QSqlDatabase and QSqlQuery **Lab Overview:** We will create a simple contact management application that allows users to add, view, update, and delete contact information. We will use an SQLite database to store the contact information and a QTableView to display the data. **Step 1: Create the Database** First, we need to create an SQLite database. You can use a tool like DB Browser for SQLite to create a new database file. Name the database file "contacts.db". **Step 2: Design the Database Schema** Next, we need to design the database schema. We will create a single table called "contacts" with the following columns: | Column Name | Data Type | Description | | --- | --- | --- | | id | INTEGER PRIMARY KEY | Unique contact ID | | name | TEXT | Contact name | | email | TEXT | Contact email | | phone | TEXT | Contact phone number | Create the table using the following SQL statement: ```sql CREATE TABLE contacts ( id INTEGER PRIMARY KEY, name TEXT, email TEXT, phone TEXT ); ``` **Step 3: Create the PySide6 Application** Create a new PySide6 application using the following code: ```python import sys import sqlite3 from PySide6.QtCore import Qt, QCoreApplication from PySide6.QtGui import QAction from PySide6.QtWidgets import QApplication, QMainWindow, QTableView, QAbstractItemView from PySide6.QtSql import QSqlDatabase, QSqlQueryModel class MainWindow(QMainWindow): def __init__(self, parent=None): super(MainWindow, self).__init__(parent) self.setWindowTitle("Contact Management App") self.setGeometry(100, 100, 600, 400) self.table_view = QTableView(self) self.table_view.setAlternatingRowColors(True) self.table_view.setModel(self.create_model()) self.setCentralWidget(self.table_view) self.create_menu() self.show() def create_model(self): model = QSqlQueryModel() model.setQuery("SELECT * FROM contacts") return model def create_menu(self): menu = self.menuBar() edit_menu = menu.addMenu("Edit") add_action = QAction("Add Contact", self) add_action.triggered.connect(self.add_contact) edit_menu.addAction(add_action) edit_action = QAction("Edit Contact", self) edit_action.triggered.connect(self.edit_contact) edit_menu.addAction(edit_action) delete_action = QAction("Delete Contact", self) delete_action.triggered.connect(self.delete_contact) edit_menu.addAction(delete_action) def add_contact(self): # TO DO: implement add contact logic pass def edit_contact(self): # TO DO: implement edit contact logic pass def delete_contact(self): # TO DO: implement delete contact logic pass if __name__ == "__main__": app = QApplication(sys.argv) window = MainWindow() sys.exit(app.exec_()) ``` **Step 4: Implement CRUD Logic** Complete the `add_contact`, `edit_contact`, and `delete_contact` methods to implement the CRUD logic. **Additional Tips and Resources:** * Use the [PySide6 documentation](https://doc.qt.io/qtforpython/) as a reference for PySide6 and Qt functionality. * Use the [SQLite documentation](https://sqlite.org/lang.html) as a reference for SQL syntax and database operations. **What's Next:** In the next topic, we will cover introduction to multithreading in PySide6. **Leave a comment or ask for help** If you have any questions or need help with this lab topic, please leave a comment below.