Imported Upstream version 3.1.1+dfsg1upstream/3.1.1+dfsg1

1 files changed, 31 insertions, 0 deletions

diff --git a/Plugins/DbSqliteSystemData/dbsqlitesystemdatainstance.cpp b/Plugins/DbSqliteSystemData/dbsqlitesystemdatainstance.cpp
new file mode 100644
index 0000000..2295006
--- /dev/null
+++ b/Plugins/DbSqliteSystemData/dbsqlitesystemdatainstance.cpp
@@ -0,0 +1,31 @@
+#include "dbsqlitesystemdatainstance.h"

+#include "dbsqlitesystemdata.h"

+

+DbSqliteSystemDataInstance::DbSqliteSystemDataInstance(const QString& name, const QString& path, const QHash<QString, QVariant>& connOptions) :

+    AbstractDb3<SystemDataSQLite>(name, path, connOptions)

+{

+}

+

+void DbSqliteSystemDataInstance::initAfterOpen()

+{

+    SqlQueryPtr res;

+

+    QString key = connOptions[DbSqliteSystemData::PASSWORD_OPT].toString();

+    if (!key.isEmpty())

+    {

+        res = exec(QString("PRAGMA key = '%1';").arg(key), Flag::NO_LOCK);

+        if (res->isError())

+            qWarning() << "Error while defining WxSqlite3 key:" << res->getErrorText();

+    }

+

+    AbstractDb3<SystemDataSQLite>::initAfterOpen();

+}

+

+QString DbSqliteSystemDataInstance::getAttachSql(Db *otherDb, const QString &generatedAttachName)

+{

+    QString pass = "";

+    if (otherDb->getConnectionOptions().contains(DbSqliteSystemData::PASSWORD_OPT))

+        pass = otherDb->getConnectionOptions()[DbSqliteSystemData::PASSWORD_OPT].toString().replace("'", "''");

+

+    return QString("ATTACH '%1' AS %2 KEY '%3';").arg(otherDb->getPath(), generatedAttachName, pass);

+}