static void
test_repo_finalize (void)
{
GomAdapter *adapter;
GomRepository *repository;
gboolean ret;
GError *error = NULL;
/* Unref repo, then close and unref adapter */
adapter = gom_adapter_new();
ret = gom_adapter_open_sync (adapter, ":memory:", &error);
g_assert_no_error (error);
g_assert (ret);
repository = gom_repository_new (adapter);
g_clear_object (&repository);
ret = gom_adapter_close_sync (adapter, &error);
g_assert_no_error (error);
g_assert (ret);
g_clear_object (&adapter);
/* Close and unref adapter, then unref repo */
adapter = gom_adapter_new();
ret = gom_adapter_open_sync (adapter, ":memory:", &error);
g_assert_no_error (error);
g_assert (ret);
repository = gom_repository_new (adapter);
ret = gom_adapter_close_sync (adapter, &error);
g_assert_no_error (error);
g_assert (ret);
g_clear_object (&adapter);
g_clear_object (&repository);
}
static void
test_notnull (void)
{
GomAdapter *adapter;
GomRepository *repository;
GList *object_types;
ItemResource *item;
GError *error = NULL;
adapter = gom_adapter_new();
gom_adapter_open_sync(adapter, ":memory:", &error);
g_assert_no_error(error);
repository = gom_repository_new(adapter);
object_types = g_list_prepend(NULL, GINT_TO_POINTER(ITEM_TYPE_RESOURCE));
gom_repository_automatic_migrate_sync(repository, 1, object_types, &error);
g_assert_no_error(error);
/* Insert an item without a name */
item = g_object_new (ITEM_TYPE_RESOURCE, "repository", repository,
"email", "*****@*****.**",
NULL);
gom_resource_save_sync(GOM_RESOURCE(item), &error);
g_assert_error(error, GOM_ERROR, GOM_ERROR_COMMAND_SQLITE);
g_assert (strstr (error->message, "NOT NULL") != NULL);
g_assert (strstr (error->message, "items.name") != NULL);
g_clear_error(&error);
g_object_unref(item);
/* Try inserting an item without an email */
item = g_object_new (ITEM_TYPE_RESOURCE, "repository", repository,
"name", "gom",
NULL);
gom_resource_save_sync(GOM_RESOURCE(item), &error);
g_assert_error(error, GOM_ERROR, GOM_ERROR_COMMAND_SQLITE);
g_assert (strstr (error->message, "NOT NULL") != NULL);
g_assert (strstr (error->message, "items.email") != NULL);
g_clear_error(&error);
g_object_unref(item);
gom_adapter_close_sync(adapter, &error);
g_assert_no_error(error);
g_object_unref(repository);
g_object_unref(adapter);
}
static void
grl_bookmarks_source_finalize (GObject *object)
{
GrlBookmarksSource *source;
GRL_DEBUG ("grl_bookmarks_source_finalize");
source = GRL_BOOKMARKS_SOURCE (object);
g_clear_object (&source->priv->repository);
if (source->priv->adapter) {
gom_adapter_close_sync (source->priv->adapter, NULL);
g_clear_object (&source->priv->adapter);
}
G_OBJECT_CLASS (grl_bookmarks_source_parent_class)->finalize (object);
}
static void
test_unique (void)
{
GomAdapter *adapter;
GomRepository *repository;
GList *object_types;
ItemResource *item;
GomFilter *filter;
GValue value = { 0, };
guint id;
gchar *name, *email;
GError *error = NULL;
adapter = gom_adapter_new();
gom_adapter_open_sync(adapter, ":memory:", &error);
g_assert_no_error(error);
repository = gom_repository_new(adapter);
object_types = g_list_prepend(NULL, GINT_TO_POINTER(ITEM_TYPE_RESOURCE));
gom_repository_automatic_migrate_sync(repository, 1, object_types, &error);
g_assert_no_error(error);
/* Insert an item */
item = g_object_new (ITEM_TYPE_RESOURCE, "repository", repository,
"name", "gom", "email", "*****@*****.**",
NULL);
gom_resource_save_sync(GOM_RESOURCE(item), &error);
g_assert_no_error(error);
g_object_get(item, "id", &id, NULL);
g_object_unref(item);
/* Fetch it, to make sure it was saved correctly */
g_value_init(&value, G_TYPE_UINT);
g_value_set_uint(&value, id);
filter = gom_filter_new_eq(ITEM_TYPE_RESOURCE, "id", &value);
g_value_unset(&value);
item = ITEM_RESOURCE (gom_repository_find_one_sync(repository,
ITEM_TYPE_RESOURCE,
filter,
&error));
g_assert_no_error(error);
g_assert(item);
g_object_unref(filter);
g_object_get(item, "name", &name, "email", &email, NULL);
g_assert_cmpstr(name, ==, "gom");
g_free(name);
g_assert_cmpstr(email, ==, "*****@*****.**");
g_free(email);
g_object_unref(item);
/* Now try inserting a new item with the same name (non UNIQUE column) */
item = g_object_new (ITEM_TYPE_RESOURCE, "repository", repository,
"name", "gom", "email", "*****@*****.**",
NULL);
gom_resource_save_sync(GOM_RESOURCE(item), &error);
g_assert_no_error(error);
g_object_get(item, "id", &id, NULL);
g_object_unref(item);
/* Fetch it, to make sure it was saved correctly */
g_value_init(&value, G_TYPE_UINT);
g_value_set_uint(&value, id);
filter = gom_filter_new_eq(ITEM_TYPE_RESOURCE, "id", &value);
g_value_unset(&value);
item = ITEM_RESOURCE (gom_repository_find_one_sync(repository,
ITEM_TYPE_RESOURCE,
filter,
&error));
g_assert_no_error(error);
g_assert(item);
g_object_unref(filter);
g_object_get(item, "name", &name, "email", &email, NULL);
g_assert_cmpstr(name, ==, "gom");
g_free(name);
g_assert_cmpstr(email, ==, "*****@*****.**");
g_free(email);
g_object_unref(item);
/* And finally try inserting an item with the same email (UNIQUE column) */
item = g_object_new (ITEM_TYPE_RESOURCE, "repository", repository,
"name", "gom2", "email", "*****@*****.**",
NULL);
gom_resource_save_sync(GOM_RESOURCE(item), &error);
g_assert_error(error, GOM_ERROR, GOM_ERROR_COMMAND_SQLITE);
g_assert (strstr (error->message, "UNIQUE") != NULL);
g_assert (strstr (error->message, "items.email") != NULL);
g_object_unref(item);
g_clear_error(&error);
gom_adapter_close_sync(adapter, &error);
g_assert_no_error(error);
g_object_unref(repository);
g_object_unref(adapter);
}
