在PyQt中，我想将两个lineEdit信息添加到csv文件的特定列中。

Question

在PyQt中，我想将两个lineEdit信息添加到csv文件的特定列中。

3

我想在csv的特定列中添加来自singerLine和titleSong的信息。我的数据库看起来像这个csv图片所示。

当点击“添加歌曲”按钮时，我想将这些数据添加到第3列（歌曲）和第4列（歌手）。这是我部分的代码（我知道它还不正确，而且我对pyqt很陌生）。

from PyQt5 import QtCore, QtGui, QtWidgets
from PyQt5.QtWidgets import QMessageBox
import sys
import csv


class QuitMessage(QtWidgets.QMessageBox):
  def __init__(self):
    QtWidgets.QMessageBox.__init__(self)
    self.setText("Really want to quit?")
    self.addButton(self.No)
    self.addButton(self.Yes)


class musicAdminUI(object):
  def setupUi(self, musicAdmin):
    musicAdmin.setObjectName("musicAdmin")
    musicAdmin.resize(734, 601)
    musicAdmin.setMinimumSize(QtCore.QSize(734, 601))
    musicAdmin.setMaximumSize(QtCore.QSize(734, 601))
    icon = QtGui.QIcon()
    icon.addPixmap(QtGui.QPixmap("musicIcon.gif"), QtGui.QIcon.Normal, 
    QtGui.QIcon.Off)
    musicAdmin.setWindowIcon(icon)
    self.exitButton = QtWidgets.QPushButton(musicAdmin)
    self.exitButton.setGeometry(QtCore.QRect(650, 565, 75, 23))
    self.exitButton.setObjectName("exitButton")
    self.titleSong = QtWidgets.QLineEdit(musicAdmin)
    self.titleSong.setGeometry(QtCore.QRect(460, 240, 181, 20))
    self.titleSong.setObjectName("titleSong")
    self.singerLine = QtWidgets.QLineEdit(musicAdmin)
    self.singerLine.setGeometry(QtCore.QRect(460, 270, 181, 20))
    self.singerLine.setObjectName("singerLine")
    self.singerLabel = QtWidgets.QLabel(musicAdmin)
    self.singerLabel.setGeometry(QtCore.QRect(370, 270, 47, 13))
    self.singerLabel.setObjectName("singerLabel")
    self.titleLabel = QtWidgets.QLabel(musicAdmin)
    self.titleLabel.setGeometry(QtCore.QRect(370, 240, 47, 13))
    self.titleLabel.setObjectName("titleLabel")
    self.availableSongs = QtWidgets.QPushButton(musicAdmin)
    self.availableSongs.setGeometry(QtCore.QRect(390, 320, 261, 51))
    self.availableSongs.setObjectName("availableSongs")
    self.warningLabel = QtWidgets.QLabel(musicAdmin)
    self.warningLabel.setGeometry(QtCore.QRect(410, 210, 261, 20))
    self.warningLabel.setText("")
    self.warningLabel.setObjectName("warningLabel")

    self.exitButton.clicked.connect(self.CloseThis)
    self.availableSongs.clicked.connect(self.addSong)

    self.retranslateUi(musicAdmin)
    QtCore.QMetaObject.connectSlotsByName(musicAdmin)

  def retranslateUi(self, musicAdmin):
    _translate = QtCore.QCoreApplication.translate
    musicAdmin.setWindowTitle(_translate("musicAdmin", "Music Library"))
    self.singerLabel.setText(_translate("musicAdmin", "Singer:"))
    self.titleLabel.setText(_translate("musicAdmin", "Title:"))
    self.exitButton.setText(_translate("AdminUI", "Exit"))
    self.availableSongs.setText(_translate("musicAdmin", "Add Song"))

  def addSong(self):
    warn = QMessageBox()
    voicer = self.singerLine.text()
    title = self.titleSong.text()
    temp = open("musics.csv", "a")
    tempRead = csv.reader(temp)
    song = voicer + ',' + title
    songs = voicer + title

    if songs != '':  # if song has string
        if voicer != '' or title != '':
            temp.write(song + '\n')
            self.warningLabel.setText("Song is added")
        else:
            warn.setWindowTitle("System")
            warn.setText("Song Details are required")
            warn.setIcon(QtWidgets.QMessageBox.Warning)
            warn.exec_()
    else:
        warn.setWindowTitle("System")
        warn.setText("Song Details are required")
        warn.setIcon(QtWidgets.QMessageBox.Warning)
        warn.exec_()

  def CloseThis(self, event):
    reply = QuitMessage().exec_()
    if reply == QtWidgets.QMessageBox.Yes:
        self.musicAdmin.close()

if __name__ == "__main__":
   app = QtWidgets.QApplication(sys.argv)
   musicAdmin = QtWidgets.QDialog()
   ui = musicAdminUI()
   ui.setupUi(musicAdmin)
   musicAdmin.show()
   sys.exit(app.exec_())

- Miyamura Yamamura

你想要做的是将你输入的文本添加到titleSong和singerLine中，并分别添加到第3列和第4列的新行中。我说得对吗？ - eyllanesc

是的，它是的..... - Miyamura Yamamura

尝试使用我的答案。 - eyllanesc

1个回答

网页内容由stack overflow 提供, 点击上面的

可以查看英文原文，
原文链接

- eyllanesc · Answer 1

要添加新行，我们必须使用writerow接收一个列表，根据您的要求，该列表应仅填充第3列和第4列的数据。为此，我们通过csv创建一个预定义大小的列表，并填充数据。

def addSong(self):
    warn = QMessageBox()
    voicer = self.singerLine.text()
    title = self.titleSong.text()
    temp = open("musics.csv", mode="r", errors='ignore') # ignore mistakes

    reader = csv.reader(temp)
    n_cols = len(next(reader)) #numbers of columns

    temp = open("musics.csv", "a") 
    writer = csv.writer(temp)

    if voicer != '' or title != '':
        data = [""]*n_cols # create a list of empty string
        data[2] = title # add 3 column
        data[3] = voicer # add 4 column
        writer.writerow(data)
        self.warningLabel.setText("Song is added")
    else:
        warn.setWindowTitle("System")
        warn.setText("Song Details are required")
        warn.setIcon(QtWidgets.QMessageBox.Warning)
        warn.exec_()