diff options
| author | 2021-12-17 07:07:47 -0500 | |
|---|---|---|
| committer | 2021-12-17 07:07:47 -0500 | |
| commit | 558b1e35fd0777ac97763c1b28056ac984e583e7 (patch) | |
| tree | 1eb2557119a117ea76535c89cd14a49e510b96bf /SQLiteStudio3/guiSQLiteStudio/dbobjectdialogs.cpp | |
| parent | c22eb635c11fd45f9c30f911d70e1d79111a49ce (diff) | |
| parent | 1fdc150116cad39aae5c5da407c3312b47a59e3a (diff) | |
Update upstream source from tag 'upstream/3.3.3+dfsg1'
Update to upstream version '3.3.3+dfsg1'
with Debian dir 9a301fff4922aed2fec0c04c7d011947168c42f1
Diffstat (limited to 'SQLiteStudio3/guiSQLiteStudio/dbobjectdialogs.cpp')
| -rw-r--r-- | SQLiteStudio3/guiSQLiteStudio/dbobjectdialogs.cpp | 24 |
1 files changed, 7 insertions, 17 deletions
diff --git a/SQLiteStudio3/guiSQLiteStudio/dbobjectdialogs.cpp b/SQLiteStudio3/guiSQLiteStudio/dbobjectdialogs.cpp index 7dd45fd..05b614b 100644 --- a/SQLiteStudio3/guiSQLiteStudio/dbobjectdialogs.cpp +++ b/SQLiteStudio3/guiSQLiteStudio/dbobjectdialogs.cpp @@ -52,12 +52,12 @@ void DbObjectDialogs::editIndex(const QString& index) void DbObjectDialogs::addTriggerOnTable(const QString& table) { - addTrigger(table, QString::null); + addTrigger(table, QString()); } void DbObjectDialogs::addTriggerOnView(const QString& view) { - addTrigger(QString::null, view); + addTrigger(QString(), view); } void DbObjectDialogs::addTrigger(const QString& table, const QString& view) @@ -161,8 +161,7 @@ bool DbObjectDialogs::dropObject(const QString& database, const QString& name) static const QString dropSql2 = "DROP %1 %2;"; static const QString dropSql3 = "DROP %1 %2.%3;"; - Dialect dialect = db->getDialect(); - QString dbName = wrapObjIfNeeded(database, dialect); + QString dbName = wrapObjIfNeeded(database); Type type = getObjectType(database, name); QString title; @@ -206,11 +205,7 @@ bool DbObjectDialogs::dropObject(const QString& database, const QString& name) SqlQueryPtr results; - QString finalSql; - if (dialect == Dialect::Sqlite3) - finalSql = dropSql3.arg(typeForSql, dbName, wrapObjIfNeeded(name, dialect)); - else - finalSql = dropSql2.arg(typeForSql, wrapObjIfNeeded(name, dialect)); + QString finalSql = dropSql3.arg(typeForSql, dbName, wrapObjIfNeeded(name)); results = db->exec(finalSql); if (results->isError()) @@ -273,7 +268,6 @@ bool DbObjectDialogs::dropObjects(const QHash<QString, QStringList>& objects) static const QString dropSql2 = "DROP %1 IF EXISTS %2;"; static const QString dropSql3 = "DROP %1 IF EXISTS %2.%3;"; - Dialect dialect = db->getDialect(); QStringList names = concat(objects.values()); QHash<QString, QHash<QString, QStringList>> groupedObjects = groupObjects(objects); @@ -298,16 +292,13 @@ bool DbObjectDialogs::dropObjects(const QHash<QString, QStringList>& objects) QHash<QString, QStringList> typeToNames; for (QHash<QString, QHash<QString, QStringList>>::const_iterator dbIt = groupedObjects.begin(); dbIt != groupedObjects.end(); ++dbIt) { - dbName = wrapObjIfNeeded(dbIt.key(), dialect); + dbName = wrapObjIfNeeded(dbIt.key()); typeToNames = dbIt.value(); for (QHash<QString, QStringList>::const_iterator typeIt = typeToNames.begin(); typeIt != typeToNames.end(); ++typeIt) { for (const QString& name : typeIt.value()) { - if (dialect == Dialect::Sqlite3) - finalSql = dropSql3.arg(typeIt.key(), dbName, wrapObjIfNeeded(name, dialect)); - else - finalSql = dropSql2.arg(typeIt.key(), wrapObjIfNeeded(name, dialect)); + finalSql = dropSql3.arg(typeIt.key(), dbName, wrapObjIfNeeded(name)); results = db->exec(finalSql); if (results->isError()) @@ -339,8 +330,7 @@ DbObjectDialogs::Type DbObjectDialogs::getObjectType(const QString& database, co static const QString typeSql = "SELECT type FROM %1.sqlite_master WHERE name = ?;"; static const QStringList types = {"table", "index", "trigger", "view"}; - Dialect dialect = db->getDialect(); - QString dbName = wrapObjIfNeeded(database, dialect); + QString dbName = wrapObjIfNeeded(database); SqlQueryPtr results = db->exec(typeSql.arg(dbName), {name}); if (results->isError()) { |
