{

QRegExp re(QLatin1String( "--.+([\n\r]{1,2};?|$)" ));

re.setMinimal(true);

query.remove( re );

query = query.trimmed();

const QString& connectionName/*=QSqlDatabase::defaultConnection*/) {

QString errorText;

if ( sql.size() > 0 ) {

const QStringList stmts = splitQueries(sql);

QSqlDatabase db = QSqlDatabase::database(connectionName);

if ( stmts.count() == 0 )

return QString();

SqlTransaction transaction( db );

for (int i=0; i < stmts.count(); i++) {

QString sqlstmt = stmts.at(i);

stripComments(sqlstmt);

if (sqlstmt.size() < 3 ) {

//SQLDEBUG << "#" << i << ") SKIPPING small statement: " << sqlstmt;

break;

}

//SQLDEBUG << QString("POST # %1 %2").arg(i).arg(sqlstmt);

QSqlQuery q = db.exec( sqlstmt );

if (q.lastError().type() != QSqlError::NoError) {

errorText = QObject::tr("Error in one of the batch statements. %1").arg(q.lastError().text());

qCritical() << QString::fromLatin1("%1.\nStatement: %2").arg(errorText).arg(sqlstmt);

return errorText;

}

}

transaction.commit();

return QString();

}

else {

errorText = QObject::tr("SQL statement passed was empty!!");

return errorText;

}

{

if (error.type() == QSqlError::StatementError &&

( error.text().contains(QLatin1String("(55P03)")) || //the actual error code, not translated. needs patched QPSQL driver

error.text().contains(QLatin1String("could not obtain lock")) )

)

{

return true;

}

return false;

{

uint hash = qHash(text);

return QString::number(hash, 16);