Updating QSqlRelationalDelegate/QSqlTableModel/QSqlTableModel when database changes?

[will49]

I have a Sqlite database that can get changed at any time from another part of my application. I'd like for the UI to be updated automatically as soon as the database is changed. I'm not quite sure how to do this.

So far I'm basing my test app on the "SQL Widget Mapper" demo app.

QSqlTableModel *model;
QDataWidgetMapper *mapper;
 
	model = new QSqlTableModel(this,db);
	model->setTable("Results");
	model->setEditStrategy(QSqlTableModel::OnManualSubmit);
 
	mapper = new QDataWidgetMapper(this);
	mapper->setModel(model);
	mapper->setItemDelegate(new QSqlRelationalDelegate(this));
	mapper->addMapping(ui.lineEdit, model->fieldIndex("job_id"));
	mapper->addMapping(ui.lineEdit_2, model->fieldIndex("date_time"));
 
connect(ui.pushButton_previous, SIGNAL(clicked()),
		mapper, SLOT(toPrevious()));
connect(ui.pushButton_next, SIGNAL(clicked()),
		mapper, SLOT(toNext()));

QSqlTableModel *model;
QDataWidgetMapper *mapper;

	model = new QSqlTableModel(this,db);
	model->setTable("Results");
	model->setEditStrategy(QSqlTableModel::OnManualSubmit);

	mapper = new QDataWidgetMapper(this);
	mapper->setModel(model);
	mapper->setItemDelegate(new QSqlRelationalDelegate(this));
	mapper->addMapping(ui.lineEdit, model->fieldIndex("job_id"));
	mapper->addMapping(ui.lineEdit_2, model->fieldIndex("date_time"));

connect(ui.pushButton_previous, SIGNAL(clicked()),
		mapper, SLOT(toPrevious()));
connect(ui.pushButton_next, SIGNAL(clicked()),
		mapper, SLOT(toNext()));

To copy to clipboard, switch view to plain text mode 

I was thinking I could emit a signal whenever the database is changed, but I'm not sure what needs to be informed of the change, and how to do it. Is it the QDataWidgetMapper that needs to know something has changed?

Thanks