gistfile1.hpp

TEST(DatabaseTest, BasicTest) {
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName(":memory:");
    ASSERT_TRUE(db.open());
    QSqlQuery query;
    EXPECT_TRUE(query.exec("CREATE TABLE IF NOT EXISTS testtable "
                           "(title, url);"));
    EXPECT_TRUE(query.prepare("INSERT INTO testtable (title, url) "
                              "VALUES (:title, :url);"));
    query.bindValue(":title", "some title");
    query.bindValue(":url", "some url");
    EXPECT_TRUE(query.exec());
    qDebug() << query.executedQuery();
    // Outputs: "INSERT INTO testtable (title, url) VALUES (?, ?);"
}