i can't update database,

**xiongxiongchuan** · 28th June 2010, 04:21

i can't update ,insert or edit the database ,someone help me pleaze

Qt Code:

Switch view

void WellDataManage::loadWellData(QString projectAddress)
{
	QString address=projectAddress;
	address+="//";
	address+="Data";
	address+="//";
	address+="SystemData";
	address+=".db3";
 
	if (!QFile::exists(address))
	{
		QMessageBox::information(this,tr("Information"),tr("There is something wrong with the wells databases"),QMessageBox::Ok,QMessageBox::Ok);
	}
 
	QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
	db.setDatabaseName(address);
	db.open();
 
 
	welldatamodel = new QSqlRelationalTableModel;
	welldatamodel->setTable("wells");
	welldatamodel->setEditStrategy(QSqlTableModel::OnManualSubmit);
	welldatamodel->setSort(0,Qt::AscendingOrder);
 
	//set Comobox model
 
 
	wellTypeComoBox->setModel(welldatamodel);
	wellTypeComoBox->setModelColumn(welldatamodel->fieldIndex("welltype"));
 
	//set header name
	welldatamodel->setHeaderData(0,Qt::Horizontal,tr("Name"));
	welldatamodel->setHeaderData(1,Qt::Horizontal,tr("Group"));
	welldatamodel->setHeaderData(2,Qt::Horizontal,tr("X"));
	welldatamodel->setHeaderData(3,Qt::Horizontal,tr("Y"));
	welldatamodel->setHeaderData(4,Qt::Horizontal,tr("Type"));
	welldatamodel->setHeaderData(5,Qt::Horizontal,tr("Production"));
	welldatamodel->setHeaderData(6,Qt::Horizontal,tr("Depth"));
	welldatamodel->setHeaderData(7,Qt::Horizontal,tr("BeginDepth"));
	welldatamodel->setHeaderData(8,Qt::Horizontal,tr("EndDepth"));
	welldatamodel->setHeaderData(9,Qt::Horizontal,tr("Altitude"));
 
 
	welldatamodel->select();
	welldatamodel->removeColumn(0);
 
	wellTableView->setModel(welldatamodel);
	wellTableView->setSelectionBehavior(QAbstractItemView::SelectRows);
	wellTableView->resizeRowsToContents();
 
//	wellTableView->enabledChange(false);
//	wellTableView->resizeColumnsToContents();
//	wellTableView->horizontalHeader()->setStretchLastSection(true);
 
 
	welldatamapper->setModel(welldatamodel);
	//welldatamapper->setSubmitPolicy(QDataWidgetMapper::AutoSubmit);	
	welldatamapper->setItemDelegate(new QSqlRelationalDelegate(this));
 
	welldatamapper->addMapping(wellNameEdit,0);
	welldatamapper->addMapping(wellGroupEdit,1);
	welldatamapper->addMapping(wellXPositionEdit,2);
	welldatamapper->addMapping(wellYPositionEdit,3);
 
	welldatamapper->addMapping(wellProductionEdit,5);
	/*welldatamapper->addMapping(wellDepthEdit,6);*/
	welldatamapper->addMapping(wellTypeComoBox,6);
	welldatamapper->addMapping(wellBeginDepthEdit,7);
	welldatamapper->addMapping(wellEndDepthEdit,8);
	welldatamapper->addMapping(wellAltitudeEdit,9);
 
	//create connect of the buttons
	welldatamapper->toFirst();//åˆå§‹åŒ–æ—¶é€‰æ‹©é€‰æ‹©ç¬¬ä¸€è¡Œ
	connect(firstAction,SIGNAL(triggered()),welldatamapper,SLOT(toFirst()));
	connect(lastAction,SIGNAL(triggered()),welldatamapper,SLOT(toLast()));
	connect(previousAction,SIGNAL(triggered()),welldatamapper,SLOT(toPrevious()));
	connect(nextAction,SIGNAL(triggered()),welldatamapper,SLOT(toNext()));
	connect(newAction,SIGNAL(triggered()),this,SLOT(addWellRecord()));
	connect(deleteAction,SIGNAL(triggered()),this,SLOT(deleteWellRecord()));
	connect(updateAction,SIGNAL(triggered()),this,SLOT(updateWellRecord()));
 
 
	connect(wellTableView->selectionModel(),SIGNAL(currentRowChanged(QModelIndex, QModelIndex)),welldatamapper,SLOT(setCurrentModelIndex(QModelIndex) ));
	connect(welldatamapper,SIGNAL(currentIndexChanged(int)),wellTableView,SLOT(selectRow (int)));
}
 
void WellDataManage::addWellRecord()
{
 
	int row=welldatamapper->currentIndex();
	welldatamapper->submit();
	welldatamodel->insertRow(row);
	welldatamapper->setCurrentIndex(row);
 
 
	wellNameEdit->clear();
	wellGroupEdit->clear();
	wellXPositionEdit->clear();
	wellYPositionEdit->clear();
	wellBeginDepthEdit->clear();
	wellEndDepthEdit->clear();
	wellProductionEdit->clear();
	wellTypeComoBox->clear();
	wellNameEdit->setFocus();
}
 
 
 
 
void WellDataManage::deleteWellRecord()
{
 
	int row=welldatamapper->currentIndex();
	welldatamodel->removeRow(row);
	welldatamapper->submit();
	welldatamodel->submit();
	//welldatamapper->setCurrentIndex(QMIN(row,welldatamodel->rowCount()-1));
 
 
}
 
void WellDataManage::updateWellRecord()
{
	welldatamapper->submit();
 
	//welldatamodel->submitAll();
 
}

void WellDataManage::loadWellData(QString projectAddress)
{
	QString address=projectAddress;
	address+="//";
	address+="Data";
	address+="//";
	address+="SystemData";
	address+=".db3";

	if (!QFile::exists(address))
	{
		QMessageBox::information(this,tr("Information"),tr("There is something wrong with the wells databases"),QMessageBox::Ok,QMessageBox::Ok);
	}

	QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
	db.setDatabaseName(address);
	db.open();


	welldatamodel = new QSqlRelationalTableModel;
	welldatamodel->setTable("wells");
	welldatamodel->setEditStrategy(QSqlTableModel::OnManualSubmit);
	welldatamodel->setSort(0,Qt::AscendingOrder);

	//set Comobox model


	wellTypeComoBox->setModel(welldatamodel);
	wellTypeComoBox->setModelColumn(welldatamodel->fieldIndex("welltype"));
	
	//set header name
	welldatamodel->setHeaderData(0,Qt::Horizontal,tr("Name"));
	welldatamodel->setHeaderData(1,Qt::Horizontal,tr("Group"));
	welldatamodel->setHeaderData(2,Qt::Horizontal,tr("X"));
	welldatamodel->setHeaderData(3,Qt::Horizontal,tr("Y"));
	welldatamodel->setHeaderData(4,Qt::Horizontal,tr("Type"));
	welldatamodel->setHeaderData(5,Qt::Horizontal,tr("Production"));
	welldatamodel->setHeaderData(6,Qt::Horizontal,tr("Depth"));
	welldatamodel->setHeaderData(7,Qt::Horizontal,tr("BeginDepth"));
	welldatamodel->setHeaderData(8,Qt::Horizontal,tr("EndDepth"));
	welldatamodel->setHeaderData(9,Qt::Horizontal,tr("Altitude"));
	

	welldatamodel->select();
	welldatamodel->removeColumn(0);

	wellTableView->setModel(welldatamodel);
	wellTableView->setSelectionBehavior(QAbstractItemView::SelectRows);
	wellTableView->resizeRowsToContents();

//	wellTableView->enabledChange(false);
//	wellTableView->resizeColumnsToContents();
//	wellTableView->horizontalHeader()->setStretchLastSection(true);


	welldatamapper->setModel(welldatamodel);
	//welldatamapper->setSubmitPolicy(QDataWidgetMapper::AutoSubmit);	
	welldatamapper->setItemDelegate(new QSqlRelationalDelegate(this));

	welldatamapper->addMapping(wellNameEdit,0);
	welldatamapper->addMapping(wellGroupEdit,1);
	welldatamapper->addMapping(wellXPositionEdit,2);
	welldatamapper->addMapping(wellYPositionEdit,3);

	welldatamapper->addMapping(wellProductionEdit,5);
	/*welldatamapper->addMapping(wellDepthEdit,6);*/
	welldatamapper->addMapping(wellTypeComoBox,6);
	welldatamapper->addMapping(wellBeginDepthEdit,7);
	welldatamapper->addMapping(wellEndDepthEdit,8);
	welldatamapper->addMapping(wellAltitudeEdit,9);

	//create connect of the buttons
	welldatamapper->toFirst();//åˆå§‹åŒ–æ—¶é€‰æ‹©é€‰æ‹©ç¬¬ä¸€è¡Œ
	connect(firstAction,SIGNAL(triggered()),welldatamapper,SLOT(toFirst()));
	connect(lastAction,SIGNAL(triggered()),welldatamapper,SLOT(toLast()));
	connect(previousAction,SIGNAL(triggered()),welldatamapper,SLOT(toPrevious()));
	connect(nextAction,SIGNAL(triggered()),welldatamapper,SLOT(toNext()));
	connect(newAction,SIGNAL(triggered()),this,SLOT(addWellRecord()));
	connect(deleteAction,SIGNAL(triggered()),this,SLOT(deleteWellRecord()));
	connect(updateAction,SIGNAL(triggered()),this,SLOT(updateWellRecord()));
	

	connect(wellTableView->selectionModel(),SIGNAL(currentRowChanged(QModelIndex, QModelIndex)),welldatamapper,SLOT(setCurrentModelIndex(QModelIndex) ));
	connect(welldatamapper,SIGNAL(currentIndexChanged(int)),wellTableView,SLOT(selectRow (int)));
}

void WellDataManage::addWellRecord()
{

	int row=welldatamapper->currentIndex();
	welldatamapper->submit();
	welldatamodel->insertRow(row);
	welldatamapper->setCurrentIndex(row);


	wellNameEdit->clear();
	wellGroupEdit->clear();
	wellXPositionEdit->clear();
	wellYPositionEdit->clear();
	wellBeginDepthEdit->clear();
	wellEndDepthEdit->clear();
	wellProductionEdit->clear();
	wellTypeComoBox->clear();
	wellNameEdit->setFocus();
}




void WellDataManage::deleteWellRecord()
{

	int row=welldatamapper->currentIndex();
	welldatamodel->removeRow(row);
	welldatamapper->submit();
	welldatamodel->submit();
	//welldatamapper->setCurrentIndex(QMIN(row,welldatamodel->rowCount()-1));


}

void WellDataManage::updateWellRecord()
{
	welldatamapper->submit();

	//welldatamodel->submitAll();

}

To copy to clipboard, switch view to plain text mode

**daemonna** · 28th June 2010, 05:14

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(address);
db.open();

just lookin in sql examples... dont you need also

db.setHostName("bigblue");
db.setUserName("acarlson");
db.setPassword("1uTbSbAs");
bool ok = db.open();

??????

**xiongxiongchuan** · 28th June 2010, 06:05

i can read the data from the database ,i just can't update it

**saa7_go** · 28th June 2010, 09:09

If you set the edit strategy to QSqlTableModel::OnManualSubmit,

Qt Code:

Switch view

welldatamodel->setEditStrategy(QSqlTableModel::OnManualSubmit);

welldatamodel->setEditStrategy(QSqlTableModel::OnManualSubmit);

To copy to clipboard, switch view to plain text mode

you must use QSqlTableModel::submitAll() or QSqlTableModel::revertAll().

**xiongxiongchuan** · 28th June 2010, 09:25

i also use the

Qt Code:

Switch view

QSqlTableModel::submitAll()

QSqlTableModel::submitAll()

To copy to clipboard, switch view to plain text mode

,it still can't work ,i have tried.

**xiongxiongchuan** · 29th June 2010, 09:52

can anyone help me ?

**saa7_go** · 29th June 2010, 12:42

How do you create the database? When i use sqlite3 application to create database and tables, then open it with Qt, there are problems when updating the data, the data won't update when calling model->submitAll().

Then i try to create database and tables from Qt using QSqlQuery, inserting some records, updating some data. And it works fine.

**xiongxiongchuan** · 29th June 2010, 14:44

i used the blow code to create the databases

Qt Code:

Switch view

QString address=projectAddress;
	address+="//";
	address+=projectName;
	address+="//";
	address+="Data";
	address+="//";
	address+="SystemData";
	address+=".db3";
 
	QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
	db.setDatabaseName(address);
	db.open();
 
	QSqlQuery query;
	query.exec("CREATE TABLE [wells] ("
		"[id] INTEGER PRIMARY KEY," 
		"[wellnames] NVARCHAR, "
		"[wellgroup] NVARCHAR," 
		"[XPosition] DOUBLE, "
		"[YPosition] DOUBLE," 
		"[welltype] CHAR, "
		"[production(m3)] DOUBLE," 
		"[depth] DOUBLE, "
		"[beginDetpth] DOUBLE, "
		"[endDepth] CHAR,"
		"[altitude] DOUBLE);");
	db.close();
	return true;

QString address=projectAddress;
	address+="//";
	address+=projectName;
	address+="//";
	address+="Data";
	address+="//";
	address+="SystemData";
	address+=".db3";

	QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
	db.setDatabaseName(address);
	db.open();

	QSqlQuery query;
	query.exec("CREATE TABLE [wells] ("
		"[id] INTEGER PRIMARY KEY," 
		"[wellnames] NVARCHAR, "
		"[wellgroup] NVARCHAR," 
		"[XPosition] DOUBLE, "
		"[YPosition] DOUBLE," 
		"[welltype] CHAR, "
		"[production(m3)] DOUBLE," 
		"[depth] DOUBLE, "
		"[beginDetpth] DOUBLE, "
		"[endDepth] CHAR,"
		"[altitude] DOUBLE);");
	db.close();
	return true;

To copy to clipboard, switch view to plain text mode

Thread: i can't update database,

Thread Tools

Search Thread

Display

i can't update database,

Re: i can't update database,

Re: i can't update database,

Re: i can't update database,

Re: i can't update database,

Re: i can't update database,

Re: i can't update database,

Re: i can't update database,

Similar Threads

QSql - "Error opening database", "unable to open database file"

how to use update()?

Is Update() the right way?

Database does not update when using QSqlRelationalTableModel and setRelation

Update a row

Bookmarks

Bookmarks

Posting Permissions