aboutsummaryrefslogtreecommitdiffstats
path: root/SQLiteStudio3/Tests/DbVersionConverterTest
diff options
context:
space:
mode:
authorLibravatarUnit 193 <unit193@unit193.net>2021-12-17 07:07:47 -0500
committerLibravatarUnit 193 <unit193@unit193.net>2021-12-17 07:07:47 -0500
commit558b1e35fd0777ac97763c1b28056ac984e583e7 (patch)
tree1eb2557119a117ea76535c89cd14a49e510b96bf /SQLiteStudio3/Tests/DbVersionConverterTest
parentc22eb635c11fd45f9c30f911d70e1d79111a49ce (diff)
parent1fdc150116cad39aae5c5da407c3312b47a59e3a (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/Tests/DbVersionConverterTest')
-rw-r--r--SQLiteStudio3/Tests/DbVersionConverterTest/DbVersionConverterTest.pro21
-rw-r--r--SQLiteStudio3/Tests/DbVersionConverterTest/tst_dbversionconvertertesttest.cpp119
2 files changed, 0 insertions, 140 deletions
diff --git a/SQLiteStudio3/Tests/DbVersionConverterTest/DbVersionConverterTest.pro b/SQLiteStudio3/Tests/DbVersionConverterTest/DbVersionConverterTest.pro
deleted file mode 100644
index cc50c4d..0000000
--- a/SQLiteStudio3/Tests/DbVersionConverterTest/DbVersionConverterTest.pro
+++ /dev/null
@@ -1,21 +0,0 @@
-#-------------------------------------------------
-#
-# Project created by QtCreator 2014-05-04T00:44:01
-#
-#-------------------------------------------------
-
-include($$PWD/../TestUtils/test_common.pri)
-
-QT += testlib
-
-QT -= gui
-
-TARGET = tst_dbversionconvertertesttest
-CONFIG += console
-CONFIG -= app_bundle
-
-TEMPLATE = app
-
-
-SOURCES += tst_dbversionconvertertesttest.cpp
-DEFINES += SRCDIR=\\\"$$PWD/\\\"
diff --git a/SQLiteStudio3/Tests/DbVersionConverterTest/tst_dbversionconvertertesttest.cpp b/SQLiteStudio3/Tests/DbVersionConverterTest/tst_dbversionconvertertesttest.cpp
deleted file mode 100644
index 7d69e7e..0000000
--- a/SQLiteStudio3/Tests/DbVersionConverterTest/tst_dbversionconvertertesttest.cpp
+++ /dev/null
@@ -1,119 +0,0 @@
-#include "dbversionconverter.h"
-#include "parser/lexer.h"
-#include "parser/keywords.h"
-#include <QString>
-#include <QtTest>
-
-class DbVersionConverterTestTest : public QObject
-{
- Q_OBJECT
-
- public:
- DbVersionConverterTestTest();
-
- private Q_SLOTS:
- void initTestCase();
- void init();
- void cleanupTestCase();
- void testColumnAutoIncr();
- void testIndexedColumn();
- void testInsertMultiValues();
- void testSelectWith();
- void testTableWithoutRowId();
- void testTableWithDefaultCtime();
-
- private:
- void printErrors();
-
- DbVersionConverter* converter = nullptr;
-};
-
-DbVersionConverterTestTest::DbVersionConverterTestTest()
-{
-}
-
-void DbVersionConverterTestTest::testColumnAutoIncr()
-{
- QString query = "CREATE TABLE test (col INTEGER PRIMARY KEY AUTOINCREMENT);";
- QString result = converter->convert3To2(query);
-
- printErrors();
- QVERIFY(converter->getErrors().size() == 0);
- QVERIFY(result == "CREATE TABLE test (col INTEGER PRIMARY KEY);");
-}
-
-void DbVersionConverterTestTest::testIndexedColumn()
-{
- QString query = "CREATE INDEX idx ON test (col COLLATE NOCASE ASC);";
- QString result = converter->convert3To2(query);
-
- printErrors();
- QVERIFY(converter->getErrors().size() == 0);
- QVERIFY(result == "CREATE INDEX idx ON test (col ASC);");
-}
-
-void DbVersionConverterTestTest::testInsertMultiValues()
-{
- QString query = "INSERT INTO test (col1, col2) VALUES (1, 'a'), (2, 'b');";
- QString result = converter->convert3To2(query);
-
- printErrors();
- QVERIFY(converter->getErrors().size() == 0);
- QVERIFY(result == "INSERT INTO test (col1, col2) SELECT 1, 'a' UNION ALL SELECT 2, 'b';");
-}
-
-void DbVersionConverterTestTest::testSelectWith()
-{
- QString query = "WITH RECURSIVE cnt (x) AS (VALUES(1) UNION ALL SELECT x + 1 FROM cnt WHERE x < 1000000) SELECT x FROM cnt;";
- QString result = converter->convert3To2(query);
-
- QVERIFY(converter->getErrors().size() == 1);
- QVERIFY(result == ";");
-}
-
-void DbVersionConverterTestTest::testTableWithoutRowId()
-{
- QString query = "CREATE TABLE test (col PRIMARY KEY) WITHOUT ROWID;";
- QString result = converter->convert3To2(query);
-
- printErrors();
- QVERIFY(converter->getErrors().size() == 0);
- QVERIFY(result == "CREATE TABLE test (col PRIMARY KEY);");
-}
-
-void DbVersionConverterTestTest::testTableWithDefaultCtime()
-{
- QString query = "CREATE TABLE test (col INT DEFAULT current_date NOT NULL);";
- QString result = converter->convert3To2(query);
-
- printErrors();
- QVERIFY(converter->getErrors().size() == 0);
- QVERIFY(result == "CREATE TABLE test (col INT NOT NULL);");
-}
-
-void DbVersionConverterTestTest::printErrors()
-{
- for (const QString& err : converter->getErrors())
- qWarning() << err;
-}
-
-void DbVersionConverterTestTest::initTestCase()
-{
- initKeywords();
- Lexer::staticInit();
- converter = new DbVersionConverter();
-}
-
-void DbVersionConverterTestTest::init()
-{
- converter->reset();
-}
-
-void DbVersionConverterTestTest::cleanupTestCase()
-{
- delete converter;
-}
-
-QTEST_APPLESS_MAIN(DbVersionConverterTestTest)
-
-#include "tst_dbversionconvertertesttest.moc"