/**
* Copyright © 2014 Canonical, Ltd.
*
* This program is free software: you can redistribute it and/or modify it under
* the terms of the GNU Lesser General Public License version 3, as published by
* the Free Software Foundation.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranties of MERCHANTABILITY,
* SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with this program. If not, see .
*
*/
#include "test-config.h"
#include
#include "url-db.h"
class UrlDBTest : public ::testing::Test
{
protected:
gchar * cachedir = nullptr;
virtual void SetUp() {
cachedir = g_build_filename(CMAKE_BINARY_DIR, "url-db-test-cache", nullptr);
g_setenv("URL_DISPATCHER_CACHE_DIR", cachedir, TRUE);
}
virtual void TearDown() {
gchar * cmdline = g_strdup_printf("rm -rf \"%s\"", cachedir);
g_spawn_command_line_sync(cmdline, nullptr, nullptr, nullptr, nullptr);
g_free(cmdline);
g_free(cachedir);
}
bool file_list_has (GList * list, const gchar * filename) {
GList * cur;
for (cur = list; cur != nullptr; cur = g_list_next(cur)) {
const gchar * path = (const gchar *)cur->data;
gchar * basename = g_path_get_basename(path);
gint same = g_strcmp0(basename, filename);
g_free(basename);
if (same == 0) {
return true;
}
}
return false;
}
};
static void verify_tables(const gchar *cachedir) {
sqlite3 * db = url_db_create_database();
ASSERT_TRUE(db != nullptr);
gchar * dbfile = g_build_filename(cachedir, "lomiri-url-dispatcher", "urls-" DB_SCHEMA_VERSION ".db", nullptr);
EXPECT_TRUE(g_file_test(dbfile, G_FILE_TEST_EXISTS));
g_free(dbfile);
const char * type = nullptr;
EXPECT_EQ(SQLITE_OK, sqlite3_table_column_metadata(db, nullptr, "configfiles", "name", &type, nullptr, nullptr, nullptr, nullptr));
EXPECT_STRCASEEQ("text", type);
EXPECT_EQ(SQLITE_OK, sqlite3_table_column_metadata(db, nullptr, "configfiles", "timestamp", &type, nullptr, nullptr, nullptr, nullptr));
EXPECT_STRCASEEQ("bigint", type);
EXPECT_EQ(SQLITE_OK, sqlite3_table_column_metadata(db, nullptr, "urls", "sourcefile", &type, nullptr, nullptr, nullptr, nullptr));
EXPECT_STRCASEEQ("integer", type);
EXPECT_EQ(SQLITE_OK, sqlite3_table_column_metadata(db, nullptr, "urls", "protocol", &type, nullptr, nullptr, nullptr, nullptr));
EXPECT_STRCASEEQ("text", type);
EXPECT_EQ(SQLITE_OK, sqlite3_table_column_metadata(db, nullptr, "urls", "domainsuffix", &type, nullptr, nullptr, nullptr, nullptr));
EXPECT_STRCASEEQ("text", type);
sqlite3_close(db);
}
TEST_F(UrlDBTest, CreateTest) {
// Do it twice to ensure that url_db_create_database works
// when invoked on a db that already has the tables.
verify_tables(cachedir);
verify_tables(cachedir);
}
TEST_F(UrlDBTest, TimestampTest) {
sqlite3 * db = url_db_create_database();
ASSERT_TRUE(db != nullptr);
guint64 time = 0;
EXPECT_FALSE(url_db_get_file_motification_time(db, "/foo", &time));
time = 12345;
EXPECT_TRUE(url_db_set_file_motification_time(db, "/foo", time));
time = 0;
EXPECT_TRUE(url_db_get_file_motification_time(db, "/foo", &time));
EXPECT_EQ(12345, time);
sqlite3_close(db);
}
TEST_F(UrlDBTest, UrlTest) {
sqlite3 * db = url_db_create_database();
ASSERT_TRUE(db != nullptr);
guint64 time = 12345;
EXPECT_TRUE(url_db_set_file_motification_time(db, "/foo.url-dispatcher", time));
/* Insert and find */
EXPECT_TRUE(url_db_insert_url(db, "/foo.url-dispatcher", "bar", "foo.com"));
EXPECT_STREQ("foo", url_db_find_url(db, "bar", "foo.com"));
EXPECT_STREQ("foo", url_db_find_url(db, "bar", "www.foo.com"));
/* Two to compete */
time = 67890;
EXPECT_TRUE(url_db_set_file_motification_time(db, "/bar.url-dispatcher", time));
EXPECT_TRUE(url_db_insert_url(db, "/bar.url-dispatcher", "bar", "more.foo.com"));
EXPECT_STREQ("foo", url_db_find_url(db, "bar", "www.foo.com"));
EXPECT_STREQ("bar", url_db_find_url(db, "bar", "more.foo.com"));
EXPECT_STREQ("bar", url_db_find_url(db, "bar", "www.more.foo.com"));
sqlite3_close(db);
}
TEST_F(UrlDBTest, FileListTest) {
sqlite3 * db = url_db_create_database();
ASSERT_TRUE(db != nullptr);
guint64 time = 12345;
/* One Dir */
EXPECT_TRUE(url_db_set_file_motification_time(db, "/base/directory/for/us/one.url-dispatcher", time));
EXPECT_TRUE(url_db_set_file_motification_time(db, "/base/directory/for/us/two.url-dispatcher", time));
/* No three! */
EXPECT_TRUE(url_db_set_file_motification_time(db, "/base/directory/for/us/four.url-dispatcher", time));
EXPECT_TRUE(url_db_set_file_motification_time(db, "/base/directory/for/us/five.url-dispatcher", time));
/* Another Dir */
EXPECT_TRUE(url_db_set_file_motification_time(db, "/base/directory/for/them/six.url-dispatcher", time));
GList * files = url_db_files_for_dir(db, "/base/directory/for/us");
EXPECT_TRUE(file_list_has(files, "one.url-dispatcher"));
EXPECT_TRUE(file_list_has(files, "two.url-dispatcher"));
EXPECT_FALSE(file_list_has(files, "three.url-dispatcher"));
EXPECT_TRUE(file_list_has(files, "four.url-dispatcher"));
EXPECT_TRUE(file_list_has(files, "five.url-dispatcher"));
EXPECT_FALSE(file_list_has(files, "six.url-dispatcher"));
g_list_free_full(files, g_free);
files = url_db_files_for_dir(db, "/base/directory/for/them");
EXPECT_FALSE(file_list_has(files, "five.url-dispatcher"));
EXPECT_TRUE(file_list_has(files, "six.url-dispatcher"));
g_list_free_full(files, g_free);
files = url_db_files_for_dir(db, "/dir/not/there");
EXPECT_EQ(0, g_list_length(files));
sqlite3_close(db);
}
TEST_F(UrlDBTest, RemoveFile) {
sqlite3 * db = url_db_create_database();
ASSERT_TRUE(db != nullptr);
guint64 time = 12345;
EXPECT_TRUE(url_db_set_file_motification_time(db, "/foo.url-dispatcher", time));
/* Insert and find */
EXPECT_TRUE(url_db_insert_url(db, "/foo.url-dispatcher", "bar", "foo.com"));
EXPECT_STREQ("foo", url_db_find_url(db, "bar", "foo.com"));
/* Remove and not find */
EXPECT_TRUE(url_db_remove_file(db, "/foo.url-dispatcher"));
EXPECT_FALSE(url_db_get_file_motification_time(db, "/foo.url-dispatcher", &time));
EXPECT_STREQ(nullptr, url_db_find_url(db, "bar", "foo.com"));
sqlite3_close(db);
}
TEST_F(UrlDBTest, ReplaceTest) {
sqlite3 * db = url_db_create_database();
ASSERT_TRUE(db != nullptr);
guint64 time = 0;
guint64 timetest = 0;
time = 12345;
EXPECT_TRUE(url_db_set_file_motification_time(db, "/foo.url-dispatcher", time));
url_db_get_file_motification_time(db, "/foo.url-dispatcher", &timetest);
EXPECT_EQ(12345, timetest);
/* Replace it */
time = 67890;
EXPECT_TRUE(url_db_set_file_motification_time(db, "/foo.url-dispatcher", time));
url_db_get_file_motification_time(db, "/foo.url-dispatcher", &timetest);
EXPECT_EQ(67890, timetest);
/* Replace it again with the same value */
EXPECT_TRUE(url_db_set_file_motification_time(db, "/foo.url-dispatcher", time));
url_db_get_file_motification_time(db, "/foo.url-dispatcher", &timetest);
EXPECT_EQ(67890, timetest);
sqlite3_close(db);
}