Add test for QgsSqliteUtils

qgis · Jun 13, 2018 · 3f938e4 · 3f938e4
1 parent 3651df0
commit 3f938e4
Show file tree

Hide file tree

Showing 2 changed files with 96 additions and 0 deletions.
diff --git a/tests/src/core/CMakeLists.txt b/tests/src/core/CMakeLists.txt
@@ -192,6 +192,7 @@ SET(TESTS
  testqgsmeshlayer.cpp
  testqgsmeshlayerrenderer.cpp
  testqgslayerdefinition.cpp
+ testqgssqliteutils.cpp
    )
 
 IF(WITH_QTWEBKIT)

diff --git a/tests/src/core/testqgssqliteutils.cpp b/tests/src/core/testqgssqliteutils.cpp
@@ -0,0 +1,95 @@
+/***************************************************************************
+     testqgssqliteutils.cpp
+     --------------------------------------
+    Date                 : 2018-06-13
+    Copyright            : (C) 2018 Alessandro Pasotti
+    Email                : elpaso at itopen dot it
+ ***************************************************************************
+ *                                                                         *
+ *   This program is free software; you can redistribute it and/or modify  *
+ *   it under the terms of the GNU General Public License as published by  *
+ *   the Free Software Foundation; either version 2 of the License, or     *
+ *   (at your option) any later version.                                   *
+ *                                                                         *
+ ***************************************************************************/
+#include "qgstest.h"
+#include <QObject>
+#include <QStringList>
+#include <QApplication>
+#include <QFileInfo>
+
+//qgis includes...
+#include "qgssqliteutils.h"
+
+
+/**
+ * \ingroup UnitTests
+ * This is a unit test to verify that QgsSqliteUtils are working correctly
+ */
+class TestQgsSqliteUtils : public QObject
+{
+    Q_OBJECT
+
+  public:
+
+    TestQgsSqliteUtils() = default;
+
+
+  private slots:
+
+    // init / cleanup
+    void initTestCase();// will be called before the first testfunction is executed.
+    void cleanupTestCase();// will be called after the last testfunction was executed.
+    void init() {}// will be called before each testfunction is executed.
+    void cleanup() {}// will be called after every testfunction.
+    // void initStyles();
+
+    void testPrintfAscii();
+    void testPrintfUtf8();
+};
+
+
+// slots
+void TestQgsSqliteUtils::initTestCase()
+{
+  // initialize with test settings directory so we don't mess with user's stuff
+  QgsApplication::init( QDir::tempPath() + "/dot-qgis" );
+  QgsApplication::initQgis();
+  QgsApplication::createDatabase();
+
+  // output test environment
+  QgsApplication::showSettings();
+
+  // Set up the QgsSettings environment
+  QCoreApplication::setOrganizationName( QStringLiteral( "QGIS" ) );
+  QCoreApplication::setOrganizationDomain( QStringLiteral( "qgis.org" ) );
+  QCoreApplication::setApplicationName( QStringLiteral( "QGIS-TEST" ) );
+
+
+}
+
+void TestQgsSqliteUtils::cleanupTestCase()
+{
+  QgsApplication::exitQgis();
+}
+
+void TestQgsSqliteUtils::testPrintfAscii()
+{
+  QString tag( "Meteor" );
+  QString query( QgsSqlite3Mprintf( "SELECT id FROM tag WHERE LOWER(name)='%q'", tag.toUtf8().toLower().constData() ) );
+  QCOMPARE( query, QString( "SELECT id FROM tag WHERE LOWER(name)='%1'" ).arg( tag.toLower() ) );
+}
+
+
+void TestQgsSqliteUtils::testPrintfUtf8()
+{
+  QString tag( "МЕТЕОР" );
+  QCOMPARE( tag.toLower(), QString( "метеор" ) );
+  QString lowerTag( tag.toLower() );
+  QString query( QgsSqlite3Mprintf( "SELECT id FROM tag WHERE LOWER(name)='%q'", lowerTag.toUtf8().constData() ) );
+  QCOMPARE( query, QString( "SELECT id FROM tag WHERE LOWER(name)='%1'" ).arg( lowerTag ) );
+}
+
+
+QGSTEST_MAIN( TestQgsSqliteUtils )
+#include "testqgssqliteutils.moc"