SQLite - QSqlDatabase::transaction()

[whitefurrows]

Now the COMMIT fail and i show a message and do nothing. Is that OK?

QSqlDatabase db = QSqlDatabase::database();
db.transaction();
 
QSqlQuery q;
if ( !q.exec("SELECT;") )
   db.rollback();
 
q.clear();
if(!db.commit())
   QMessageBox();

QSqlDatabase db = QSqlDatabase::database();
db.transaction();
 
QSqlQuery q;
if ( !q.exec("SELECT;") )
   db.rollback();
 
q.clear();
if(!db.commit())
   QMessageBox();

To copy to clipboard, switch view to plain text mode 

[wysota]

I don't know what you are asking for but you can't commit a transaction that has already been rolled back.

[whitefurrows]

I want read a sql-script and rollback if a sql-statement fails. I'm not sure how can i do that right. That's my code:

QSqlDatabase db = QSqlDatabase::database();
db.transaction();
 
bool sql_ok=TRUE;
QSqlQuery q;
QFile file(:/script.sql);
QString script=file.readAll();
QStringList sql=script.split(";", QString::SkipEmptyParts);
 
for (int i=0; i<sql.count(); i++)
{
	sql_ok=q.exec(sql[i]);
	if (!sql_ok)
	{
		QMessageBox::critical(0, "Error", q.lastError().text());
		db.rollback();
		break;
	}
}
 
q.clear();
if(sql_ok)
{
	if(!db.commit()){
		QMessageBox::critical(0, "Error", db.lastError().text());
		db.rollback();
	}
}

QSqlDatabase db = QSqlDatabase::database();
db.transaction();

bool sql_ok=TRUE;
QSqlQuery q;
QFile file(:/script.sql);
QString script=file.readAll();
QStringList sql=script.split(";", QString::SkipEmptyParts);

for (int i=0; i<sql.count(); i++)
{
	sql_ok=q.exec(sql[i]);
	if (!sql_ok)
	{
		QMessageBox::critical(0, "Error", q.lastError().text());
		db.rollback();
		break;
	}
}

q.clear();
if(sql_ok)
{
	if(!db.commit()){
		QMessageBox::critical(0, "Error", db.lastError().text());
		db.rollback();
	}
}

To copy to clipboard, switch view to plain text mode 

Please help me and give me a example how that works right. Thanks in advance.

[Lesiok]

Just simply like this

QSqlDatabase db = QSqlDatabase::database();
db.transaction();
 
bool sql_ok=TRUE;
QSqlQuery q;
QFile file(:/script.sql);
QString script=file.readAll();
QStringList sql=script.split(";", QString::SkipEmptyParts);
 
for (int i=0; i<sql.count() && sql_ok; i++)
{
    sql_ok=q.exec(sql[i]);
}
 
q.clear();
if(sql_ok)
{
    sql_ok = db.commit();
}
 
if(!sql_ok)
{
    QMessageBox::critical(0, "Error", q.lastError().text());
    db.rollback();
}

QSqlDatabase db = QSqlDatabase::database();
db.transaction();
 
bool sql_ok=TRUE;
QSqlQuery q;
QFile file(:/script.sql);
QString script=file.readAll();
QStringList sql=script.split(";", QString::SkipEmptyParts);
 
for (int i=0; i<sql.count() && sql_ok; i++)
{
    sql_ok=q.exec(sql[i]);
}
 
q.clear();
if(sql_ok)
{
    sql_ok = db.commit();
}

if(!sql_ok)
{
    QMessageBox::critical(0, "Error", q.lastError().text());
    db.rollback();
}

To copy to clipboard, switch view to plain text mode 

[whitefurrows]

Thanks for the help, the problem is now solved.