Created
October 6, 2013 11:40
-
-
Save savolai/6852986 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* @brief executeQueriesFromFile Read each line from a .sql QFile | |
* (assumed to not have been opened before this function), and when ; is reached, execute | |
* the SQL gathered until then on the query object. Then do this until a COMMIT SQL | |
* statement is found. In other words, this function assumes each file is a single | |
* SQL transaction, ending with a COMMIT line. | |
*/ | |
void executeQueriesFromFile(QFile *file, QSqlQuery *query) | |
{ | |
while (!file->atEnd()){ | |
QByteArray readLine=""; | |
QString cleanedLine; | |
QString line=""; | |
bool finished=false; | |
while(!finished){ | |
readLine = file->readLine(); | |
cleanedLine=readLine.trimmed(); | |
// remove comments at end of line | |
QStringList strings=cleanedLine.split("--"); | |
cleanedLine=strings.at(0); | |
// remove lines with only comment, and DROP lines | |
if(!cleanedLine.startsWith("--") | |
&& !cleanedLine.startsWith("DROP") | |
&& !cleanedLine.isEmpty()){ | |
line+=cleanedLine; | |
} | |
if(cleanedLine.endsWith(";")){ | |
break; | |
} | |
if(cleanedLine.startsWith("COMMIT")){ | |
finished=true; | |
} | |
} | |
if(!line.isEmpty()){ | |
query->exec(line); | |
} | |
if(!query->isActive()){ | |
qDebug() << QSqlDatabase::drivers(); | |
qDebug() << query->lastError(); | |
qDebug() << "test executed query:"<< query->executedQuery(); | |
qDebug() << "test last query:"<< query->lastQuery(); | |
} | |
} | |
} | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
If you won't end statement with ; it's gonna loop forever.