#include "sql_test_helper.hpp"
#include "sqlite_repository.hpp"
#include "test_support.hpp"
#include <QTemporaryDir>
#include <QtTest>
using namespace orders;
class SqlTests : public QObject {
  Q_OBJECT
private slots:
  void roundTripAndRollback() {
    QTemporaryDir directory;
    QVERIFY(directory.isValid());
    auto path = directory.filePath("orders.sqlite");
    {
      SqliteRepository repository(path);
      QVERIFY(succeeded(repository.replaceAll(samples())));
    }
    SqliteRepository reopened(path);
    QVERIFY(std::get<std::vector<Order>>(reopened.list()) == samples());
    QVERIFY(execSql(
        path,
        "CREATE TRIGGER reject_import BEFORE INSERT ON orders WHEN NEW.id=22 "
        "BEGIN SELECT RAISE(ABORT, 'injected database failure'); END"));
    std::vector<Order> incoming{{11, "First insertion"},
                                {22, "Rejected insertion"}};
    auto failed = reopened.replaceAll(incoming);
    QVERIFY(!succeeded(failed));
    QCOMPARE(std::get<Error>(failed).code, ErrorCode::storage);
    QVERIFY(std::get<std::vector<Order>>(reopened.list()) == samples());
    incoming[1].id = 11;
    QVERIFY(!succeeded(reopened.replaceAll(incoming)));
    QVERIFY(std::get<std::vector<Order>>(reopened.list()) == samples());
    std::vector<Order> quoted{{9, "O'Reilly \"parts\"", 2}};
    QVERIFY(succeeded(reopened.replaceAll(quoted)));
    QVERIFY(std::get<std::vector<Order>>(reopened.list()) == quoted);
    QVERIFY(succeeded(reopened.replaceAll({})));
    QVERIFY(std::get<std::vector<Order>>(reopened.list()).empty());
  }
  void cannotOpen() {
    QTemporaryDir directory;
    SqliteRepository bad(directory.filePath("missing/parent/db.sqlite"));
    QVERIFY(!succeeded(bad.list()));
    QVERIFY(!succeeded(bad.replaceAll(samples())));
  }
};
QTEST_GUILESS_MAIN(SqlTests)
#include "tests.moc"
