Python - Import CSV file and save it into Database SQLAlchemy
<p>i have a prblem with importing CSV-file into Database...
Im using SQLAlchemy in Python and wanted to open a CSV-File than show it in QTableWidget to maybe change the values and after write it to DB (New Table).</p>

<pre><code>def setinTable(self):

    colcnt = len(self.title)
    rowcnt = len(self.data)
    self.tabel_model = QtGui.QTableWidget(rowcnt, colcnt)
    vheader = QtGui.QHeaderView(QtCore.Qt.Orientation.Vertical)
    self.tabel_model.setVerticalHeader(vheader)
    hheader = QtGui.QHeaderView(QtCore.Qt.Orientation.Horizontal)
    self.tabel_model.setHorizontalHeader(hheader)
    self.tabel_model.setHorizontalHeaderLabels(self.title)
    for i in range(rowcnt):
        for j in range(len(self.data[0])):
            item = QtGui.QTableWidgetItem(str(self.data[i][j]))
            self.tabel_model.setItem(i, j, item)
    self.tabel_model.horizontalHeader().sectionDoubleClicked.connect(self.changeHorizontalHeader)
    self.setCentralWidget(self.tabel_model)
</code></pre>

<h1>Get CSV-Data</h1>

<pre><code>def getdata(filepath):
    with open(filepath, 'r') as csvfile:
        sample = csvfile.read(1024)
        dialect = csv.Sniffer().sniff(sample, [';',',','|'])
        csvfile.seek(0)

        reader = csv.reader(csvfile,dialect=dialect)
        header = next(reader)
        lines = []
        for line in reader:
            lines.append(line)
        return lines
</code></pre>

<p>Reading and showing the CSV-File data in a QTableWidget is working .. but i dont know how to save it to a MySQL Database </p>