On 02/16/2013 07:01 PM, Srini Kommoori wrote: > Can you set/get the sql db using python? > > As you are on Python, I would use sqlalchemy or native python bindings > for the sql interface and test it out.
The database connection works. I get the correct values in the lineEdit widgets. As I mentioned when I set up OnFieldChange and AutoSubmit the form would update the first field on entry. > > > > On Sat, Feb 16, 2013 at 3:19 PM, Adrian Klaver <[email protected] > <mailto:[email protected]>> wrote: > > OpenSuse 12.2 > pyside 1.1.2-1.11 > Python 2.7.3 > > I have the following and it will not save the data to the database: > > class PlantForm(QtGui.QMainWindow): > def __init__(self, parent=None): > super(PlantForm, self).__init__(parent) > loader = QtUiTools.QUiLoader() > self.ui = > > loader.load("/home/aklaver/software_projects/greenhouse_app/python_code/plant_app_qt/forms/plant_form.ui") > self.model = QtSql.QSqlTableModel(self, db=db) > self.model.setTable("plant1") > self.model.setSort(0, QtCore.Qt.AscendingOrder) > self.model.setEditStrategy(self.model.OnManualSubmit) > self.model.select() > self.dm <http://self.dm> = QtGui.QDataWidgetMapper(self) > self.dm.setSubmitPolicy(self.dm.ManualSubmit) > self.dm.setModel(self.model) > self.dm.addMapping(self.ui.plantNoLi, 0) > self.dm.addMapping(self.ui.commonLi, 1) > self.dm.addMapping(self.ui.genusLi, 2) > self.dm.addMapping(self.ui.speciesLi, 3) > self.dm.toFirst() > self.saveBtn = self.ui.saveBtn > self.saveBtn.clicked.connect(self.model.submitAll) > self.ui.show() > self.center() > > def center(self): > qr = self.frameGeometry() > cp = QtGui.QDesktopWidget().availableGeometry().center() > qr.moveCenter(cp) > self.move(qr.topLeft()) > > I am obviously missing something, I am just not sure what? > I tried the above with OnFieldChange for the model and AutoSubmit for > the DataMapper. When I opened the form the first field would update to > its existing value bit then I could not change anything. The changed > value stick in the widget, they just do not get to the database. > > Thanks, > > -- > Adrian Klaver > [email protected] <mailto:[email protected]> > _______________________________________________ > PySide mailing list > [email protected] <mailto:[email protected]> > http://lists.qt-project.org/mailman/listinfo/pyside > > -- Adrian Klaver [email protected] _______________________________________________ PySide mailing list [email protected] http://lists.qt-project.org/mailman/listinfo/pyside
