#!/usr/bin/env python
import os
import sys
from PyQt4.QtCore import *
from PyQt4.QtGui import *
from PyQt4.QtSql import *
def __init__(self, parent=None):
super(ExampleDlg, self).__init__(parent)
label1
= QLabel("First Edit:") label4
= QLabel("Second Edit:")
fieldLayout.addWidget(label1, 0, 0)
fieldLayout.addWidget(self.edit1, 0, 1, 1, 3)
fieldLayout.addWidget(label2, 1, 0)
fieldLayout.addWidget(self.dateTime1, 1, 1)
fieldLayout.addWidget(label3, 1, 2)
fieldLayout.addWidget(self.dateTime2, 1, 3)
fieldLayout.addWidget(label4, 2, 0)
fieldLayout.addWidget(self.edit2, 2, 1, 1, 3)
self.setLayout(fieldLayout)
self.model.setTable("calls")
self.model.select()
self.mapper.setModel(self.model)
self.mapper.addMapping(self.edit1, 1)
#self.mapper.addMapping(self.dateTime1, 2)
self.mapper.addMapping(self.dateTime2, 3)
self.mapper.addMapping(self.edit2, 4)
self.mapper.toFirst()
filename = os.path.join(os.path.dirname(__file__), "example.db")
db.setDatabaseName(filename)
if not db.open():
sys.exit(1)
form = ExampleDlg()
form.show()
sys.exit(app.exec_())
#!/usr/bin/env python
import os
import sys
from PyQt4.QtCore import *
from PyQt4.QtGui import *
from PyQt4.QtSql import *
class ExampleDlg(QDialog):
def __init__(self, parent=None):
super(ExampleDlg, self).__init__(parent)
label1 = QLabel("First Edit:")
self.edit1 = QLineEdit()
label2 = QLabel("Unmapped:")
self.dateTime1 = QDateTimeEdit()
label3 = QLabel("Mapped:")
self.dateTime2 = QDateTimeEdit()
label4 = QLabel("Second Edit:")
self.edit2 = QLineEdit()
fieldLayout = QGridLayout()
fieldLayout.addWidget(label1, 0, 0)
fieldLayout.addWidget(self.edit1, 0, 1, 1, 3)
fieldLayout.addWidget(label2, 1, 0)
fieldLayout.addWidget(self.dateTime1, 1, 1)
fieldLayout.addWidget(label3, 1, 2)
fieldLayout.addWidget(self.dateTime2, 1, 3)
fieldLayout.addWidget(label4, 2, 0)
fieldLayout.addWidget(self.edit2, 2, 1, 1, 3)
self.setLayout(fieldLayout)
self.model = QSqlRelationalTableModel(self)
self.model.setTable("calls")
self.model.select()
self.mapper = QDataWidgetMapper(self)
self.mapper.setSubmitPolicy(QDataWidgetMapper.ManualSubmit)
self.mapper.setModel(self.model)
self.mapper.setItemDelegate(QSqlRelationalDelegate(self))
self.mapper.addMapping(self.edit1, 1)
#self.mapper.addMapping(self.dateTime1, 2)
self.mapper.addMapping(self.dateTime2, 3)
self.mapper.addMapping(self.edit2, 4)
self.mapper.toFirst()
app = QApplication(sys.argv)
filename = os.path.join(os.path.dirname(__file__), "example.db")
db = QSqlDatabase.addDatabase("QSQLITE")
db.setDatabaseName(filename)
if not db.open():
sys.exit(1)
form = ExampleDlg()
form.show()
sys.exit(app.exec_())
To copy to clipboard, switch view to plain text mode
Bookmarks