时间戳

首页 > 解决方案 > 在 Python 中：一次将 QtableWidget 中的所有条目插入数据库表

python - 在 Python 中：一次将 QtableWidget 中的所有条目插入数据库表

问题描述

想知道是否有人知道如何使用 python 将 qtablewidget 的所有条目插入数据库。到目前为止，我发现了这个编码：

# Creating a query for later execution using .prepare()
insertDataQuery = QSqlQuery()
insertDataQuery.prepare(
    """
    INSERT INTO contacts (
        name,
        job,
        email
    )
    VALUES (?, ?, ?)
    """
)

# Sample data
data = [
    ("Joe", "Senior Web Developer", "joe@example.com"),
    ("Lara", "Project Manager", "lara@example.com"),
    ("David", "Data Analyst", "david@example.com"),
    ("Jane", "Senior Python Developer", "jane@example.com"),
]

# Use .addBindValue() to insert data
for name, job, email in data:
    insertDataQuery.addBindValue(name)
    insertDataQuery.addBindValue(job)
    insertDataQuery.addBindValue(email)
    insertDataQuery.exec()

我被困在将 qtablewidget 的条目分配给数据

标签： pythonpyqt5qtablewidget

解决方案

您可以使用以下方法：

# Ignore lazy imports
import sys
from typing import *

from PyQt5.QtCore import *
from PyQt5.QtGui import *
from PyQt5.QtSql import *
from PyQt5.QtWidgets import *

首先，让我们创建一个函数，该函数QTableWidget使用您提供的数据返回 a：

QTableWidget

def createTable() -> QTableWidget:
    """Let's create a QTableWidget with the data you provided."""

    data = [
        ("Joe", "Senior Web Developer", "joe@example.com"),
        ("Lara", "Project Manager", "lara@example.com"),
        ("David", "Data Analyst", "david@example.com"),
        ("Jane", "Senior Python Developer", "jane@example.com"),
    ]

    table = QTableWidget()

    table.setRowCount(len(data))
    table.setColumnCount(len(data[0]))

    for i, row in enumerate(data):
        for j, val in enumerate(row):
            table.setItem(i, j, QTableWidgetItem(val))

    return table

现在我们创建一个函数来从表中获取数据并以相同的格式返回它：

def getData(table: QTableWidget) -> List[Tuple[str]]:
    """Fetch the data from the QTableWidget and return it as `data`."""

    data = []
    for row in range(table.rowCount()):
        rowData = []
        for col in range(table.columnCount()):
            rowData.append(table.item(row, col).data(Qt.EditRole))
        data.append(tuple(rowData))

    return data

对于 db insert 部分，我们可以重用您提供的代码：

def insertData(data: List[Tuple[str]]) -> None:
    """Creating a query for later execution using .prepare()"""

    insertDataQuery = QSqlQuery()
    insertDataQuery.prepare(
        """
        INSERT INTO contacts (
            name,
            job,
            email
        )
        VALUES (?, ?, ?)
        """
    )
    # Use .addBindValue() to insert data
    for name, job, email in data:
        insertDataQuery.addBindValue(name)
        insertDataQuery.addBindValue(job)
        insertDataQuery.addBindValue(email)
        insertDataQuery.exec_()

    # Note that you need to run `QSqlDatabase().commit()`` if you want the data to be committed in the database.

现在把它们放在一起：

app = QApplication([sys.argv])

# Connect to sample database
sampleDb = QSqlDatabase.addDatabase("QSQLITE")
sampleDb.setDatabaseName("sample.sqlite")
sampleDb.open()


# Create table with sample data
table = createTable()

# Get data from table
data = getData(table)

# Insert data into the database
insertData(data)


sys.exit(app.exec_())

推荐阅读